Monitoring Dashboard

Last updated: 2020-12-15 10:46:14

    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

    1. 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.
    2. 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

    1. 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.
    2. 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

    1. 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.
    2. 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.

    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?

    Was this page helpful?

    • Not at all
    • Not very helpful
    • Somewhat helpful
    • Very helpful
    • Extremely helpful
    Send Feedback
    Help