MySQL is an open source relational database management system (RDBMS) based on Structured Query Language (SQL).

Prerequisites

  1. Create a user.
CREATE USER '<Username>'@'localhost' IDENTIFIED BY '<Password>';
  1. Grant minimum privileges to the user.
GRANT REPLICATION CLIENT ON *.* TO '<Username>'@'localhost';
 
GRANT PROCESS ON *.* TO '<Username>'@'localhost';
 
GRANT SELECT ON performance_schema.* TO '<Username>'@'localhost';
 
FLUSH PRIVILEGES;

@‘localhost’ is only for local connections. Use hostname/IP for remote connections.

  1. Use the username and password to monitor MySQL.

  2. For Virtual Machines, install the Linux Agent.

Configuring the credentials

Configure the credentials in the directory /opt/opsramp/agent/conf/app.d/creds.yaml

mysql:
- name: mysql
  user: <username>
  pwd: <Password>
  encoding-type: plain
  labels:
    key1: val1
    key2: val2

Configuring the application

Virtual machine

Configure the application in the directory /opt/opsramp/agent/conf/app/discovery/auto-detection.yaml

- name: mysql
  instance-checks:
    service-check:
      - mysql
    process-check:
      - mysql
    port-check:
      - 3306

Docker environment

Configure the application in the directory /opt/opsramp/agent/conf/app/discovery/auto-container-detection.yaml

- name: mysql
  container-checks:
    image-check:
      - mysql
    port-check:
      - 3306

Kubernetes environment

Configure the application in config.yaml

- name: mysql
  container-checks:
    image-check:
      - mysql
    port-check:
      - 3306

Validate

Go to Resources under the Infrastructure tab to check if your resources are onboarded and the metrics are collected.

Metrics

OpsRamp MetricMetric Display NameUnit
mysql_performance_Qcache_inserts

Number of queries added to the query cache
Performance Qcache InsertsQueries / second
mysql_performance_Table_locks_waited

Total number of times a request for a table lock could not be granted immediately and a wait was needed
Performance Table Locks WaitedWait
mysql_myisam_Key_buffer_bytes_used

MyISAM key buffer bytes used
MyISAM Key Buffer Bytes Usedbytes
mysql_performance_Open_tables

Number of tables that are open.
Performance Open TablesTables
mysql_net_Max_used_connections

Maximum number of connections that have been in use simultaneously since the server started
Net Max Used ConnectionsConnections
mysql_performance_Com_delete_multi

Rate of delete-multi statements
Performance DeleteMulti StatementsQueries / second
mysql_performance_Slow_queries

Rate of queries that have taken more than long_query_time
Performance Slow QueriesQueries / second
mysql_myisam_Key_buffer_bytes_unflushed

MyISAM key buffer bytes unflushed
MyISAM Key Buffer Bytes Unflushedbytes
mysql_performance_Bytes_sent

Number of bytes sent to all clients
Performance Bytes Sentbytes / second
mysql_performance_Com_replace

Rate of replace statements
Performance Replace StatementsQueries / second
mysql_performance_Com_delete

Rate of delete statements
Performance Delete StatementsQueries / second
mysql_performance_Table_locks_waited_rate

Total number of times a request for a table lock could not be granted immediately and a wait was needed
Performance Table Locks Waited RateWaits / second
mysql_performance_Threads_running

Number of threads that are not sleeping
Performance Threads RunningThreads
mysql_performance_Queries

Rate of queries
Performance QueriesQueries / second
mysql_net_Aborted_connects

Number of failed attempts to connect to the MySQL server
Net Aborted ConnectsConnections / second
mysql_performance_Com_load

Rate of load statements
Performance Load StatementsQueries / second
mysql_performance_Qcache_lowmem_prunes

Number of queries that were deleted from the query cache because of low memory
Performance Qcache LowMem PrunesQueries / second
mysql_performance_Created_tmp_tables

Rate of internal temporary tables created by second by the server while executing statements
Performance Created Tmp TablesTables / second
mysql_performance_Created_tmp_disk_tables

