10のクライアントから各10000回のクエリ発行を5セット
read
mysqlslap -u root -p --engine=innodb --auto-generate-sql --auto-generate-sql-load-type=read --auto-generate-sql-add-autoincrement --number-char-cols=3 --number-int-cols=5 --number-of-queries=10000 --concurrency=10 --iterations=5
write
mysqlslap -u root -p --engine=innodb --auto-generate-sql --auto-generate-sql-load-type=write --auto-generate-sql-add-autoincrement --number-char-cols=3 --number-int-cols=5 --number-of-queries=10000 --concurrency=10 --iterations=5
update
mysqlslap -u root -p --engine=innodb --auto-generate-sql --auto-generate-sql-load-type=update --auto-generate-sql-add-autoincrement --number-char-cols=3 --number-int-cols=5 --number-of-queries=10000 --concurrency=10 --iterations=5
MySQL 5.5.32
read
Benchmark
Running for engine innodb
Average number of seconds to run all queries: 0.962 seconds
Minimum number of seconds to run all queries: 0.947 seconds
Maximum number of seconds to run all queries: 0.991 seconds
Number of clients running queries: 10
Average number of queries per client: 1000
write
Benchmark
Running for engine innodb
Average number of seconds to run all queries: 8.988 seconds
Minimum number of seconds to run all queries: 7.938 seconds
Maximum number of seconds to run all queries: 10.250 seconds
Number of clients running queries: 10
Average number of queries per client: 1000
update
Benchmark
Running for engine innodb
Average number of seconds to run all queries: 9.826 seconds
Minimum number of seconds to run all queries: 9.453 seconds
Maximum number of seconds to run all queries: 10.581 seconds
Number of clients running queries: 10
Average number of queries per client: 1000