Updated on 2023-12-13 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 box containing your target instance and click Details.
  7. In the upper right corner of the page, click Go to Old Edition.

    Figure 2 Accessing Intelligent O&M of the old version

  8. Choose Performance > Real-Time Performance.

    • View the server uptime, connection information, and buffer pool information.
      Figure 3 Viewing server information
    • Click Set Metric, select the metrics to display, and click OK.
      Figure 4 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: Number of INSERT statements executed per second.

      InnoDB Cache

      Cache Hit Ratio: Cache hit ratio.

      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.

      Total lock waits: Total lock waits.

      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 5 Modifying the time interval
    • Pause or start the real-time performance function based on service requirements.
      Figure 6 Pausing or starting the real-time performance function