The InnoDB tables related to the
InnoDB storage engine help you to monitor ongoing
InnoDB activity, to detect inefficiencies before
they turn into issues, or to troubleshoot performance and capacity
issues that do occur. As your database becomes bigger and busier,
running up against the limits of your hardware capacity, you monitor
and tune these aspects to keep the database running smoothly. The
monitoring information deals with:
InnoDBtable compression, a feature whose use depends on a balance between I/O reduction, CPU usage, buffer pool management, and how much compression is possible for your data.Transactions and locks, features that balance high performance for a single operation, against the ability to run multiple operations concurrently. (Transactions are the high-level, user-visible aspect of concurrency. Locks are the low-level mechanism that transactions use to avoid reading or writing unreliable data.)