MySQL Slow Query Log Analysis Plugin

[TheWitness]

All,

Pleased to announce a new Science Project plugin for those who make analyzing MySQL a part of their daily lives. It's not the end all, do all, but it sure helped me out.

You may obtain the plugin here:

http://docs.cacti.net/plugin:slowlog

I have attached some 'fancy' graphs and images below with actual data.

TheWitness

[mrevelle]

Thanks for this, though it doesn't work. Maybe I missed something but the plugin installs alright but it seems like the chdir statement in slowlog.php is screwing things up, the plugin keeps checking for stuff within */cacti/plugins as well as */cacti and apache is reporting the following errors because of it:



[Fri Sep 30 13:50:34 2011] [error] [client 172.31.0.78] File does not exist: /var/www/cacti/plugins/slowlog/include, referer: http://zeta.officemax.int/cacti/plugins ... slowlog.ph[Fri Sep 30 13:50:34 2011] [error] [client 172.31.0.78] File does not exist: /var/www/cacti/plugins/slowlog/plugins, referer: http://zeta.officemax.int/cacti/plugins ... slowlog.ph
[Fri Sep 30 13:50:34 2011] [error] [client 172.31.0.78] File does not exist: /var/www/cacti/plugins/slowlog/include, referer: http://zeta.officemax.int/cacti/plugins ... slowlog.ph[Fri Sep 30 13:50:34 2011] [error] [client 172.31.0.78] File does not exist: /var/www/cacti/plugins/slowlog/plugins, referer: http://zeta.officemax.int/cacti/plugins ... slowlog.ph
[Fri Sep 30 13:50:34 2011] [error] [client 172.31.0.78] File does not exist: /var/www/cacti/plugins/slowlog/images/tab_graphs.gif, referer: http://zeta.officemax.int/cacti/plugins/slow[Fri Sep 30 13:50:34 2011] [error] [client 172.31.0.78] File does not exist: /var/www/cacti/plugins/slowlog/images/transparent_line.gif, referer: http://zeta.officemax.int/cacti/plugin
[Fri Sep 30 13:50:34 2011] [error] [client 172.31.0.78] File does not exist: /var/www/cacti/plugins/slowlog/images/shadow_gray.gif, referer: http://zeta.officemax.int/cacti/plugins/slo[Fri Sep 30 13:50:34 2011] [error] [client 172.31.0.78] File does not exist: /var/www/cacti/plugins/slowlog/images/cacti_backdrop2.gif, referer: http://zeta.officemax.int/cacti/plugins
[Fri Sep 30 13:50:34 2011] [error] [client 172.31.0.78] File does not exist: /var/www/cacti/plugins/slowlog/images/tab_console.gif, referer: http://zeta.officemax.int/cacti/plugins/slo[Fri Sep 30 13:50:34 2011] [error] [client 172.31.0.78] File does not exist: /var/www/cacti/plugins/slowlog/images/shadow.gif, referer: http://zeta.officemax.int/cacti/plugins/slowlog/
[Fri Sep 30 13:50:34 2011] [error] [client 172.31.0.78] File does not exist: /var/www/cacti/plugins/slowlog/images/arrow.gif, referer: http://zeta.officemax.int/cacti/plugins/slowlog/s[Fri Sep 30 13:50:34 2011] [error] [client 172.31.0.78] File does not exist: /var/www/cacti/plugins/slowlog/images/favicon.ico


EDIT: Got it, incorrect $url_path - one question though, how did you set up the pretty graph/pictures?

[TheWitness]

Once you import a mysql-slow.log file, you simply have to edit it and select the various tabs.

[mrevelle]

Yeah that's what I thought based on your screen shots. It's showing the actual log data but I get no graphs from any of the tabs. Logs show nothing relevant to resolving the issue as far as I can see. Any suggestions?

Haha nevermind, I'm a retard. I did a dist-upgrade to Ubuntu's beta and it has no flash-plugin yet. We're all good thanks a lot.

[TheWitness]

Your welcome... Any bugs, let us know.

[maddog107]

Thanks for this plugin. One question, is there a way to automatically pull in the slowquery log say every hour? We can do it via a cronjob or something. Let me know as that is what we are looking for. Thanks.

[Eol]

FYI on 0.8.8c this plugin lose all the overall web structure, i.e. you lose all the "tab" and the ability to navigate in the Cacti UI.

[TheWitness]

New Slowlog after over 10 years dead!

[TheWitness]

Way faster, and nicer to look at.

[mrossTTX]

looks awesome