分类： Mysql/postgreSQL
2010-10-12 18:05:47
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
