Solved

Using mysql_slow_log_parser

Posted on 2006-11-17
1
821 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Enroll in May's Course of the Month

May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Auto-indent certain lines in Notepad++ 10 167
convert Systemjs to Webpack 3 120
powershell script error 2 28
run powershell script endlessly 3 20
In this tutorial I will show you how to make a simple HTML bar chart with the usage of WhizBase, If you want more information about WhizBase please read my previous articles at http://www.experts-exchange.com/ARTH_5123186.html (http://www.experts-ex…
Batch, VBS, and scripts in general are incredibly useful for repetitive tasks.  Some tasks can take a while to complete and it can be annoying to check back only to discover that your script finished 5 minutes ago.  Some scripts may complete nearly …
The viewer will learn the basics of jQuery, including how to invoke it on a web page. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery.: (CODE)
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

740 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