sysbench

mysql安装

参考http://blog.csdn.net/zhanngle/article/details/41042631

sysbench基本使用方法

参考http://blog.chinaunix.net/uid-7589639-id-4126046.html

输入测试数据

sysbench –test=oltp –oltp-table-size=8000000 –db-driver=mysql –mysql-socket=/tmp/mysql.sock –mysql-user=root –mysql-password=’root’ –mysql-db=test prepare

清除测试数据

sysbench –test=oltp –oltp-table-size=8000000 –db-driver=mysql –mysql-socket=/tmp/mysql.sock –mysql-user=root –mysql-password=’root’ –mysql-db=test cleanup

测试

sysbench –test=oltp –oltp-table-size=8000000 –oltp-read-only=off –init-rng=on –num-threads=16 –max-requests=0 –oltp-dist-type=uniform –max-time=360 –mysql-user=root –mysql-password=’root’ –mysql-db=test –db-driver=mysql –mysql-socket=/tmp/mysql.sock run > result.log