PHPackages                             marcusschwarz/myprofi - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Database & ORM](/categories/database)
4. /
5. marcusschwarz/myprofi

AbandonedArchivedLibrary[Database & ORM](/categories/database)

marcusschwarz/myprofi
=====================

Analyze your MySQL Slow Query Logfiles

v1.0.0(9y ago)1191GPL-3.0PHPPHP >=5.5.0

Since Oct 19Pushed 9y ago1 watchersCompare

[ Source](https://github.com/MarcusSchwarz/myprofi)[ Packagist](https://packagist.org/packages/marcusschwarz/myprofi)[ Docs](https://github.com/MarcusSchwarz/myprofi)[ RSS](/packages/marcusschwarz-myprofi/feed)WikiDiscussions master Synced 2mo ago

READMEChangelog (1)Dependencies (1)Versions (2)Used By (0)

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

[![Build Status](https://camo.githubusercontent.com/83e634996e24eae21c6a3ea44cfa472b95c13417e6a39e147d5898fd2ccc1fa7/68747470733a2f2f7472617669732d63692e6f72672f4d61726375735363687761727a2f6d7970726f66692e7376673f6272616e63683d6d6173746572)](https://travis-ci.org/MarcusSchwarz/myprofi)

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

Originally written 2006 by camka at

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 ` 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
- 2016 - Marcus Schwarz

###  Health Score

26

—

LowBetter than 43% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity9

Limited adoption so far

Community5

Small or concentrated contributor base

Maturity58

Maturing project, gaining track record

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

###  Release Activity

Cadence

Unknown

Total

1

Last Release

3490d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/c27df794dcccfa8af83ef88a2c23ce95278d08fde7049d31dfacff86882bf7e9?d=identicon)[MarcusSchwarz](/maintainers/MarcusSchwarz)

---

Tags

profilingmysql

###  Code Quality

TestsPHPUnit

### Embed Badge

![Health badge](/badges/marcusschwarz-myprofi/health.svg)

```
[![Health](https://phpackages.com/badges/marcusschwarz-myprofi/health.svg)](https://phpackages.com/packages/marcusschwarz-myprofi)
```

###  Alternatives

[doctrine/dbal

Powerful PHP database abstraction layer (DBAL) with many features for database schema introspection and management.

9.7k578.4M5.6k](/packages/doctrine-dbal)[kirschbaum-development/eloquent-power-joins

The Laravel magic applied to joins.

1.6k25.2M34](/packages/kirschbaum-development-eloquent-power-joins)[scienta/doctrine-json-functions

A set of extensions to Doctrine that add support for json query functions.

58523.9M35](/packages/scienta-doctrine-json-functions)[illuminated/db-profiler

Database Profiler for Laravel Web and Console Applications.

168237.4k](/packages/illuminated-db-profiler)[stefanfroemken/mysqlreport

Analyze and profile your TYPO3 databases queries

1314.9k](/packages/stefanfroemken-mysqlreport)[cytopia/mysqldump-secure

Secure mysqldump script with encryption, compression, logging, blacklisting and Nagios monitoring integration

1474.7k1](/packages/cytopia-mysqldump-secure)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)