Please recommend performance testing tool for MySQL under Ubuntu/Debian [closed]

开发者_如何学JAVA As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance. Closed 9 years ago.

I would like to test performance of my MySQL MyISAM and InnoDB engines under Debian or Ubuntu Server for CPU and memory consumption. I need to simulate many concurrent reads, writes and updates. I can set up a separate isolated environment similar to my production server to perform the tests.

---

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

1. Install

   sudo apt-get install sysbench

2. Prepare

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

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

---

Jmeter would also work using Jdbc sampler.

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

---

MYSQL Workbench should do.

http://wb.mysql.com/

---

You can try this : http://osdb.sourceforge.net/