Mysql --log-slow-queries

[Djunity]

[SOLVED]

Hi all,

If have tryd a few things allready but i am unable to add this function to mysql http://dev.mysql.com/doc/refman/4.1/en/slow-query-log.html

I have added

log-slow-queries=/var/log/mysql-slow.log

to the /etc/my.cnf
but when i try to start mysqld again it failed with error:

Starting MySQL....The server quit without updating PID file (/var/lib/mysql/server.domain.com.pid).

How do you have to add it to mysql ?

 

[Djunity]

Did find the anwser it should be:

slow-query-log = 1
slow-query-log = /var/log/mysql_slow_query.log