bonglonglong

mtstat is now totally on launchpad. You can evendownload 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:


--- _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",


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.