InnoDB Status Page
If your MySQL database uses the InnoDB storage engine, the InnoDB Status page of the Activity drilldown contains a regularly-updated log of the output from InnoDB.
To open the InnoDB Status page
- Select the Spotlight on MySQL connection in the Spotlight Browser.
-
Click Activity | InnoDB Status.
Background
An interesting architectural features of the MySQL RDBMS is the implementation of a storage engine. This allows the core MySQL engine – which is concerned with processing SQL requests – to interact with a variety of underlying, low-level, storage engines that are responsible for low level access to the underlying storage.
This architecture allows MySQL to offer the user a choice of underlying storage handlers with different capabilities and also allows external parties – other open source companies or end users themselves – to write storage handlers for special purposes.
There are a number of storage engine choices for MySQL, but the two most significant are:
- MyISAM - A fast and light-weight MySQL handler, but one that is not transaction-capable. Within MyISAM, tables are represented as files on disk.
- InnoDB - A MySQL handler that is transaction-capable, and that is in many respects similar to Oracle (row level locking, consistency across multiple versions, and so on).
InnoDB status
The data reported can include:
- Semaphores
- Transactions
- File I/O
- Index statistics
- Memory statistics
- Row operations