The maximum connection number and IOPS are different according to different specifications of JCS for MySQL, see here.
Tutorial of performance test for JCS for MySQL is shown as below
SysBench is a scriptable multi-thread benchmark test tool based on LuaJIT. It is mostly used for database benchmark test, but it can also be used to create any complex workload involving no database server.
$ yum install gcc gcc-c++ autoconf automake make libtool bzr mysql-devel $ unzip 1.0.zip $ cd sysbench-1.0 $ ./autogen.sh $ ./configure --prefix=/usr $ make $ make install
See Create Account.
See Create Database. You need to create a database named sbtest and remember to grant the read-write permission of new database to the account created previously when creating the database.
$ sysbench ./share/sysbench/oltp_read_write.lua --table_size=10000000 --db-driver=mysql --tables=10 --mysql-host=XXX --mysql-user=XXX --mysql-password=XXX prepare
$ sysbench ./share/sysbench/oltp_read_write.lua --tables=10 --threads=32 --max-requests=999999999 --time=3600 --table_size=10000000 --db-driver=mysql --mysql-host=XXX --mysql-user=XXX --mysql-password=XXX run
$ sysbench ./share/sysbench/oltp_read_write.lua --tables=10 --threads=32 --max-requests=999999999 --time=3600 --table_size=10000000 --db-driver=mysql --mysql-host=XXX --mysql-user=XXX --mysql-password=XXX cleanup
CREATE TABLE `sbtest7` ( `id` int(11) NOT NULL AUTO_INCREMENT, `k` int(11) NOT NULL DEFAULT '0', `c` char(120) NOT NULL DEFAULT '', `pad` char(60) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `k_7` (`k`) ) ENGINE=InnoDB
id: 1 k: 5003504 c: 98210233655-92920312724-46680254539-74097273196-30247159819-37778834059-40387910259-28547466616-68642657061-93956851311 pad: 13866500364-00628646396-45402716318-87575412098-94787248459
$ SELECT c FROM sbtest3 WHERE id=5007521 $ SELECT c FROM sbtest7 WHERE id BETWEEN 5000580 AND 5000679 $ SELECT SUM(k) FROM sbtest2 WHERE id BETWEEN 4992664 AND 4992763 $ SELECT DISTINCT c FROM sbtest6 WHERE id BETWEEN 5041654 AND 5041753 ORDER BY c
$ UPDATE sbtest2 SET k=k+1 WHERE id=4979352 $ DELETE FROM sbtest6 WHERE id=5037406 $ INSERT INTO sbtest4 (id, k, c, pad) VALUES (4995019, 4995155, '58990155292-53936825106-56125467619-3...