Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Anyone recommend any benchmarking tools or practices for MySQL on windows?

share|improve this question

migrated from superuser.com Oct 20 '11 at 10:19

This question came from our site for computer enthusiasts and power users.

2  
I don't know, it's kind of a vague question. madphp, can you specify what exactly you want to do? –  slhck Oct 20 '11 at 8:11
    
I have nothing in mind right now. I want a allround good benchmarking tool to log slow queries/find bottlenecks on windows and IIS. –  madphp Oct 20 '11 at 15:00
add comment

1 Answer

up vote 1 down vote accepted

For Windows/IIS you should stick with "Performance Monitor"

To check slow queries add this to your my.conf

# start slow log
slow-query-log=1
slow-query-log-file=*<hostname>*-slow.log
log-queries-not-using-indexes
log-slow-admin-statements
log-slow-slave-statements
# end slow log

I believe you can set if on the fly using SET GLOBAL on mysql prompt, example:

SET GLOBAL slow_query_log=OFF;
SET GLOBAL log_queries_not_using_indexes=OFF;

You may want to check on Spotlight from Quest software, it gives a nice visual interface to see what is happening on the system... (and are free)

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.