mysql_slow_log_parser

Developed In: Perl  — Status:  Production - GA

This perl script parses a MySQL slow_queries log file ignoring all queries less than $min_time and prints out how many times a query was greater than $min_time with the seconds it took each time to run. The queries are sorted by number of times it ran, with the most often query appearing at the bottom of the output. Usage: mysql_slow_log_parser logfile

http://www.retards.org/projects/mysql/
Shantanu Oak
_Other - see project for details
Database Administrators
Expert
Production - GA
Perl

Current Tags

oksoft 

You must be logged in to tag this project

No Comments yet

Votes

  • Rated 5.00 out of 5
Rated 5.00 out of 5 with 1 votes cast.
You must be logged in to vote.

Watches

0 members are watching this project
You must be logged in to track this project.

Provide Feedback

Please note:
HTML will be purified, but we allow for a number of HTML tags so that you have the flexibility to decorate your comment text to some extent. The comments allow the following HTML tags:

strong, b, em, blockquote, a, code, pre

To put code into your comment, simply encapsulate your code with
[code language="XXX"][/code], where XXX is any common language, for instance "PHP", "SQL", "C", etc.

You must be logged in to comment