戻る
-
タイトル
Overview of the MySQL Tables dashboard -
説明
What does the MySQL agent Tables dashboard represent? -
対策
The Tables dashboard provides pertinent table information for the MySQL instance being monitored. The Databases table shows aggregated metrics for tables in that database, including growth rate and table and index counts and sizes. The Tables table displays the following metrics, in row format, for each MySQL agent instance deployed:
- Selector button – used to select a specific table for the graphs below.
- Health Indicator – Indicates the overall health of the deployed instance.
- Tables – provides the name and a total count of tables in the MySQL instance being monitored
- Indexes – The number of indexes in the table
- Rows – The number of rows in the table
- Avg Row Length – Average size of rows in the table
- Used – Percentage of used space in the table
- Free – Percentage of free space in the table
- UsedMB – Megabytes of used space in the table
- FreeMB – Megabytes of free space in the table
- TotalSizeMB – Megabytes of total size in the table
- AutoExtend – The increment size for extending the size of an auto-extending table when it becomes full.
The graphs below provide the following information for the selected table
- Row Count – Graphs the number of rows in the tablespace for the selected time range
- Space Used – Graphs the Table’s Used Space vs. Total Size for the selected time range.
- Growth Rate – Shows growth/shrinkage of selected table size.
- Locks Held or Requested – Shows locks held or requested for selected table