MySQL数据库测试 select 1、先创建数据库test,再准备数据time /usr/local/sysbench/bin/sysbench –test=oltp –num-threads=4 –mysql-table-engine=innodb –mysql-user=root –mysql-password=123 –db-driver=mysql –mysql-db=test –oltp-table-size=3000000 –oltp-table-name=t1 –oltp-nontrx-mode=insert –mysql-socket=/tmp/mysql.sock prepare 2、执行测试time /usr/local/sysbench/bin/sysbench –test=oltp –mysql-table-engine=innodb –mysql-user=root –mysql-password=123 –db-driver=mysql –mysql-db=test –oltp-table-size=3000000 –oltp-table-name=t1 –mysql-socket=/tmp/mysql.sock run 3、清除测试数据time /usr/local/sysbench/bin/sysbench –test=oltp –mysql-table-engine=innodb –mysql-user=root –mysql-password=123 –db-driver=mysql –mysql-db=test –oltp-table-size=3000000 –oltp-table-name=t1 –mysql-socket=/tmp/mysql.sock cleanup 还可以加上进程数–num-threads=4删除测试–oltp-nontrx-mode=delete MySQL数据库测试 insert 300W 1、先创建数据库test,再准备数据time /usr/local/sysbench/bin/sysbench –test=oltp –num-threads=4 –mysql-table-engine=innodb –mysql-user=root –mysql-password=123 –db-driver=mysql –mysql-db=test –oltp-table-size=3000000 –oltp-table-name=t1 –oltp-nontrx-mode=insert –mysql-socket=/tmp/mysql.sock prepare 2、执行insert测试time /usr/local/sysbench/bin/sysbench –test=oltp –num-threads=4 –mysql-table-engine=innodb –mysql-user=root –mysql-password=123 –db-driver=mysql –mysql-db=test –oltp-table-size=10000000 –oltp-table-name=t1 –oltp-nontrx-mode=insert –mysql-socket=/tmp/mysql.sock run