Summary Page
The Activity Summary page provides an overview of the activity on the database you are diagnosing.
To open the Summary page
- Select the Spotlight on MySQL connection in the Spotlight Browser.
-
Click Activity | Summary.
SQL Execution Rates Chart
This chart show the execution rates for various types of SQL statements. Rates are shown as statements executed per second. If an SQL statement is cached within the query cache, it does not register as a SELECT execution on this chart.
| Data Series | Description |
|---|---|
|
SQL Statements |
The execution rate for all SQL statements executed on the database. |
|
Selects |
The execution rate for SELECT statements executed on the database. |
|
Inserts |
The execution rate for INSERT statements executed on the database. |
|
Updates |
The execution rate for UPDATE statements executed on the database. |
|
Deletes |
The execution rate for DELETE statements executed on the database. |
|
Commits |
The execution rate for COMMIT statements executed on the database. |
Row Access Chart
This chart shows the rate of InnoDB activity measured in table rows processed (read, inserted, updated, or deleted) per second.
| Data Series | Description |
|---|---|
|
Reads |
The rate at which rows are read by the InnoDB storage engine. |
|
Inserts |
The rate at which rows are inserted by the InnoDB storage engine. |
|
Deletes |
The rate at which rows are deleted by the InnoDB storage engine. |
|
Updates |
The rate at which rows are updated by the InnoDB storage engine. |
Sessions Chart
This chart shows the number of sessions connected and active (running a SQL statement, for example), the number connected and idle (sleeping), and the number of cached connection threads.
| Data Series | Description |
|---|---|
|
Cached |
The number of cached connection threads. |
|
Idle |
The number of sleeping sessions. |
|
Active |
The number of active sessions. |
Logical I/O Chart
The Logical I/O chart shows the rate of logical database reads and writes.
| Data Series | Description |
|---|---|
|
Logical Reads |
The rate of read-only requests for database data. |
|
Logical Writes |
The rate of changes to data in memory. |
|
Log Buffer Writes |
The rate of writes to the InnoDB log buffer. |
Miss Rates Chart
This chart shows the percentage of requests made to MySQL that could not be satisfied by data or SQL statements in memory.
| Data Series | Description |
|---|---|
|
Query Cache |
The query cache miss rate represents the percentage of SELECT statement requests that cannot be satisfied from within the query cache and which therefore are executed by MySQL. |
|
Buffer Cache |
The buffer cache miss rate represents the percentage of data requests that cannot be satisfied from within the buffer pool, and which therefore require a physical read from disk. |
|
Mutex |
The mutex miss rate represents the percentage of data requests that cannot be satisfied by an available mutex (mutual exclusion object). A mutex allows multiple program threads to share the same resource (for example, access to a file). |
Physical I/O Chart
This chart shows the rate of physical disk I/O being performed by the InnoDB storage engine. Physical I/O falls into the three categories depicted in this chart:
| Data Series | Description |
|---|---|
|
Physical Reads |
The rate at which InnoDB reads data from the tablespace files on disk to satisfy the requirements of an SQL operation that cannot find the required data in the InnoDB buffer pool. |
|
Physical Writes |
The rate at which InnoDB writes modified data to the tablespace files on disk. |
|
Log Writes |
The rate at which InnoDB writes entries to the transaction log (this will always happen when a COMMIT is issued). |