# Slow Log Analyser

**URL:** <https://forums.percona.com/t/slow-log-analyser/945>\
**Category:** Other MySQL® Questions\
**Created:** [September 29, 2008, 6:42am UTC](https://forums.percona.com/t/slow-log-analyser/945 "2008-09-29T06:42:21Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![AlexN](https://avatars.discourse-cdn.com/v4/letter/a/b9bd4f/32.png) [@AlexN](https://forums.percona.com/u/AlexN)\
**Post date:** [September 29, 2008, 6:42am UTC](https://forums.percona.com/t/slow-log-analyser/945/1 "2008-09-29T06:42:21Z")

</div>

I used the program called ‘mysql\_slow\_log\_parser’ and found several problems in it. First of all, it replaces numbers in field and table names with XXXs.  
But the biggest problem is that this program crushes on large sql files. Currently I have slow log files about 450Mb in size.

I’ve modified the script so that it now handles large files well, and does not replace numbers in table names.

Here is the script. Please tell me if there are any issues.

---

<div class="post-metadata">

**Author:** ![xaprb](https://avatars.discourse-cdn.com/v4/letter/x/49beb7/32.png) [@xaprb](https://forums.percona.com/u/xaprb)\
**Post date:** [December 25, 2009, 7:58am UTC](https://forums.percona.com/t/slow-log-analyser/945/2 "2009-12-25T07:58:51Z")

</div>

We have all switched to using mk-query-digest these days. Among other things, it has a real test suite.