GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Slow Log Analyser

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Slow Log Analyser

    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.

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

    Comment

    Working...
    X