Chat now with support
Chat with Support

Spotlight on Oracle 10.8 - Getting Started Guide

Welcome to Spotlight Install Spotlight Start Spotlight Spotlight on Oracle Spotlight on Oracle Data Guard Spotlight on Oracle RAC Spotlight on Unix Spotlight on Windows Spotlight on MySQL Troubleshooting: Connection Problems

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