The logs collected for MySQL are the General, Error, and Slow Query logs. The examples below include an aborted connection to a database from the Error logs and several query related logs from the General logs.
MySQL Error Logs Example
MySQL General Logs Example
MySQL Slow Query Logs Example
MySQL: 5.6.x, 5.7.x, 8.x
Follow these steps to set up log collection from MySQL.
Locate the local MySQL log file locations.
MySQL Log Files
For more information on MySQL log files, click here.
- Install the BindPlane Log Agent on the host system.
- Login to BindPlane and select the Logs tab.
- Select the Sources tab.
- In the top-right portion of the screen, click on the Add Source Configuration button
Add Source Configuration Button
- Choose MySQL
- Fill out the MySQL log configuration options.
MySQL Log Configuration Form
Choose the log types to collect from, and ensure the path is correct.
Updated 2 months ago