Enterprise Manager
The Global Table/Row Statistics dashboard displays information on the table and row activity on the monitored server.
Table 5.9 Tables / Rows Performance Page Regions
Name | Description |
---|---|
Opened Tables | Graphs the number of cached frm files and the total number of opened tables. |
Currently Open Tables | Graphs the number of tables open in the table cache. |
Temporary Tables | Graphs the number of temporary tables created, and the number of temporary tables converted to disk-based tables. |
Table Locks | Graphs the number of times a table lock request was granted immediately and the number of times it could not be granted immediately. |
Table Scan Ratio | Graphs the ratio of rows read via indexes versus rows read via table scan. |
Row Reads | Graphs the average of rows read via indexes per second and the rows read via scan. |
Row Writes | Graphs the number of requests to write, update or delete a row. |
Sorts | Graphs the number of sorts performed using ranges and scans. |
Rows Sorted | Graphs the number of sorted rows. |
Sort Merge Passes | Graphs the number of merge passes performed by the sort algorithm. |
Table Configuration | Lists the table-specific system variables and their values. |