Updated on 2024-08-29 GMT+08:00

Real-Time Performance

The Real-Time Performance tab displays key metrics of your instance and allows you to compare performance of your instance by date, helping you keep track of changes of your periodic services and metrics and detect exceptions.

Procedure

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and project.
  3. Click in the upper left corner, and under Databases, click Data Admin Service.
  4. In the navigation pane, choose Intelligent O&M > Instance List.

    Alternatively, on the Overview page, click Go to Intelligent O&M.

  5. In the upper right corner of the Instance List page, search for instances by engine type, instance name, or instance IP.

    Figure 1 Searching for instances

  6. Locate the instance whose real-time performance you want to view and click Details.
  7. Choose Performance > Real-Time Performance.

    • View the server uptime, connection information, and buffer pool information.
      Figure 2 Viewing server information
    • Click Set Metric, select the metrics to display, and click OK.
      Figure 3 Setting performance metrics
      Table 1 Real-time performance metrics

      Metric

      Description

      Slow Sessions

      [Slow Session] Number of new slow sessions.

      QPS | TPS

      QPS: SQL statement executions per second.

      TPS: Transactions executed per second.

      Connections

      Total: Number of enabled connections.

      Active: Number of active connections.

      DML Executions

      select: SELECT statement executions per second.

      insert: INSERT statement executions per second.

      update: UPDATE statement executions per second.

      delete: DELETE statement executions per second.

      insert_select: INSERT and QUERY statement executions per second.

      InnoDB Cache

      Cache Hit Ratio: Measures how many content requests a cache can deliver successfully from its cache storage, compared to how many requests it receives.

      Cache Usage: Cache usage.

      InnoDB Accessed Rows

      rows_read: Rows read from an InnoDB storage engine table.

      rows_inserted: Rows inserted into an InnoDB storage engine table.

      rows_updated: Rows written from an InnoDB storage engine table.

      rows_deleted: Rows deleted from an InnoDB storage engine table.

      Logical Reads | Physical Reads

      Logic Reads: Logical reads per second.

      Physical Reads: Physical reads per second.

      InnoDB Average Row Lock Duration (ms)

      Average lock time of InnoDB row locks. The unit is ms.

      InnoDB Row Lock Waits

      Average InnoDB Row Lock Waits: Average waits of InnoDB row locks.

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

      Temporary Tables | Files

      Temporary tables: Temporary tables automatically created when SQL statements are executed.

      Temporary files: Temporary files automatically created when SQL statements are executed.

      Network Traffic

      Total: Total incoming and outgoing traffic of an instance.

      Incoming: Incoming traffic of an instance.

      Outgoing: Outgoing traffic of an instance.

    • Adjust the time interval of collecting metrics. The interval ranges from 1 to 10 seconds.
      Figure 4 Adjusting the time interval of collecting metrics
    • Pause or start the real-time performance function based on service requirements.
      Figure 5 Pausing or starting the real-time performance function