Charmed MySQL K8s

Channel Revision Published Runs on
8.0/stable 180 02 Sep 2024
Ubuntu 22.04
8.0/stable 181 02 Sep 2024
Ubuntu 22.04
8.0/candidate 211 11 Dec 2024
Ubuntu 22.04
8.0/candidate 210 11 Dec 2024
Ubuntu 22.04
8.0/beta 211 09 Dec 2024
Ubuntu 22.04
8.0/beta 210 09 Dec 2024
Ubuntu 22.04
8.0/edge 211 09 Dec 2024
Ubuntu 22.04
8.0/edge 210 09 Dec 2024
Ubuntu 22.04
juju deploy mysql-k8s --channel 8.0/stable
Show information

Platform:

Alert rules

This page contains a markdown version of the alert rules described in the mysql-k8s-operator repository. The following file(s) are the source of truth:

This documentation describes the latest alert rule expressions. See the YAML file(s) on listed above if you require an older version.

MySQLExporterK8s

Alert Severity Notes
MySQLDown critical MySQL instance is down.
MySQLTooManyConnections(>90%) warning MySQL instance is using > 90% of max_connections.
Consider checking the client application responsible for generating those additional connections.
MySQLHighThreadsRunning warning MySQL instance is actively using > 80% of max_connections.
Consider reviewing the value of the max-connections config parameter or allocate more resources to your database server.
MySQLHighPreparedStatementsUtilization(>80%) warning MySQL instance is using > 80% of max_prepared_stmt_count.
Too many prepared statements might consume a lot of memory.
MySQLSlowQueries info MySQL instance has a slow query.
Consider optimizing the query by reviewing its execution plan, then rewrite the query and add any relevant indexes.
MySQLInnoDBLogWaits warning MySQL instance has long InnoDB log waits.
MySQL InnoDB log writes might be stalling. Check I/O activity on your nodes to find the responsible process or query. Consider using iotop and the performance_schema.
MySQLRestarted info MySQL instance restarted.
MySQL restarted less than one minute ago. If the restart was unplanned or frequent, check Loki logs (e.g. error.log).

Help improve this document in the forum (guidelines). Last updated 2 months ago.