miriamn Posted September 25, 2008 Share Posted September 25, 2008 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 Link to comment https://forums.phpfreaks.com/topic/125756-solved-log-slow-queries-mycnf-file/ Share on other sites More sharing options...
mysqldba Posted September 26, 2008 Share Posted September 26, 2008 Does the user that the MySQL server runs as have write permission to that directory? Link to comment https://forums.phpfreaks.com/topic/125756-solved-log-slow-queries-mycnf-file/#findComment-651135 Share on other sites More sharing options...
miriamn Posted September 28, 2008 Author Share Posted September 28, 2008 Hi, Yow are right!!! Now the file was created.. thank you! Miriam Link to comment https://forums.phpfreaks.com/topic/125756-solved-log-slow-queries-mycnf-file/#findComment-652238 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.