How to Use the MySQL Query Wizard in Nagios XI

The MySQL Query Wizard in Nagios XI makes it easy to monitor the results of specific SQL queries from your MySQL or MariaDB databases. Instead of relying only on general server stats, this wizard lets you track custom values like row counts, replication lag, or order backlogs.

Simply provide your database connection details, enter the SQL query you’d like to monitor, and define your warning and critical thresholds. Within minutes, you’ll have proactive monitoring in place for the metrics that matter most to your applications.

You can also refer to this documentation for full details:

Here is a direct link to the PDF as well:

MySQL Wizard Query