MySQL is an open source relational database management system (RDBMS) based on Structured Query Language (SQL).
Prerequisites
- Create a user.
CREATE USER '<Username>'@'localhost' IDENTIFIED BY '<Password>';
- 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;
Note: @‘localhost’ is only for local connections. Use hostname/IP for remote connections.
Use the username and password to monitor MySQL.
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 Metric | Metric Display Name | Unit | Description |
|---|---|---|---|
| mysql_performance_Qcache_inserts | Performance Qcache Inserts | Queries / second | Number of queries added to the query cache |
| mysql_performance_Table_locks_waited | Performance Table Locks Waited | Wait | Total number of times a request for a table lock could not be granted immediately and a wait was needed |
| mysql_myisam_Key_buffer_bytes_used | MyISAM Key Buffer Bytes Used | bytes | MyISAM key buffer bytes used |
| mysql_performance_Open_tables | Performance Open Tables | Tables | Number of tables that are open. |
| mysql_net_Max_used_connections | Net Max Used Connections | Connections | Maximum number of connections that have been in use simultaneously since the server started |
| mysql_performance_Com_delete_multi | Performance DeleteMulti Statements | Queries / second | Rate of delete-multi statements |
| mysql_performance_Slow_queries | Performance Slow Queries | Queries / second | Rate of queries that have taken more than long_query_time |
| mysql_myisam_Key_buffer_bytes_unflushed | MyISAM Key Buffer Bytes Unflushed | bytes | MyISAM key buffer bytes unflushed |
| mysql_performance_Bytes_sent | Performance Bytes Sent | bytes / second | Number of bytes sent to all clients |
| mysql_performance_Com_replace | Performance Replace Statements | Queries / second | Rate of replace statements |
| mysql_performance_Com_delete | Performance Delete Statements | Queries / second | Rate of delete statements |
| mysql_performance_Table_locks_waited_rate | Performance Table Locks Waited Rate | Waits / second | Total number of times a request for a table lock could not be granted immediately and a wait was needed |
| mysql_performance_Threads_running | Performance Threads Running | Threads | Number of threads that are not sleeping |
| mysql_performance_Queries | Performance Queries | Queries / second | Rate of queries |
| mysql_net_Aborted_connects | Net Aborted Connects | Connections / second | Number of failed attempts to connect to the MySQL server |
| mysql_performance_Com_load | Performance Load Statements | Queries / second | Rate of load statements |
| mysql_performance_Qcache_lowmem_prunes | Performance Qcache LowMem Prunes | Queries / second | Number of queries that were deleted from the query cache because of low memory |
| mysql_performance_Created_tmp_tables | Performance Created Tmp Tables | Tables / second | Rate of internal temporary tables created by second by the server while executing statements |
| mysql_performance_Created_tmp_disk_tables | Performance Created Tmp Disk Tables | Tables / second | Rate of internal on-disk temporary tables created by second by the server while executing statements |
| mysql_myisam_Key_reads | MyISAM Key Reads | Reads / second | 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. |
| mysql_performance_Com_replace_select | Performance ReplaceSelect Statements | Queries / second | Rate of replace-select statements |
| mysql_performance_Com_select | Performance Select Statements | Queries / second | Rate of select statements |
| mysql_performance_Bytes_received | Performance Bytes Received | bytes / second | Number of bytes received from all clients |
| mysql_myisam_Key_write_requests | MyISAM Key Write Requests | Writes / second | Number of requests to write a key block to the MyISAM key cache |
| mysql_myisam_Key_writes | MyISAM Key Writes | Writes / second | Number of physical writes of a key block from the MyISAM key cache to disk |
| mysql_performance_Com_insert | Performance Insert Statements | Queries / second | Rate of insert statements |
| mysql_performance_Threads_connected | Performance Threads Connected | Connections | Number of currently open connections |
| mysql_performance_Com_update_multi | Performance UpdateMulti Statements | Queries / second | Rate of update-multi statement |
| mysql_performance_Com_update | Performance Update Statements | Queries / second | Rate of update statements |
| mysql_net_Connections | Net Connections | Connections / second | Rate of connections to the server |
| mysql_performance_Com_insert_select | Performance InsertSelect Statements | Queries / second | Rate of insert-select statements |
| mysql_performance_Qcache_hits | Performance Qcache Hits | Hits / second | Rate of query cache hits |
| mysql_performance_Questions | Performance Questions | Queries / second | Rate of statements executed by the server |
| mysql_performance_Created_tmp_files | Performance Created Tmp Files | Files / second | Rate of temporary files created by second |
| mysql_myisam_Key_read_requests | MyISAM Key Read Requests | Reads / second | Number of requests to read a key block from the MyISAM key cache |
| mysql_performance_Open_files | Performance Open Files | Files | Number of open files |
| mysql_net_Aborted_clients | Net Aborted Clients | Connections / second | Number of connections that were aborted because the client died without closing the connection properly |
| mysql_performance_query_cache_size | Performance Query Cache Size | bytes | Amount of memory allocated for caching query results |
| mysql_performance_table_open_cache | Performance Table Open Cache | Tables | Number of open tables for all threads. Increasing this value increases the number of file descriptors that mysqld requires |
| mysql_performance_Key_cache_utilization | Performance Key Cache Utilization | Fraction | Key cache utilization ratio |
| mysql_performance_thread_cache_size | Performance Thread Cache Size | bytes | 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 |
| mysql_myisam_key_buffer_size | MyISAM Key Buffer Size | bytes | Size of the buffer used for index blocks |
| mysql_net_max_connections | Net Max Connections | Connections | Maximum permitted number of simultaneous client connections |
| mysql_Innodb_buffer_pool_read_requests | InnoDB Buffer Pool Read Requests | Reads / second | Number of logical read requests |
| mysql_Innodb_Mutex_spin_waits | InnoDB Mutex Spin Waits | Events / second | Rate of InnoDB semaphore/mutex spin waits for the internal sync array |
| mysql_Innodb_row_lock_waits | InnoDB Row Lock Waits | Events / second | Number of times per second a row lock had to be waited for |
| mysql_Innodb_row_lock_time | InnoDB Row Lock Time | milliseconds / second | Rate of time spent in acquiring row locks for InnoDB tables |
| mysql_Innodb_buffer_pool_bytes_dirty | InnoDB Buffer Pool Bytes Dirty | bytes | Total current number of bytes held in dirty pages in the InnoDB buffer pool |
| mysql_Innodb_current_row_locks | InnoDB Current Row Locks | Locks | Number of current row locks |
| mysql_Innodb_buffer_pool_bytes_used | InnoDB Buffer Pool Bytes Used | bytes | Number of used bytes in the InnoDB Buffer Pool |
| mysql_Innodb_data_writes | InnoDB Data Writes | Writes / second | Rate of data writes |
| mysql_Innodb_Mutex_spin_rounds | InnoDB Mutex Spin Rounds | Events / second | Rate of InnoDB semaphore/mutex spin rounds for the internal sync array |
| mysql_Innodb_buffer_pool_bytes_total | InnoDB Buffer Pool Bytes Total | bytes | Total number of bytes in the InnoDB Buffer Pool |
| mysql_Innodb_os_log_fsyncs | InnoDB OS Log Fsyncs Writes | Writes / second | Rate of fsync writes to the log file |
| mysql_Innodb_row_lock_current_waits | InnoDB Row Lock Current Waits | Locks | Number of row locks currently being waited for by operations on InnoDB tables |
| mysql_Innodb_buffer_pool_bytes_free | InnoDB Buffer Pool Bytes Free | bytes | Number of free bytes in the InnoDB Buffer Pool |
| mysql_Innodb_data_reads | InnoDB Data Reads | Reads / second | Rate of data reads |
| mysql_Innodb_buffer_pool_utilization | InnoDB Buffer Pool Utilization | Fraction | Utilization of the InnoDB Buffer Pool |
| mysql_Innodb_buffer_pool_reads | InnoDB Buffer Pool Reads | Reads / second | Number of logical reads that InnoDB could not satisfy from the buffer pool, and had to read directly from disk |
| mysql_Innodb_Mutex_OS_waits | InnoDB Mutex OS Waits | Events / second | Rate of InnoDB semaphore/mutex waits yielded to the OS. |
| mysql_Binlog_disk_use | BinLog Disk Use | bytes | Total binary log file size |
| mysql_Binlog_cache_disk_use | BinLog Cache Disk Use | Transactions | 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 |
| mysql_performance_Handler_rollback | Performance Handler Rollback | Operations / second | Number of internal ROLLBACK statements |
| mysql_performance_Handler_delete | Performance Handler Delete | Operations / second | Number of internal DELETE statements |
| mysql_performance_Qcache_not_cached | Performance Qcache Not Cached | Queries / second | Number of noncached queries (not cacheable, or not cached due to the query_cache_type setting) |
| mysql_performance_Qcache_total_blocks | Performance Qcache Total Blocks | Blocks | Total number of blocks in the query cache |
| mysql_performance_Select_range | Performance Select Range | Operations / second | Number of joins that used ranges on the first table. This is normally not a critical issue even if the value is quite large |
| mysql_performance_Handler_read_prev | Performance Handler Read Prev | Operations / second | Number of internal READ_PREV statements |
| mysql_performance_Sort_rows | Performance Sort Rows | Operations / second | Number of sorted rows |
| mysql_performance_Qcache_free_memory | Performance Qcache Free Memory | bytes | Amount of free memory for the query cache |
| mysql_performance_Handler_read_rnd_next | Performance Handler Read Rnd Next | Operations / second | Number of internal READ_RND_NEXT statements |
| mysql_performance_Select_range_check | Performance Select Range Check | Operations / second | 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 |
| mysql_performance_Select_scan | Performance Select Scan | Operations / second | Number of joins that did a full scan of the first table |
| mysql_performance_Qcache_free_blocks | Performance Qcache Free Blocks | Blocks | Number of free memory blocks in the query cache |
| mysql_performance_Table_locks_immediate_rate | Performance Table Locks Granted Immediate Rate | LocksGranted / second | Number of times a request for a table lock could be granted immediately |
| mysql_performance_Handler_prepare | Performance Handler Prepare | Operations / second | Number of internal PREPARE statements |
| mysql_performance_Opened_tables | Performance Opened Tables | Tables / second | Number of tables that have been opened. If Opened_tables is big, your table_open_cache value is probably too small |
| mysql_performance_Handler_read_first | Performance Handler Read First | Operations / Second | Number of internal READ_FIRST statements |
| mysql_performance_Sort_merge_passes | Performance Sort Merge Passes | Operations / second | 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 |
| mysql_performance_Select_full_join | Performance Select Full Join | Operations / second | 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 |
| mysql_performance_Handler_read_key | Performance Handler Read Key | Operations / second | Number of internal READ_KEY statements |
| mysql_performance_Handler_read_next | Performance Handler Read Next | Operations / second | Number of internal READ_NEXT statements |
| mysql_performance_Threads_cached | Performance Threads Cached | Threads | Number of threads in the thread cache |
| mysql_performance_Table_locks_immediate | Performance Table Locks Granted Immediate | LocksGranted / second | Number of times a request for a table lock could be granted immediately |
| mysql_performance_Threads_created | Performance Threads Created | Threads | Number of threads created to handle connections. If Threads_created is big, you may want to increase the thread_cache_size value |
| mysql_Binlog_cache_use | BinLog Cache Use | Transactions | Number of transactions that used the binary log cache |
| mysql_performance_Sort_range | Performance Sort Range | Operations / second | Number of sorts that were done using ranges |
| mysql_performance_Handler_read_rnd | Performance Handler Read Rnd | Operations / second | Number of internal READ_RND statements |
| mysql_performance_Handler_update | Performance Handler Update | Operations / second | Number of internal UPDATE statements |
| mysql_performance_Qcache_queries_in_cache | Performance Qcache Queries In Cache | Queries | Number of queries registered in the query cache |
| mysql_performance_Select_full_range_join | Performance Select Full Range Join | Operations / second | Number of joins that used a range search on a reference table |
| mysql_performance_Sort_scan | Performance Sort Scan | Operations / second | Number of sorts that were done by scanning the table |
| mysql_performance_Handler_write | Performance Handler Write | Operations / second | Number of internal WRITE statements |
| mysql_performance_Handler_commit | Performance Handler Commit | Operations / second | Number of internal COMMIT statements |
| mysql_performance_Table_open_cache_hits | Performance Table Open Cache Hits | Hits / second | Number of hits for open tables cache lookups |
| mysql_performance_Table_open_cache_misses | Performance Table Open Cache Misses | Misses / second | Number of misses for open tables cache lookups |
| mysql_Innodb_os_log_pending_fsyncs | InnoDB OS Log Pending Fsyncs | Operations | Number of pending InnoDB log fsync (sync-to-disk) requests |
| mysql_Innodb_s_lock_spin_waits | InnoDB S Lock Spin Waits | Waits / second | Number of shared (read) semaphore spin waits within the InnoDB sync array |
| mysql_Innodb_hash_index_cells_used | InnoDB Hash Index Cells Used | Cells | Number of used cells of the adaptive hash index |
| mysql_Innodb_pending_buffer_pool_flushes | InnoDB Pending Buffer Pool Flushes | Flushes | As shown in the FILE I/O section of the SHOW ENGINE INNODB STATUS output |
| mysql_Innodb_current_transactions | InnoDB Current Transactions | Transactions | Current InnoDB transactions |
| mysql_Innodb_queries_queued | InnoDB Queries Queued | Queries | As shown in the FILE I/O section of the SHOW ENGINE INNODB STATUS output |
| mysql_Innodb_tables_in_use | InnoDB Tables In Use | Tables | InnoDB Tables In Use |
| mysql_Innodb_pending_ibuf_aio_reads | InnoDB Pending Ibuf AIO Reads | Reads | As shown in the FILE I/O section of the SHOW ENGINE INNODB STATUS output |
| mysql_Innodb_pages_written | InnoDB Pages Written | Pages / second | Number of InnoDB pages written |
| mysql_Innodb_log_waits | InnoDB Log Waits | Waits / second | Number of times the log buffer was too small and a wait was required for it to be flushed before continuing |
| mysql_Innodb_buffer_pool_wait_free | InnoDB Buffer Pool Wait Free | Waits | 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 |
| mysql_Innodb_OS_file_fsyncs | InnoDB OS File Fsyncs | Operations / second | Rate of fsync() operations performed by InnoDB |
| mysql_Innodb_lsn_flushed | InnoDB Lsn Flushed | Flushed up to log sequence number as shown in the LOG section of the SHOW ENGINE INNODB STATUS output | |
| mysql_Innodb_ibuf_size | InnoDB Ibuf Size | Pages | Number of pages used within the InnoDB secondary index insert buffer |
| mysql_Innodb_buffer_pool_pages_data | InnoDB Buffer Pool Pages Data | Pages | Number of pages in the InnoDB buffer pool containing data. Number includes both dirty and clean pages |
| mysql_Innodb_s_lock_spin_rounds | InnoDB S Lock Spin Rounds | Rounds / second | Number of shared (read) semaphore spin rounds within the InnoDB sync array |
| mysql_Innodb_rows_read | InnoDB Rows Read | Rows / second | Number of rows read from InnoDB tables |
| mysql_Innodb_lsn_current | InnoSB Lsn Current | Current redo log sequence number within InnoDB | |
| mysql_Innodb_x_lock_spin_rounds | InnoDB X Lock Spin Rounds | Rounds / second | Number of exclusive (write) semaphore spin rounds within the InnoDB sync array |
| mysql_Innodb_lsn_Last_checkpoint | InnoDB Lsn Last Checkpoint | Log sequence number last checkpoint as shown in the LOG section of the SHOW ENGINE INNODB STATUS output | |
| mysql_Innodb_os_log_pending_writes | InnoDB OS Log Pending Writes | Writes | Number of pending InnoDB log writes |
| mysql_Innodb_mem_recovery_system | InnoDB Mem Recovery System | As shown in the BUFFER POOL AND MEMORY section of the SHOW ENGINE INNODB STATUS output | |
| mysql_Innodb_s_lock_OS_waits | InnodDB S Lock OS Waits | Waits / second | Number of shared (read) semaphore waits yielded to the OS by InnoDB |
| mysql_Innodb_buffer_pool_pages_dirty | InnoDB Buffer Pool Pages Dirty | Pages | Current number of dirty pages in the InnoDB buffer pool |
| mysql_Innodb_mem_total | InnoDB Mem Total | bytes | Total memory allocated for the InnoDB buffer pool |
| mysql_Innodb_pending_aio_sync_ios | InnoDB Pending AIO Sync IOS | As shown in the FILE I/O section of the SHOW ENGINE INNODB STATUS output | |
| mysql_Innodb_ibuf_merged | InnoDB Ibuf Merged | Merges / second | InnoDB Ibuf merged |
| mysql_Innodb_queries_inside | InnoDB Queries Inside | Queries | As shown in the FILE I/O section of the SHOW ENGINE INNODB STATUS output |
| mysql_Innodb_mem_lock_system | InnoDB Mem Lock System | As shown in the BUFFER POOL AND MEMORY section of the SHOW ENGINE INNODB STATUS output | |
| mysql_Innodb_pending_log_writes | InnoDB Pending Log Writes | Writes | Total number of writes pending to the InnoDB redo logs |
| mysql_Innodb_Pages_created | InnoDB Pages Created | Pages / second | Number of InnoDB pages created |
| mysql_Innodb_buffer_pool_pages_free | InnoDB Buffer Pool Pages Free | Pages | Number of free pages in the InnoDB buffer pool |
| mysql_Innodb_Hash_index_cells_total | InnoDB Hash Index Cells Total | Cells | Total number of cells of the adaptive hash index |
| mysql_Innodb_ibuf_merged_inserts | InnoDB Ibuf Merged Inserts | Operations / second | Rate of inserts to the InnoDB secondary index insert buffer |
| mysql_Innodb_dblwr_pages_written | InnoDB Dblwr Pages Written | Pages / second | Number of pages written per second to the doublewrite buffer |
| mysql_Innodb_lock_structs | InnoDB Lock Structs | Locks / second | Total number of lock structs in use by all transactions within InnoDB |
| mysql_Innodb_rows_updated | InnoDB Rows Updated | Rows / second | Number of rows updated in InnoDB tables |
| mysql_Innodb_dblwr_writes | InnoDB Dblwr Writes | bytes / second | Number of doublewrite operations performed per second |
| mysql_Innodb_active_transactions | InnoDB Active Transactions | Transactions | InnoDB active transactions |
| mysql_Innodb_ibuf_merged_delete_marks | InnoDB Ibuf Merged Delete Marks | Operations / second | Rate of deleted records merged by change buffering |
| mysql_Innodb_data_read | InnoDB Data Read | bytes / second | Amount of data read per second |
| mysql_Innodb_buffer_pool_read_ahead_evicted | InnoDB Buffer Pool Read Ahead Evicted | Pages / second | 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 |
| mysql_Innodb_mem_additional_pool | InnoDB Mem Additional Pool | bytes | Total memory allocated for the InnoDB additional pool |
| mysql_Innodb_History_list_length | InnoDB History List Length | Transactions | Number of transactions that currently have undo space allocated to them (unpurged) |
| mysql_Innodb_data_pending_fsyncs | InnoDB Data Pending Fsyncs | Operations | Current number of pending fsync() operations |
| mysql_Innodb_OS_file_writes | InnoDB OS File Writes | Writes / second | Rate of file writes performed by write threads within InnoDB |
| mysql_Innodb_locked_transactions | InnoDB Locked Transactions | Transactions | Total number of transactions waiting for row locks within InnoDB |
| mysql_Innodb_Pending_normal_aio_writes | InnoDB Pending Normal AIO Writes | Writes | As shown in the FILE I/O section of the SHOW ENGINE INNODB STATUS output |
| mysql_Innodb_ibuf_merges | InnoDB Ibuf Merges | InnoDB Ibuf merges | |
| mysql_Innodb_mem_Adaptive_hash | InnoDB Mem Adaptive Hash | bytes | As shown in the BUFFER POOL AND MEMORY section of the SHOW ENGINE INNODB STATUS output |
| mysql_Innodb_mem_Page_hash | InnoDB Mem Page Hash | As shown in the BUFFER POOL AND MEMORY section of the SHOW ENGINE INNODB STATUS output | |
| mysql_Innodb_data_pending_reads | InnoDB Data Pending Reads | Reads | Current number of pending reads |
| mysql_Innodb_pending_checkpoint_writes | InnoDB Pending Checkpoint Writes | Writes | Total number of currently pending checkpoint writes within InnoDB |
| mysql_Innodb_Buffer_pool_pages_total | InnoDB Buffer Pool Pages Total | Pages | Total size of the InnoDB buffer pool |
| mysql_Innodb_data_written | InnoDB Data Written | bytes / second | Amount of data written per second |
| mysql_Innodb_buffer_pool_read_ahead | InnoDB Buffer Pool Read Ahead | Pages / second | Number of pages read into the InnoDB buffer pool by the read-ahead background thread |
| mysql_Innodb_semaphore_wait_time | InnoDB Semaphore Wait Time | seconds | InnoDB semaphore wait time |
| mysql_Innodb_buffer_pool_data | InnoDB Buffer Pool Data | bytes | Total number of bytes in the InnoDB buffer pool containing data. The number includes both dirty and clean pages |
| mysql_Innodb_buffer_pool_read_ahead_rnd | InnoDB Buffer Pool Read Ahead Rnd | Operations | Number of random read-aheads initiated by InnoDB. This happens when a query scans a large portion of a table but in random order |
| mysql_Innodb_semaphore_waits | InnoDB Semaphore Waits | InnoDB semaphore waits | |
| mysql_Innodb_log_writes | InnoDB Log Writes | Writes / second | Number of physical writes to the InnoDB redo log file |
| mysql_Innodb_OS_file_reads | InnoDB OS File Reads | Reads / second | Rate of files reads performed by read threads within InnoDB |
| mysql_Innodb_ibuf_merged_deletes | InnoDB Ibuf Merged Deletes | Operations / second | Total number of times the InnoDB secondary index delete buffer was merged to the InnoDB datafiles |
| mysql_Innodb_mem_thread_hash | InnoDB Mem Thread Hash | Checkpoint age as shown in the LOG section of the SHOW ENGINE INNODB STATUS output | |
| mysql_Innodb_log_write_requests | InnoDB Log Write Requests | Writes / second | Number of write requests for the InnoDB redo log |
| mysql_Innodb_mem_dictionary | InnoDB Mem Dictionary | bytes | As shown in the BUFFER POOL AND MEMORY section of the SHOW ENGINE INNODB STATUS output |
| mysql_Innodb_Pending_normal_aio_reads | InnoDB Pending Normal AIO Reads | Reads | As shown in the FILE I/O section of the SHOW ENGINE INNODB STATUS output |
| mysql_Innodb_ibuf_free_list | 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 | |
| mysql_Innodb_x_lock_spin_waits | InnoDB X lock Spin Waits | Waits / second | Number of exclusive (write) semaphore spin waits within the InnoDB sync array |
| mysql_Innodb_os_log_written | InnoDB OS Log Written | bytes / second | Number of bytes written to the InnoDB log |
| mysql_Innodb_x_lock_OS_waits | InnoDB X Lock OS Waits | Waits / second | Number of exclusive (write) semaphore waits yielded to the OS by InnoDB |
| mysql_Innodb_pages_read | InnoDB Pages Read | Pages / second | Number of InnoDB pages read |
| mysql_Innodb_checkpoint_age | InnoDB Checkpoint Age | Checkpoint age as shown in the LOG section of the SHOW ENGINE INNODB STATUS output | |
| mysql_Innodb_buffer_pool_write_requests | InnoDB Buffer Pool Write Requests | Writes / second | Number of writes done to the InnoDB buffer pool |
| mysql_Innodb_buffer_pool_pages_flushed | InnoDB Buffer Pool Pages Flushed | Pages / second | Number of requests to flush pages from the InnoDB buffer pool |
| mysql_Innodb_Pending_log_flushes | InnoDB Pending Log Flushes | Flushes | As shown in the FILE I/O section of the SHOW ENGINE INNODB STATUS output |
| mysql_Innodb_rows_inserted | InnoDB Rows Inserted | Rows / second | Number of rows inserted into InnoDB tables |
| mysql_Innodb_ibuf_segment_size | InnoDB Ibuf Segment Size | Pages | Total size, in pages, of the InnoDB secondary index insert buffer |
| mysql_Innodb_rows_deleted | InnoDB Rows Deleted | Rows / second | Number of rows deleted from InnoDB tables |
| mysql_Innodb_read_views | InnoDB Read Views | As shown in the FILE I/O section of the SHOW ENGINE INNODB STATUS output | |
| mysql_Innodb_data_fsyncs | InnoDB Data Fsyncs | Operations / second | Number of fsync() operations per second |
| mysql_Innodb_data_pending_writes | InnoDB Data Pending Writes | Writes | Current number of pending writes |
| mysql_Innodb_mem_file_system | InnoDB Mem File System | As shown in the BUFFER POOL AND MEMORY section of the SHOW ENGINE INNODB STATUS output | |
| mysql_Innodb_pending_aio_log_ios | InnoDB Pending AIO Log IOS | As shown in the FILE I/O section of the SHOW ENGINE INNODB STATUS output | |
| mysql_Innodb_locked_tables | InnoDB Locked Tables | Tables | InnoDB tables locked |
| mysql_galera_wsrep_flow_control_paused | Galera Wsrep Flow Control Paused | Fraction | Shows the fraction of the time, since FLUSH STATUS was last called, that the node paused due to Flow Control |
| mysql_galera_wsrep_cert_deps_distance | 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 | |
| mysql_galera_wsrep_local_recv_queue_avg | Galera Wsrep Local Recv Queue Avg | Shows the average size of the local received queue since the last status query | |
| mysql_galera_wsrep_cluster_size | Galera Wsrep Cluster Size | Nodes | Current number of nodes in the Galera cluster |
| mysql_galera_wsrep_local_send_queue_avg | Galera Wsrep Local Send Queue Avg | Show an average for the send queue length since the last FLUSH STATUS query | |
| mysql_performance_query_run_time_avg | Performance Query Run Time Avg | microseconds | Avg query response time per schema |
| mysql_performance_digest_95th_percentile_avg_us | Performance Digest 95th Percentile Avg US | microseconds | Query response time 95th percentile per schema |
| mysql_info_schema_size | Info Schema Size | megabytes | Size of schemas |
| mysql_replication_slaves_connected | Replication Slaves Connected | Slaves | Number of slaves connected to a replication master |
| mysql_replication_Seconds_Behind_Master | Replication Seconds Behind Master | seconds | Lag between the master and the slave |
| mysql_performance_Qcache_utilization_instant | Performance Qcache Utilization Instant | percent | Percentage of the query cache memory being used at this instant (delta) |
| mysql_performance_Qcache_utilization | Performance Qcache Utilization | percent | Percentage of the query cache memory currently being used |
| mysql_performance_Opened_files | Performance Opened Files | Files | Number of files that have been opened only with my_open() function |
| mysql_performance_Open_table_definitions | Performance Open Table Definitions | Files | Number of cached .frm files. These files store the information of table structure in it |
| mysql_performance_Opened_table_definitions | Performance Opened Table Definitions | Files | Number of .frm files that have been cached. These files store the information of table structure in it |
| mysql_performance_Com_call_procedure | Performance CallProcedure Statements | Queries / second | Number of call-procedure statements |
| mysql_performance_Handler_read_last | Performance Handler Read Last | Reads / second | Number of times the last entry in an index was read |
| mysql_Binlog_stmt_cache_disk_use | 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 | |
| mysql_performance_Uptime | Performance Uptime | seconds | Number of seconds that the server has been up |
| mysql_Innodb_io_capacity | InnoDB IO Capacity | Limit on I/O activity for XtraDB/InnoDB background tasks, including merging data from the insert buffer and flushing pages. | |
| mysql_Innodb_log_buffer_size | InnoDB Log Buffer Size | bytes | 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 |
| mysql_Innodb_flush_log_at_trx_commit | 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 | |
| mysql_Innodb_force_recovery | InnoDB Force Recovery | Mode | 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) |
| mysql_Innodb_log_file_size | InnoDB Log File Size | bytes | 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 |
| mysql_Innodb_buffer_pool_size | InnoDB Buffer Pool Size | bytes | 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 |
| mysql_Innodb_buffer_pool_pages_misc | InnoDB Buffer Pool Pages Misc | Pages | Number of pages that are busy because they have been allocated for administrative overhead such as row locks or the adaptive hash index |
| mysql_Innodb_Buffer_Pool_hit_rate | InnoDB Buffer Pool Hit Rate | Fraction | Buffer Pool hit rate |
| mysql_Innodb_Hash_Searches | InnoDB Hash Searches | Searches | Hash Searches |
| mysql_Innodb_Non_Hash_Searches | InnoDB NonHash Searches | Searches | Non-Hash Searches |