Solved

Using mysql_slow_log_parser

Posted on 2006-11-17
1
810 Views
Last Modified: 2013-12-25
This is probably a REALLY easy one... but I never use PERL. So I am not familiar with the usage.

There is a PERL script available at http://www.retards.org/projects/mysql/ called mysql_slow_log_parser

How do I go about actually using it?

I have installed ActivePerl on my server... and I have a slow_log file from mysql that I would like to parse using this script.

My real question is how to actually instantiate the mysql_slow_log_parser script.

The webiste for the script says:

Usage: mysql_slow_log_parser logfile

so my question is this... do I download the script available at http://www.retards.org/projects/mysql/mysql_slow_log_parser then save it as  mysql_slow_log_parser.pl?

I tried that... then went to the command line and used: mysql_slow_log_parser slow_log

There is probably a very simple answer to my question... but it is urgent.

Thanks in advance.
0
Comment
Question by:rocketTendon
1 Comment
 
LVL 84

Accepted Solution

by:
ozo earned 500 total points
ID: 17969745
You can save it as mysql_slow_log_parser.pl then type
perl mysql_slow_log_parser.pl slow_log
or save it as mysql_slow_log_parser make it executable, and type
mysql_slow_log_parser slow_log
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
VBScript - Find file starting with XXXX use that in runnig rest of code 9 78
Need help to rewrite script 3 79
Scripting vs. Programming languages 25 165
Linux Scripting 3 122
Introduction:   Welcome to my first article ever. To begin with, the reason I write this article.  I participated in a question on Experts Exchange about the start command in Windows and there were some discussion about the usage. The discussio…
Active Directory replication delay is the cause to many problems.  Here is a super easy script to force Active Directory replication to all sites with by using an elevated PowerShell command prompt, and a tool to verify your changes.
Learn the basics of while and for loops in Python.  while loops are used for testing while, or until, a condition is met: The structure of a while loop is as follows:     while <condition>:         do something         repeate: The break statement m…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question