Rate of internal on-disk temporary tables created by second by the server while executing statements
Performance Created Tmp Disk TablesTables / second
mysql_myisam_Key_reads

Number of physical reads of a key block from disk into the MyISAM key cache. If Key_reads is large, then your key_buffer_size value is probably too small. The cache miss rate can be calculated as Key_reads/Key_read_requests.
MyISAM Key ReadsReads / second
mysql_performance_Com_replace_select

Rate of replace-select statements
Performance ReplaceSelect StatementsQueries / second
mysql_performance_Com_select

Rate of select statements
Performance Select StatementsQueries / second
mysql_performance_Bytes_received

Number of bytes received from all clients
Performance Bytes Receivedbytes / second
mysql_myisam_Key_write_requests

Number of requests to write a key block to the MyISAM key cache
MyISAM Key Write RequestsWrites / second
mysql_myisam_Key_writes

Number of physical writes of a key block from the MyISAM key cache to disk
MyISAM Key WritesWrites / second
mysql_performance_Com_insert

Rate of insert statements
Performance Insert StatementsQueries / second
mysql_performance_Threads_connected

Number of currently open connections
Performance Threads ConnectedConnections
mysql_performance_Com_update_multi

Rate of update-multi statement
Performance UpdateMulti StatementsQueries / second
mysql_performance_Com_update

Rate of update statements
Performance Update StatementsQueries / second
mysql_net_Connections

Rate of connections to the server
Net ConnectionsConnections / second
mysql_performance_Com_insert_select

Rate of insert-select statements
Performance InsertSelect StatementsQueries / second
mysql_performance_Qcache_hits

Rate of query cache hits
Performance Qcache HitsHits / second
mysql_performance_Questions

Rate of statements executed by the server
Performance QuestionsQueries / second
mysql_performance_Created_tmp_files

Rate of temporary files created by second
Performance Created Tmp FilesFiles / second
mysql_myisam_Key_read_requests

Number of requests to read a key block from the MyISAM key cache
MyISAM Key Read RequestsReads / second
mysql_performance_Open_files

Number of open files
Performance Open FilesFiles
mysql_net_Aborted_clients

Number of connections that were aborted because the client died without closing the connection properly
Net Aborted ClientsConnections / second
mysql_performance_query_cache_size

Amount of memory allocated for caching query results
Performance Query Cache Sizebytes
mysql_performance_table_open_cache

Number of open tables for all threads. Increasing this value increases the number of file descriptors that mysqld requires
Performance Table Open CacheTables
mysql_performance_Key_cache_utilization

Key cache utilization ratio
Performance Key Cache UtilizationFraction
mysql_performance_thread_cache_size

How many threads the server should cache for reuse. When a client disconnects, the client's threads are put in the cache if there are fewer than thread_cache_size threads there
Performance Thread Cache Sizebytes
mysql_myisam_key_buffer_size

Size of the buffer used for index blocks
MyISAM Key Buffer Sizebytes
mysql_net_max_connections

Maximum permitted number of simultaneous client connections
Net Max ConnectionsConnections
mysql_Innodb_buffer_pool_read_requests

Number of logical read requests
InnoDB Buffer Pool Read RequestsReads / second
mysql_Innodb_Mutex_spin_waits

Rate of InnoDB semaphore/mutex spin waits for the internal sync array
InnoDB Mutex Spin WaitsEvents / second
mysql_Innodb_row_lock_waits

Number of times per second a row lock had to be waited for
InnoDB Row Lock WaitsEvents / second
mysql_Innodb_row_lock_time

Rate of time spent in acquiring row locks for InnoDB tables
InnoDB Row Lock Timemilliseconds / second
mysql_Innodb_buffer_pool_bytes_dirty

Total current number of bytes held in dirty pages in the InnoDB buffer pool
InnoDB Buffer Pool Bytes Dirtybytes
mysql_Innodb_current_row_locks

Number of current row locks
InnoDB Current Row LocksLocks
mysql_Innodb_buffer_pool_bytes_used

