Monitoring Metric | Description |
cpu_use_rate | CPU Utilization |
memory_use_rate | Memory Utilization |
memory_use | Memory Usage |
volume_rate | Disk Utilization |
real_capacity | Used Disk Space |
capacity | Occupied Disk Space |
bytes_sent | Outbound Traffic |
bytes_received | Inbound Traffic |
qps | QPS |
tps | TPS |
connection_use_rate | Connection Utilization |
max_connections | Max Connections |
threads_connected | Connected Threads |
slow_queries | Slow Queries |
select_scan | Full-Table Scans |
select_count | Queries |
com_update | Updates |
com_delete | Deletions |
com_insert | Insertions |
com_replace | Overwrites |
queries | Total Requests |
query_rate | Query Utilization |
created_tmp_tables | Temp Tables |
table_locks_waited | Table Locks Awaited |
innodb_cache_hit_rate | InnoDB Cache Hit Rate |
innodb_cache_use_rate | InnoDB Cache Utilization |
innodb_os_file_reads | InnoDB Disk Reads |
innodb_os_file_writes | InnoDB Disk Writes |
innodb_os_fsyncs | InnoDB fsync Count |
innodb_num_open_files | InnoDB Opened Tables |
key_cache_hit_rate | MyISAM Cache Hit Rate |
key_cache_use_rate | MyISAM Cache Utilization |
com_commit | Submissions |
com_rollback | Rollbacks |
threads_created | Created Threads |
created_tmp_disk_tables | Temp Disk Tables |
threads_running | Running Threads |
created_tmp_files | Temp Files |
handler_read_rnd_next | Requests of Reading Next Row |
handler_rollback | Internal Rollbacks |
handler_commit | Internal Submissions |
innodb_buffer_pool_pages_free | InnoDB Empty Pages |
innodb_buffer_pool_pages_total | Total InnoDB Pages |
innodb_buffer_pool_read_requests | InnoDB Logical Reads |
innodb_buffer_pool_reads | InnoDB Physical Reads |
innodb_data_read | InnoDB Reads |
innodb_data_reads | Total InnoDB Reads |
innodb_data_written | InnoDB Writes |
innodb_data_writes | Total InnoDB Writes |
innodb_rows_deleted | InnoDB Rows Deleted |
innodb_rows_inserted | InnoDB Rows Inserted |
innodb_rows_updated | InnoDB Rows Updated |
innodb_rows_read | InnoDB Rows Read |
innodb_row_lock_time_avg | Average InnoDB Row Lock Acquiring Time |
innodb_row_lock_waits | InnoDB Row Lock Waits |
key_blocks_unused | Unused Blocks in Key Cache |
key_blocks_used | Used Blocks in Key Cache |
key_read_requests | Data Blocks Read by Key Cache |
key_reads | Data Blocks Read by Disks |
key_write_requests | Data Blocks Written into Key Cache |
key_writes | Data Blocks Written into Disks |
opened_tables | Opened Tables |
table_locks_immediate | Table Locks Released Immediately |
open_files | Total Opened Files |
log_capacity | Log Space |
slave_io_running | IO Thread Status |
slave_sql_running | SQL Thread Status |
master_slave_sync_distance | Source-Replica Delay Distance |
seconds_behind_master | Source-Replica Delay Time |
Monitoring Metric | Description |
cpu_use_rate | CPU Utilization |
memory_use_rate | Memory Utilization |
memory_use | Memory Usage |
volume_rate | Storage Utilization |
real_capacity | Used Storage Space |
qcache_hits | Cache Hits |
qcache_hit_rate | Cache Hit Rate |
capacity | Total Storage Space |
bytes_sent | Outbound Traffic |
bytes_received | Inbound Traffic |
queries | QPS |
com_commit | TPS |
max_connections | Max Connections |
threads_connected | Connected Threads |
slow_queries | Slow Queries |
select_scan | Full-Table Scans |
select_count | Queries |
com_update | Updates |
com_delete | Deletions |
com_insert | Insertions |
com_replace | Overwrites |
created_tmp_tables | Temp Tables |
innodb_cache_hit_rate | InnoDB Cache Hit Rate |
innodb_cache_use_rate | InnoDB Cache Utilization |
threads_created | Created Threads |
threads_running | Running Threads |
handler_rollback | Rolled-Back Transactions per Second |
innodb_buffer_pool_read_requests | InnoDB Logical Reads |
handler_commit | Committed Transactions per Second |
innodb_buffer_pool_write_requests | InnoDB Logic Write |
innodb_rows_deleted | InnoDB Rows Deleted |
innodb_rows_updated | InnoDB Rows Updated |
innodb_rows_inserted | InnoDB Rows Inserted |
innodb_rows_read | InnoDB Rows Read |
log_capacity | Log Space |
replicate_lag | Replica Instance Delay in Redo Log Based Replication |
replicate_lsn_lag | Redo Log LSN Difference between Source and Replica Instances |
replicate_status | Replication Status of Replica Instance |
Monitoring Metric | Description |
cmd_big_value | Big Value Request |
cmd_err | Execution Error |
cmd_hits | Read Request Hit |
cmd_hits_ratio | Read Request Hit Rate |
%cmd_key_count | Key Requests |
cmd_mget | Mget Requests |
cmd_miss | Read Request Miss |
cmd_other | Other Requests |
cmd_read | Read Request |
cmd_slow | Slow Query |
cmd_write | Write Request |
commands | Total Requests |
connections | Connections |
connections_util | Connection Utilization |
%cpu_max_util | Max Node CPU Utilization |
%cpu_util | CPU Utilization |
%evicted | Evicted Keys |
expired | Expired Keys |
in_bandwidth_util | Inbound Traffic Utilization |
%in_flow | Inbound Traffic |
MBit/sin_flow_limit | Inbound Traffic Throttling Trigger |
keys | Total Keys |
latency_max | Max Execution Latency |
mslatency_other | Avg Latency of Other Commands |
mslatency_avg | Avg Execution Latency |
mslatency_read | Avg Read Latency |
mslatency_write | Avg Write Latency |
msmem_max_util | Max Node MEM Utilization |
%mem_used | Memory Usage |
MBmem_util | Memory Utilization |
%out_bandwidth_util | Outbound Traffic Utilization |
%out_flow | Outbound Traffic |
MBit/sout_flow_limit | Outbound Traffic Throttling Trigger |
latency_p99 | P99 Execution Latency |
Monitoring Metric | Description | Agent Access | Direct Access |
cpu_use_rate | CPU Utilization | ✓ | × |
memory_use_rate | Memory Utilization | ✓ | × |
memory_use | Memory Usage | ✓ | × |
volume_rate | Disk Utilization | ✓ | × |
real_capacity | Used Disk Space | ✓ | × |
capacity | Occupied Disk Space | ✓ | × |
bytes_sent | Outbound Traffic | ✓ | ✓ |
bytes_received | Inbound Traffic | ✓ | ✓ |
qps | QPS | ✓ | ✓ |
tps | TPS | ✓ | ✓ |
connection_use_rate | Connection Utilization | ✓ | ✓ |
max_connections | Max Connections | ✓ | ✓ |
threads_connected | Connected Threads | ✓ | ✓ |
slow_queries | Slow Queries | ✓ | ✓ |
select_scan | Full-Table Scans | ✓ | ✓ |
select_count | Queries | ✓ | ✓ |
com_update | Updates | ✓ | ✓ |
com_delete | Deletions | ✓ | ✓ |
com_insert | Insertions | ✓ | ✓ |
com_replace | Overwrites | ✓ | ✓ |
queries | Total Requests | ✓ | ✓ |
query_rate | Query Utilization | ✓ | ✓ |
created_tmp_tables | Temp Tables | ✓ | ✓ |
table_locks_waited | Table Locks Awaited | ✓ | ✓ |
innodb_cache_hit_rate | InnoDB Cache Hit Rate | ✓ | ✓ |
innodb_cache_use_rate | InnoDB Cache Utilization | ✓ | ✓ |
innodb_os_file_reads | InnoDB Disk Reads | ✓ | ✓ |
innodb_os_file_writes | InnoDB Disk Writes | ✓ | ✓ |
innodb_os_fsyncs | InnoDB fsync Count | ✓ | ✓ |
innodb_num_open_files | InnoDB Opened Tables | ✓ | ✓ |
key_cache_hit_rate | MyISAM Cache Hit Rate | ✓ | ✓ |
key_cache_use_rate | MyISAM Cache Utilization | ✓ | ✓ |
com_commit | Submissions | ✓ | ✓ |
com_rollback | Rollbacks | ✓ | ✓ |
threads_created | Created Threads | ✓ | ✓ |
created_tmp_disk_tables | Temp Disk Tables | ✓ | ✓ |
threads_running | Running Threads | ✓ | ✓ |
created_tmp_files | Temp Files | ✓ | ✓ |
handler_read_rnd_next | Requests of Reading Next Row | ✓ | ✓ |
handler_rollback | Internal Rollbacks | ✓ | ✓ |
handler_commit | Internal Submissions | ✓ | ✓ |
innodb_buffer_pool_pages_free | InnoDB Empty Pages | ✓ | ✓ |
innodb_buffer_pool_pages_total | Total InnoDB Pages | ✓ | ✓ |
innodb_buffer_pool_read_requests | InnoDB Logical Reads | ✓ | ✓ |
innodb_buffer_pool_reads | InnoDB Physical Reads | ✓ | ✓ |
innodb_data_read | InnoDB Reads | ✓ | ✓ |
innodb_data_reads | Total InnoDB Reads | ✓ | ✓ |
innodb_data_written | InnoDB Writes | ✓ | ✓ |
innodb_data_writes | Total InnoDB Writes | ✓ | ✓ |
innodb_rows_deleted | InnoDB Rows Deleted | ✓ | ✓ |
innodb_rows_inserted | InnoDB Rows Inserted | ✓ | ✓ |
innodb_rows_updated | InnoDB Rows Updated | ✓ | ✓ |
innodb_rows_read | InnoDB Rows Read | ✓ | ✓ |
innodb_row_lock_time_avg | Average InnoDB Row Lock Acquiring Time | ✓ | ✓ |
innodb_row_lock_waits | InnoDB Row Lock Waits | ✓ | ✓ |
key_blocks_unused | Unused Blocks in Key Cache | ✓ | ✓ |
key_blocks_used | Used Blocks in Key Cache | ✓ | ✓ |
key_read_requests | Data Blocks Read by Key Cache | ✓ | ✓ |
key_reads | Data Blocks Read by Disks | ✓ | ✓ |
key_write_requests | Data Blocks Written into Key Cache | ✓ | ✓ |
key_writes | Data Blocks Written into Disks | ✓ | ✓ |
opened_tables | Opened Tables | ✓ | ✓ |
table_locks_immediate | Table Locks Released Immediately | ✓ | ✓ |
open_files | Total Opened Files | ✓ | ✓ |
log_capacity | Log Space | ✓ | × |
Was this page helpful?