Help Center > > User Guide> MySQL Database Management (Standard Edition)> CloudDBA> Real-Time Performance

Real-Time Performance

Updated at: Mar 20, 2020 GMT+08:00

Scenarios

With CloudDBA, you can comprehensively analyze DB instances to understand their performance and operating statuses. CloudDBA provides multi-dimensional and real-time performance monitoring information about a single instance, multiple DB instances, and displays performance dashboard of multiple DB instances.

Prerequisites

You have logged in to the DAS console.

Procedure

  1. In the upper menu bar, choose CloudDBA > Real-Time Performance. The monitoring metrics are displayed.
  2. View single-instance performance, multi-instance performance, or multi-instance performance dashboard. You can start or stop monitoring and set the monitoring interval (1 to 10 seconds).
  3. Click Settings in the upper right corner of the page. On the displayed page, select the required metrics. There are 21 performance metrics in total. You can choose to view the metrics in graphs or a table or drag the graph to adjust its location.

    Table 1 Real-time performance metrics

    Metric

    Description

    QPS

    Number of SQL statements executed per second.

    TPS

    Average number of transactions executed per second.

    thread_conn

    Number of connections

    thread_run

    Number of active connections

    com_sel

    Number of times that the select statement is executed per second

    com_ins

    Number of times that the insert statement is executed per second

    com_upd

    Number of times that the update statement is executed per second

    com_del

    Number of times that the delete statement is executed per second

    netIn

    Incoming traffic

    netOut

    Outgoing traffic

    netTotal

    Total traffic

    ibp_dirtyPages

    Percentage of dirty pages in the InnoDB buffer pool

    hits

    Cache hit ratio

    rows_ins

    Number of rows written from the table in the InnoDB storage engine

    rows_read

    Number of rows read from the table in the InnoDB storage engine

    rows_upd

    Number of updated rows from the table in the InnoDB storage engine

    rows_del

    Number of deleted rows from the table in the InnoDB storage engine

    ibp_usedPages

    InnoDB buffer pool usage

    ibp_readHits

    InnoDB buffer pool hit ratio.

    com_ins_sel

    Number of times that the insert and query statements are executed per second

    tmpDiskTables

    Number of temporary tables that are automatically created on the disk when statements are executed

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel