开发者

Suitable MySQL benchmark tool

开发者_运维问答

I'm looking for a benchmark tool that can benchmark MySQL Replication.

  • It can connect to multiple replicas and the master. So it does write operations on the master, and reads from slaves.
  • It should also be capable for adjusting read (SELECT)/write (UPDATE, DELETE ...) ratio, or change the number of read and number of write.
  • The output is expected to be tps or more.

Does anyone can suggest a tool for me? Thanks in advance.


Unfortunately, I don't know of any benchmarks which perform R/W splitting. This is something you may have to build yourself, but it should be fairly straightforward to modify existing benchmarks as mysqlslap or the MySQL Benchmark Suite.


use sysbench.. its good.. http://www.howtoforge.com/how-to-benchmark-your-system-cpu-file-io-mysql-with-sysbench

-Priyesh

0

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