How can we test an existing database and queries against it using
sysbench tool?
You can take a look into this post:
Stress test MySQL with queries captured with general log in MySQL
Currently I am using mysqlslap for stress testing. Does it provide
reliable and useful information?
Use mysqlslap or sysbench(with default oltp tests) can be useful, in my opinion, in order to choose the right starting combination between HW architecture, MySQL version and MySQL configuration/initial tuning. To do this you have to collect and plot all results obtained(cpu, I/O, MySQL server info etc) changing these three parametres. I have worked with standard tests and "my" tests on the same HW combination and I obtained significant differences.
So, always in my opinion, the best way is:
find your right HW, MySQL version and initial tuning using standard oltp
test your workload using your tests (see first response) and works for the final/fine tunining then
UPDATE #1
So What should i understand from this image ? Do i need to increase
CPU as 100% is being used. Does my local MySQL set up is not able to
handle 100 concurrent connections for a single query as it is taking
huge time of 79 secs ?
It seems that your bottleneck is the disk I/O not the CPU, because operations occurring during the sending data state tend to perform large amounts of disk access (reads). You can try to increase your innodb_buffer_pool_size to up to 80% of the machine physical memory size(on a dedicated server, on your local machine try increasing step by step), larger you set this value less disk I/O is needed to access data in tables
Best Answer
You need to compile it yourself.
I downloaded the tarball and read the README-WIN.txt. It certainly indicates that it can be compiled on Windows using CMake.