Spotlight on Oracle 10.6 - Release Notes

The InnoDB panel provides an overview of the activity within the transaction-capable InnoDB storage engine, if that storage engine is used by the MySQL database under investigation. Information displayed here includes:

• The size, availability and hit rate of the InnoDB buffer pool.
• The rate of insert, update, delete and select operations expressed in rows processed per second.
• The size of the InnoDB log buffer.
• The number of threads performing I/O for InnoDB.

The flows between the InnoDB panel and the Storage panel represent the rate of I/O operations between the InnoDB storage engine and tablespace files on disk. The flows include:

• The rate at which InnoDB writes data to tablespace files on disk.
• The rate of of physical I/O operations from the InnoDB tablespace files into the InnoDB buffer pool.
• The I/O rate to the InnoDB transaction log.