Bindplane

The Bindplane Developer Hub

Welcome to the Bindplane developer hub. You'll find comprehensive guides and documentation to help you start working with Bindplane as quickly as possible, as well as support if you get stuck. Let's jump right in!

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 'username'@'%' IDENTIFIED WITH mysql_native_password BY 'tmppassword';
GRANT SELECT,EXECUTE ON sys.* TO 'username'@'%';
GRANT REPLICATION CLIENT, REPLICATION SLAVE, PROCESS, SHOW DATABASES, SELECT ON *.* TO 'username'@'%';
FLUSH PRIVILEGES;

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