Unknown variable 'slow_query_log=1' [closed]
Solution 1:
As Michael Hampton pointed out, you almost certainly have slow_query_log in the wrong section or the wrong file. One can have multiple my.cnf
s, and each my.cnf
is laid out as an INI file, with each command picking up different section(s); for example, [client]
is ignored by mysqld
, but is read by mysqldump
, and then overridden by any settings supplied in [mysqldump]
.
For slow_query_log
, you usually would want that in the [mysqld]
section of your server-level my.cnf
. Including it in your user my.cnf
(i.e., ~/.my.cnf
) will have no effect whatsoever, as the server is what needs to read it.