MariaDB Query Logging

Quick note on how to configure file-based query logging in MariaDB & turn query logging on and off:

SET GLOBAL general_log_file='/var/log/mariadb/query.log';
SET GLOBAL log_output = 'FILE';
-- Turn on query logging
SET GLOBAL general_log = 'ON';
-- Turn off query logging
SET GLOBAL general_log = 'OFF';

Leave a Reply

Your email address will not be published. Required fields are marked *