Databases Reference
In-Depth Information
Summary
MySQL's primary means of exposing server internals is the
SHOW
commands, but that's
changing. The introduction in MySQL 5.1 of pluggable
INFORMATION_SCHEMA
tables per-
mitted the InnoDB plugin to add some very valuable instrumentation, and Percona
Server adds many more. However, the ability to read
SHOW ENGINE INNODB STATUS
output
and interpret it remains essential for managing InnoDB. In MySQL 5.5 and newer server
versions, the Performance Schema is available, and it will probably become the most
powerful and complete means of inspecting the server's internals. The great thing about
the Performance Schema is that it's time-based, meaning that MySQL is finally getting
instrumented for elapsed time, not just operation counts.
