❑ mysqlslap 사용하기

# find / -name mysqlslap
/usr/bin/mysqlslap

# mysqlslap --no-defaults --create-schema=test --query="SELECT * FROM tmptable100000_innodb" --concurrency=10 --iterations=30 --socket=/database/mysql/mysql.sock -h localhost -uroot -proot

Benchmark
        Average number of seconds to run all queries: 2.621 seconds
        Minimum number of seconds to run all queries: 1.412 seconds
        Maximum number of seconds to run all queries: 32.743 seconds
        Number of clients running queries: 10
        Average number of queries per client: 1

# mysqlslap --no-defaults --create-schema=test --query="SELECT * FROM tmptable100000_myisam" --concurrency=10 --iterations=30 --socket=/database/mysql/mysql.sock -h localhost -uroot -proot

Benchmark
        Average number of seconds to run all queries: 2.127 seconds
        Minimum number of seconds to run all queries: 1.402 seconds
        Maximum number of seconds to run all queries: 18.392 seconds
        Number of clients running queries: 10
        Average number of queries per client: 1


--no-defaults : UTF8사용시 반드시 필요
--create-schema : db명
--concurrency:접속세션수
--iterations:테스트 반복 횟수