Jump to content


Photo

Empty Slow Query Log Displays An Error


  • Please log in to reply
1 reply to this topic

#1 Art van Scheppingen

Art van Scheppingen

    Newbie

  • Members
  • Pip
  • 1 posts

Posted 29 November 2011 - 10:57 AM

On most of our servers we implemented a log rotate script that will flush the log files, resulting in "empty" logfiles containing this:

/usr/sbin/mysqld, Server version: 5.1.58-rel12.9-log Percona Server (GPL), 12.9, Revision 271. started with:
Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock
Time Id Command Argument


But MONyog shows me this error:

Error
No queries were found.
Make sure you have given valid slow query log file. Slow Query Log and General Query Log have different formats. Make sure you have entered the correct filename. Click here to review settings for this connection

If a query gets logged the error will go away.
The second line is correct, but the first and third line will actually confuse our DBAs.
Can you add an extra check if the slow log file contains the header info?
Thanks!

#2 Mahesh

Mahesh

    Advanced Member

  • Admin
  • PipPipPip
  • 491 posts
  • Gender:Male
  • Location:Bangalore,India
  • Interests:MySQL, Cricket, Music..

Posted 30 November 2011 - 05:14 AM

Actually this is generic message we are showing in-case there is no query logged or by mistake user has specified incorrect file path for slow log section mentioned "General log" file path and vice-versa.

I have added your request regarding 3rd line:
Make sure you have given valid slow query log file. Slow Query Log and General Query Log have different formats. Make sure you have entered the correct filename. Click here to review settings for this connection
Program should have extra check, whether mentioned file path belongs to slow log or general log respectively or any other invalid file path.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users