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

Real-Time Performance

Updated at: Sep 29, 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 a MySQL DB instance on the DAS console.

Procedure

  1. On the top menu bar, choose CloudDBA > Real-Time Performance.

    Figure 1 Real-Time Performance

  2. On the displayed page, view a variety of metrics, including slow SQL queries, connections, QPS/TPS. You can also pause or start the monitoring and set the monitoring interval (1 to 10 seconds).
  3. Click Set Metric in the upper right corner to select your required metrics. There are 26 performance metrics in total.

    Figure 2 Real-Time Performance
    Table 1 Real-time performance metrics

    Metric

    Description

    Slow Queries

    Difference between two adjacent slow query collection points.

    QPS | TPS

    QPS: Number of SQL statement executions per second.

    TPS: Number of transactions executed per second.

    Connections

    Total: Number of enabled connections.

    Active: Number of active connections among the enabled ones.

    DML Executions

    select: Number of SELECT statement executions per second.

    insert: Number of INSERT statement executions per second.

    update: Number of UPDATE statement executions per second.

    delete: Number of DELETE statement executions per second.

    insert_select: Number of INSERT and QUERY statement executions per second.

    InnoDB Cache

    Cache Hit Ratio: Cache hit ratio.

    Cache Usage: Cache usage.

    InnoDB Accessed Rows

    rows_read: Number of rows read from an InnoDB storage engine table.

    rows_inserted: Number of rows inserted into an InnoDB storage engine table.

    rows_updated: Number of rows updated in an InnoDB storage engine table.

    rows_deleted: Number of rows deleted from an InnoDB storage engine table.

    Logical Reads | Physical Reads

    Logic Reads: Number of logical reads per second.

    Physical Reads: Number of physical reads per second.

    InnoDB Average Row Lock Duration (ms)

    Average locking time of InnoDB row locks (ms).

    InnoDB Row Lock Waits

    Average InnoDB Row Lock Waits: Average wait times of InnoDB row locks.

    Current InnoDB Row Lock Waits: Number of current waits of InnoDB row locks.

    Temporary Tables | Files

    Temporary tables: Number of temporary tables that are automatically created during SQL statement execution.

    Temporary files: Number of temporary files that are automatically created during SQL statement execution.

    Network Traffic

    Total: Total incoming and outgoing traffic of an instance.

    Incoming: Incoming traffic of an instance.

    Outgoing: Outgoing traffic of an instance.

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