❑ sysbench 사용하기

###################For MYISAM(rows:10000)#######################
# sysbench --test=oltp --db-driver=mysql --oltp-table-size=10000 --mysql-host=localhost --mysql-user=root --mysql-password=root --mysql-db=test --mysql-table-engine=myisam --mysql-socket=/database/mysql/mysql.sock prepare

mysql> create table benchdb.sbtest10000_myisam as select * from test.sbtest;

# sysbench --test=oltp --db-driver=mysql --mysql-host=localhost --mysql-user=root --mysql-password=root --mysql-db=test --mysql-table-engine=myisam --mysql-socket=/database/mysql/mysql.sock --oltp-read-only --oltp-test-mode=simple --num-threads=20 run

# sysbench --test=oltp --db-driver=mysql --oltp-table-size=10000 --mysql-host=localhost --mysql-user=root --mysql-password=root --mysql-db=test --mysql-table-engine=myisam --mysql-socket=/database/mysql/mysql.sock cleanup



###################For INNODB(rows:10000)#######################
# sysbench --test=oltp --db-driver=mysql --oltp-table-size=10000 --mysql-host=localhost --mysql-user=root --mysql-password=root --mysql-db=test --mysql-table-engine=innodb --mysql-socket=/database/mysql/mysql.sock prepare

mysql> create table benchdb.sbtest10000_myisam as select * from test.sbtest;

# sysbench --test=oltp --db-driver=mysql --mysql-host=localhost --mysql-user=root --mysql-password=root --mysql-db=test --mysql-table-engine=innodb --mysql-socket=/database/mysql/mysql.sock --oltp-read-only --oltp-test-mode=simple --num-threads=20 run

# sysbench --test=oltp --db-driver=mysql --oltp-table-size=10000 --mysql-host=localhost --mysql-user=root --mysql-password=root --mysql-db=test --mysql-table-engine=innodb --mysql-socket=/database/mysql/mysql.sock cleanup

<참고URL>

http://intomysql.blogspot.jp/2010/12/sysbench-mysql-oltp.html

http://seuis398.blog.me/70093869223

http://www-06.ibm.com/jp/domino01/mkt/cnpages7.nsf/page/default-00381DC3

http://sysbench.sourceforge.net/docs/#database_mode