MySQL

Configure MySQL Log Source with BindPlane

Supported Versions

MySQL versions

  • 9.0
  • 8.0
  • 5.7

MariaDB versions

  • 10.6
  • 10.5
  • 10.4
  • 10.3
  • 10.2

Prerequisites

To enable certain log files, it may be necessary to edit the MySQL configuration file: mysqld.cnf.

Error Log

This is generally enabled by default. To change the file path, you can set or update "log_error" within mysqld.cnf.

For more details, see the error log documentation here.

Query Log

🚧

Query Log

Note that by enabling the query log, all queries will be logged. This can consume significant disk space.

To enable the query log, set general_log_file to the desired log path and set general_log = 1.

For more details, see the query log documentation here.

Slow Query Log

To enable the slow query log, set slow_query_log_file to the desired log path. Set slow_query_log = 1 and optionally, configure long_query_time.

For more details, see the slow query log documentation here.

Configuration

Option

Description

General Logs

Use this field to verify the path to the General log file and adjust default as needed (/var/log/mysql/general.log).

Slow Query Logs

Use this field to verify the path to the Slow Query log file and adjust default as needed (/var/log/mysql/slow.log).

Error Logs

Use this field to verify the path to the Error log file and adjust default as needed (/var/log/mysql/mysqld.log).

Start At

Choose whether to start reading from the beginning or end of a file with "end" being the default.

Log Types

Types

mysql.slow_query

mysql.server-start

mysql.error

mysql.audit

mysql.general

Dashboards

Dashboards for this source will be added soon.

Advanced

For more information on the advanced configuration capabilities, see our detailed plugin guide here.