-
These pages augment the excellent MySQL Reference Manual with the additions and changes provided by the OurDelta patches for MySQL 5.0. For MariaDB (5.1 and above) see the MariaDB documentation.
General Monitoring & ControlUserStats: SHOW TABLE|INDEX|CLIENT|USER_STATISTICS (and INFORMATION_SCHEMA.*)
- MicroSlow – more granular, filtered, and extended information in slow query log.
-
KILL IF IDLE – Kill connection but only if idle.
InnoDB Monitoring & Control - InnoDB Locks Held – Add locks held, remove locked records in SHOW ENGINE INNODB STATUS.
-
INNODB_BUFFER_POOL_CONTENT – new INFORMATION_SCHEMA table.
InnoDB Freeze – Freeze Innodb file system activity.Replication
Mirrored Binlogs – Make simple failover possible in hierachical slave setups.
Fast Master Promotion – Makes replication failover without shutdown possible.