tencent cloud

Intelligent Monitoring (Monitoring Dashboard)
Last updated: 2025-07-29 16:52:52
Intelligent Monitoring (Monitoring Dashboard)
Last updated: 2025-07-29 16:52:52

Feature Description

DBbrain allows you to customize the monitoring dashboard and link, compare, and view the monitoring data of multiple instances and metrics.
Note:
Currently, the monitoring dashboard feature is supported for TencentDB for MySQL (excluding basic single-node instances), TDSQL-C for MySQL, TencentDB for MariaDB, Tencent Cloud Database TDSQL for MySQL, TencentDB for Redis, TencentDB for MongoDB, and self-built MySQL.


Creating a Dashboard

1. Log in to the DBbrain Console.
2. In the left sidebar, select Monitoring & Alarm > Intelligent Monitoring.
3. Select the database type at the top.
4. Select Monitoring Dashboard tab.
5. Click Create Dashboard, input the dashboard name, select the monitoring metrics to compare, add monitoring instances, and then click Save to complete the creation of the monitoring dashboard.




Finding/Editing/Deleting a Dashboard

1. Log in to the DBbrain Console.
2. In the left sidebar, select Monitoring & Alarm > Intelligent Monitoring.
3. Select the database type at the top.
4. Select Monitoring Dashboard tab.
5. Click the dropdown list of the dashboard name to switch and view different monitoring dashboards.
Click Edit to modify the monitoring metrics and instances of the current dashboard.
Click Delete to delete the current dashboard.


Viewing Dashboard Details

1. Log in to the DBbrain Console.
2. In the left sidebar, select Monitoring & Alarm > Intelligent Monitoring.
3. Select the database type at the top.
4. Select Monitoring Dashboard tab.
5. Select the dashboard name to view, and select to view Real-Time or Historical data.
Real-Time: Users can view the performance metrics of instances in the past three minutes. By default, it refreshes automatically. Click Stop Refresh to stop real-time monitoring.
Historical: Select different time periods to display the monitoring dashboard view for the selected period. It supports switching between the last 1 hour, last 3 hours, last 24 hours, last 7 days, and custom time periods.
6. View dashboard monitoring metrics.
The monitoring dashboard supports chart linkage and switching between single-column and double-column display modes.
Enabling Chart Interaction
Turn on the Chart Interaction switch at the top right of the page to link and compare the monitoring views of multiple instances or metrics. When you hover over a data point in any trend chart, the data at the same time point will be displayed in other trend charts. Click the data point to pin the data show. To unpin it, click Deselect the Time Point.

Switching between Single-Column and Double-Column Display Modes
Click the button next to Chart Linkage at the top right of the page to switch between single-column and double-column display modes.
Double-Column Display Mode

Single-Column Display Mode

Freely drag trend charts: You can freely drag the position of different trend charts. Click the border of the trend chart to drag it.
View trend charts in fine granularity: Click on a specific time point in the trend chart, then drag the mouse to select a time range for zooming in, enabling granular display of trend data for the targeted period.

Zoom in trend charts: Drag the icon at the bottom-right corner of the trend chart to zoom in for a clearer fine-grained view of the trend of a single performance metric.


Monitoring Metrics

DBbrain (MySQL)

DBbrain (MySQL) custom monitoring dashboard currently supports the following monitoring metrics:
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),%

DBbrain (TDSQL-C for MySQL)

DBbrain (TDSQL-C for MySQL) custom monitoring dashboard currently supports the following monitoring metrics.
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

DBbrain (MariaDB and TDSQL for MySQL)

DBbrain (MariaDB and TDSQL for MySQL) custom monitoring dashboard currently supports the following monitoring metrics:
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

DBbrain (Redis)

DBbrain (Redis) custom monitoring dashboard currently supports the following monitoring metrics.
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

DBbrain (MongoDB)

DBbrain (MongoDB) custom monitoring dashboard currently supports the following monitoring metrics.
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

DBbrain (Self-Built MySQL)

DBbrain (Self-Built MySQL) custom monitoring dashboard currently supports the following monitoring metrics:
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),%
×
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No

Feedback