MySQL
Monitor MySQL and MySQL-based Database Servers
Data Collection Setup
Metrics are collected via JDBC from the MySQL Database.
Install the MySQL sys schema (required for versions older than 5.7.7)
The MySQL sys schema is installed by default on MySQL versions 5.7.7 or later. Only users of MySQL versions earlier than 5.7.7 need to install it. You can install the schema by running the below commands from the system running MySQL.
If using MySQL 5.7, replace the ./sys_56.sql file name in the final command with ./sys_57.sql.
git clone https://github.com/mysql/mysql-sys.git
cd mysql-sys/
mysql -u root -p < ./sys_56.sql
## For MySQL 5.7.6 or older
mysql -u root -p < ./sys_57.sql
Network Requirements
Port: 3306 (TCP) Default to the MySQL Database Server
Least Privileged User
In order to access and return certain metrics from your database, specific privileges must be granted to the designated MySQL user. If you encounter errors when creating the monitoring user, make sure to run the user script as a script. You can also run each line separately.
If executing this script in DBeaver, make sure to execute 'as a script' (alt+X)
CREATE USER 'bluemedora'@'%' IDENTIFIED BY 'yourmonitoringpassword';
GRANT SELECT,EXECUTE ON sys.* TO 'bluemedora'@'%';
GRANT REPLICATION CLIENT, REPLICATION SLAVE, PROCESS, SHOW DATABASES, SELECT ON *.* TO 'bluemedora'@'%';
FLUSH PRIVILEGES;
CREATE USER 'bluemedora'@'%' IDENTIFIED WITH mysql_native_password BY 'yourmonitoringpassword';
GRANT SELECT,EXECUTE ON sys.* TO 'bluemedora'@'%';
GRANT REPLICATION CLIENT, REPLICATION SLAVE, PROCESS, SHOW DATABASES, SELECT ON *.* TO 'bluemedora'@'%';
FLUSH PRIVILEGES;
Supported Versions
MySQL: 5.6.x, 5.7.x, 8.x
- Storage Engine: InnoDB or MyISAM
MariaDB: 10.0, 10.1, or 10.2
- Storage Engine: XtraDB
If using a MySQL version earlier than 5.7.7, query resources and metrics will be unavailable unless the MySQL sys schema is installed. See: Installing the MySQL sys schema (Pre-5.7.7 Only)
Connection Parameters
| Name | Required? | Description |
|---|---|---|
| Host | Required | The MySQL Server to connect to. |
| Port | The port for communication to the MySQL Server. | |
| Username | Required | |
| Password | Required | |
| SSL Configuration | The SSL mode to use when connecting to the target. Can be configured to not use SSL (No SSL), use SSL but do not verify the target's certificate (No Verify), and use SSL and verify the target's certificate (Verify). | |
| Databases | Comma-separated list of database(s) to monitor. Leave blank to monitor all databases. | |
| Database Types | This field is only taken into account if the 'databases' field is not specified. | |
| Connection Timeout (seconds) | The number of seconds to allow for connecting to the target. Specifying 0 will indicate to use the system default. | |
| Query Timeout (seconds) | The number of seconds to allow for the query to return a response. This is used to cancel any queries that run longer than expected. |
Metrics
Database
| Name | Description |
|---|---|
| Average Delete Wait Time (Picoseconds) | The average Delete wait time |
| Average Fetch Wait Time (Picoseconds) | The average Fetch wait time |
| Average Insert Wait Time (Picoseconds) | The average Insert wait time |
| Average Read Wait Time (Picoseconds) | The average Read wait time |
| Average Read/Write Wait Time (Picoseconds) | The average R/W wait time |
| Average Update Wait Time (Picoseconds) | The average Update wait time |
| Average Write Wait Time (Picoseconds) | The average Write wait time |
| Binary Log Dump Threads (Threads) | The number of Binlog Dump threads |
| Change User Threads (Threads) | The number of Change User threads |
| Close Statement Threads (Threads) | The number of Close Statement threads |
| Connect Out Threads (Threads) | The number of Connect Out threads |
| Connect Threads (Threads) | The number of Connect threads |
| Connected Threads (Threads) | The number of Connected threads |
| Create Database Threads (Threads) | The number of Create DB threads |
| Daemon Threads (Threads) | The number of Daemon threads |
| Data Size (Bytes) | The size of the database's data |
| Database Name | The name of the database |
| Debug Threads (Threads) | The number of Debug threads |
| Delayed Insert Threads (Threads) | The number of Delayed Insert threads |
| Drop Database Threads (Threads) | The number of Drop DB threads |
| Error Threads (Threads) | The number of Error threads |
| Execute Threads (Threads) | The number of Execute threads |
| Fetch Threads (Threads) | The number of Fetch threads |
| Field List Threads (Threads) | The number of Field List threads |
| Index Size (Bytes) | The size of the database's indexes |
| Initialize Database Threads (Threads) | The number of Init DB threads |
| I/O Miscellaneous Latency (Picoseconds) | The average latency of miscellaneous I/O |
| I/O Miscellaneous Requests (Requests) | The number of I/O miscellaneous requests |
| I/O Read Latency (Picoseconds) | The average latency of I/O reads |
| I/O Read Requests (Requests) | The number of I/O read requests |
| I/O Reads (Bytes) | The number of I/O reads |
| I/O Write Latency (Picoseconds) | The average latency of I/O writes |
| I/O Write Requests (Requests) | The number of I/O write requests |
| I/O Writes (Bytes) | The number of I/O writes |
| Kill Threads (Threads) | The number of Kill threads |
| Long Data Threads (Threads) | The number of Long Data threads |
| Maximum Delete Wait Time (Picoseconds) | The maximum Delete wait time |
| Maximum Fetch Wait Time (Picoseconds) | The maximum Fetch wait time |
| Maximum Insert Wait Time (Picoseconds) | The maximum Insert wait time |
| Maximum Read Wait Time (Picoseconds) | The maximum Read wait time |
| Maximum Read/Write Wait Time (Picoseconds) | The maximum R/W wait time |
| Maximum Update Wait Time (Picoseconds) | The maximum Update wait time |
| Maximum Write Wait Time (Picoseconds) | The maximum Write wait time |
| Minimum Delete Wait Time (Picoseconds) | The minimum Delete wait time |
| Minimum Fetch Wait Time (Picoseconds) | The minimum Fetch wait time |
| Minimum Insert Wait Time (Picoseconds) | The minimum Insert wait time |
| Minimum Read Wait Time (Picoseconds) | The minimum Read wait time |
| Minimum Read/Write Wait Time (Picoseconds) | The minimum R/W wait time |
| Minimum Update Wait Time (Picoseconds) | The minimum Update wait time |
| Minimum Write Wait Time (Picoseconds) | The minimum Write wait time |
| Miscellaneous Threads (Threads) | The number of Miscellaneous threads |
| Ping Threads (Threads) | The number of Ping threads |
| Prepare Threads (Threads) | The number of Prepare threads |
| Process List Threads (Threads) | The number of Processlist threads |
| Query Threads (Threads) | The number of Query threads |
| Quit Threads (Threads) | The number of Quit threads |
| Refresh Threads (Threads) | The number of Refresh threads |
| Register Slave Threads (Threads) | The number of Register Slave threads |
| Reset Statement Threads (Threads) | The number of Reset Statement threads |
| Rows Deleted (Rows) | The number of rows deleted |
| Rows Fetched (Rows) | The number of rows fetched |
| Rows Inserted (Rows) | The number of rows inserted |
| Rows Read (Rows) | The number of rows read |
| Rows Read/Written (Rows) | The total number of rows read and written |
| Rows Updated (Rows) | The number of rows updated |
| Rows Written (Rows) | The number of rows written |
| Set Option Threads (Threads) | The number of Set Option threads |
| Shutdown Threads (Threads) | The number of Shutdown threads |
| Sleep Threads (Threads) | The number of Sleep threads |
| Statistics Threads (Threads) | The number of Statistics threads |
| Table Dump Threads (Threads) | The number of Table Dump threads |
| Total Delete Wait Time (Picoseconds) | The total Delete wait time |
| Total Fetch Wait Time (Picoseconds) | The total Fetch wait time |
| Total Insert Wait Time (Picoseconds) | The total Insert wait time |
| Total Read Wait Time (Picoseconds) | The total Read wait time |
| Total Read/Write Wait Time (Picoseconds) | The total R/W wait time |
| Total Size (Bytes) | The total size of the database |
| Total Update Wait Time (Picoseconds) | The total Update wait time |
| Total Write Wait Time (Picoseconds) | The total Write wait time |
| Unused Indexes (Indexes) | The number of unused indexes |
Index
| Name | Description |
|---|---|
| Delete Latency (Picoseconds) | The total wait time of timed deletes from the index |
| Index Name | The name of the index |
| Insert Latency (Picoseconds) | The total wait time of timed inserts into the index |
| Is Used | Whether or not the index is used |
| Rows Deleted (Rows) | The total number of rows deleted from the index |
| Rows Inserted (Rows) | The total number of rows inserted into the index |
| Rows Selected (Rows) | The total number of rows read using the index |
| Rows Updated (Rows) | The total number of rows updated in the index |
| Select Latency (Picoseconds) | The total wait time of timed reads using the index |
| Table Name | The table that contains the index |
| Table Schema | The schema that contains the table |
| Update Latency (Picoseconds) | The total wait time of timed updates in the index |
Instance
| Name | Description |
|---|---|
| Aborted Connections (Attempts) | The number of failed attempts to connect to the MySQL server |
| Active Transactions (Transactions) | The number of active transactions |
| Active Transactions Rolled Back (Transactions) | The number of resurrected active transactions rolled back |
| Adaptive Hash Binary Tree Searches (Searches) | The number of searches using B-tree on an index search |
| Adaptive Hash Pages Added (Pages) | The number of index pages on which the Adaptive Hash Index is built |
| Adaptive Hash Pages Removed (Pages) | The number of index pages whose corresponding Adaptive Hash Index entries were removed |
| Adaptive Hash Rows Added (Rows) | The number of Adaptive Hash Index rows added |
| Adaptive Hash Rows Deleted With No Hash Entry (Rows) | The number of rows deleted that did not have corresponding Adaptive Hash Index entries |
| Adaptive Hash Rows Removed (Rows) | The number of Adaptive Hash Index rows removed |
| Adaptive Hash Rows Updated (Rows) | The number of Adaptive Hash Index rows updated |
| Adaptive Hash Searches (Searches) | The number of successful searches using Adaptive Hash Index |
| ALTER TABLEs, CREATE INDEXes, and DROP INDEXes In Progress | Number of ALTER TABLE, CREATE INDEX, DROP INDEX in progress |
| Background Drop Table Time (Microseconds) | The time spent to process drop table list |
| Buffer Data Reads (Bytes) | The amount of data read in bytes |
| Buffer Data Written (Bytes) | The amount of data written in bytes |
| Buffer Flush Adaptive (Batches) | The number of adaptive batches |
| Buffer Flush Adaptive Pages (Pages) | The pages queued as an adaptive batch |
| Buffer Flush Adaptive Total Pages (Pages) | The total pages flushed as part of adaptive flushing |
| Buffer Flush Average Page Rate (Pages) | The average number of pages at which flushing is happening |
| Buffer Flush Background (Batches) | The number of background batches |
| Buffer Flush Background Pages (Pages) | The number of pages queued as a background batch |
| Buffer Flush Background Total Pages (Pages) | The total pages flushed as part of background batches |
| Buffer Flush Batch Pages (Pages) | The number of pages queued as a flush batch |
| Buffer Flush Batch Rescans (Calls) | The number of times rescan of flush list forced |
| Buffer Flush Batch Scanned (Pages) | The total pages scanned as part of flush batch |
| Buffer Flush Batch Scanned Per Call (Pages) | The number of pages scanned per flush batch scan |
| Buffer Flush Batch Scans (Calls) | The number of times buffer flush list flush is called |
| Buffer Flush Batch Total Pages (Pages) | The total pages flushed as part of flush batch |
| Buffer Flush Batches (Batches) | The number of flush batches |
| Buffer Flush For Dirty (%) | The percent of I/O capacity used to avoid max dirty page limit. |
| Buffer Flush For LSN (%) | The percent of I/O capacity used to avoid reusable redo space limit |
| Buffer Flush LSN Average Rate | The average redo generation rate |
| Buffer Flush Neighbor (Calls) | The number of times neighbors flushing is invoked |
| Buffer Flush Neighbor Pages (Pages) | The number of pages queued as a neighbor batch |
| Buffer Flush Neighbor Total Pages | The total neighbors flushed as part of neighbor flush |
| Buffer Flush Requests (Pages) | The number of pages requested for flushing |
| Buffer Flush Sync (Batches) | The number of sync batches |
| Buffer Flush Sync Pages (Pages) | The pages queued as a sync batch |
| Buffer Flush Sync Total Pages (Pages) | The total pages flushed as part of sync batches |
| Buffer Flush Sync Waits | The number of times a wait happens due to sync flushing |
| Buffer LRU Batch Evict Pages (Pages) | The number of pages queued as a LRU evict batch |
| Buffer LRU Batch Evict Total Pages (Pages) | The total pages evicted as part of LRU evict batch |
| Buffer LRU Batch Flush Pages (Pages) | The number of pages queued as a LRU flush batch |
| Buffer LRU Batch Flush Total Pages (Pages) | The total pages flushed as part of LRU flush batch |
| Buffer LRU Batch Number Scanned (Calls) | The number of times LRU batch is called |
| Buffer LRU Batch Pages (Pages) | The number of pages queued as an LRU batch |
| Buffer LRU Batch Scanned (Pages) | The total pages scanned as part of LRU batch |
| Buffer LRU Batch Scanned Per Call (Pages) | The number of pages scanned per LRU batch call |
| Buffer LRU Batch Total Pages (Pages) | The total pages flushed as part of LRU batches |
| Buffer LRU Batches (Pages) | The number of LRU batches |
| Buffer LRU Batches Evict (Batches) | The number of LRU evict batches |
| Buffer LRU Batches Flush (Batches) | The number of LRU flush batches |
| Buffer LRU Get Free Search (Searches) | The number of searches performed for a clean page |
| Buffer LRU Search Scanned (Pages) | The total pages scanned as part of LRU search |
| Buffer LRU Search Scanned Per Call (Pages) | The number of pages scanned per single LRU search |
| Buffer LRU Searches (Searches) | The number of times LRU search is performed |
| Buffer LRU Single Flush Failure Count (Attempts) | The number of attempts to flush a single page from LRU failed |
| Buffer LRU Single Flush Number Scan (Calls) | The number of times single page LRU flush is called |
| Buffer LRU Single Flush Scanned (Pages) | The total pages scanned as part of single page LRU flush |
| Buffer LRU Single Flush Scanned Per Call (Pages) | The number of pages scanned per single LRU flush |
| Buffer LRU Unzip Search Number Scan (Searches) | The number of times LRU unzip search is performed |
| Buffer LRU Unzip Search Scanned (Pages) | The total pages scanned as part of LRU unzip search |
| Buffer LRU Unzip Search Scanned Per Call (Pages) | The number of pages scanned per single LRU unzip search |
| Buffer Page Read Extent Descriptor (Pages) | The number of Extent Descriptor Pages read |
| Buffer Page Read File Space Header (Pages) | The number of File Space Header Pages read |
| Buffer Page Read First Compressed BLOB (Pages) | The number of First Compressed BLOB Pages read |
| Buffer Page Read Index Inode (Pages) | The number of Index Inode Pages read |
| Buffer Page Read Index Insert Buffer Leaf (Pages) | The number of Insert Buffer Index Leaf Pages read |
| Buffer Page Read Index Insert Buffer Non Leaf (Pages) | The number of Insert Buffer Index Non-Leaf Pages read |
| Buffer Page Read Index Leaf (Pages) | The number of Index Leaf Pages read |
| Buffer Page Read Index Non Leaf (Pages) | The number of Index Non-leaf Pages read |
| Buffer Page Read Insert Buffer Bitmap (Pages) | The number of Insert Buffer Bitmap Pages read |
| Buffer Page Read Insert Buffer Free List (Pages) | The number of Insert Buffer Free List Pages read |
| Buffer Page Read Other (Pages) | The number of other/unknown (old version of InnoDB) Pages read |
| Buffer Page Read Subsequent Compressed BLOB (Pages) | The number of Subsequent Compressed BLOB Pages read |
| Buffer Page Read System Page (Pages) | The number of System Pages read |
| Buffer Page Read Transaction System (Pages) | The number of Transaction System Pages read |
| Buffer Page Read Uncompressed BLOB (Pages) | The number of Uncompressed BLOB Pages read |
| Buffer Page Read Undo Log (Pages) | The number of Undo Log Pages read |
| Buffer Page Written Extent Descriptor (Pages) | The number of Extent Descriptor Pages written |
| Buffer Page Written File Space Header (Pages) | The number of File Space Header Pages written |
| Buffer Page Written First Compressed BLOB (Pages) | The number of First Compressed BLOB Pages written |
| Buffer Page Written Index Inode (Pages) | The number of Index Inode Pages written |
| Buffer Page Written Index Insert Buffer Leaf (Pages) | The number of Insert Buffer Index Leaf Pages written |
| Buffer Page Written Index Insert Buffer Non Leaf (Pages) | The number of Insert Buffer Index Non-Leaf Pages written |
| Buffer Page Written Index Leaf (Pages) | The number of Index Leaf Pages written |
| Buffer Page Written Index Non Leaf (Pages) | The number of Index Non-leaf Pages written |
| Buffer Page Written Insert Buffer Bitmap (Pages) | The number of Insert Buffer Bitmap Pages written |
| Buffer Page Written Insert Buffer Free List (Pages) | The number of Insert Buffer Free List Pages written |
| Buffer Page Written Other (Pages) | The number of other/unknown (old version InnoDB) Pages written |
| Buffer Page Written Subsequent Compressed BLOB (Pages) | The number of Subsequent Compressed BLOB Pages written |
| Buffer Page Written System Page (Pages) | The number of System Pages written |
| Buffer Page Written Transaction System (Pages) | The number of Transaction System Pages written |
| Buffer Page Written Uncompressed BLOB (Pages) | The number of Uncompressed BLOB Pages written |
| Buffer Page Written Undo Log (Pages) | The number of Undo Log Pages written |
| Buffer Pages Created (Pages) | The number of pages created |
| Buffer Pages Read (Pages) | The number of pages read |
| Buffer Pages Written (Pages) | The number of pages written |
| Buffer Pool Data (Bytes) | The number of buffer bytes containing data |
| Buffer Pool Dirty (Bytes) | The number of buffer bytes currently dirty |
| Buffer Pool Pages Data (Pages) | The number of buffer pages containing data |
| Buffer Pool Pages Dirty (Pages) | The number of buffer pages currently dirty |
| Buffer Pool Pages Free (Pages) | The buffer pages currently free |
| Buffer Pool Pages Miscellaneous (Pages) | The number of buffer pages for miscellaneous use such as row locks or the adaptive hash index |
| Buffer Pool Pages Total (Pages) | The total buffer pool size in pages |
| Buffer Pool Read Ahead (Pages) | The number of pages read as read ahead |
| Buffer Pool Read Ahead Evicted (Pages) | The read-ahead pages evicted without being accessed |
| Buffer Pool Read Requests (Reads) | The number of logical read requests |
| Buffer Pool Reads (Reads) | The number of reads directly from disk |
| Buffer Pool Size (Bytes) | The server buffer pool size (all buffer pools) in bytes |
| Buffer Pool Wait Free (Writes) | The number of times waited for free buffer |
| Buffer Pool Write Requests (Writes) | The number of write requests |
| Change Buffer Deleted Merged Operations Discarded (Rows) | The number of delete merged operations discarded |
| Change Buffer Deleted Records Merged (Rows) | The number of deleted records merged by change buffering |
| Change Buffer Insert Merged Operations Discarded (Rows) | The number of insert merged operations discarded |
| Change Buffer Inserted Records Merged (Rows) | The number of inserted records merged by change buffering |
| Change Buffer Merge Time (Microseconds) | The time spent to process change buffer merge |
| Change Buffer Number Merges (Rows) | The number of change buffer merges |
| Change Buffer Purge Merged Records Discarded (Rows) | The number of purge merged operations discarded |
| Change Buffer Purge Records Merged (Rows) | The number of purge records merged by change buffering |
| Change Buffer Size (Pages) | The change buffer size in pages |
| Checkpoint Time (Microseconds) | The time spent by master thread to do checkpoint |
| Compression Padding Decrements | The number of times padding is decremented due to good compressibility |
| Compression Padding Increments | The number of times padding is incremented to avoid compression failures |
| Connections (Attempts) | The number of connection attempts (successful or not) to the MySQL server |
| Current LSN | The current log sequence number value |
| Current Rollback Size (Pages) | The current rollback segment size |
| Deadlocks (Locks) | The number of deadlocks |
| Dictionary LRU Processing Time (Microseconds) | The time spent to process DICT LRU list |
| Doublewrite Operation Pages Written (Pages) | The number of pages that have been written for doublewrite operations (doublewrite_operation_pages_written) |
| Doublewrite Writes (Operations) | The number of doublewrite operations that have been performed (doublewrite_writes) |
| Files Currently Open | The number of files currently open |
| fsync() Calls Count (Calls) | The number of fsync() calls |
| Hostname | The Hostname |
| Index Page Discards (Pages) | The number of index pages discarded |
| Index Page Merge Attempts (Attempts) | The number of index page merge attempts |
| Index Page Merge Successes (Merges) | The number of successful index page merges |
| Index Page Reorganization Attempts (Attempts) | The number of index page reorganization attempts |
| Index Page Reorganization Successes | The number of successful index page reorganizations |
| Index Page Splits | The number of index page splits |
| Index Push-Down Condition Check Attempts (Indexes) | The number of Index Push-Down Condition check attempts |
| Index Push-Down Condition Matches (Indexes) | The number of Index Push-Down Conditions with a match |
| Index Push-Down Condition No Matches (Indexes) | The number of Index Push-Down Conditions with no match |
| Index Push-Down Conditions Out Of Range (Indexes) | The number of Index Push-Down Conditions out of range |
| Indexes Being Created Online (Indexes) | Number of indexes being created online |
| Indexes Waiting To Drop (Indexes) | Number of indexes waiting to be dropped after failed index creation |
| Insert And Update Commits (Transactions) | The number of transactions committed with inserts and updates |
| Instance Name | The Instance Name |
| Lock Timeouts (Locks) | The number of lock timeouts |
| Log Checkpoints (Checkpoints) | The number of checkpoints |
| Log Flush Time (Microseconds) | The time spent to flush log records |
| Log I/O Operations (Operations) | The number of log I/Os |
| Log Pending Checkpoint Writes (Checkpoints) | The pending checkpoints |
| Log Waits (Requests) | The number of log waits due to small log buffer |
| Log Write Requests (Requests) | The number of log write requests |
| Log Writes (Writes) | The number of log writes |
| LSN At Last Checkpoint | The log sequence number at last checkpoint |
| LSN Checkpoint Age | The current log sequence number value minus log sequence number at last checkpoint |
| LSN Of Last Flush | The log sequence number of Last flush |
| Master Active Loops | The number of times master thread performs its tasks when server is active |
| Master Idle Loops | The number of times master thread performs its tasks when server is idle |
| Master Purge Time (Microseconds) | The time spent by master thread to purge records |
| Master Thread Sleep Time (Seconds) | The amount of time master thread has slept |
| Maximum Connections (Connections) | The Max Connections |
| Maximum Modified LSN Age For ASYNC Preflush | The maximum log sequence number difference; when exceeded, start asynchronous preflush |
| Maximum Modified LSN Age For SYNC Preflush | The maximum log sequence number difference; when exceeded, start synchronous preflush |
| Maximum Used Connections (Connections) | The maximum number of connections that have been in use simultaneously since the server started |
| Memory Pool Size (Bytes) | Size of a memory pool InnoDB uses to store data dictionary and internal data structures in bytes |
| Memory Validation Time (Microseconds) | The time spent to do memory validation |
| Non-Locking Auto-Commit Read Only Commits (Transactions) | The number of non-locking auto-commit read-only transactions committed |
| Oldest LSN In Buffer Pool | The oldest modified block log sequence number in the buffer pool |
| OS Data Reads (Reads) | The number of reads initiated |
| OS Data Writes (Writes) | The number of writes initiated |
| OS Log fsync Writes (Writes) | The number of fsync log writes |
| OS Log Pending fsync Writes (Writes) | The number of pending fsync writes |
| OS Log Pending Writes (Writes) | The number of pending log file writes |
| OS Log Writes (Bytes) | The bytes of log written |
| OS Pending Reads (Reads) | The number of reads pending |
| OS Pending Writes (Writes) | The number of writes pending |
| OS Waits From Exclusive Latch Request (Waits) | The number of Read/Write Lock OS waits due to exclusive latch request |
| OS Waits From Shared Latch Request (Waits) | The number of Read/Write Lock OS waits due to shared latch request |
| Page Size (Bytes) | The Page Size |
| Pages Compressed (Pages) | The number of pages compressed |
| Pages Decompressed (Pages) | The number of pages decompressed |
| Pending Log Writes (Writes) | The pending log writes |
| Port | The Port |
| Purge Delete Marked Records (Rows) | The number of delete-marked rows purged |
| Purge DML Delay Time (Milliseconds) | The microseconds DML to be delayed due to purge lagging |
| Purge Invoked (Purges) | The number of times purge was invoked |
| Purge Resume Count (Purges) | The number of times purge was resumed |
| Purge Stop Count (Purges) | The number of times purge was stopped |
| Purge Undo Log Pages (Pages) | The number of undo log pages handled by the purge |
| Purge Update Existing Or External Records (Purges) | The number of purges on updates of existing records and updates on delete marked record with externally stored field |
| Read Only Transaction Commits (Transactions) | The number of read-only transactions committed |
| Read/Write Lock Spin Loop Rounds From Exclusive Latch Request (Waits) | The number of Read/Write Lock spin loop rounds due to exclusive latch request |
| Read/Write Lock Spin Loop Rounds From Shared Latch Request (Waits) | The number of Read/Write Lock spin loop rounds due to shared latch request |
| Read/Write Lock Spin Waits From Exclusive Latch Request (Waits) | The number of Read/Write Lock spin waits due to exclusive latch request |
| Read/Write Lock Spin Waits From Shared Latch Request (Waits) | The number of Read/Write Lock spin waits due to shared latch request |
| Read Write Transaction Commits (Transactions) | The number of read-write transactions committed |
| Record Lock Requests (Locks) | The number of record locks requested |
| Record Lock Waits (Locks) | The number of record locks requested |
| Record Locks (Locks) | The current number of record locks on tables |
| Record Locks Created (Locks) | The number of record locks created |
| Record Locks Removed (Locks) | The number of record locks removed from the lock queue |
| Row Lock Current Waits (Locks) | Number of row locks currently being waited for |
| Row Lock Time (Milliseconds) | Time spent in acquiring row locks |
| Row Lock Time Average (Milliseconds) | The average time to acquire a row lock |
| Row Lock Time Maximum (Milliseconds) | The maximum time to acquire a row lock |
| Row Lock Waits (Locks) | Number of times a row lock had to be waited for |
| Rows Deleted (Rows) | The number of rows deleted |
| Rows Inserted (Rows) | The number of rows inserted |
| Rows Read (Rows) | The number of rows read |
| Rows Updated (Rows) | The number of rows updated |
| Server Activity Count | The current server activity count |
| Server ID | The Identifier of the MySQL Instance |
| Server UUID | The Universally Unique Identifier of the MySQL Instance |
| SSL Client Connections (Attempts) | The number of SSL connection attempts to an SSL-enabled master |
| SSL Connection Renegotiates (Attempts) | The number of negotiates needed to establish the connection to an SSL-enabled master |
| SSL Finished Connections (Connections) | The number of successful slave connections to an SSL-enabled master |
| Table Handles Closed | The number of table handles closed |
| Table Handles Opened | The number of table handles opened |
| Table Lock Waits (Locks) | The number of record locks requested |
| Table Locks (Locks) | The number of tables locks |
| Table Locks Created (Locks) | The number of table locks created |
| Table Locks Removed (Locks) | The number of table locks removed from the lock queue |
| Table Reference Count | The number of table references |
| Tables Waiting To Drop (Tables) | Number of tables in background drop table list |
| Threads Connected (Connections) | The number of currently open connections |
| Total Allocated Memory (Bytes) | The total allocated memory |
| Transaction Rollback Segment History List Length (Transactions) | The length of the TRX_RSEG_HISTORY list |
| Transaction Rollbacks (Transactions) | The number of transactions rolled back |
| Transactions Rolled Back To Savepoint (Transactions) | The number of transactions rolled back to savepoint |
| Undo Slots Cached (Slots) | The number of undo slots cached |
| Undo Slots Used (Slots) | The number of undo slots used |
| Version | The Version |
Query
| Name | Description |
|---|---|
| Average Errors | The total number of errors produced by occurrences of the statement |
| Average Latency (Picoseconds) | The average wait time per timed occurrence of the statement |
| Average Lock Latency (Picoseconds) | The average time waiting for locks per timed occurrence of the statement |
| Average Rows Affected (Rows) | The average number of rows affected per occurrence of the statement |
| Average Rows Examined (Rows) | The average number of rows read from storage engines per occurrence of the statement |
| Average Rows Sent (Rows) | The average number of rows returned per occurrence of the statement |
| Average Rows Sorted (Rows) | The average number of rows sorted per occurrence of the statement |
| Average Sort Merge Passes (Rows) | The average number of sort merge passes per occurrence of the statement |
| Average Temporary Tables Created In-Memory (Rows) | The average number of internal in-memory temporary tables created per occurrence of the statement |
| Average Temporary Tables Created On-Disk (Rows) | The average number of internal on-disk temporary tables created per occurrence of the statement |
| Average Warnings | The average number of warnings produced by occurrences of the statement |
| Database | The default database for the statement, or 'None' if there is none |
| Error Count | The total number of errors produced by occurrences of the statement |
| Execution Count | The total number of times the statement has executed |
| First Seen | The first time at which the statement was seen |
| Last Seen | The most recent time at which the statement was seen |
| Lock Latency (Picoseconds) | The total time waiting for locks by timed occurrences of the statement |
| Maximum Latency (Picoseconds) | The maximum single wait time of timed occurrences of the statement |
| Rank | The rank of this query, according to the way queries are ordered (usually by average latency) |
| Rows Affected (Rows) | The total number of rows affected by occurrences of the statement |
| Rows Examined (Rows) | The total number of rows read from storage engines by occurrences of the statement |
| Rows Sent (Rows) | The total number of rows returned by occurrences of the statement |
| Rows Sorted (Rows) | The total number of rows sorted by occurrences of the statement |
| Sort Merge Passes (Rows) | The total number of sort merge passes by occurrences of the statement |
| SQL ID | An identifier for the query, also known as the digest |
| SQL Text | The normalized statement string |
| Temporary Tables Created In-Memory (Rows) | The total number of internal in-memory temporary tables created by occurrences of the statement |
| Temporary Tables Created On-Disk (Rows) | The total number of internal on-disk temporary tables created by occurrences of the statement |
| Total Latency (Picoseconds) | The total wait time of timed occurrences of the statement |
| Warning Count | The total number of warnings produced by occurrences of the statement |
Query Plan
| Name | Description |
|---|---|
| Plan | JSON representation of the query execution plan. |
Replication Master
| Name | Description |
|---|---|
| Auto Positioning | Whether or not auto-positioning is in use |
| Connect Retry Duration (Seconds) | The number of seconds between connect retries |
| ID | The server_id value from the master |
| Last I/O Error Message | The error message of the most recent error that caused the I/O thread to stop |
| Last I/O Error Number | The error number of the most recent error that caused the I/O thread to stop. 0 means no error has been recorded |
| Last I/O Error Timestamp | A timestamp in YYMMDD HH:MM:SS format that shows when the most recent I/O error took place |
| Last SQL Error Message | The error message of the most recent error that caused the SQL thread to stop |
| Last SQL Error Number | The error number of the most recent error that caused the SQL thread to stop. 0 means no error has been recorded |
| Last SQL Error Timestamp | A timestamp in YYMMDD HH:MM:SS format that shows when the last SQL error occurred |
| Master Host | The master host that the slave is connected to |
| Master Port | The port used to connect to the master |
| Master Retry Count (Attempts) | The number of times the slave can attempt to reconnect to the master in the event of a lost connection |
| Master SSL Allowed | Whether or not an SSL connection to the master is permitted. This value will report as 'Ignored' if an SSL connection is permitted but the slave server does not have SSL support enabled |
| Master SSL Verify Server Certificate | Whether or not SSL server certificates must be validated |
| Master User | The user name of the account used to connect to the master |
| Master UUID | The Universally Unique Identifier from the master |
| Slave I/O Running | Whether the I/O thread is started and has connected successfully to the master |
| Slave I/O State | A copy of the State field of the SHOW PROCESSLIST output for the slave I/O thread. This tells you what the thread is doing: trying to connect to the master, waiting for events from the master, reconnecting to the master, and so on |
| Slave SQL Running | Whether the SQL thread is started |
| Slave SQL Running State | The state of the SQL thread |
| SQL Delay (Seconds) | The number of seconds that the slave must lag the master |
Replication Slave
| Name | Description |
|---|---|
| Master Host | The host name of the slave server as specified on the slave with the --report-host option |
| Master ID | The unique server ID of the master server that the slave server is replicating from |
| Master Port | The port on the master to which the slave server is listening, as specified on the slave with the --report-port option |
| Server ID | The server_id value from the slave |
| Slave UUID | The Universally Unique Identifier from the slave |
Table
| Name | Description |
|---|---|
| Data Size (Bytes) | The size of the table's data |
| Database Name | The name of the database that contains this table |
| Delete Average Wait Time (Picoseconds) | The average wait time of deletes |
| Delete Maximum Wait Time (Picoseconds) | The maximum wait time of deletes |
| Delete Minimum Wait Time (Picoseconds) | The minimum wait time of deletes |
| Delete Total Wait Time (Picoseconds) | The total wait time of deletes |
| Fetch Average Wait Time (Picoseconds) | The average wait time of fetches |
| Fetch Maximum Wait Time (Picoseconds) | The maximum wait time of fetches |
| Fetch Minimum Wait Time (Picoseconds) | The minimum wait time of fetches |
| Fetch Total Wait Time (Picoseconds) | The total wait time of fetches |
| Fully Scanned Count | The number of times the table has been fully scanned |
| Index Size (Bytes) | The size of the table's indexes |
| Insert Average Wait Time (Picoseconds) | The average wait time of inserts |
| Insert Maximum Wait Time (Picoseconds) | The maximum wait time of inserts |
| Insert Minimum Wait Time (Picoseconds) | The minimum wait time of inserts |
| Insert Total Wait Time (Picoseconds) | The total wait time of inserts |
| I/O Miscellaneous Latency (Picoseconds) | The total wait time of miscellaneous I/O requests for the table |
| I/O Miscellaneous Requests (Requests) | The total number of miscellaneous I/O requests for the table |
| I/O Read (Bytes) | The total number of bytes read from the table |
| I/O Read Latency (Picoseconds) | The total wait time of reads from the table |
| I/O Read Requests (Requests) | The total number of read requests for the table |
| I/O Write (Bytes) | The total number of bytes written to the table |
| I/O Write Latency (Picoseconds) | The total wait time of writes to the table |
| I/O Write Requests (Requests) | The total number of write requests for the table |
| Read Average Wait Time (Picoseconds) | The average wait time of reads |
| Read Maximum Wait Time (Picoseconds) | The maximum wait time of reads |
| Read Minimum Wait Time (Picoseconds) | The minimum wait time of reads |
| Read Total Wait Time (Picoseconds) | The total wait time of reads |
| Read/Write Average Wait Time (Picoseconds) | The average wait time of reads and writes |
| Read/Write Maximum Wait Time (Picoseconds) | The maximum wait time of reads and writes |
| Read/Write Minimum Wait Time (Picoseconds) | The minimum wait time of reads and writes |
| Read/Write Total Wait Time (Picoseconds) | The total wait time of reads and writes |
| Rows Deleted | The number of rows deleted |
| Rows Fetched | The number of rows fetched |
| Rows Inserted | The number of rows inserted |
| Rows Read | The number of rows read |
| Rows Read and Written | The total number of rows read and written |
| Rows Updated | The number of rows updated |
| Rows Written | The number of rows written |
| Table Name | The name of the table |
| Total Size (Bytes) | The total size of the table |
| Update Average Wait Time (Picoseconds) | The average wait time of updates |
| Update Maximum Wait Time (Picoseconds) | The maximum wait time of updates |
| Update Minimum Wait Time (Picoseconds) | The minimum wait time of updates |
| Update Total Wait Time (Picoseconds) | The total wait time of updates |
| Write Average Wait Time (Picoseconds) | The average wait time of writes |
| Write Maximum Wait Time (Picoseconds) | The maximum wait time of writes |
| Write Minimum Wait Time (Picoseconds) | The minimum wait time of writes |
| Write Total Wait Time (Picoseconds) | The total wait time of writes |
Tablespace
| Name | Description |
|---|---|
| Compression | The type of compression set for the tablespace |
| Current File Size (Bytes) | The actual size of the file, which is the amount of space allocated on disk |
| File Format | The tablespace file format. The data in this field is interpreted from the tablespace flags information that resides in the .ibd file |
| Flag Settings | This value provides bit level information about tablespace format and storage characteristics |
| ID | The tablespace ID |
| Maximum File Size (Bytes) | The apparent size of the file, which represents the maximum size of the file, uncompressed |
| Name | The database and table name |
| Page Size (Bytes) | The tablespace page size. The data in this field is interpreted from the tablespace flags information that resides in the .ibd file |
| Row Format | The tablespace row format (Compact or Redundant, Dynamic, or Compressed). The data in this field is interpreted from the tablespace flags information that resides in the .ibd file |
| Space Type | The type of tablespace. Possible values include General (for InnoDB general tablespaces created using CREATE TABLESPACE) and Single (for InnoDB file-per-table tablespaces) |
| Zip Page Size (Bytes) | The tablespace zip page size. The data in this field is interpreted from the tablespace flags information that resides in the .ibd file |
Updated almost 5 years ago