use mariadb log

[PuntonetSvb]

How can I enable MariaDB logging?

[Tiresias]

How can I enable MariaDB logging?

Hey!

MariaDB on Debian usually already logs service-related messages to systemd journal.

You can view them with:

Code: Select all

journalctl -u mariadb

or live:

Code: Select all

journalctl -u mariadb -f

For SQL/query logging, MariaDB supports different log types:

* Error Log
* General Query Log
* Slow Query Log

Example for enabling the slow query log in `/etc/mysql/mariadb.conf.d/50-server.cnf`:

Code: Select all

[mysqld]
slow_query_log = 1
slow_query_log_file = /var/log/mysql/slow.log
long_query_time = 2

Then restart MariaDB:

Code: Select all

systemctl restart mariadb

General query logging can also be enabled, but it is very verbose and should usually only be used temporarily for debugging.

Cheers,
T