innodb高速化

ib_logfile* のおき場所をtmpfsに変えたら早くなりました。

/etc/my.cnfに下記を追加
innodb_log_group_home_dir = /dev/shm

--変更前--
$ mysqlslap --auto-generate-sql --auto-generate-sql-guid-primary --engine=innodb --number-int-cols=3 --number-char-cols=5 --concurrency=300 --auto-generate-sql-write-number=10000 --auto-generate-sql-execute-number=100 --socket=/var/lib/mysql/mysql.sock --auto-generate-sql-load-type=mixed
Benchmark
Running for engine innodb
Average number of seconds to run all queries: 18.046 seconds
Minimum number of seconds to run all queries: 18.046 seconds
Maximum number of seconds to run all queries: 18.046 seconds
Number of clients running queries: 300
Average number of queries per client: 100

--変更後--
$ mysqlslap --auto-generate-sql --auto-generate-sql-guid-primary --engine=innodb --number-int-cols=3 --number-char-cols=5 --concurrency=300 --auto-generate-sql-write-number=10000 --auto-generate-sql-execute-number=100 --socket=/var/lib/mysql/mysql.sock --auto-generat
e-sql-load-type=mixed
Benchmark
Running for engine innodb
Average number of seconds to run all queries: 3.243 seconds
Minimum number of seconds to run all queries: 3.243 seconds
Maximum number of seconds to run all queries: 3.243 seconds
Number of clients running queries: 300
Average number of queries per client: 100

まあ、そりゃそうだ。

そして当然ながら安全性には欠けます。サーバが落ちないことを願う。