Logs Management

Slow queries Logs

Open your MySQL configuration file (usually my.cnf or my.ini).

[mysqld]
slow_query_log = 1 # Activate Slow queries Logging
slow_query_log_file = /var/log/mysql/mysql-slow.log # Adjust the path as needed
long_query_time = 2 # Log queries taking longer than 2 seconds
log_queries_not_using_indexes = 1 # Optional: Log queries not using indexes


MySQL Console Options

SET GLOBAL slow_query_log = 'ON';
SET GLOBAL long_query_time = 2; -- Set to 2 seconds
Eninam BAGNABANA     |         |     bagnadavid@outlook.fr     |