To enable certain log files, it may be necessary to edit the MySQL configuration file: mysqld.cnf.
To enable MariaDB Audit logs, it is necessary to install the MariaDB Audit Plugin. More information can be found here.
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.
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.
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.
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).
Use this field to verify the path to the Error log file and adjust default as needed (/var/log/mysql/mysqld.log).
Choose whether to start reading from the beginning or end of a file with "end" being the default.
Users can configure dashboards using visualizations. More information can be found on our visualizations and dashboards page.
For more information on the advanced configuration capabilities, see our detailed plugin guide here.
Updated about 1 year ago