Logs Collected

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 ExampleMySQL Error Logs Example

MySQL Error Logs Example

MySQL General Logs ExampleMySQL General Logs Example

MySQL General Logs Example

MySQL Slow Query Logs ExampleMySQL Slow Query Logs Example

MySQL Slow Query Logs Example

Supported Versions

MySQL: 5.6.x, 5.7.x, 8.x

Log Collection Setup

Follow these steps to set up log collection from MySQL.

Pre-requisites

Locate the local MySQL log file locations.

📘

MySQL Log Files

For more information on MySQL log files, click here.

Configure a MySQL Source

  1. Install the BindPlane Log Agent on the host system.
  2. Login to BindPlane and select the Logs tab.
Logs TabLogs Tab

Logs Tab

  1. Select the Sources tab.
Sources TabSources Tab

Sources Tab

  1. In the top-right portion of the screen, click on the Add Source Configuration button
Add Source Configuration ButtonAdd Source Configuration Button

Add Source Configuration Button

  1. Choose MySQL
  2. Fill out the MySQL log configuration options.
MySQL Log Configuration FormMySQL Log Configuration Form

MySQL Log Configuration Form

Choose the log types to collect from, and ensure the path is correct.