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 is supported only for TencentDB for MySQL (excluding the Basic Edition) and TencentDB for CynosDB (compatible with MySQL).
Log in to the DBbrain console, select Monitoring & Alarm > Intelligent Monitoring on the left sidebar. On the displayed page, select a database type at the top and select the Monitoring Dashboard tab.
In DBbrain, the custom monitoring dashboard for TencentDB for MySQL currently supports the following monitoring metrics.
Monitoring Metric | Description |
---|---|
cpu_use_rate | CPU utilization |
memory_use_rate | Memory utilization |
memory_use | Used memory |
volume_rate | Disk utilization |
real_capacity | Used disk capacity |
capacity | Total disk capacity |
bytes_sent | Outbound traffic |
bytes_received | Inbound traffic |
qps | QPS |
tps | TPS |
connection_use_rate | Connection utilization |
max_connections | The maximum number of connections |
threads_connected | Connected threads |
slow_queries | The number of slow queries |
select_scan | The number of full-table scans |
select_count | The number of queries |
com_update | The number of updates |
com_delete | The number of deletions |
com_insert | The number of insertions |
com_replace | The number of overwrites |
queries | Total requests |
query_rate | Query utilization |
created_tmp_tables | The number of temp tables |
table_locks_waited | The number of times that requests for table locks have to wait |
innodb_cache_hit_rate | InnoDB cache hit rate |
innodb_cache_use_rate | InnoDB cache utilization |
innodb_os_file_reads | The number of InnoDB disk reads |
innodb_os_file_writes | The number of InnoDB disk writes |
innodb_os_fsyncs | The number of InnoDB fsync() operations |
innodb_num_open_files | The number of tables InnoDB currently holds open |
key_cache_hit_rate | MyISAM cache hit rate |
key_cache_use_rate | MyISAM cache utilization |
com_commit | The number of commits |
com_rollback | The number of rollbacks |
threads_created | The number of created threads |
created_tmp_disk_tables | The number of temp tables created on the disk |
threads_running | Running threads |
created_tmp_files | The number of temp files |
handler_read_rnd_next | The number of requests to read the next row |
handler_rollback | The number of internal rollbacks |
handler_commit | The number of internal commits |
innodb_buffer_pool_pages_free | The number of free pages in InnoDB |
innodb_buffer_pool_pages_total | The number of total pages in InnoDB |
innodb_buffer_pool_read_requests | The number of InnoDB logical reads |
innodb_buffer_pool_reads | The number of InnoDB physical reads |
innodb_data_read | The amount of data read from InnoDB tables |
innodb_data_reads | The number of InnoDB reads |
innodb_data_written | The amount of data written to InnoDB tables |
innodb_data_writes | The number of InnoDB writes |
innodb_rows_deleted | The number of rows deleted from InnoDB tables |
innodb_rows_inserted | The number of rows inserted into InnoDB tables |
innodb_rows_updated | The number of rows updated in InnoDB tables |
innodb_rows_read | The number of rows read from InnoDB tables |
innodb_row_lock_time_avg | The average time to acquire a row lock for InnoDB tables |
innodb_row_lock_waits | The number of times operations on InnoDB tables have to wait for a row lock |
key_blocks_unused | The number of unused blocks in key cache |
key_blocks_used | The number of used blocks in key cache |
key_read_requests | The number of reads of blocks from the key cache |
key_reads | The number of reads of blocks from the disk |
key_write_requests | The number of writes of blocks to the key cache |
key_writes | The number of writes of blocks to the disk |
opened_tables | The number of opened tables |
table_locks_immediate | The number of times that a request for a table lock can be granted immediately |
open_files | Total number of opened files |
log_capacity | Log space |
slave_io_running | IO thread status |
slave_sql_running | SQL thread status |
master_slave_sync_distance | Delayed data between the source and replica |
seconds_behind_master | Source-replica delay time |
In DBbrain, the custom monitoring dashboard for TencentDB for CynosDB (compatible with MySQL) currently supports the following monitoring metrics.
Monitoring Metric | Description |
---|---|
cpu_use_rate | CPU utilization |
memory_use_rate | Memory utilization |
memory_use | Used memory |
volume_rate | Storage utilization |
real_capacity | Used storage capacity |
qcache_hits | The number of cache hits |
qcache_hit_rate | Cache hit rate |
capacity | Total storage capacity |
bytes_sent | Outbound traffic |
bytes_received | Inbound traffic |
queries | QPS |
com_commit | TPS |
max_connections | The maximum number of connections |
threads_connected | Connected threads |
slow_queries | The number of slow queries |
select_scan | The number of full-table scans |
select_count | The number of queries |
com_update | The number of updates |
com_delete | The number of deletions |
com_insert | The number of insertions |
com_replace | The number of overwrites |
created_tmp_tables | The number of temp tables |
innodb_cache_hit_rate | InnoDB cache hit rate |
innodb_cache_use_rate | InnoDB cache utilization |
threads_created | Number of created threads |
threads_running | Running threads |
handler_rollback | The number of transactions rolled back per second |
innodb_buffer_pool_read_requests | The number of InnoDB logical reads |
handler_commit | The number of transactions committed per second |
innodb_buffer_pool_write_requests | InnoDB logical writes |
innodb_rows_deleted | The number of rows deleted from InnoDB tables |
innodb_rows_updated | The number of rows updated in InnoDB tables |
innodb_rows_inserted | The number of rows inserted into InnoDB tables |
innodb_rows_read | The number of rows read from InnoDB tables |
log_capacity | Log space |
replicate_lag | Redo log replication delay between the source and replica |
replicate_lsn_lag | Redo log LSN difference between the source and replica |
replicate_status | Replication status of the replica |
Was this page helpful?