Where do I find the MysqlDumpSlow command?

Question

Hi I'm logging slow queries because we're having some performance issues and I have read about mysqldumpslow and thought that would be a good way to sort through the queries.

At the command prompt, I type mysqldumpslow and I get this:

'mysqldumpslow' is not recognized as an internal or external command, operable program or batch file.

I'm using MySQL version 5.0.79 on Windows Vista.

Note: c:\Program Files\MySQL\MySQL Server 5.0\bin is my path and I have searched the drive for 'mysqldumpslow' and can not find it.

What am I doing wrong?

Note: MySql 5.0.x does support the mysqldumpslow command follow this link to manual

Answer 1

edit : oops, I read the manual wrong, and gave wrong information :-( sorry :-( let's give it another try...

I've just installed MySQL on windows, to try using mysqldumpslow, and I don't have mysqldumpslow installed either :-( So, you are not alone, and it doesn't seem to be a problem with your install (I've tried 5.1.x, but as you highlighted, it should be the same for 5.0.x)

Looking at the "mysqldumpslow" I have under Linux, it appears it is a Perl script ; and Perl is not often installed on a Windows machine. Maybe that would be a hint to a solution...

Well, after a bit more testing, when installing MySQL, it seems you have to select "Developpers Components > Scripts, examples", which is not installed by default (at least on windows) -- no need to reinstall everything : you can "modify" the installation, to add this option.

Then, you will have a "script" directory next to the "bin" one. For instance, on your install, it should be something like "c:\Program Files\MySQL\MySQL Server 5.0\scripts".

In this directory, there are some scripts ; one of them is mysqldumpslow.pl ; which is what you are looking for ;-)

Now, you "just" have to get Perl installed and running on your machine (sorry, I've never installed Perl on windows ; but you can find some informations here)

Hope this helps better than what I posted before !