marcusschwarz/myprofi

This package is abandoned and no longer maintained. No replacement package was suggested.

Analyze your MySQL Slow Query Logfiles

v1.0.0 2016-10-19 22:10 UTC

Requires

• php: >=5.5.0

Requires (Dev)

• phpunit/phpunit: ^4.8

GPL-3.0

• Marcus Schwarz

• mysql
• profiling

README

#MyProfi v1.0.0 ####MySQL Log Profiler and Analyzer

MyProfi is mysql profiler and analyzer, which outputs statistics of mostly used queries by reading query log file.

Originally written 2006 by camka at [e-mail]

Usage: php myprofi.php [OPTIONS] INPUTFILE

Options:

• top N Output only N top queries.

• type "query types" Output only statistics for the queries of given query types. Query types are comma separated words that queries may begin with.

• html Output statistics in html format.

• sample Output one sample query per each query pattern to be able to use it with EXPLAIN query to analyze its performance.

• csv Considers an input file to be in csv format. Note, that if the input file extension is .csv, it is also considered as csv.

• slow Treats an input file as a slow query log.

• sort <CRITERIA> Sort output statistics by given CRITERIA. Works only for slow query log format.
  Possible values of CRITERIA: qt_total | qt_avg | qt_max | lt_total | lt_avg | lt_max | rs_total | rs_avg | rs_max | re_total | re_avg | re_max, where two-letter prefix stands for "Query time", "Lock time", "Rows sent", "Rows executed".
  Values taken from data provided by slow query log respectively.
  Suffix after _ character tells MyProfi to take total, maximum or average calculated values.

Example:

php parser.php -csv -top 10 -type "select, update" general_log.csv

MyProfi will work with php5.5 and newer.

Copyright (C)

• 2006 camka at [e-mail]
• 2016 - Marcus Schwarz [e-mail]