开发者

How to run benchmarking on MySQL?

My server has installed MySQL Server 5.1. I would like to run benchmarking on the MySQL, but I couldn't found sql-bench, which is Benchmark Suite provided by MySQL.

The MySQL Benchmark Suite seem like complicated to be install or setup into my server. I need one can be direct setup to test the benchmark without using Perl script liked the benchmark suite from MySQL.

Do anyone knows how to get the most popular benchmarking tool to measure MySQL performance? I need to measure the performance of my SQL written in ASP.Net that connecting to MySQL. I need to optimize the SQL script.

It's better has a benchmarking tool where can be read my SQL in many开发者_如何转开发 times and return me the query result's time for comparison, etc. I just need to know the time consuming and performance for the each SQL runs in many times.


One of the Maatkit tools might help you:

Maatkit - mk-query-profiler

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