Solved

Using mysql_slow_log_parser

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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

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…
In threads here at EE, each comment has a unique Identifier (ID). It is easy to get the full path for an ID via the right-click context menu. However, we often want to post a short link within a thread rather than the full link. This article shows a…
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…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

830 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