티스토리 뷰

데이터베이스/MySQL

sysbench 사용하기 - test=oltp

쌀맛나는세상 2009. 11. 25. 00:10

설치

centos 5.3 의 경우

mysql-5.0.77-3.el5
mysql-server-5.0.77-3.el5
mysql-devel-5.0.77-3.el5
이 필요

http://sysbench.sourceforge.net/ 에서 최신 릴리즈 다운로드



$wget http://downloads.sourceforge.net/project/sysbench/sysbench/0.4.12/sysbench-0.4.12.tar.gz?use_mirror=cdnetworks-kr-1
$tar xvfz sysbench-0.4.12.tar.gz
$cd sysbench-0.4.12
$autogen.sh       (
$./configure
$make ; make install

$mysql -u root -p
SQL> create database sbtest;

SQL> grant all on sbtest.* to sbtest@localhost identified by 'sbtest' with grant option;

SQL>grant all on sbtest.* to sbtest identified by 'sbtest' with grant option;

SQL> flush privileges


#테이블 및 데이터 생성
./sysbench --test=oltp --mysql-table-type=myisam --oltp-table-size=10000 --mysql-password=sbtest --mysql-socket=/var/lib/mysql/mysql.sock prepare
#테스트 실행
./sysbench --num-threads=16 --max-requests=1000 --test=oltp --oltp-table-size=10000 --mysql-socket=/var/lib/mysql/mysql.sock --mysql-password=sbtest --oltp-read-only run


# MyISAM 로그
log-isam=/usr/local/mysql/var/myisamlog.log
# 쿼리 로그
log=/usr/local/mysql/var/mysql.log
# 수정 로그
log-update=/usr/local/mysql/var/mysql-update.log
# 바이너리 로그
log-bin=/usr/local/mysql/var/mysql-bins.log

# 슬로우 쿼리 로그
log-slow-queries=/usr/local/mysql/var/mysql-slow.log
long_query_time=5


OLTP test statistics:
    queries performed:
        read:                            14000
        write:                           0
        other:                           2000
        total:                           16000
    transactions:                        1000   (101.13 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 14000  (1415.81 per sec.)
    other operations:                    2000   (202.26 per sec.)

Test execution summary:
    total time:                          9.8883s
    total number of events:              1000
    total time taken by event execution: 49.7444
    per-request statistics:
         min:                                  6.98ms
         avg:                                 49.74ms
         max:                               6569.56ms
         approx.  95 percentile:             142.41ms

Threads fairness:
    events (avg/stddev):           62.5000/123.74
    execution time (avg/stddev):   3.1090/4.24