MySQL Logs Monitoring | Atatus Documentation

The MySQL module collects the error and slow logs generated by MySQL server.

Setup & Configuration

The MySQL module is included with the Atatus Infra agent by default, please follow the below steps to enable.

Add the following lines in the file /etc/atatus-infra-agent/atatus.yml.

copy
```
logs_enabled: true
```
Copy the mysql example configuration file.

copy
```
cd /etc/atatus-infra-agent/conf.d/mysql.d/
sudo cp mysql.yml.template mysql.yml
```

Update the file /etc/atatus-infra-agent/conf.d/mysql.d/mysql.yml with below configurations.

copy

# Log section
logs:

  # - type : (mandatory) type of log input source (error / slowlog)

  - type: error
  - type: slowlog

copy

# If you have custom mysql log path, you can use below syntax

  # - type: (mandatory) type of log input source (error / slowlog)
  #   paths: (mandatory) Set paths if type is file
  #   service: (mandatory) name of the service owning the log
  #   source: (mandatory) attribute that defines which integration is sending the log

# Log section
logs:
   - type: error
     paths:
        - /var/log/mysql/error.log*
        - /var/log/mysqld.log*
     source: mysql
     service: mysql
   - type: slowlog
     paths:
        - /var/log/mysql/mysql-slow.log*
     source: mysql
     service: mysql

Restart the atatus infrastructure agent.

copy
```
sudo service atatus-infra-agent restart
```