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 bat...
I have installed mysql-client-5.4.2 Multithreaded SQL database (client) mysql-server-5.4.2 Multithreaded SQL database (server) on my FreeBSD 8.0 box Why isnt there mysqldumpslow command available? What port should i install to make it available ...
Hi, Im recording slow queries longer than 2 seconds. That is running fine except, the daily backups also get recorded in slow log because 1) mysqldump calls select * from xyz (big table); and 2) when inserting the backup into a new db (yesterday's backup, sundays backup, etc). How to prevent mysqldump from logging slow queries? Is there...