Parse mysql logs to analyse the logsMysql logs goes on building in size and stretch and deprecates to subfiles after a limit. For you would like to have a quick parsing and some filter study which help you go ahead understanding queries that takes too long or is pretty slow… Parse mysql logs to analyse the logs

I got the below two files and had been using since then , and just sharing those files as it is downloaded. if i happen to get the site back, I would remove them and put the links back…Just doing this much before i go lazy or workholic šŸ˜‰

search for the keywords: mysql_slow_log_filter.pl and mysql_slow_log_parser.pl and i think you would land up in one of the best readable sites on mysql….

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: