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';