Sheeri dot com
The She-BA
Array
Syndicate
InnoDB information
May
04
SHOW ENGINE INNODB STATUS shows current InnoDB status, including deadlocks. I was thinking a while back it would be nice to have a log of all deadlocks. Well, I got my answer:
http://dev.mysql.com/doc/refman/5.0/en/innodb-monitor.html
To cause the standard InnoDB Monitor to write to the standard output of mysqld, use the following SQL statement:
CREATE TABLE innodb_monitor (a INT) ENGINE=INNODB;
The monitor can be stopped by issuing the following statement:
DROP TABLE innodb_monitor;
No kidding....but hey, at
No kidding....but hey, at least it's there, and it's dynamic -- you don't need to restart the server to do it....
And whoever dreampt up that
And whoever dreampt up that interface to enabling/disabling logging functionality should probably have something horrible happen to them. OUCH! it *burns*.
A server variable, please!