DB服务器性能测试

1.mysqlslap --defaults-file=/etc/my.cnf --concurrency=50,100,200 --iterations=1 --number-int-cols=4 --number-char-cols=35 --auto-generate-sql --auto-generate-sql-add-autoincrement --auto-generate-sql-load-type=mixed --engine=myisam,innodb --number-of-queries=2000 --debug-info -uroot -pyoohouse
2. sysbench --test=cpu --cpu-max-prime=20000 run
3.sysbench --test=threads --num-threads=64 --thread-yields=100 --thread-locks=2 run
4.sysbench --test=fileio --num-threads=16 --file-total-size=3G --file-test-mode=rndrw prepare
5.sysbench --test=fileio --num-threads=16 --file-total-size=3G --file-test-mode=rndrw run
6.sysbench --test=fileio --num-threads=16 --file-total-size=3G --file-test-mode=rndrw cleanup
7.sysbench --test=memory --memory-block-size=8k --memory-total-size=4G run
8./opt/sysbench/bin/sysbench --test=oltp --mysql-table-engine=innodb --oltp-table-size=1000000 --mysql-user=root --mysql-password=yoohouse --mysql-db=test --mysql-socket=/tmp/mysql.sock run
9./opt/sysbench/bin/sysbench --test=oltp --mysql-table-engine=myisam --oltp-table-size=1000000 --mysql-user=root --mysql-password=yoohouse --mysql-db=test --mysql-socket=/tmp/mysql.sock run