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

Question

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.

Answer 1

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