Real-Time Performance

Procedure

1. Log in to the DAS 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.
8. Choose Performance > Real-Time Performance.
   • View the server uptime, connection information, and buffer pool information.
   • Click Set Metric, select the metrics to display, and click OK.

     Table 1 Real-time performance metrics

     Metric	Description
     Slow Sessions	Number of new slow sessions
     QPS | TPS	QPS: SQL statements executed per second TPS: transactions executed per second
     Connections	Total: enabled connections Active: active connections
     DML Executions	select: SELECT statements executed per second insert: INSERT statements executed per second update: UPDATE statements executed per second delete: DELETE statements executed per second insert_select: 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 (ms) of InnoDB row locks
     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.
   • Pause or start the real-time performance function based on service requirements.