Number of used bytes in the InnoDB Buffer Pool
InnoDB Buffer Pool Bytes Usedbytes
mysql_Innodb_data_writes

Rate of data writes
InnoDB Data WritesWrites / second
mysql_Innodb_Mutex_spin_rounds

Rate of InnoDB semaphore/mutex spin rounds for the internal sync array
InnoDB Mutex Spin RoundsEvents / second
mysql_Innodb_buffer_pool_bytes_total

Total number of bytes in the InnoDB Buffer Pool
InnoDB Buffer Pool Bytes Totalbytes
mysql_Innodb_os_log_fsyncs

Rate of fsync writes to the log file
InnoDB OS Log Fsyncs WritesWrites / second
mysql_Innodb_row_lock_current_waits

Number of row locks currently being waited for by operations on InnoDB tables
InnoDB Row Lock Current WaitsLocks
mysql_Innodb_buffer_pool_bytes_free

Number of free bytes in the InnoDB Buffer Pool
InnoDB Buffer Pool Bytes Freebytes
mysql_Innodb_data_reads

Rate of data reads
InnoDB Data ReadsReads / second
mysql_Innodb_buffer_pool_utilization

Utilization of the InnoDB Buffer Pool
InnoDB Buffer Pool UtilizationFraction
mysql_Innodb_buffer_pool_reads

Number of logical reads that InnoDB could not satisfy from the buffer pool, and had to read directly from disk
InnoDB Buffer Pool ReadsReads / second
mysql_Innodb_Mutex_OS_waits

Rate of InnoDB semaphore/mutex waits yielded to the OS.
InnoDB Mutex OS WaitsEvents / second
mysql_Binlog_disk_use

Total binary log file size
BinLog Disk Usebytes
mysql_Binlog_cache_disk_use

Number of transactions that used the temporary binary log cache but that exceeded the value of binlog_cache_size and used a temporary file to store statements from the transaction
BinLog Cache Disk UseTransactions
mysql_performance_Handler_rollback

Number of internal ROLLBACK statements
Performance Handler RollbackOperations / second
mysql_performance_Handler_delete

Number of internal DELETE statements
Performance Handler DeleteOperations / second
mysql_performance_Qcache_not_cached

Number of noncached queries (not cacheable, or not cached due to the query_cache_type setting)
Performance Qcache Not CachedQueries / second
mysql_performance_Qcache_total_blocks

Total number of blocks in the query cache
Performance Qcache Total BlocksBlocks
mysql_performance_Select_range

Number of joins that used ranges on the first table. This is normally not a critical issue even if the value is quite large
Performance Select RangeOperations / second
mysql_performance_Handler_read_prev

Number of internal READ_PREV statements
Performance Handler Read PrevOperations / second
mysql_performance_Sort_rows

Number of sorted rows
Performance Sort RowsOperations / second
mysql_performance_Qcache_free_memory

Amount of free memory for the query cache
Performance Qcache Free Memorybytes
mysql_performance_Handler_read_rnd_next

Number of internal READ_RND_NEXT statements
Performance Handler Read Rnd NextOperations / second
mysql_performance_Select_range_check

Number of joins without keys that check for key usage after each row. If this is not 0, you should carefully check the indexes of your tables
Performance Select Range CheckOperations / second
mysql_performance_Select_scan

Number of joins that did a full scan of the first table
Performance Select ScanOperations / second
mysql_performance_Qcache_free_blocks

Number of free memory blocks in the query cache
Performance Qcache Free BlocksBlocks
mysql_performance_Table_locks_immediate_rate

Number of times a request for a table lock could be granted immediately
Performance Table Locks Granted Immediate RateLocksGranted / second
mysql_performance_Handler_prepare

Number of internal PREPARE statements
Performance Handler PrepareOperations / second
mysql_performance_Opened_tables

Number of tables that have been opened. If Opened_tables is big, your table_open_cache value is probably too small
Performance Opened TablesTables / second
mysql_performance_Handler_read_first

Number of internal READ_FIRST statements
Performance Handler Read FirstOperations / Second
mysql_performance_Sort_merge_passes

