OurDelta - Builds for MySQL

These pages augment the excellent MySQL Reference Manual with the additions and changes provided by the OurDelta patches.

General Monitoring & Control

• UserStats: 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.