gumbercules / mysqlslow
Parser class for MySQL slow query log
This package's canonical repository appears to be gone and the package has been frozen as a result.
Requires (Dev)
- phpunit/phpunit: ^4.5
This package is not auto-updated.
Last update: 2024-10-12 16:57:07 UTC
README
PHP lib for parsing a MySQL slow query log
Usage
Install with composer:
composer require gumbercules/mysqlslow
Include the namespace:
use Gumbercules\MysqlSlow;
Instantiate new file reader:
$parser = new LogParser($file_path);
$file_path must be the path to a .log file
Get the log entries with:
$parser->getEntries();
This returns an array of LogEntry objects for your .log file. See LogEntry.php for the methods available for accessing various properties. For example: $entry->getQueryTime(); will return the query duration for an entry.
Other
This library is used by my tool MySQL Slow Query Log Viewer. Check that out if you fancy!
Contribute
Feel free to fork and PR. I haven't finished writing tests for this yet, and also I'd like to hear if people have issues with their own logs; all my own tests were using real logs from a production server but I honestly don't know if there are variations across logs which could cause issues.
Contact
@garethellis on Twitter <3