[SOLVED] log-slow-queries my.cnf file

[miriamn]

Hello all,

 

I want to print the slow queries to a special log file, so I changed my /etc/my.conf file and add the following lines:

 

log-slow-queries = /logs/log/mysql_slow.log

long_query_time = 5

 

then I restart mysql and with "show variables" command saw that there was a change:

 

log_slow_queries                | ON                        |

| long_query_time                | 5                 

 

 

BUT-

I didn't find the log file I have been created!!!

 

What I have to do more?

 

thanks!!!

 

Miriam

[mysqldba]

Does the user that the MySQL server runs as have write permission to that directory?

[miriamn]

Hi,

Yow are right!!!

Now the file was created..

thank you!

 

Miriam