MyProfi 0.161 Beta

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 its becomes too easy to extract those queries to start optimizing db by adding indexes, reconsidering database structure, etc.. MyProfi is a command line tool that parses mysql query log and outputs statistics of the most frequently used or the slowest queries, sorting them by number of times they appear in a log file or by total/average execution time.

Requirements:	No special requirements
Platforms:	Linux
Keyword:	Command Line,  Command Line Tool,  Id,  Line Tool,  May Be,  Myprofi,  Mysql Query,  Mysql Query Log,  Queries,  Query,  Query Log,  Select,  Select Name From User Where Id,  Statistics,  Where
Users rating:	0/10