Real-Time Performance

Procedure

1. Log in to the DAS console.
2. On the Overview page, click Go to Intelligent O&M.
3. Locate your desired instance and click Details to go to the Intelligent O&M overview page.
4. On the Real-Time Performance tab page, view the server uptime, connection information, and buffer pool.
5. Click Start/Pause or change the time interval (1 to 10 seconds) to adjust the performance monitoring. You can also click Set Metric to specify required metrics based on service requirements.

   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:Transactions executed per second
   Connections	Total: Number of enabled connections. Active: Active connections among the enabled ones.
   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: 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 updated in 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 wait times of InnoDB row locks. Current InnoDB Row Lock Waits: Current waits of InnoDB row locks.
   Temporary Tables | Files	Temporary tables: Temporary tables that are automatically created during SQL statement execution. Temporary files: 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.