Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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


migration rejected from Aug 18 '14 at 23:16

This question came from our site for computer enthusiasts and power users. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

closed as too broad by Michael Hampton Aug 18 '14 at 23:16

There are either too many possible answers, or good answers would be too long for this format. Please add details to narrow the answer set or to isolate an issue that can be answered in a few paragraphs.If this question can be reworded to fit the rules in the help center, please edit the question.

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
up vote 2 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
# 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)


This has been somewhat useful to me:

We can also try with this: – Reza Mamun Feb 12 '15 at 20:26

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