前回の続き
rarirure.rip
HammerDB
HammerDB の使い方は atsuizo さんのを参考にしました。
atsuizo.hatenadiary.jp
TPC-C を流す
設定
hammerdb>print dict
Dictionary Settings for MySQL
connection {
mysql_host = hasegawa.cluster.ap-northeast-1.rds.amazonaws.com
mysql_port = 3306
}
tpcc {
mysql_count_ware = 1
mysql_num_vu = 1
mysql_user = root
mysql_pass = ZokWAWywPwQtO7xr
mysql_dbase = tpcc
mysql_storage_engine = innodb
mysql_partition = false
mysql_total_iterations = 1000000
mysql_raiseerror = false
mysql_keyandthink = false
mysql_driver = timed
mysql_rampup = 2
mysql_duration = 5
mysql_allwarehouse = false
mysql_timeprofile = false
mysql_async_scale = false
mysql_async_client = 10
mysql_async_verbose = false
mysql_async_delay = 1000
}
hammerdb>print vuconf Virtual Users = 4 User Delay(ms) = 500 Repeat Delay(ms) = 500 Iterations = 1 Show Output = 1 Log Output = 0 Unique Log Name = 1 No Log Buffer = 0 Log Timestamps = 1
結果
5回計測した、平均 TPM
without RDS Proxy
TEST RESULT : System achieved 29349 MySQL TPM at 9754 NOPM TEST RESULT : System achieved 23279 MySQL TPM at 7660 NOPM TEST RESULT : System achieved 30078 MySQL TPM at 9929 NOPM TEST RESULT : System achieved 30173 MySQL TPM at 9892 NOPM TEST RESULT : System achieved 30125 MySQL TPM at 9940 NOPM
平均 TPM: 28,601
with RDS Proxy
TEST RESULT : System achieved 29353 MySQL TPM at 9709 NOPM TEST RESULT : System achieved 20001 MySQL TPM at 6526 NOPM TEST RESULT : System achieved 23056 MySQL TPM at 7553 NOPM TEST RESULT : System achieved 20105 MySQL TPM at 6551 NOPM TEST RESULT : System achieved 26769 MySQL TPM at 8721 NOPM
平均 TPM: 23,857
まとめ
RDS Proxy を使うとパフォーマンスは落ちる。