Where do I find the MysqlDumpSlow command?

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 !

try typing

whereis mysqldumpslow

If that still says its not installed,

EDIT: Above is not relevant, as on windows. Missed that, thanks to commenter for pointing it out.

I always use mysqlsla (mysql slow log analyser) ahead of mysqldumpslow - you could give that a go.

http://hackmysql.com/mysqlsla