Chat now with support
Chat with Support

Spotlight on Oracle 10.4 - Release Notes

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

  1. Select the Spotlight on MySQL connection in the Spotlight Browser.
  2. 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

 

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating