Linux

トップ > チップス > Linux

さくらのクラウドでsysbench

# sysbench --test=fileio --file-test-mode=rndrw prepare
# sysbench --test=fileio --file-test-mode=rndrw run

Operations performed: 6000 Read, 4000 Write, 12800 Other = 22800 Total
Read 93.75Mb Written 62.5Mb Total transferred 156.25Mb (13.751Mb/sec)
  880.05 Requests/sec executed

Test execution summary:
    total time: 11.3630s
    total number of events: 10000
    total time taken by event execution: 2.4630
    per-request statistics:
         min: 0.01ms
         avg: 0.25ms
         max: 4.02ms
         approx. 95 percentile: 0.58ms

Threads fairness:
    events (avg/stddev): 10000.0000/0.00
    execution time (avg/stddev): 2.4630/0.00

mysqlslap --no-defaults --concurrency=10 --iterations=1 --engine=innodb --number-of-queries=10000 --auto-generate-sql
Benchmark
Running for engine innodb
Average number of seconds to run all queries: 16.906 seconds
Minimum number of seconds to run all queries: 16.906 seconds
Maximum number of seconds to run all queries: 16.906 seconds
Number of clients running queries: 10
Average number of queries per client: 1000


さくらのVPS(大阪リージョン)が4Mb/sec程度だったことを考えると、月額2000円ほどで13.7Mb/secはコストパフォーマンスが良いかもしれません。ちなみに、以下は参考までに測定したDellの物理サーバの成績です。やっぱり快速ですね。

Operations performed: 6000 Read, 4000 Write, 12800 Other = 22800 Total
Read 93.75Mb Written 62.5Mb Total transferred 156.25Mb (34.416Mb/sec)
 2202.60 Requests/sec executed

Test execution summary:
    total time: 4.5401s
    total number of events: 10000
    total time taken by event execution: 0.1011
    per-request statistics:
         min: 0.00ms
         avg: 0.01ms
         max: 0.09ms
         approx. 95 percentile: 0.02ms

Threads fairness:
    events (avg/stddev): 10000.0000/0.00
    execution time (avg/stddev): 0.1011/0.00

# mysqlslap --no-defaults --concurrency=10 --iterations=1 --engine=innodb --number-of-queries=10000 --auto-generate-sql
Benchmark
Running for engine innodb
Average number of seconds to run all queries: 15.548 seconds
Minimum number of seconds to run all queries: 15.548 seconds
Maximum number of seconds to run all queries: 15.548 seconds
Number of clients running queries: 10
Average number of queries per client: 1000
# sysbench
sysbench 0.4.12: multi-threaded system evaluation benchmark

Running the test with following options:
Number of threads: 1

Extra file open flags: 0
128 files, 16Mb each
2Gb total file size
Block size 16Kb
Number of random requests for random IO: 10000
Read/Write ratio for combined random IO test: 1.50
Periodic FSYNC enabled, calling fsync() each 100 requests.
Calling fsync() at the end of test, Enabled.
Using synchronous I/O mode
Doing random r/w test
Threads started!
Done.

Operations performed: 6000 Read, 4000 Write, 12800 Other = 22800 Total
Read 93.75Mb Written 62.5Mb Total transferred 156.25Mb (564.51Mb/sec)
36128.40 Requests/sec executed

Test execution summary:
    total time: 0.2768s
    total number of events: 10000
    total time taken by event execution: 0.0503
    per-request statistics:
         min: 0.00ms
         avg: 0.01ms
         max: 0.07ms
         approx. 95 percentile: 0.01ms

Threads fairness:
    events (avg/stddev): 10000.0000/0.00
    execution time (avg/stddev): 0.0503/0.00

# mysqlslap
Benchmark
Running for engine innodb
Average number of seconds to run all queries: 2.186 seconds
Minimum number of seconds to run all queries: 2.186 seconds
Maximum number of seconds to run all queries: 2.186 seconds
Number of clients running queries: 10
Average number of queries per client: 1000


参考URL

• タグ別一覧: [linux]
• チップス一覧