Number of merge passes that the sort algorithm has had to do. If this value is large, you should consider increasing the value of the sort_buffer_size system variable
Performance Sort Merge PassesOperations / second
mysql_performance_Select_full_join

Number of joins that perform table scans because they do not use indexes. If this value is not 0, you should carefully check the indexes of your tables
Performance Select Full JoinOperations / second
mysql_performance_Handler_read_key

Number of internal READ_KEY statements
Performance Handler Read KeyOperations / second
mysql_performance_Handler_read_next

Number of internal READ_NEXT statements
Performance Handler Read NextOperations / second
mysql_performance_Threads_cached

Number of threads in the thread cache
Performance Threads CachedThreads
mysql_performance_Table_locks_immediate

Number of times a request for a table lock could be granted immediately
Performance Table Locks Granted ImmediateLocksGranted / second
mysql_performance_Threads_created

Number of threads created to handle connections. If Threads_created is big, you may want to increase the thread_cache_size value
Performance Threads CreatedThreads
mysql_Binlog_cache_use

Number of transactions that used the binary log cache
BinLog Cache UseTransactions
mysql_performance_Sort_range

Number of sorts that were done using ranges
Performance Sort RangeOperations / second
mysql_performance_Handler_read_rnd

Number of internal READ_RND statements
Performance Handler Read RndOperations / second
mysql_performance_Handler_update

Number of internal UPDATE statements
Performance Handler UpdateOperations / second
mysql_performance_Qcache_queries_in_cache

Number of queries registered in the query cache
Performance Qcache Queries In CacheQueries
mysql_performance_Select_full_range_join

Number of joins that used a range search on a reference table
Performance Select Full Range JoinOperations / second
mysql_performance_Sort_scan

Number of sorts that were done by scanning the table
Performance Sort ScanOperations / second
mysql_performance_Handler_write

Number of internal WRITE statements
Performance Handler WriteOperations / second
mysql_performance_Handler_commit

Number of internal COMMIT statements
Performance Handler CommitOperations / second
mysql_performance_Table_open_cache_hits

Number of hits for open tables cache lookups
Performance Table Open Cache HitsHits / second
mysql_performance_Table_open_cache_misses

Number of misses for open tables cache lookups
Performance Table Open Cache MissesMisses / second
mysql_Innodb_os_log_pending_fsyncs

Number of pending InnoDB log fsync (sync-to-disk) requests
InnoDB OS Log Pending FsyncsOperations
mysql_Innodb_s_lock_spin_waits

Number of shared (read) semaphore spin waits within the InnoDB sync array
InnoDB S Lock Spin WaitsWaits / second
mysql_Innodb_hash_index_cells_used

Number of used cells of the adaptive hash index
InnoDB Hash Index Cells UsedCells
mysql_Innodb_pending_buffer_pool_flushes

As shown in the FILE I/O section of the SHOW ENGINE INNODB STATUS output
InnoDB Pending Buffer Pool FlushesFlushes
mysql_Innodb_current_transactions

Current InnoDB transactions
InnoDB Current TransactionsTransactions
mysql_Innodb_queries_queued

As shown in the FILE I/O section of the SHOW ENGINE INNODB STATUS output
InnoDB Queries QueuedQueries
mysql_Innodb_tables_in_use

InnoDB Tables In Use
InnoDB Tables In UseTables
mysql_Innodb_pending_ibuf_aio_reads

As shown in the FILE I/O section of the SHOW ENGINE INNODB STATUS output
InnoDB Pending Ibuf AIO ReadsReads
mysql_Innodb_pages_written

Number of InnoDB pages written
InnoDB Pages WrittenPages / second
mysql_Innodb_log_waits

Number of times the log buffer was too small and a wait was required for it to be flushed before continuing
InnoDB Log WaitsWaits / second
mysql_Innodb_buffer_pool_wait_free

When InnoDB needs to read or create a page and no clean pages are available, InnoDB flushes some dirty pages first and waits for that operation to finish. This counter counts instances of these waits
InnoDB Buffer Pool Wait FreeWaits
mysql_Innodb_OS_file_fsyncs

