Turn "log slow queries" ON.
- by CodedK
Hello,
I'm trying to log mysql slow queries, but I can't turn it on.
I will explain all my steps:
Open and Edit my.cnf and add the following lines:
long_query_time = 5
slow_query_log_file = /myfolder/slowq.log
log_slow_queries = 1 =(I have MySQL 5.0.7)
Give mysql user permitions to write on the file:
chown -R mysql:mysql…