Monitoring

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.

Performance Monitoring Panel

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.

MetricDefault Monitoring Metric
Pod CPU UtilizationPod'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 UtilizationPod'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 ReceivedThe average bytes per second received from the network in the past 5 minutes
Network TransmittedThe average bytes per second sent onto the network in the last 5 minutes
PVC UsedPVC storage usage.
MySQL ConnectionsMax 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 ActivityThreads Connected is the number of open connections, while Threads Running is the number of threads not sleeping.
MySQL Table LocksMySQL 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 SortsThis 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 QueriesSlow queries are defined as queries that are slower than the long_query_time setting.
InnoDB Buffer Pool RequestsInnoDB Buffer Pool Requests refers to the total number of read and write requests made to the InnoDB buffer pool.
TPSTransactions Per Second (TPS) is a key performance metric that measures the number of transactions MySQL processes per second.
CommandsCommands refer to the number of SQL statements executed by MySQL, including queries, inserts, updates, deletes, and other database operations.