tencent cloud

Feedback

Intelligent Monitoring - Monitoring Dashboard

Last updated: 2022-09-01 18:34:46

    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, self-built MySQL, TencentDB for Redis, and TencentDB for MongoDB.

    Creating a Dashboard

    1. Log in to the DBbrain console and select Monitoring and Alarming > Intelligent Monitoring on the left sidebar. On the displayed page, select a database type and an instance 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 and select Monitoring and Alarming > Intelligent Monitoring on the left sidebar. On the displayed page, select a database type and an instance at the top, and select the Monitoring Dashboard tab.

    • Click the dashboard name drop-down list to switch between different monitoring dashboards.
    • After selecting a dashboard, click Edit to modify its monitoring metrics and instance.
    • Click Delete to delete the current dashboard.

    Viewing Dashboard Details

    Enabling chart interaction

    1. Log in to the DBbrain console and select Monitoring and Alarming > Intelligent Monitoring on the left sidebar. On the displayed page, select a database type and an instance at the top, and select the Monitoring Dashboard tab.
    2. Toggle on Chart Interaction on the right to link and compare the monitoring views of multiple instances or metrics.
      When you hover over a data point in any monitoring view, the data at the same time point will be displayed in other monitoring views. Click the data point to pin it for display. To unpin it, click Deselect the Time Point.

    Switching between one-column and two-column modes

    1. Click the button on the right of Chart Interaction in the top-right corner to switch.
    2. Click the border of a monitoring view to drag it to the desired position.

    Switching between real-time and historical views

    Click Real-Time or Historical to view the real-time or historical monitoring view.

    • The real-time monitoring view displays the performance metric comparison of the instance in the last three minutes and is automatically refreshed by default. You can click Disable refresh to stop refreshing the monitoring data in real time.
    • In the historical monitoring view, you can select a time range (Last hour, Last 3 hours, Last 24 hours, Last 7 days, or a custom time range) to display the monitoring dashboard in the selected time range.

    Monitoring Metrics

    DBbrain (TencentDB for MySQL)

    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 Memory Usage
    volume_rate Disk Utilization
    real_capacity Used Disk Space
    capacity Occupied Disk Space
    bytes_sent Outbound Traffic
    bytes_received Inbound Traffic
    qps QPS
    tps TPS
    connection_use_rate Connection Utilization
    max_connections Max Connections
    threads_connected Connected Threads
    slow_queries Slow Queries
    select_scan Full-Table Scans
    select_count Queries
    com_update Updates
    com_delete Deletions
    com_insert Insertions
    com_replace Overwrites
    queries Total Requests
    query_rate Query Utilization
    created_tmp_tables Temp Tables
    table_locks_waited Table Locks Awaited
    innodb_cache_hit_rate InnoDB Cache Hit Rate
    innodb_cache_use_rate InnoDB Cache Utilization
    innodb_os_file_reads InnoDB Disk Reads
    innodb_os_file_writes InnoDB Disk Writes
    innodb_os_fsyncs InnoDB fsync Count
    innodb_num_open_files InnoDB Opened Tables
    key_cache_hit_rate MyISAM Cache Hit Rate
    key_cache_use_rate MyISAM Cache Utilization
    com_commit Submissions
    com_rollback Rollbacks
    threads_created Created Threads
    created_tmp_disk_tables Temp Disk Tables
    threads_running Running Threads
    created_tmp_files Temp Files
    handler_read_rnd_next Requests of Reading Next Row
    handler_rollback Internal Rollbacks
    handler_commit Internal Submissions
    innodb_buffer_pool_pages_free InnoDB Empty Pages
    innodb_buffer_pool_pages_total Total InnoDB Pages
    innodb_buffer_pool_read_requests InnoDB Logical Reads
    innodb_buffer_pool_reads InnoDB Physical Reads
    innodb_data_read InnoDB Reads
    innodb_data_reads Total InnoDB Reads
    innodb_data_written InnoDB Writes
    innodb_data_writes Total InnoDB Writes
    innodb_rows_deleted InnoDB Rows Deleted
    innodb_rows_inserted InnoDB Rows Inserted
    innodb_rows_updated InnoDB Rows Updated
    innodb_rows_read InnoDB Rows Read
    innodb_row_lock_time_avg Average InnoDB Row Lock Acquiring Time
    innodb_row_lock_waits InnoDB Row Lock Waits
    key_blocks_unused Unused Blocks in Key Cache
    key_blocks_used Used Blocks in Key Cache
    key_read_requests Data Blocks Read by Key Cache
    key_reads Data Blocks Read by Disks
    key_write_requests Data Blocks Written into Key Cache
    key_writes Data Blocks Written into Disks
    opened_tables Opened Tables
    table_locks_immediate Table Locks Released Immediately
    open_files Total Opened Files
    log_capacity Log Space
    slave_io_running IO Thread Status
    slave_sql_running SQL Thread Status
    master_slave_sync_distance Source-Replica Delay Distance
    seconds_behind_master Source-Replica Delay Time

    DBbrain (TDSQL-C for MySQL)

    In DBbrain, the custom monitoring dashboard for TDSQL-C for MySQL currently supports the following monitoring metrics.

    Monitoring Metric Description
    cpu_use_rate CPU Utilization
    memory_use_rate Memory Utilization
    memory_use Memory Usage
    volume_rate Storage Utilization
    real_capacity Used Storage Space
    qcache_hits Cache Hits
    qcache_hit_rate Cache Hit Rate
    capacity Total Storage Space
    bytes_sent Outbound Traffic
    bytes_received Inbound Traffic
    queries QPS
    com_commit TPS
    max_connections Max Connections
    threads_connected Connected Threads
    slow_queries Slow Queries
    select_scan Full-Table Scans
    select_count Queries
    com_update Updates
    com_delete Deletions
    com_insert Insertions
    com_replace Overwrites
    created_tmp_tables Temp Tables
    innodb_cache_hit_rate InnoDB Cache Hit Rate
    innodb_cache_use_rate InnoDB Cache Utilization
    threads_created Created Threads
    threads_running Running Threads
    handler_rollback Rolled-Back Transactions per Second
    innodb_buffer_pool_read_requests InnoDB Logical Reads
    handler_commit Committed Transactions per Second
    innodb_buffer_pool_write_requests InnoDB Logic Write
    innodb_rows_deleted InnoDB Rows Deleted
    innodb_rows_updated InnoDB Rows Updated
    innodb_rows_inserted InnoDB Rows Inserted
    innodb_rows_read InnoDB Rows Read
    log_capacity Log Space
    replicate_lag Replica Instance Delay in Redo Log Based Replication
    replicate_lsn_lag Redo Log LSN Difference between Source and Replica Instances
    replicate_status Replication Status of Replica Instance

    DBbrain (TencentDB for Redis)

    In DBbrain, the custom monitoring dashboard for TencentDB for Redis currently supports the following monitoring metrics:

    Monitoring Metric Description
    cmd_big_value Big Value Request
    cmd_err Execution Error
    cmd_hits Read Request Hit
    cmd_hits_ratio Read Request Hit Rate
    %cmd_key_count Key Requests
    cmd_mget Mget Requests
    cmd_miss Read Request Miss
    cmd_other Other Requests
    cmd_read Read Request
    cmd_slow Slow Query
    cmd_write Write Request
    commands Total Requests
    connections Connections
    connections_util Connection Utilization
    %cpu_max_util Max Node CPU Utilization
    %cpu_util CPU Utilization
    %evicted Evicted Keys
    expired Expired Keys
    in_bandwidth_util Inbound Traffic Utilization
    %in_flow Inbound Traffic
    MBit/sin_flow_limit Inbound Traffic Throttling Trigger
    keys Total Keys
    latency_max Max Execution Latency
    mslatency_other Avg Latency of Other Commands
    mslatency_avg Avg Execution Latency
    mslatency_read Avg Read Latency
    mslatency_write Avg Write Latency
    msmem_max_util Max Node MEM Utilization
    %mem_used Memory Usage
    MBmem_util Memory Utilization
    %out_bandwidth_util Outbound Traffic Utilization
    %out_flow Outbound Traffic
    MBit/sout_flow_limit Outbound Traffic Throttling Trigger
    latency_p99 P99 Execution Latency

    DBbrain (self-built MySQL)

    In DBbrain, the custom monitoring dashboard for self-built MySQL currently supports the following monitoring metrics:

    Monitoring Metric Description Agent Access Direct Access
    cpu_use_rate CPU Utilization ×
    memory_use_rate Memory Utilization ×
    memory_use Memory Usage ×
    volume_rate Disk Utilization ×
    real_capacity Used Disk Space ×
    capacity Occupied Disk Space ×
    bytes_sent Outbound Traffic
    bytes_received Inbound Traffic
    qps QPS
    tps TPS
    connection_use_rate Connection Utilization
    max_connections Max Connections
    threads_connected Connected Threads
    slow_queries Slow Queries
    select_scan Full-Table Scans
    select_count Queries
    com_update Updates
    com_delete Deletions
    com_insert Insertions
    com_replace Overwrites
    queries Total Requests
    query_rate Query Utilization
    created_tmp_tables Temp Tables
    table_locks_waited Table Locks Awaited
    innodb_cache_hit_rate InnoDB Cache Hit Rate
    innodb_cache_use_rate InnoDB Cache Utilization
    innodb_os_file_reads InnoDB Disk Reads
    innodb_os_file_writes InnoDB Disk Writes
    innodb_os_fsyncs InnoDB fsync Count
    innodb_num_open_files InnoDB Opened Tables
    key_cache_hit_rate MyISAM Cache Hit Rate
    key_cache_use_rate MyISAM Cache Utilization
    com_commit Submissions
    com_rollback Rollbacks
    threads_created Created Threads
    created_tmp_disk_tables Temp Disk Tables
    threads_running Running Threads
    created_tmp_files Temp Files
    handler_read_rnd_next Requests of Reading Next Row
    handler_rollback Internal Rollbacks
    handler_commit Internal Submissions
    innodb_buffer_pool_pages_free InnoDB Empty Pages
    innodb_buffer_pool_pages_total Total InnoDB Pages
    innodb_buffer_pool_read_requests InnoDB Logical Reads
    innodb_buffer_pool_reads InnoDB Physical Reads
    innodb_data_read InnoDB Reads
    innodb_data_reads Total InnoDB Reads
    innodb_data_written InnoDB Writes
    innodb_data_writes Total InnoDB Writes
    innodb_rows_deleted InnoDB Rows Deleted
    innodb_rows_inserted InnoDB Rows Inserted
    innodb_rows_updated InnoDB Rows Updated
    innodb_rows_read InnoDB Rows Read
    innodb_row_lock_time_avg Average InnoDB Row Lock Acquiring Time
    innodb_row_lock_waits InnoDB Row Lock Waits
    key_blocks_unused Unused Blocks in Key Cache
    key_blocks_used Used Blocks in Key Cache
    key_read_requests Data Blocks Read by Key Cache
    key_reads Data Blocks Read by Disks
    key_write_requests Data Blocks Written into Key Cache
    key_writes Data Blocks Written into Disks
    opened_tables Opened Tables
    table_locks_immediate Table Locks Released Immediately
    open_files Total Opened Files
    log_capacity Log Space ×
    Contact Us

    Contact our sales team or business advisors to help your business.

    Technical Support

    Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

    7x24 Phone Support