用 DumbMonit 监控 MySQL or MariaDB database

Logs in and runs a query: catches a database that is up but no longer answering.

产品说明为英文，与产品内一致。页面标签使用您的语言。

DumbMonit 监控的内容

典型用途. Database: connection and a query you choose

示例

您需要准备

Username / passwordA read-only account created for monitoring, never an application one.

默认端口: 3306

设置步骤: Monitor a MySQL or MariaDB database

In the mysql client, create an account with no privilege (adjust the host part to the DumbMonit machine).
```
CREATE USER 'dumbmonit'@'%' IDENTIFIED BY 'a-long-password';
```
In DumbMonit, enter the server, for example db.home.lan:3307 (port 3306 by default), then the account's user and password.
Optional: replace the default query SELECT 1 with one that returns a single number, to chart it.

注意. The check opens a real connection on every poll: on an instance close to its connection limit, give it a longer interval.