Rate of fsync() operations performed by InnoDB
InnoDB OS File FsyncsOperations / second
mysql_Innodb_lsn_flushed

Flushed up to log sequence number as shown in the LOG section of the SHOW ENGINE INNODB STATUS output
InnoDB Lsn Flushed
mysql_Innodb_ibuf_size

Number of pages used within the InnoDB secondary index insert buffer
InnoDB Ibuf SizePages
mysql_Innodb_buffer_pool_pages_data

Number of pages in the InnoDB buffer pool containing data. Number includes both dirty and clean pages
InnoDB Buffer Pool Pages DataPages
mysql_Innodb_s_lock_spin_rounds

Number of shared (read) semaphore spin rounds within the InnoDB sync array
InnoDB S Lock Spin RoundsRounds / second
mysql_Innodb_rows_read

Number of rows read from InnoDB tables
InnoDB Rows ReadRows / second
mysql_Innodb_lsn_current

Current redo log sequence number within InnoDB
InnoSB Lsn Current
mysql_Innodb_x_lock_spin_rounds

Number of exclusive (write) semaphore spin rounds within the InnoDB sync array
InnoDB X Lock Spin RoundsRounds / second
mysql_Innodb_lsn_Last_checkpoint

Log sequence number last checkpoint as shown in the LOG section of the SHOW ENGINE INNODB STATUS output
InnoDB Lsn Last Checkpoint
mysql_Innodb_os_log_pending_writes

Number of pending InnoDB log writes
InnoDB OS Log Pending WritesWrites
mysql_Innodb_mem_recovery_system

As shown in the BUFFER POOL AND MEMORY section of the SHOW ENGINE INNODB STATUS output
InnoDB Mem Recovery System
mysql_Innodb_s_lock_OS_waits

Number of shared (read) semaphore waits yielded to the OS by InnoDB
InnodDB S Lock OS WaitsWaits / second
mysql_Innodb_buffer_pool_pages_dirty

Current number of dirty pages in the InnoDB buffer pool
InnoDB Buffer Pool Pages DirtyPages
mysql_Innodb_mem_total

Total memory allocated for the InnoDB buffer pool
InnoDB Mem Totalbytes
mysql_Innodb_pending_aio_sync_ios

As shown in the FILE I/O section of the SHOW ENGINE INNODB STATUS output
InnoDB Pending AIO Sync IOS
mysql_Innodb_ibuf_merged

InnoDB Ibuf merged
InnoDB Ibuf MergedMerges / second
mysql_Innodb_queries_inside

As shown in the FILE I/O section of the SHOW ENGINE INNODB STATUS output
InnoDB Queries InsideQueries
mysql_Innodb_mem_lock_system

As shown in the BUFFER POOL AND MEMORY section of the SHOW ENGINE INNODB STATUS output
InnoDB Mem Lock System
mysql_Innodb_pending_log_writes

Total number of writes pending to the InnoDB redo logs
InnoDB Pending Log WritesWrites
mysql_Innodb_Pages_created

Number of InnoDB pages created
InnoDB Pages CreatedPages / second
mysql_Innodb_buffer_pool_pages_free

Number of free pages in the InnoDB buffer pool
InnoDB Buffer Pool Pages FreePages
mysql_Innodb_Hash_index_cells_total

Total number of cells of the adaptive hash index
InnoDB Hash Index Cells TotalCells
mysql_Innodb_ibuf_merged_inserts

Rate of inserts to the InnoDB secondary index insert buffer
InnoDB Ibuf Merged InsertsOperations / second
mysql_Innodb_dblwr_pages_written

Number of pages written per second to the doublewrite buffer
InnoDB Dblwr Pages WrittenPages / second
mysql_Innodb_lock_structs

Total number of lock structs in use by all transactions within InnoDB
InnoDB Lock StructsLocks / second
mysql_Innodb_rows_updated

Number of rows updated in InnoDB tables
InnoDB Rows UpdatedRows / second
mysql_Innodb_dblwr_writes

