MyProfi 0.18 Beta

A command line tool that parses mysql query log and outputs statistics.

  Add it to your Download Basket!

 Add it to your Watch List!

0/5

Rate it!

What's new in MyProfi 0.18 Beta:

  • Added: HTML output option
Read full changelog
send us
an update
LICENSE TYPE:
GPL (GNU General Public License) 
USER RATING:
UNRATED
  0.0/5
DEVELOPED BY:
camka
HOMEPAGE:
myprofi.sourceforge.net
CATEGORY:
ROOT \ Database \ Database APIs
MyProfi project is a command line tool that parses mysql query log and outputs statistics of most frequently used queries, sorting them by number of times they appear in a log file. The similar queries are groupped together.

Thus, select id from user where login="admin" and select id from user where login='root' become select id from user where login={} - the variable parts of queries are replaced with {} markers, this make statistics analysis as easy as revewing the top of most frequently occured queries' patterns.

When developing an application one can hardly predict, which of the sql queries will run the most often, and which less often. The most popular queries are to be the first candidates for optimisation, fine tuning and polishing. By optimizing the most frequenly run queries the developer may achieve significant performance gain for overall system. By reviewing the statistics of MyProfi output it's becomes too easy to extract those queries to start optimizing db by adding indexes, reconsidering database structure, etc.

Last updated on April 21st, 2009

feature list requirements

#mysql logger #log parser #mysql statistics #MyProfi #mysql #log #parser

Add your review!

SUBMIT