PHPackages                             phpfui/mysql-slow-log-parser - 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. phpfui/mysql-slow-log-parser

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

phpfui/mysql-slow-log-parser
============================

MySQL and MariaDB Slow Query Log Parser featuring sortable results

V1.1.3(6mo ago)42894MITPHPPHP >=8.0 <8.6CI passing

Since Dec 4Pushed 6mo ago1 watchersCompare

[ Source](https://github.com/phpfui/MySQLSlowQueryParser)[ Packagist](https://packagist.org/packages/phpfui/mysql-slow-log-parser)[ Docs](http://phpfui.com/?n=PHPFUI\MySQLSlowQuery)[ RSS](/packages/phpfui-mysql-slow-log-parser/feed)WikiDiscussions master Synced 1w ago

READMEChangelog (6)Dependencies (5)Versions (13)Used By (0)

PHPFUI\\MySQLSlowLog\\Parser [![Tests](https://github.com/phpfui/MySQLSlowQueryParser/actions/workflows/tests.yml/badge.svg)](https://github.com/phpfui/MySQLSlowQueryParser/actions?query=workflow%3Atests) [![Latest Packagist release](https://camo.githubusercontent.com/385cd1829ed2c591376f3d7ebfd620ed6f628f99108d5e988e2c518e20e8eaad/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f762f7068706675692f6d7973716c2d736c6f772d6c6f672d7061727365722e737667)](https://packagist.org/packages/phpfui/mysql-slow-log-parser) [![](https://camo.githubusercontent.com/742e8be8005b1fe76a64a5d8f5e6a5d4f63bf315e9a44a6d23e4e11c76b0555f/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f5048505374616e2d6c6576656c253230362d627269676874677265656e2e7376673f7374796c653d666c6174)](https://camo.githubusercontent.com/742e8be8005b1fe76a64a5d8f5e6a5d4f63bf315e9a44a6d23e4e11c76b0555f/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f5048505374616e2d6c6576656c253230362d627269676874677265656e2e7376673f7374796c653d666c6174)
=========================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================

[](#phpfuimysqlslowlogparser---)

PHP Parser for MySQL and MariaDB Slow Query Logs featuring sortable results

Requirements
------------

[](#requirements)

- Modern PHP version
- MySQL 5.7 or higher, or MariaDB

Usage
-----

[](#usage)

```
$parser = new \PHPFUI\MySQLSlowQuery\Parser($logFilePath);

// Return the sessions in the file as array
$sessions = $parser->getSessions();

// Return all entries in file as array, or pass session number (0 based)
$entries = $parser->getEntries();

if (count($entries))
  {
  // Get the worst offender
  $entry = $parser->sortEntries()->getEntries()[0];
  echo 'Query ' . implode(' ', $entry->Query) . " took {$entry->Query_time} seconds at {$entry->Time}\n";

  // Get the most rows examined
  $entry = $parser->sortEntries('Rows_examined', 'desc')->getEntries()[0];
  echo 'Query ' . implode(' ', $entry->Query) . " looked at {$entry->Rows_examined} rows\n";
  }
```

Entries
-------

[](#entries)

**\\PHPFUI\\MySQLSlowQuery\\Entry** provides details on each query. Supported fields:

- Time
- User
- Host
- Id
- Query\_time
- Lock\_time
- Rows\_sent
- Rows\_examined
- Query (array)
- Session (zero based)

**MariaDB** adds the following fields:

- Thread\_id
- Schema
- QC\_hit
- Rows\_affected
- Bytes\_sent
- Tmp\_tables
- Tmp\_disk\_tables
- Tmp\_table\_sizes
- Full\_scan
- Full\_join
- Tmp\_table
- Tmp\_table\_on\_disk
- Filesort
- Filesort\_on\_disk
- Merge\_passes
- Priority\_queue
- explain

Sessions
--------

[](#sessions)

**\\PHPFUI\\MySQLSlowQuery\\Session** contains MySQL server information and are created on server restarts and log flushes. Pass the zero based session number to getEntries for only that Session's entries. Supported fields:

- Server
- Version
- Port
- Transport

Sort Entries
------------

[](#sort-entries)

By default, entries are returned in log order, but call sortEntries on the Parser to sort by any valid field (parameter 1). Sort defaults to 'desc', anything else will sort ascending.

Full Class Documentation
------------------------

[](#full-class-documentation)

[PHPFUI/InstaDoc](http://phpfui.com/?n=PHPFUI%5CMySQLSlowQuery)

License
-------

[](#license)

Distributed under the MIT License.

###  Health Score

48

—

FairBetter than 95% of packages

Maintenance67

Regular maintenance activity

Popularity19

Limited adoption so far

Community13

Small or concentrated contributor base

Maturity78

Established project with proven stability

 Bus Factor1

Top contributor holds 95.9% of commits — single point of failure

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

Every ~163 days

Recently: every ~266 days

Total

12

Last Release

192d ago

PHP version history (8 changes)V1.0.0PHP >=7.1

V1.0.5PHP >=7.1 | <8.1

V1.0.6PHP >=7.4 <8.2

V1.0.7PHP >=7.4 <8.3

V1.1PHP >=8.0 <8.3

V1.1.1PHP >=8.0 <8.4

V1.1.2PHP >=8.0 <8.5

V1.1.3PHP >=8.0 <8.6

### Community

Maintainers

![](https://avatars.githubusercontent.com/u/7434059?v=4)[Bruce Wells](/maintainers/PHPFUI)[@phpfui](https://github.com/phpfui)

---

Top Contributors

[![phpfui](https://avatars.githubusercontent.com/u/7434059?v=4)](https://github.com/phpfui "phpfui (47 commits)")[![peter279k](https://avatars.githubusercontent.com/u/9021747?v=4)](https://github.com/peter279k "peter279k (1 commits)")[![rmuit](https://avatars.githubusercontent.com/u/153133?v=4)](https://github.com/rmuit "rmuit (1 commits)")

---

Tags

logparsermysqlmariadbqueryslow

###  Code Quality

TestsPHPUnit

Static AnalysisPHPStan

Code StylePHP CS Fixer

Type Coverage Yes

### Embed Badge

![Health badge](/badges/phpfui-mysql-slow-log-parser/health.svg)

```
[![Health](https://phpackages.com/badges/phpfui-mysql-slow-log-parser/health.svg)](https://phpackages.com/packages/phpfui-mysql-slow-log-parser)
```

###  Alternatives

[nilportugues/sql-query-formatter

A very lightweight PHP class that reformats unreadable and computer-generated SQL query statements to human-friendly, readable text.

401.1M24](/packages/nilportugues-sql-query-formatter)[wazaari/monolog-mysql

A handler for Monolog that sends messages to MySQL

140884.1k6](/packages/wazaari-monolog-mysql)[chillerlan/php-database

An extensible database wrapper and query builder.

431.2k2](/packages/chillerlan-php-database)[addapp/laravel-query-log

Logs full mysql queries.

135.4k](/packages/addapp-laravel-query-log)[stefanfroemken/mysqlreport

Analyze and profile your TYPO3 databases queries

1314.9k](/packages/stefanfroemken-mysqlreport)

PHPackages © 2026

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