The monitoring data embedded in the panel can be used for MySQL monitoring and alerting regarding resources, performance, and capacity, and supports configuring notification policies.
The intuitively presented monitoring data can be utilized to provide decision support for operational inspection or performance tuning.
The platform collects the commonly used monitoring metrics related to MySQL's resources, performance, and capacity by default. In the Monitoring tab of the instance, real-time monitoring data for the metrics can be viewed.
Metric | Default Monitoring Metric |
---|---|
Pod CPU Utilization | Pod's CPU usage. Pods with a CPU usage exceeding 100% will be ignored, because under normal circumstances, the CPU usage will not exceed 100%. If it exceeds 100%, please check whether all containers of the pod have set resource limits. |
Pod Memory Utilization | Pod's memory usage. Pods with a memory usage exceeding 100% will be ignored, because under normal circumstances, memory usage will not exceed 100%. If it exceeds 100%, please check whether all containers of the pod have set resource limits. |
Network Received | The average bytes per second received from the network in the past 5 minutes |
Network Transmitted | The average bytes per second sent onto the network in the last 5 minutes |
PVC Used | PVC storage usage. |
MySQL Connections | Max Connections is the maximum permitted number of simultaneous client connections. By default, this is 151. Increasing this value increases the number of file descriptors that mysqld requires. |
MySQL Client Thread Activity | Threads Connected is the number of open connections, while Threads Running is the number of threads not sleeping. |
MySQL Table Locks | MySQL takes a number of different locks for varying reasons. In this graph, we can see how many table-level locks MySQL has requested from the storage engine. |
MySQL Sorts | This graph also shows when sorts had to scan a whole table or a given range of a table in order to return the results that could not have been sorted via an index. |
MySQL Slow Queries | Slow queries are defined as queries that are slower than the long_query_time setting. |
InnoDB Buffer Pool Requests | InnoDB Buffer Pool Requests refers to the total number of read and write requests made to the InnoDB buffer pool. |
TPS | Transactions Per Second (TPS) is a key performance metric that measures the number of transactions MySQL processes per second. |
Commands | Commands refer to the number of SQL statements executed by MySQL, including queries, inserts, updates, deletes, and other database operations. |