Number of doublewrite operations performed per second
InnoDB Dblwr Writesbytes / second
mysql_Innodb_active_transactions

InnoDB active transactions
InnoDB Active TransactionsTransactions
mysql_Innodb_ibuf_merged_delete_marks

Rate of deleted records merged by change buffering
InnoDB Ibuf Merged Delete MarksOperations / second
mysql_Innodb_data_read

Amount of data read per second
InnoDB Data Readbytes / second
mysql_Innodb_buffer_pool_read_ahead_evicted

Number of pages read into the InnoDB buffer pool by the read-ahead background thread that were subsequently evicted without having been accessed by queries
InnoDB Buffer Pool Read Ahead EvictedPages / second
mysql_Innodb_mem_additional_pool

Total memory allocated for the InnoDB additional pool
InnoDB Mem Additional Poolbytes
mysql_Innodb_History_list_length

Number of transactions that currently have undo space allocated to them (unpurged)
InnoDB History List LengthTransactions
mysql_Innodb_data_pending_fsyncs

Current number of pending fsync() operations
InnoDB Data Pending FsyncsOperations
mysql_Innodb_OS_file_writes

Rate of file writes performed by write threads within InnoDB
InnoDB OS File WritesWrites / second
mysql_Innodb_locked_transactions

Total number of transactions waiting for row locks within InnoDB
InnoDB Locked TransactionsTransactions
mysql_Innodb_Pending_normal_aio_writes

As shown in the FILE I/O section of the SHOW ENGINE INNODB STATUS output
InnoDB Pending Normal AIO WritesWrites
mysql_Innodb_ibuf_merges

InnoDB Ibuf merges
InnoDB Ibuf Merges
mysql_Innodb_mem_Adaptive_hash

As shown in the BUFFER POOL AND MEMORY section of the SHOW ENGINE INNODB STATUS output
InnoDB Mem Adaptive Hashbytes
mysql_Innodb_mem_Page_hash

As shown in the BUFFER POOL AND MEMORY section of the SHOW ENGINE INNODB STATUS output
InnoDB Mem Page Hash
mysql_Innodb_data_pending_reads

Current number of pending reads
InnoDB Data Pending ReadsReads
mysql_Innodb_pending_checkpoint_writes

Total number of currently pending checkpoint writes within InnoDB
InnoDB Pending Checkpoint WritesWrites
mysql_Innodb_Buffer_pool_pages_total

Total size of the InnoDB buffer pool
InnoDB Buffer Pool Pages TotalPages
mysql_Innodb_data_written

Amount of data written per second
InnoDB Data Writtenbytes / second
mysql_Innodb_buffer_pool_read_ahead

Number of pages read into the InnoDB buffer pool by the read-ahead background thread
InnoDB Buffer Pool Read AheadPages / second
mysql_Innodb_semaphore_wait_time

InnoDB semaphore wait time
InnoDB Semaphore Wait Timeseconds
mysql_Innodb_buffer_pool_data

Total number of bytes in the InnoDB buffer pool containing data. The number includes both dirty and clean pages
InnoDB Buffer Pool Databytes
mysql_Innodb_buffer_pool_read_ahead_rnd

Number of random read-aheads initiated by InnoDB. This happens when a query scans a large portion of a table but in random order
InnoDB Buffer Pool Read Ahead RndOperations
mysql_Innodb_semaphore_waits

InnoDB semaphore waits
InnoDB Semaphore Waits
mysql_Innodb_log_writes

Number of physical writes to the InnoDB redo log file
InnoDB Log WritesWrites / second
mysql_Innodb_OS_file_reads

Rate of files reads performed by read threads within InnoDB
InnoDB OS File ReadsReads / second
mysql_Innodb_ibuf_merged_deletes

Total number of times the InnoDB secondary index delete buffer was merged to the InnoDB datafiles
InnoDB Ibuf Merged DeletesOperations / second
mysql_Innodb_mem_thread_hash

Checkpoint age as shown in the LOG section of the SHOW ENGINE INNODB STATUS output
InnoDB Mem Thread Hash
mysql_Innodb_log_write_requests

