searchjilo.blogg.se

Use Managed Service for Prometheus to view monitoring data and configure alert rules

Indicates the files that are opened by InnoDB. Mysql_global_status_innodb_num_open_files Indicates the files that are opened in the MySQL database. Indicates the files that are being opened.

Indicates the slow queries of the MySQL database. Indicates the connections that timed out. Indicates the failed connection attempts. When the number of connections reaches the upper limit, requests to establish connections are denied. Indicates the upper limit on the connections to the MySQL database. Indicates the maximum number of connections to the MySQL database. Indicates the number of threads on which the requests to connect to the MySQL database are sent but do not succeed yet. Indicates the number of threads on which connections to the MySQL database are established. You can use this metric to view the information about a specific error and the number of connection errors. Indicates connection errors that are one of the major database errors. Mysql_global_status_connection_errors_total

You can add an alert rule based on this metric to identify MySQL databases whose running duration is less than 30 minutes. Indicates the running duration of the MySQL database. Indicates whether the MySQL database is available.