MySQL-Exporter

Linux

Windows

The MySQL-Exporter is used to extract statistics and status information from the MySQL/MariaDB.

This provides information about the daemon itself as well as about queries (e.g. statistics on IOWaits and locks) and sessions.

Configuration

To obtain the desired information, a corresponding user must be created in the database:

CREATE USER 'vimon'@'localhost' IDENTIFIED BY 'vimonPassw0rd' WITH MAX_USER_CONNECTIONS 3;
GRANT PROCESS, REPLICATION CLIENT, SELECT ON *.* TO 'vimon'@'localhost';

The access data defined here must then be stored in config/mysql_exporter/my.cnf.

The password should not contain any special characters. Otherwise, the functionality of the exporter is not guaranteed.