MySQL and MariaDB queries per second alert


The Queries Per Second alert notifies you when its configured condition is met on MySQL and MariaDB instances so you can investigate and respond.

Screenshot pending: Mini DBA MySQL and MariaDB Queries Per Second alert screenshot placeholder

Alert summary

  • Platform: MySQL and MariaDB
  • Alert category: Query
  • Default enabled: true
  • Default evaluation frequency: Minute
  • Threshold label: Complete per second
  • Unit: queries

What Mini DBA checks

Mini DBA describes this alert as: Queries completed per second Both slow and normal are counted Mini DBA evaluates this alert once a minute so changes are detected quickly.

How this alert helps

This alert helps reveal query and workload pressure. It points you toward expensive statements, plan changes, inefficient access patterns, or bursts of work that need investigation before they affect service levels.

When to enable it

Enable it on any monitored MySQL and MariaDB instance where this condition would require an administrator to investigate or communicate with the application team. Tune noisy development systems after you have a short baseline.

Threshold guidance

Threshold meaning: Complete per second. Major threshold: 200 queries. Minor threshold: 100 queries. Comparison direction: over. For an over-threshold alert, decreasing a threshold makes that severity fire sooner; increasing it tolerates more load or pressure. Set the minor threshold as an early-warning level and the major threshold at the highest acceptable value for the service.

Remediation for an active alert

Use the query, wait, and performance views to find the statement or subsystem behind the pressure. Compare against the recent baseline, update statistics, tune indexes, adjust application batching, and move maintenance work away from peak periods where possible.

Investigation workflow

  1. Confirm the alert is still active and note the first seen time, affected instance, and severity.
  2. Review the lead session, SQL text, wait type, blocking chain, login, host, and application name in Mini DBA before changing configuration or ending sessions.
  3. Compare the current value with the normal baseline for the same time of day or maintenance window.
  4. Record the cause, corrective action, and whether thresholds or routing should be adjusted after the incident.

Avoiding alert noise

If this alert is noisy, check whether the workload naturally has short bursts. Raise the duration or threshold for expected batch windows, but keep a lower route for production systems where user-facing latency matters. Avoid simply disabling the alert until you know whether the noise is caused by threshold choice or by a real capacity trend.

Related pages