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

NameRequired?Description
HostRequiredThe MySQL Server to connect to.
PortThe port for communication to the MySQL Server.
UsernameRequired
PasswordRequired
SSL ConfigurationThe 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).
DatabasesComma-separated list of database(s) to monitor. Leave blank to monitor all databases.
Database TypesThis 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

NameDescription
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 NameThe 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

NameDescription
Delete Latency (Picoseconds)The total wait time of timed deletes from the index
Index NameThe name of the index
Insert Latency (Picoseconds)The total wait time of timed inserts into the index
Is UsedWhether 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 NameThe table that contains the index
Table SchemaThe schema that contains the table
Update Latency (Picoseconds)The total wait time of timed updates in the index

Instance

NameDescription
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 ProgressNumber 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 RateThe 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 PagesThe 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 WaitsThe 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 DecrementsThe number of times padding is decremented due to good compressibility
Compression Padding IncrementsThe 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 LSNThe 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 OpenThe number of files currently open
fsync() Calls Count (Calls)The number of fsync() calls
HostnameThe 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 SuccessesThe number of successful index page reorganizations
Index Page SplitsThe 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 NameThe 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 CheckpointThe log sequence number at last checkpoint
LSN Checkpoint AgeThe current log sequence number value minus log sequence number at last checkpoint
LSN Of Last FlushThe log sequence number of Last flush
Master Active LoopsThe number of times master thread performs its tasks when server is active
Master Idle LoopsThe 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 PreflushThe maximum log sequence number difference; when exceeded, start asynchronous preflush
Maximum Modified LSN Age For SYNC PreflushThe 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 PoolThe 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
PortThe 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 CountThe current server activity count
Server IDThe Identifier of the MySQL Instance
Server UUIDThe 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 ClosedThe number of table handles closed
Table Handles OpenedThe 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 CountThe 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
VersionThe Version

Query

NameDescription
Average ErrorsThe 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 WarningsThe average number of warnings produced by occurrences of the statement
DatabaseThe default database for the statement, or 'None' if there is none
Error CountThe total number of errors produced by occurrences of the statement
Execution CountThe total number of times the statement has executed
First SeenThe first time at which the statement was seen
Last SeenThe 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
RankThe 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 IDAn identifier for the query, also known as the digest
SQL TextThe 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 CountThe total number of warnings produced by occurrences of the statement

Query Plan

NameDescription
PlanJSON representation of the query execution plan.

Replication Master

NameDescription
Auto PositioningWhether or not auto-positioning is in use
Connect Retry Duration (Seconds)The number of seconds between connect retries
IDThe server_id value from the master
Last I/O Error MessageThe error message of the most recent error that caused the I/O thread to stop
Last I/O Error NumberThe 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 TimestampA timestamp in YYMMDD HH:MM:SS format that shows when the most recent I/O error took place
Last SQL Error MessageThe error message of the most recent error that caused the SQL thread to stop
Last SQL Error NumberThe error number of the most recent error that caused the SQL thread to stop. 0 means no error has been recorded
Last SQL Error TimestampA timestamp in YYMMDD HH:MM:SS format that shows when the last SQL error occurred
Master HostThe master host that the slave is connected to
Master PortThe 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 AllowedWhether 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 CertificateWhether or not SSL server certificates must be validated
Master UserThe user name of the account used to connect to the master
Master UUIDThe Universally Unique Identifier from the master
Slave I/O RunningWhether the I/O thread is started and has connected successfully to the master
Slave I/O StateA 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 RunningWhether the SQL thread is started
Slave SQL Running StateThe state of the SQL thread
SQL Delay (Seconds)The number of seconds that the slave must lag the master

Replication Slave

NameDescription
Master HostThe host name of the slave server as specified on the slave with the --report-host option
Master IDThe unique server ID of the master server that the slave server is replicating from
Master PortThe port on the master to which the slave server is listening, as specified on the slave with the --report-port option
Server IDThe server_id value from the slave
Slave UUIDThe Universally Unique Identifier from the slave

Table

NameDescription
Data Size (Bytes)The size of the table's data
Database NameThe 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 CountThe 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 DeletedThe number of rows deleted
Rows FetchedThe number of rows fetched
Rows InsertedThe number of rows inserted
Rows ReadThe number of rows read
Rows Read and WrittenThe total number of rows read and written
Rows UpdatedThe number of rows updated
Rows WrittenThe number of rows written
Table NameThe 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

NameDescription
CompressionThe 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 FormatThe tablespace file format. The data in this field is interpreted from the tablespace flags information that resides in the .ibd file
Flag SettingsThis value provides bit level information about tablespace format and storage characteristics
IDThe tablespace ID
Maximum File Size (Bytes)The apparent size of the file, which represents the maximum size of the file, uncompressed
NameThe 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 FormatThe 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 TypeThe 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