Please recommend a performance testing tool for MySQL under Ubuntu / Debian

Question

I would like to test the performance of my MySQL MyISAM and InnoDB modules under Debian or Ubuntu Server for CPU and memory consumption. I need to simulate many simultaneous reads, writes, and updates. I can set up a separate sandbox, similar to my production server, for testing.

Answer 1

For Debian, sysbench is hard to beat. This is a simple 1-2-3:

• Installation

  sudo apt-get install sysbench

• Preparation

  sysbench --test=oltp --oltp-table-size=1000000 --mysql-db=test --mysql-user=root --mysql-password=yourrootsqlpassword prepare

• Benchmark

  sysbench --test=oltp --oltp-table-size=1000000 --mysql-db=test --mysql-user=root --mysql-password=yourrootsqlpassword --max-time=60 --oltp-read-only=on --max-requests=0 --num-threads=8 run

Answer 2

MYSQL Workbench should do.

http://wb.mysql.com/

Answer 3

Jmeter will also work using the Jdbc sampler.

http://jmeter.apache.org/usermanual/intro.html

Answer 4

You can try the following: http://osdb.sourceforge.net/