Home ยป Content

InnoDB information

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!