Real-Time Performance

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