Solved

Using mysql_slow_log_parser

Posted on 2006-11-17
1
806 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

In this tutorial I will focus on how to use WhizBase as a tool for sending ICQ messages to ICQ. Here I will use a new technology in WhizBase, published in WhizBase 5.1 version. In this tutorial I will use 3 files, pager.wbsp for the processing, e…
This article will show, step by step, how to integrate R code into a R Sweave document
Learn the basics of if, else, and elif statements in Python 2.7. Use "if" statements to test a specified condition.: The structure of an if statement is as follows: (CODE) Use "else" statements to allow the execution of an alternative, if the …
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

863 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now