With CloudDBA, you can comprehensively analyze DB instances to understand their performance and operating statuses. CloudDBA provides multi-dimensional and real-time performance monitoring information about a single instance, multiple DB instances, and displays performance dashboard of multiple DB instances.
You have logged in to the DAS console.
- In the upper menu bar, choose CloudDBA > Real-Time Performance. The monitoring metrics are displayed.
- View single-instance performance, multi-instance performance, or multi-instance performance dashboard. You can start or stop monitoring and set the monitoring interval (1 to 10 seconds).
- Click Settings in the upper right corner of the page. On the displayed page, select the required metrics. There are 21 performance metrics in total. You can choose to view the metrics in graphs or a table or drag the graph to adjust its location.
Table 1 Real-time performance metrics
Number of SQL statements executed per second.
Average number of transactions executed per second.
Number of connections
Number of active connections
Number of times that the select statement is executed per second
Number of times that the insert statement is executed per second
Number of times that the update statement is executed per second
Number of times that the delete statement is executed per second
Percentage of dirty pages in the InnoDB buffer pool
Cache hit ratio
Number of rows written from the table in the InnoDB storage engine
Number of rows read from the table in the InnoDB storage engine
Number of updated rows from the table in the InnoDB storage engine
Number of deleted rows from the table in the InnoDB storage engine
InnoDB buffer pool usage
InnoDB buffer pool hit ratio.
Number of times that the insert and query statements are executed per second
Number of temporary tables that are automatically created on the disk when statements are executed