marcusschwarz/myprofi

Analyze your MySQL Slow Query Logfiles

MyProfi v1.0.0

MySQL Log Profiler and Analyzer

, _(*1)

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

Originally written 2006 by camka at camka@users.sourceforge.net, _(*3)

Usage: php myprofi.php [OPTIONS] INPUTFILE, _(*4)

Options:, _(*5)

• top N Output only N top queries., _(*6)

• type "query types" Output only statistics for the queries of given query types. Query types are comma separated words that queries may begin with., _(*7)

• html Output statistics in html format., _(*8)

• sample Output one sample query per each query pattern to be able to use it with EXPLAIN query to analyze its performance., _(*9)

• 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., _(*10)

• slow Treats an input file as a slow query log., _(*11)

• 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., _(*12)

Example:, _(*13)

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

MyProfi will work with php5.5 and newer., _(*14)

Copyright (C) - 2006 camka at camka@users.sourceforge.net - 2016 - Marcus Schwarz github@maswaba.de, _(*15)