slow queries log wont work
Uptime: 1258 Threads: 1 Questions: 37925 Slow queries: 110 Opens: 182 Flush tables: 1 Open tables: 176 Queries per second avg: 30.147
so the mysqld after being restarted hasnt been up all that long, but the slow queries keep building,
In my.cnf
[safe_mysqld]
set-variable = long_query_time=1
set-variable = log-slow-queries = /var/mysql/slow_queries.log
I've even tried putting this in
[mysqld]
set-variable = long_query_time=1
set-variable = log-slow-queries = /var/mysql/slow_queries.log
I'm using mysql ver 3
-rw-rwxrw- 1 mysql mysql 0 Jun 9 21:29 slow_queries.log
then i check permissions, but the file is empty
