Enterprise Manager
Lists the InnoDB Activity metrics and provides a brief description of each.
Table 8.8 InnoDB Activity Metrics
| Name | Description |
|---|---|
| Target Name | Name of the OEM Target |
| Buffer Pool Pages Flushed (Delta) | The number of buffer pool page-flush requests. |
| Buffer Pool Read Ahead (Delta) | The number of pages read into the InnoDB buffer pool by the read-ahead background thread. |
| Buffer Pool Read Ahead Evicted (Delta) | Pages read into InnoDB buffer pool by the read-ahead thread that were evicted without been accessed by queries. |
| Buffer Pool Read Requests (Delta) | The number of logical read requests InnoDB has done. |
| Buffer Pool Reads (Delta) | The number of logical reads that InnoDB could not satisfy from the buffer pool, and had to read directly from the disk. |
| Buffer Pool Wait Free (Delta) | Normally, writes to the InnoDB buffer pool happen in the background. |
| Buffer Pool Write Requests (Delta) | The number writes done to the InnoDB buffer pool. |
| Data Fsyncs (Delta) | The number of fsync() operations so far. |
| Data Read (Delta) | The amount of data read since the server was started. |
| Data Reads (Delta) | The total number of data reads. |
| Data Writes (Delta) | The total number of data writes. |
| Data Written (Delta) | The amount of data written so far, in bytes. |
| Dblwr Pages Written (Delta) | The number of pages that have been written for doublewrite operations. |
| Dblwr Writes (Delta) | The number of doublewrite operations that have been performed. |
| Log Waits (Delta) | The number of times that the log buffer was too small and a wait was required for it to be flushed before continuing. |
| Log Write Requests (Delta) | The number of log write requests. |
| Log Writes (Delta) | The number of physical writes to the log file. |
| Os Log Fsyncs (Delta) | The number of fsync() writes done to the log file. |
| Os Log Written (Delta) | The number of bytes written to the log file. |
| Pages Created (Delta) | The number of pages created. |
| Pages Read (Delta) | The number of pages read. |
| Pages Written (Delta) | The number of pages written. |
| Row Lock Time (Delta) | The total time spent in acquiring row locks, in milliseconds. |
| Row Lock Waits (Delta) | The number of times a row lock had to be waited for. |
| Rows Deleted (Delta) | The number of rows deleted from InnoDB tables. |
| Rows Inserted (Delta) | The number of rows inserted into InnoDB tables. |
| Rows Read (Delta) | The number of rows read from InnoDB tables. |
| Rows Updated (Delta) | The number of rows updated in InnoDB tables. |
| Truncated Status Writes (Delta) | The number of times output from the SHOW ENGINE INNODB STATUS statement has been truncated. |