- Enter to MySQL/MariaDB server command-line tool (change root with your username and password):
mysql -u root -proot- Set the general log file path:
SET GLOBAL general_log_file='/var/log/mysql/mycustom.log';
joseluisq
/ mysql_query_log.md
Last active
November 27, 2025 09:34
How to enable the MySQL/MariaDB general query logs
Picking the right architecture = Picking the right battles + Managing trade-offs
- Clarify and agree on the scope of the system
- User cases (description of sequences of events that, taken together, lead to a system doing something useful)
- Who is going to use it?
- How are they going to use it?