In one week's time I'll be presenting common_schema: DBA's framework for MySQL at Percona Live, London.
This talk introduces the rich toolset known as common_schema. It is free, open source, extremely useful in solving DBA & developer tasks, and is the next best thing ever invented next to SQL pie charts.
- Views, with which you can detect and terminate idle transactions, blocking transactions; roll your range partitions; find duplicate keys; block/unblock accounts; get fine grained privileges per account; find AUTO_ICNREMENT free space; ...
- Routines: do meta executions such as eval(); get query checksums; duplicating accounts; killing suspicious connections;