Mysql – How to monitor thesql slow log and send mail to alert

alertemailmonitoringMySQL

I have enabled mysql slow query log on Ubuntu server.
I prefer to get the email alert with the slow sql when any slow query appeared so I can optimize the sql.
I need a lightweight solution.

Best Answer

I often use the mytop, top like query monitor for MySQL it is a Perl script with some hack you can add a functionality of send alert notification.

Related Solutions

Mysql slow query log is on but not logging anything

I had the same problem. Solved it after reading this: https://stackoverflow.com/a/11861305/686304

In order to enable slow queries logging, you need first to enable general logging.

Just set 'general_log' to 'ON' (in my.cnf)

general_log = 1

MySQL – How to Enable Slow Query Log

Correct.

It's best to put this in the general/global (top) part of your my.cnf file.

There are two things you need to do : (1) enable it, and (2) define the logfile destination.

slow_query_log = 1
slow_query_log_file = /var/log/mysql/slow-query.log

Hope this helps.

Best Answer

Related Solutions

Mysql slow query log is on but not logging anything

MySQL – How to Enable Slow Query Log

Related Topic