Docs
These pages augment the excellent MySQL Reference Manual with the additions and changes provided by the OurDelta patches. See also Percona’s patch docuwiki and MariaDB 5.1 documentation.
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.
(work in progress – more coming up and yes you can help!)