marcusschwarz/myprofi

Analyze your MySQL Slow Query Logfiles

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

This package is auto-updated.

Last update: 2024-10-21 00:53:56 UTC


README

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

Build Status

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

Originally written 2006 by camka at camka@users.sourceforge.net

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)