gistfile1.md

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.6.10

read
Benchmark
Running for engine innodb
Average number of seconds to run all queries: 3.271 seconds
Minimum number of seconds to run all queries: 3.232 seconds
Maximum number of seconds to run all queries: 3.323 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: 5.781 seconds
Minimum number of seconds to run all queries: 3.424 seconds
Maximum number of seconds to run all queries: 7.325 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: 4.675 seconds
Minimum number of seconds to run all queries: 4.191 seconds
Maximum number of seconds to run all queries: 5.571 seconds
Number of clients running queries: 10
Average number of queries per client: 1000

MariaDB 10.0.3

read
Benchmark
Running for engine innodb
Average number of seconds to run all queries: 2.954 seconds
Minimum number of seconds to run all queries: 2.900 seconds
Maximum number of seconds to run all queries: 3.083 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: 3.053 seconds
Minimum number of seconds to run all queries: 2.957 seconds
Maximum number of seconds to run all queries: 3.117 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: 4.547 seconds
Minimum number of seconds to run all queries: 4.459 seconds
Maximum number of seconds to run all queries: 4.600 seconds
Number of clients running queries: 10
Average number of queries per client: 1000

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