- Release Notes
- Product Introduction
- Purchase Guide
- Operation Guide
- Best Practices
- FAQs
- API Documentation
- Service Level Agreement
- Glossary
- Contact Us
- Release Notes
- Product Introduction
- Purchase Guide
- Operation Guide
- Best Practices
- FAQs
- API Documentation
- Service Level Agreement
- Glossary
- Contact Us
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).
Creating a Dashboard
- 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.
- Click Create Dashboard, enter the dashboard name, select the monitoring metrics for comparison, add an instance, and click Save.
Finding/Editing/Deleting a Dashboard
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.
- Click the dashboard name drop-down list to switch between different dashboards.
- After selecting a dashboard, click Edit to modify the monitoring metrics and instance of the current dashboard.
- Click Delete to delete the current dashboard.
Enabling Chart Interaction
- 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.
- Toggle on the Chart Interaction switch on the right to link and compare the monitoring views of multiple instances or metrics.
Switching between Real-Time/Historical Views
- 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.
- Click Real-Time or Historical to view the corresponding real-time or historical monitoring view.
- The real-time monitoring view allows you to view the performance metric comparison of the instance over the last 3 minutes and is automatically refreshed by default. Click Disable refresh to stop refreshing the monitoring data.
- In the historical monitoring view, you can select a time period to display the view of monitoring dashboard over the selected time period, and you can switch among the last hour, last 3 hours, last 24 hours, last 7 days, and custom time period.
- The real-time monitoring view allows you to view the performance metric comparison of the instance over the last 3 minutes and is automatically refreshed by default. Click Disable refresh to stop refreshing the monitoring data.
Monitoring Metrics
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?