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.

11481148

MySQL Error Logs Example

11511151

MySQL General Logs Example

12291229

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.
284284

Logs Tab

  1. Select the Sources tab.
249249

Sources Tab

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

Add Source Configuration Button

  1. Choose MySQL
  2. Fill out the MySQL log configuration options.
506506

MySQL Log Configuration Form

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