mysqlベンチ比較結果

mysqlbench 結果


** 検証環境構成
 CPU        Core2 Duo T7700@2.40GHz * 2
 Memory     512MB
 mysql      5.0.77/5.5.20
 mysqlbench 0.1.0
** 100コネクション 10000トランザクション
--5.5.20
 # ./mysqlbench -U benchuser -P benchuser mysqlbench -c 100 -t 10000 mysqlbench
 starting vacuum...OPTIMIZE TABLE tellers: Commands out of sync; you can't run this command now
 DELETE FROM history: Commands out of sync; you can't run this command now
 OPTIMIZE TABLE history: Commands out of sync; you can't run this command now
 end.
 all connection OK
 go
  end.

 transaction type                    . . . : TPC-B (sort of)
 scaling factor                      . . . : 100
 number of clients                     . . : 100
 number of transactions per client         : 10000
 number of transactions actually processed : 1000000/1000000
 tps (include connections establishing)  . : 669.439800
 tps (exclude connections establishing)  . : 669.456226

--5.0.77
 # ./mysqlbench -U benchuser -P benchuser mysqlbench -c 100 -t 10000 mysqlbench
 starting vacuum...OPTIMIZE TABLE tellers: Commands out of sync; you can't run this command now
 DELETE FROM history: Commands out of sync; you can't run this command now
 OPTIMIZE TABLE history: Commands out of sync; you can't run this command now
 end.
 all connection OK
 go
  end.

 transaction type                    . . . : TPC-B (sort of)
 scaling factor                      . . . : 100
 number of clients                     . . : 100
 number of transactions per client         : 10000
 number of transactions actually processed : 1000000/1000000
 tps (include connections establishing)  . : 389.050391
 tps (exclude connections establishing)  . : 389.057694


-------
** 50コネクション 500トランザクション
--5.5.20
 # ./mysqlbench -U benchuser -P benchuser mysqlbench -c 50 -t 500 mysqlbench
 starting vacuum...OPTIMIZE TABLE tellers: Commands out of sync; you can't run th                                                                                                                                 is command now
 DELETE FROM history: Commands out of sync; you can't run this command now
 OPTIMIZE TABLE history: Commands out of sync; you can't run this command now
 end.
 all connection OK
 go
  end.

 transaction type                    . . . : TPC-B (sort of)
 scaling factor                      . . . : 100
 number of clients                     . . : 50
 number of transactions per client         : 500
 number of transactions actually processed : 25000/25000
 tps (include connections establishing)  . : 646.765235
 tps (exclude connections establishing)  . : 647.112414

--5.0.77
 # ./mysqlbench -U benchuser -P benchuser mysqlbench -c 50 -t 500 mysqlbench
 starting vacuum...OPTIMIZE TABLE tellers: Commands out of sync; you can't run this command now
 DELETE FROM history: Commands out of sync; you can't run this command now
 OPTIMIZE TABLE history: Commands out of sync; you can't run this command now
 end.
 all connection OK
 go
  end.

 transaction type                    . . . : TPC-B (sort of)
 scaling factor                      . . . : 100
 number of clients                     . . : 50
 number of transactions per client         : 500
 number of transactions actually processed : 25000/25000
 tps (include connections establishing)  . : 389.911091
 tps (exclude connections establishing)  . : 390.063899

** 検証結果を受けて

-100*10000=1000000

--5.5.20

 tps (include connections establishing)  . : 669.439800

 tps (exclude connections establishing)  . : 669.456226

--5.0.77

 tps (include connections establishing)  . : 389.050391

 tps (exclude connections establishing)  . : 389.057694

 →コネクション数が伸びれば延びるほど差がつく可能性あり

-50*500=25000トランザクション

--5.5.20

 tps (include connections establishing)  . : 646.765235

 tps (exclude connections establishing)  . : 647.112414

--5.0.77

 tps (include connections establishing)  . : 389.911091

 tps (exclude connections establishing)  . : 390.063899

 →新バージョンの方がかなり優秀

-次回は…。

 つぎはもうちょっとCPU特盛りのサーバで試してみたい。

 最低でも12コア前後のサーバで試して底力がどんなもんか。