MySQL Performance: MySQL => Slow Log Analyser

Members

Help

Home

Home » Performance » MySQL » Slow Log Analyser

Show: Today's Messages :: Show Polls :: Message Navigator

Slow Log Analyser [message #3592]

Mon, 29 September 2008 08:12

AlexN
Messages: 20
Registered: October 2007
Location: Moscow,Russia

Junior Member

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.

Attachment: slow_log_parser.pl
(Size: 4.64KB, Downloaded 108 time(s))

Report message to a moderator

Previous Topic:	More on autoincrement vs guid vs natural key
Next Topic:	MySQL Server Really High Load Question

Goto Forum:

-=] Back to Top [=-

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 9 23:03:03 EDT 2009

Total time taken to generate the page: 0.00503 seconds

.:: Contact :: Home ::.

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.