Number of write requests for the InnoDB redo log
InnoDB Log Write RequestsWrites / second
mysql_Innodb_mem_dictionary

As shown in the BUFFER POOL AND MEMORY section of the SHOW ENGINE INNODB STATUS output
InnoDB Mem Dictionarybytes
mysql_Innodb_Pending_normal_aio_reads

As shown in the FILE I/O section of the SHOW ENGINE INNODB STATUS output
InnoDB Pending Normal AIO ReadsReads
mysql_Innodb_ibuf_free_list

Insert buffer free list, as shown in the INSERT BUFFER AND ADAPTIVE HASH INDEX section of the SHOW ENGINE INNODB STATUS output
InnoDB Ibuf Free List
mysql_Innodb_x_lock_spin_waits

Number of exclusive (write) semaphore spin waits within the InnoDB sync array
InnoDB X lock Spin WaitsWaits / second
mysql_Innodb_os_log_written

Number of bytes written to the InnoDB log
InnoDB OS Log Writtenbytes / second
mysql_Innodb_x_lock_OS_waits

Number of exclusive (write) semaphore waits yielded to the OS by InnoDB
InnoDB X Lock OS WaitsWaits / second
mysql_Innodb_pages_read

Number of InnoDB pages read
InnoDB Pages ReadPages / second
mysql_Innodb_checkpoint_age

Checkpoint age as shown in the LOG section of the SHOW ENGINE INNODB STATUS output
InnoDB Checkpoint Age
mysql_Innodb_buffer_pool_write_requests

Number of writes done to the InnoDB buffer pool
InnoDB Buffer Pool Write RequestsWrites / second
mysql_Innodb_buffer_pool_pages_flushed

Number of requests to flush pages from the InnoDB buffer pool
InnoDB Buffer Pool Pages FlushedPages / second
mysql_Innodb_Pending_log_flushes

As shown in the FILE I/O section of the SHOW ENGINE INNODB STATUS output
InnoDB Pending Log FlushesFlushes
mysql_Innodb_rows_inserted

Number of rows inserted into InnoDB tables
InnoDB Rows InsertedRows / second
mysql_Innodb_ibuf_segment_size

Total size, in pages, of the InnoDB secondary index insert buffer
InnoDB Ibuf Segment SizePages
mysql_Innodb_rows_deleted

Number of rows deleted from InnoDB tables
InnoDB Rows DeletedRows / second
mysql_Innodb_read_views

As shown in the FILE I/O section of the SHOW ENGINE INNODB STATUS output
InnoDB Read Views
mysql_Innodb_data_fsyncs

Number of fsync() operations per second
InnoDB Data FsyncsOperations / second
mysql_Innodb_data_pending_writes

Current number of pending writes
InnoDB Data Pending WritesWrites
mysql_Innodb_mem_file_system

As shown in the BUFFER POOL AND MEMORY section of the SHOW ENGINE INNODB STATUS output
InnoDB Mem File System
mysql_Innodb_pending_aio_log_ios

As shown in the FILE I/O section of the SHOW ENGINE INNODB STATUS output
InnoDB Pending AIO Log IOS
mysql_Innodb_locked_tables

InnoDB tables locked
InnoDB Locked TablesTables
mysql_galera_wsrep_flow_control_paused

Shows the fraction of the time, since FLUSH STATUS was last called, that the node paused due to Flow Control
Galera Wsrep Flow Control PausedFraction
mysql_galera_wsrep_cert_deps_distance

Shows the average distance between the lowest and highest sequence number, or seqno, values that the node can possibly apply in parallel
Galera Wsrep Cert Deps Distance
mysql_galera_wsrep_local_recv_queue_avg

Shows the average size of the local received queue since the last status query
Galera Wsrep Local Recv Queue Avg
mysql_galera_wsrep_cluster_size

Current number of nodes in the Galera cluster
Galera Wsrep Cluster SizeNodes
mysql_galera_wsrep_local_send_queue_avg

