MySQL

Configure MySQL Log Source with BindPlane

356

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

OptionDescription
General LogsUse this field to verify the path to the General log file and adjust default as needed (/var/log/mysql/general.log).
Slow Query LogsUse this field to verify the path to the Slow Query log file and adjust default as needed (/var/log/mysql/slow.log).
Error LogsUse this field to verify the path to the Error log file and adjust default as needed (/var/log/mysql/mysqld.log).
Start AtChoose 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

Advanced

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