







No. | Monitoring Metrics |
1 | bytes_received (Inbound Traffic),Bytes/sec |
2 | bytes_sent (Outbound Traffic),Bytes/sec |
3 | capacity (Occupied Disk Space),MB |
4 | com_commit (Submissions),requests/sec |
5 | com_delete (Deletions),requests/sec |
6 | com_insert (Insertions),requests/sec |
7 | com_replace (Overwrites),requests/sec |
8 | com_rollback (Rollbacks),requests/sec |
9 | com_select (Queries),requests/sec |
10 | com_update (Updates),requests/sec |
11 | connection_use_rate (Connection Utilization),% |
12 | cpu_use_rate (CPU Utilization),% |
13 | created_tmp_disk_tables (Temp Disk Tables),requests/sec |
14 | created_tmp_files (Temp Files),requests/sec |
15 | created_tmp_tables (Temp Tables),requests/sec |
16 | disk_log_used (Log Space),MB |
17 | handler_commit (Internal Submissions),requests/sec |
18 | handler_read_rnd_next (Requests of Reading Next Row),requests/sec |
19 | handler_rollback (Internal Rollbacks),requests/sec |
20 | innodb_buffer_pool_pages_free (InnoDB Empty Pages) |
21 | innodb_buffer_pool_pages_total (Total InnoDB Pages) |
22 | innodb_buffer_pool_read_requests (InnoDB Logical Reads),requests/sec |
23 | innodb_buffer_pool_reads (InnoDB Physical Reads),requests/sec |
24 | innodb_cache_hit_rate (InnoDB Cache Hit Rate),% |
25 | innodb_cache_use_rate (InnoDB Cache Utilization),% |
26 | innodb_data_read (InnoDB Reads),Byte/sec |
27 | innodb_data_reads (Total InnoDB Reads),requests/sec |
28 | innodb_data_writes (Total InnoDB Writes),requests/sec |
29 | innodb_data_written (InnoDB Writes),Byte/sec |
30 | innodb_num_open_files (InnoDB Opened Tables) |
31 | innodb_os_file_reads (InnoDB Disk Reads),requests/sec |
32 | innodb_os_file_writes (InnoDB Disk Writes),requests/sec |
33 | innodb_os_fsyncs (InnoDB fsync Count),requests/sec |
34 | innodb_row_lock_time_avg (Average InnoDB Row Lock Acquiring Time), ms |
35 | innodb_row_lock_waits (InnoDB Row Lock Waits),requests/sec |
36 | innodb_rows_deleted (InnoDB Rows Deleted),requests/sec |
37 | innodb_rows_inserted (InnoDB Rows Inserted),requests/sec |
38 | innodb_rows_read (InnoDB Rows Read),requests/sec |
39 | innodb_rows_updated (InnoDB Rows Updated),requests/sec |
40 | key_blocks_unused (Unused Blocks in Key Cache) |
41 | key_blocks_used (Used Blocks in Key Cache) |
42 | key_cache_hit_rate (MyISAM Cache Hit Rate),% |
43 | key_cache_use_rate (MyISAM Cache Utilization),% |
44 | key_read_requests (Data Blocks Read by Key Cache),requests/sec |
45 | key_reads (Data Blocks Read by Disks),requests/sec |
46 | key_write_requests (Data Blocks Written into Key Cache),requests/sec |
47 | key_writes (Data Blocks Written into Disks),requests/sec |
48 | log_capacity (Log Space),MB |
49 | master_slave_sync_distance (Source-Replica Delay Distance),MB |
50 | max_connections (Max Connections) |
51 | memory_use (Memory Usage),MB |
52 | memory_use_rate (MEM),% |
53 | open_files (Total Opened Files) |
54 | opened_tables (Opened Tables) |
55 | qps (QPS),requests/sec |
56 | queries (Total Requests),requests/sec |
57 | query_rate (Query Utilization),% |
58 | real_capacity (Used Disk Space),MB |
59 | seconds_behind_master (Source-Replica Delay Time),sec |
60 | select_count (Queries),requests/sec |
61 | select_scan (Full-Table Scans),requests/sec |
62 | slave_io_running (IO Thread Status),0 Yes, 1 No, 2 Connecting |
63 | slave_sql_running (SQL Thread Status),0 Yes, 1 No |
64 | slow_queries (Slow SQL),times |
65 | table_locks_immediate (Table locks released immediately),requests/sec |
66 | table_locks_waited (Table Locks Awaited),requests/sec |
67 | threads_connected (Connected Threads) |
68 | threads_created (Created Threads) |
69 | threads_running (Running Threads) |
70 | tps (TPS),requests/sec |
71 | volume_rate (Disk Utilization),% |
No. | Monitoring Metrics |
1 | bytes_received (Inbound Traffic),Bytes/sec |
2 | bytes_sent (Outbound Traffic),Bytes/sec |
3 | ccu (ccu),Count |
4 | com_commit (Submissions),Commits/sec |
5 | com_delete (Deletions),requests/sec |
6 | com_insert (Insertions),requests/sec |
7 | com_replace (Overwrites),requests/sec |
8 | com_rollback (Rollbacks),Count/s |
9 | com_update (Updates),requests/sec |
10 | connection_use_rate (Connection Utilization),% |
11 | cpu_use_rate (CPU Utilization),% |
12 | created_tmp_disk_tables (Temp Tables),Count/s |
13 | created_tmp_files (Temp Files),Count/s |
14 | created_tmp_tables (Temp Tables),requests/sec |
15 | data_volume_usage (Data Tablespace Usage),MB |
16 | handler_commit (Committed Transactions per Second),requests/sec |
17 | handler_read_rnd_next (Requests of Reading Next Row),Count/s |
18 | handler_rollback (Rolled-Back Transactions per Second),requests/sec |
19 | innodb_buffer_pool_pages_dirty (InnoDB Dirty Pages),Count |
20 | innodb_buffer_pool_pages_free (InnoDB Empty Pages),Count |
21 | innodb_buffer_pool_pages_total (Total InnoDB Pages),Count |
22 | innodb_buffer_pool_read_requests (InnoDB Logical Reads),requests/sec |
23 | innodb_buffer_pool_reads (InnoDB Physical Reads),Count/s |
24 | innodb_buffer_pool_write_requests (InnoDB Logic Write),requests/sec |
25 | innodb_cache_hit_rate (InnoDB Cache Hit Rate),% |
26 | innodb_cache_use_rate (InnoDB Cache Utilization),% |
27 | innodb_data_pending_reads (InnoDB Data Pending Reads),Count |
28 | innodb_data_pending_writes (InnoDB Data Pending Writes),Count |
29 | innodb_data_read (InnoDB Reads),Bytes/s |
30 | innodb_data_reads (Total InnoDB Reads),Count/s |
31 | innodb_data_writes (Total InnoDB Writes),Count/s |
32 | innodb_data_written (InnoDB Writes),Bytes/s |
33 | innodb_log_waits (InnoDB Log Write Waits),Count/s |
34 | innodb_log_write_requests (InnoDB Log Physical Write Requests),Count/s |
35 | innodb_log_writes (InnoDB Log Physical Writes),Count/s |
36 | innodb_num_open_files (InnoDB Opened Tables),Count |
37 | innodb_os_file_reads (Disk Reads),Count |
38 | innodb_os_file_writes (Disk Writes),Count |
39 | innodb_os_fsyncs (InnoDB Fsyncs Calls),Count |
40 | innodb_row_lock_time_avg (Average InnoDB Row Lock Acquiring Time),ms |
41 | innodb_row_lock_waits (InnoDB Row Lock Waits),Count/s |
42 | innodb_rows_deleted (InnoDB Rows Deleted),requests/sec |
43 | innodb_rows_inserted (InnoDB Rows Inserted),requests/sec |
44 | innodb_rows_read (InnoDB Rows Read),requests/sec |
45 | innodb_rows_updated (InnoDB Rows Updated),requests/sec |
46 | latency_delete_p95 (Time Consumed for DELETE (P95)),us |
47 | latency_delete_p99 (Time Consumed for DELETE (P99)),us |
48 | latency_insert_p95 (Time Consumed for INSERT (P95)),us |
49 | latency_insert_p99 (Time Consumed for INSERT (P99)),us |
50 | latency_other_p95 (Time Consumed for OTHER (P95)),us |
51 | latency_other_p99 (Time Consumed for OTHER (P99)),us |
52 | latency_p95 (Time Consumed for All Requests (P95)),us |
53 | latency_p99 (Time Consumed for All Requests (P99)),us |
54 | latency_replace_p95 (Time Consumed for REPLACE (P95)),us |
55 | latency_replace_p99 (Time Consumed for REPLACE (P99)),us |
56 | latency_select_p95 (Time Consumed for SELECT (P95)),us |
57 | latency_select_p99 (Time Consumed for SELECT (P99)),us |
58 | latency_update_p95 (Time Consumed for UPDATE (P95)),us |
59 | latency_update_p99 (Time Consumed for UPDATE (P99)),us |
60 | max_connections (Max Connections), |
61 | memory_use (Memory Usage),MB |
62 | memory_use_rate (MEM),% |
63 | open_files (Total Opened Files),Count |
64 | opened_tables (Opened Tables),Count |
65 | qcache_hit_rate (Cache Hit Rate),% |
66 | qcache_hits (Cache Hits),times |
67 | qcache_use_rate (Qcache Utilization),% |
68 | qps (Operations/sec),Count/s |
69 | select_full_join (Full-Table Scan Joins),Count/s |
70 | select_full_range_join (Range Scan Joins),Count/s |
71 | select_scan (Full-Table Scans),requests/sec |
72 | slow_queries (Slow SQL),times |
73 | storage_use (Storage Usage),MB |
74 | sort_merge_passes (Sort Merge Passes),Count/s |
75 | storage_use_rate (Storage Utilization),% |
76 | table_locks_immediate (Table locks released immediately),Count/s |
77 | table_locks_waited (Table Locks Awaited),Count/s |
78 | table_open_cache_hits (Open Table Cache Hits),Count/s |
79 | table_open_cache_misses (Open Table Cache Misses),Count/s |
80 | threads_connected (Connected Threads) |
81 | threads_created (Created Threads) |
82 | threads_running (Running Threads) |
83 | tmp_volume_usage (Temp Tablespace Usage),MB |
84 | tps (Transactions/sec),Count/s |
85 | undo_volume_usage (Undo Tablespace Usage),MB |
No. | Monitoring Metrics |
1 | binlog_disk_available (Available Log Disk Space),MB |
2 | commit_total (Submissions),requests/sec |
3 | conn_max (Max Connections) |
4 | conn_usage_rate (Connection Utilization),% |
5 | cpu_use_rate (CPU Utilization),% |
6 | data_disk_available (Available Data Disk Space),MB |
7 | data_disk_used (Data Disk Usage),MB |
8 | data_disk_used_rate (Data Disk Utilization),% |
9 | delete_total (Deletions),requests/sec |
10 | innodb_buffer_pool_read_requests (InnoDB Logical Reads),requests/sec |
11 | innodb_buffer_pool_reads (InnoDB Physical Reads),requests/sec |
12 | innodb_rows_deleted (InnoDB Rows Deleted),requests/sec |
13 | innodb_rows_inserted (InnoDB Rows Inserted),requests/sec |
14 | innodb_rows_read (InnoDB Rows Read),requests/sec |
15 | innodb_rows_updated (InnoDB Rows Updated),requests/sec |
16 | insert_total (Insertions),requests/sec |
17 | long_query (Slow SQL),times |
18 | replace_total (Overwrites),requests/sec |
19 | request_total (Total Requests),requests/sec |
20 | rollback_total (Rollbacks),requests/sec |
21 | select_total (Queries),requests/sec |
22 | threads_connected (Connected Threads) |
23 | threads_running_count (Running Threads) |
24 | update_total (Updates),requests/sec |
No. | Monitoring Metrics |
1 | cmd_big_value (Big Value Request),requests/sec |
2 | cmd_err (Execution Error),requests/sec |
3 | cmd_hits (Read Request Hit),times |
4 | cmd_hits_ratio (Read Request Hit Rate),% |
5 | cmd_key_count (Key Requests),requests/sec |
6 | cmd_mget (Mget Requests),requests/sec |
7 | cmd_miss (Read Request Miss),times |
8 | cmd_other (Other Requests),requests/sec |
9 | cmd_read (Read Request),requests/sec |
10 | cmd_slow (Slow Query),times |
11 | cmd_write (Write Request),requests/sec |
12 | commands (Total Requests),requests/sec |
13 | connections (Connections), |
14 | connections_util (Connection Utilization),% |
15 | cpu_max_util (Max Node CPU Utilization),% |
16 | cpu_util (CPU Utilization),% |
17 | evicted (Evicted Keys),times |
18 | expired (Expired Keys),times |
19 | in_bandwidth_util (Inbound Traffic Utilization),% |
20 | in_flow (Inbound Traffic),MBit/s |
21 | keys (Total Keys),times |
22 | in_flow_limit (Inbound Traffic Throttling Trigger),times |
23 | latency_avg (Avg Execution Latency),ms |
24 | latency_max (Max Execution Latency),ms |
25 | latency_other (Avg Latency of Other Commands),ms |
26 | latency_p99 (P99 Execution Latency),ms |
27 | latency_read (Avg Read Latency),ms |
28 | latency_write (Avg Write Latency),ms |
29 | mem_max_util (Max Node MEM Utilization),% |
30 | mem_used (Memory Usage),MB |
31 | mem_util (Memory Utilization),% |
32 | out_bandwidth_util (Outbound Traffic Utilization),% |
33 | out_flow (Outbound Traffic),MBit/s |
34 | out_flow_limit (Outbound Traffic Throttling Trigger),times |
No. | Monitoring Metrics |
1 | 100ms (Requests with over 100 ms Latency),times |
2 | 100ms_aggregates (aggregate Requests with over 100 ms Latency),times |
3 | 100ms_commands (command Requests with over 100 ms Latency),times |
4 | 100ms_counts (count Requests with over 100 ms Latency),times |
5 | 100ms_deletes (delete Requests with over 100 ms Latency),times |
6 | 100ms_getmores (getMore Requests with over 100 ms Latency),times |
7 | 100ms_inserts (insert Requests with over 100 ms Latency),times |
8 | 100ms_reads (read Requests with over 100 ms Latency),times |
9 | 100ms_updates (update Requests with over 100 ms Latency),times |
10 | 10ms (Requests with 10-50 ms Latency),times |
11 | 10ms_aggregates (aggregate Requests with 10-50 ms Latency),times |
12 | 10ms_commands (command Requests with 10-50 ms Latency),times |
13 | 10ms_counts (count Reuests with 10-50 ms Latency),times |
14 | 10ms_deletes (delete Requests with 10-50 ms Latency),times |
15 | 10ms_getmores (getMore Requests with 10-50 ms Latency),times |
16 | 10ms_inserts (insert Requests with 10-50 ms Latency),times |
17 | 10ms_reads (read Requests with 10-50 ms Latency),times |
18 | 10ms_updates (update Reuests with 10-50 ms Latency),times |
19 | 50ms (Requests with 50-100 ms Latency),times |
20 | 50ms_aggregates (aggregate Requests with 50-100 ms Latency),times |
21 | 50ms_commands (command Requests with 50-100 ms Latency),times |
22 | 50ms_counts (count Requests with 50-100 ms Latency),times |
23 | 50ms_deletes (delete Requests with 50-100 ms Latency),times |
24 | 50ms_getmores (getMore Requests with 50-100 ms Latency),times |
25 | 50ms_inserts (insert Requests with 50-100 ms Latency),times |
26 | 50ms_reads (read Requests with 50-100 ms Latency),times |
27 | 50ms_updates (update Requests with 50-100 ms Latency),times |
28 | aggregates (aggregate Requests),times |
29 | avg_aggregate_ms (Avg Latency of aggregate Requests),ms |
30 | avg_all_requests_ms (Avg Latency of All Requests),ms |
31 | avg_command_ms (Avg Latency of command Requests),ms |
32 | avg_count_ms (Avg Latency of count Requests),ms |
33 | avg_delete_ms (Avg Latency of delete Requests),ms |
34 | avg_getmore_ms (Avg Latency of getMore Requests),ms |
35 | avg_insert_ms (Avg Latency of insert Requests),ms |
36 | avg_read_ms (Avg Latency of read Requests),ms |
37 | avg_update_ms (Avg Latency of update Requests),ms |
38 | commands (command Requests),times |
39 | conn (Connections) |
40 | connper (Percentage of Connections ),% |
41 | counts (count Requests),times |
42 | cpuusage (Max Cluster CPU Utilization),% |
43 | deletes (delete Requests),times |
44 | disk (Disk Usage),MB |
45 | diskusage (Disk Utilization),% |
46 | getmores (getMore Requests),times |
47 | inserts (insert Requests),times |
48 | memory (Memory Usage),MB |
49 | memusage (Memory Utilization),% |
50 | netin (Inbound Network Traffic),Bytes |
51 | netout (Outbound Network Traffic),Bytes |
52 | oplogreservedtime (Oplog Retention Period (hr)),h |
53 | qps (QPS),requests/sec |
54 | reads (read Requests),times |
55 | success (Successfully Processed Requests),times |
56 | syncdelayseconds (Read-Only Instance Sync Delay),s |
57 | syncstatus (Read-Only Instance Sync Status) |
58 | updates (update Requests),times |
No. | Monitoring Metrics | Agent-Based Access | Direct Access |
1 | bytes_received (Inbound Traffic),Bytes/sec | ✓ | ✓ |
2 | bytes_sent (Outbound Traffic),Bytes/sec | ✓ | ✓ |
3 | capacity (Occupied Disk Space),MB | ✓ | × |
4 | com_commit (Submissions),requests/sec | ✓ | ✓ |
5 | com_delete (Deletions),requests/sec | ✓ | ✓ |
6 | com_insert (Insertions),requests/sec | ✓ | ✓ |
7 | com_replace (Overwrites),requests/sec | ✓ | ✓ |
8 | com_rollback (Rollbacks),requests/sec | ✓ | ✓ |
9 | com_select (Queries),requests/sec | ✓ | ✓ |
10 | com_update (Updates),requests/sec | ✓ | ✓ |
11 | connection_use_rate (Connection Utilization),% | ✓ | ✓ |
12 | cpu_use_rate (CPU),% | ✓ | × |
13 | created_tmp_disk_tables (Temp Disk Tables),requests/sec | ✓ | ✓ |
14 | created_tmp_files (Temp Files),requests/sec | ✓ | ✓ |
15 | created_tmp_tables (Temp Tables),requests/sec | ✓ | ✓ |
16 | handler_commit (Internal Submissions),requests/sec | ✓ | ✓ |
17 | handler_rollback (Internal Rollbacks),requests/sec | ✓ | ✓ |
18 | handler_read_rnd_next (Requests of Reading Next Row),requests/sec | ✓ | ✓ |
19 | innodb_buffer_pool_pages_free (InnoDB Empty Pages) | ✓ | ✓ |
20 | innodb_buffer_pool_pages_total (Total InnoDB Pages) | ✓ | ✓ |
21 | innodb_buffer_pool_read_requests (InnoDB Logical Reads),requests/sec | ✓ | ✓ |
22 | innodb_buffer_pool_reads (InnoDB Physical Reads),requests/sec | ✓ | ✓ |
23 | innodb_data_read (InnoDB Reads),Byte/sec | ✓ | ✓ |
24 | innodb_data_reads (Total InnoDB Reads),requests/sec | ✓ | ✓ |
25 | innodb_data_writes (Total InnoDB Writes),requests/sec | ✓ | ✓ |
26 | innodb_data_written (InnoDB Writes),Byte/sec | ✓ | ✓ |
27 | innodb_num_open_files (InnoDB Opened Tables) | ✓ | ✓ |
28 | innodb_row_lock_time_avg (Average InnoDB Row Lock Acquiring Time), ms | ✓ | ✓ |
29 | innodb_row_lock_waits (InnoDB Row Lock Waits),requests/sec | ✓ | ✓ |
30 | innodb_rows_deleted (InnoDB Rows Deleted),requests/sec | ✓ | ✓ |
31 | innodb_rows_inserted (InnoDB Rows Inserted),requests/sec | ✓ | ✓ |
32 | innodb_rows_read (InnoDB Rows Read),requests/sec | ✓ | ✓ |
33 | innodb_rows_updated (InnoDB Rows Updated),requests/sec | ✓ | ✓ |
34 | key_blocks_unused (Unused Blocks in Key Cache) | ✓ | ✓ |
35 | key_blocks_used (Used Blocks in Key Cache) | ✓ | ✓ |
36 | key_read_requests (Data Blocks Read by Key Cache),requests/sec | ✓ | ✓ |
37 | key_reads (Data Blocks Read by Disks),requests/sec | ✓ | ✓ |
38 | key_write_requests (Data Blocks Written into Key Cache),requests/sec | ✓ | ✓ |
39 | key_writes (Data Blocks Written into Disks),requests/sec | ✓ | ✓ |
40 | log_capacity (Log Space),MB | ✓ | × |
41 | max_connections (Max Connections) | ✓ | ✓ |
42 | memory_use (Memory Usage),MB | ✓ | × |
43 | memory_use_rate (MEM),% | ✓ | × |
44 | open_files (Total Opened Files), | ✓ | ✓ |
45 | opened_tables (Opened Tables), | ✓ | ✓ |
46 | qps (QPS),requests/sec | ✓ | ✓ |
47 | queries (Total Requests),requests/sec | ✓ | ✓ |
48 | real_capacity (Used Disk Space),MB | ✓ | × |
49 | select_count (Queries),requests/sec | ✓ | ✓ |
50 | select_scan (Full-Table Scans),requests/sec | ✓ | ✓ |
51 | slow_queries (Slow SQL),times | ✓ | ✓ |
52 | table_locks_immediate (Table locks released immediately),requests/sec | ✓ | ✓ |
53 | table_locks_waited (Table Locks Awaited),requests/sec | ✓ | ✓ |
54 | threads_connected (Connected Threads) | ✓ | ✓ |
55 | threads_created (Created Threads) | ✓ | ✓ |
56 | threads_running (Running Threads) | ✓ | ✓ |
57 | tps (TPS),requests/sec | ✓ | ✓ |
58 | volume_rate (Disk Utilization),% | ✓ | × |
Feedback