Show an average for the send queue length since the last FLUSH STATUS query
Galera Wsrep Local Send Queue Avg
mysql_performance_query_run_time_avg

Avg query response time per schema
Performance Query Run Time Avgmicroseconds
mysql_performance_digest_95th_percentile_avg_us

Query response time 95th percentile per schema
Performance Digest 95th Percentile Avg USmicroseconds
mysql_info_schema_size

Size of schemas
Info Schema Sizemegabytes
mysql_replication_slaves_connected

Number of slaves connected to a replication master
Replication Slaves ConnectedSlaves
mysql_replication_Seconds_Behind_Master

Lag between the master and the slave
Replication Seconds Behind Masterseconds
mysql_performance_Qcache_utilization_instant

Percentage of the query cache memory being used at this instant (delta)
Performance Qcache Utilization Instantpercent
mysql_performance_Qcache_utilization

Percentage of the query cache memory currently being used
Performance Qcache Utilizationpercent
mysql_performance_Opened_files

Number of files that have been opened only with my_open() function
Performance Opened FilesFiles
mysql_performance_Open_table_definitions

Number of cached .frm files. These files store the information of table structure in it
Performance Open Table DefinitionsFiles
mysql_performance_Opened_table_definitions

Number of .frm files that have been cached. These files store the information of table structure in it
Performance Opened Table DefinitionsFiles
mysql_performance_Com_call_procedure

Number of call-procedure statements
Performance CallProcedure StatementsQueries / second
mysql_performance_Handler_read_last

Number of times the last entry in an index was read
Performance Handler Read LastReads / second
mysql_Binlog_stmt_cache_disk_use

Number of non-transaction statements that used the binary log statement cache but that exceeded the value of binlog_stmt_cache_size and used a temporary file to store those statements
BinLog Stmt Cache Disk Use
mysql_performance_Uptime

Number of seconds that the server has been up
Performance Uptimeseconds
mysql_Innodb_io_capacity

Limit on I/O activity for XtraDB/InnoDB background tasks, including merging data from the insert buffer and flushing pages.
InnoDB IO Capacity
mysql_Innodb_log_buffer_size

Size of the buffer that InnoDB uses to write to the log files on disk. The default value is 1MB for the built-in InnoDB, 8MB for InnoDB Plugin. Sensible values range
InnoDB Log Buffer Sizebytes
mysql_Innodb_flush_log_at_trx_commit

Value of innodb_use_global_flush_log_at_trx_commit determines whether this variable can be reset with a SET statement or not
InnoDB Flush Log At Trx Commit
mysql_Innodb_force_recovery

Crash recovery mode, the possible values are 0-6 : Normal Startup(0), Server Starts even if it detects a corrupt page(1), Prevent Master Thread from running(2), No Transaction Rollbacks after crash recovery(3), Prevent insert buffer merge Operations(4), Ignores undo logs-InnoDB treats incomplete Transactions as Committed(5), Ignores Redo log roll-forward in connection with recovery.(6)
InnoDB Force RecoveryMode
mysql_Innodb_log_file_size

Size of each log file in a log group. The combined size of log files must be less than 4GB. The default value is 5MB. Sensible values range from 1MB to 1/N-th of the size of the buffer pool, where N is the number of log files in the group
InnoDB Log File Sizebytes
mysql_Innodb_buffer_pool_size

Size of the memory buffer InnoDB uses to cache data and indexes of its tables. The default value is 8MB. The larger you set this value, the less disk I/O is needed to access data in tables
InnoDB Buffer Pool Sizebytes
mysql_Innodb_buffer_pool_pages_misc

Number of pages that are busy because they have been allocated for administrative overhead such as row locks or the adaptive hash index
InnoDB Buffer Pool Pages MiscPages
mysql_Innodb_Buffer_Pool_hit_rate

Buffer Pool hit rate
InnoDB Buffer Pool Hit RateFraction
mysql_Innodb_Hash_Searches

Hash Searches
InnoDB Hash SearchesSearches
mysql_Innodb_Non_Hash_Searches

Non-Hash Searches
InnoDB NonHash SearchesSearches