Need Help Getting Slow Query Log Working On Centos Setup.

[marcm]

post removed. I attempted to stop the service but it failed somehow. I used the command: # /etc/init.d/MONyogd stop and it stopped it and I was able to restart it.

[Sayan Chaliha]

Hey Marc,

Depending on your MySQL server version, you can enable your slow query log from within MONyog's interface (check attached screen-shot; this feature requires MySQL versions 5.1.6 or above).

If you're using an older version of the server, you could add the following to your my.cnf/my.ini:

Code:

slow_query_log=ON
slow_query_log_file= log_slow_queries=ON
long_query_time=
log_queries_not_using_indexes=

As for guidelines on where to store the slow query log file, you should check MySQL's documentation; specifically: http://dev.mysql.com…log-tables.html

Using NOW() is okay. However, you should know that NOW() returns the time when the query began execution, and not the current system time. To get the current system time use SYSDATE() instead.

PS: The screen-shot attachment failed… I'll try and upload it again.

[Sayan Chaliha]

[attachment=1404:slowlog.JPG]

[marcm]

Hi Sayan,

Thank you. I was able to manually add it into my my.cnf file and I added a path and then just manually inserted the path into MONyog and it worked. 🙂

So far I am loving MONyog and I only wish I would have installed it sooner 😉

Once I added in the SSH settings and got the monitors and advisors working I was really pleased!

Thanks again.

I'm sure I'll be back with more questions.

[Sayan Chaliha]

Hey Marc,

Glad that you're liking MONyog! You're always welcome here with any questions you may have. You can also create a support ticket here if you think you've run into problems with MONyog, and rest assured, we'll try our best and address those issues within 24 working hours!

Also please feel free to give us any feedback you may have while using MONyog (you can mail them to [email protected]).

[Author]

Posts