In August Productions

il corra walks you through building mysql-proxy for ubuntu.
il corra » mysql-proxy on ubuntu 7.04 feisty

First of all, there is not a packetized mysql-proxy for Ubuntu, so the only way to install it is to build it from the source

Which is great. But I'd like to take this opportunity to tell people that I've actually been working on packages for debian/ubuntu. They're almost ready to be released into the wild (I'm waiting on an almost non-related event) If you'd like to play with the packaging stuff before then, check out http://launchpad.net/mysql-proxy
I'll be sure to let everyone know when the packages themselves are in an APT repository.

mtstat is now totally on launchpad. You can even download files.
I moved a few things around for 0.7.3. The MySQL plugins are now in mysql.mtstat instead of mtstat_mysql. (To go along with my putting the NDB/Connectors Python stuff in mysql.cluster - I'm trying to make a mysql namespace here) And I split up the mysqlqps plugin into mysqlqps, mysqlhandler and mysqlqcache. You can do multiple plugins like:
mtstat -Mmysqlqps,mysqlhandler
And you'll get output like:

_uptime __sel__ __ins__ __del__ __upd__ _quest_|___hf__ __hnxt_ __hkey_ __rrnd_ __rnxt_

1998k      0       0       0       0       0 |     0       0       0       0       0

1998k     80       8       0       5     411 |     0     359     364       5   10144

1998k     27       8       0       6     288 |     0     240     222       1       2

1998k     86       7       0       8     531 |     0     300     411       3   10141

1998k     29       4       0       2     388 |     0      77     107       0    5062

1998k     35       1       0       2     193 |     0      24     117       1       3

1998k    100       4       0       4     704 |     0      95     356       1     665

1998k    110       7       0      24    1083 |     0     127     416       4    9470

Yoshinori pointed out a bug in the MySQLdb adapter. In the C code it passes a default port value of 3306. Of course, this means that if you don't set the port in code but expect to pick up the port number from my.cnf, it won't work. The patch is really, really small. The port number passed to mysql_real_connect() should be 0 - not 3306. But it might be a while before that hits. So for now, if you need to do an alternate port, you can either get a copy of MySQLdb and apply this patch:
[C] --- _mysql_connections.c.orig 2007-08-03 23:20:28.000000000 -0700 +++ _mysql_connections.c 2007-08-03 23:20:33.000000000 -0700 @@ -15,7 +15,7 @@ #endif char *host = NULL, *user = NULL, *passwd = NULL, *db = NULL, *unix_socket = NULL; - uint port = 3306; + uint port = 0; uint client_flag = 0; static char *kwlist[] = { "host", "user", "passwd", "db", "port", "unix_socket", "conv", [/C]
Or you can hard code your port into mysql.mtstat.mysqlbase.
Also, I've turned on the bug tracker on launchpad, so please let me know if you're having any problems.