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.