Download the PHP package marcusschwarz/myprofi without Composer
On this page you can find all versions of the php package marcusschwarz/myprofi. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download marcusschwarz/myprofi
More information about marcusschwarz/myprofi
Files in marcusschwarz/myprofi
Package myprofi
Short Description Analyze your MySQL Slow Query Logfiles
License GPL-3.0
Homepage https://github.com/MarcusSchwarz/myprofi
FAQ
Example:
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
- Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
- To use Composer is sometimes complicated. Especially for beginners.
- Composer needs much resources. Sometimes they are not available on a simple webspace.
- If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
- Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Informations about the package myprofi
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 [email protected]
Usage: php myprofi.php [OPTIONS] INPUTFILE
Options:
-
top NOutput 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. -
htmlOutput statistics in html format. -
sampleOutput one sample query per each query pattern to be able to use it with EXPLAIN query to analyze its performance. -
csvConsiders an input file to be in csv format. Note, that if the input file extension is .csv, it is also considered as csv. -
slowTreats 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.csvMyProfi will work with php5.5 and newer.
Copyright (C)
- 2006 camka at [email protected]
- 2016 - Marcus Schwarz [email protected]
