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

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

share

migration rejected from superuser.com Aug 18 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 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.

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

2 Answers 2

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
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

This has been somewhat useful to me: https://sourceforge.net/projects/win-mysql-bench/

share

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