云数据库RDS MySQL性能测试与对比@2025年01月

在不同的云厂商,购买相同规格的MySQL实例(如4vCPU-16GB),获得的性能相同吗?

本次测试中,极限性能(512并发下的QPS)表现如上图:腾讯云性能最好,达3.6万;其次是阿里云2.7万,相比于上一次测试的4.0万性能下降比较明显;其次是华为、AWS、百度,再次是Azure、Google云和Oracle云。更多详细数据参考如下。

Sysbench QPS 详细数据

dataaliyunawsazurebaidugooglehuaweioracletencent
457892183151720171915247630325868
8871643352964382234154546504610518
161437382725489697560718472783916903
322013215377911111910858214384771723484
4823026178621143915330964118667774726802
6424990199471262318316987721269788930054
96269542246113578205351042322137852935131
128269242320014057214811068221394823036199
192265862330914484214271120322040795836259
256259332339614640218271141322847743835743
384272092292414638214521155224148769035747
512276622277814674214051135024079719636052

Latency (Event) 详细数据

如下表格分别为:平均延迟 和 95%延迟数据。单位为:毫秒/ms。

dataaliyunawsazurebaidugooglehuaweioracletencent
412.4432.9847.4535.7037.6029.0823.7412.27
816.5233.2248.5837.6842.1631.6728.5413.69
1620.0434.8152.4641.2947.4333.9936.7417.04
3228.6137.4563.2148.3667.1140.0474.6324.53
4837.5248.3775.5256.3589.6146.28111.5232.23
6446.1057.7591.2562.89116.6154.16146.0038.33
9664.1176.92127.2584.14165.7678.04202.5649.18
12885.5799.30163.88107.25215.61107.68279.9063.64
192129.99148.24238.56161.27308.43156.77434.1295.30
256177.67196.91314.68211.08403.63201.61619.30128.89
384254.00301.39472.05322.16598.09286.09898.19193.28
512333.11404.42627.82430.45811.55382.501279.61255.51
dataaliyunawsazurebaidugooglehuaweioracletencent
418.9536.2455.8241.1047.4737.5636.8914.73
825.7436.2457.8744.9861.0839.6546.6317.01
1629.1941.1062.1950.1187.5641.8566.8421.89
3244.1745.7978.6062.19147.6149.21121.0831.94
4866.8459.9995.8177.19204.1156.84200.4741.85
6486.0071.83121.0890.78219.3668.05267.4149.21
96116.80101.13183.21125.52272.27123.28325.9862.19
128147.61142.39248.83164.45331.91150.29442.7377.19
192219.36211.60376.49227.40450.77231.53634.66116.80
256282.25272.27511.33292.60569.67320.171376.60158.63
384376.49411.96802.05427.07831.46539.712449.36253.35
512484.44549.521109.09559.501129.24549.523982.86369.77

MySQL 参数对比表格

dataaliyunawsazurebaidugooglehuaweioracletencent
have_sslDISABLEDYESYESDISABLEDYESDISABLEDYESDISABLED
innodb_buffer_pool_size9.75GB11GB12GB12GB11GB9GB17GB12GB
innodb_doublewriteONOFFOFFONONONONON
innodb_flush_log_at_trx_commit11111111
innodb_flush_methodO_DIRECTO_DIRECTfsyncfsyncO_DIRECTO_DIRECTO_DIRECTO_DIRECT
innodb_io_capacity200002002002000500012000125020000
innodb_read_io_threads44NA84424
innodb_write_io_threads44NA84444
log_binONOFFONONONONONON
performance_schemaOFFOFFONOFFONOFFONOFF
rpl_semi_sync_master_enabledONNANAONNAONNAON
rpl_semi_sync_master_timeout1000NANA10000NA10000NA10000
sync_binlog11110001111
thread_pool_size8NA4NANANA164
version8.0.368.0.398.0.39-azure8.0.32-2.0.0.28.0.31-google8.0.28-2310038.0.40-u3-cloud8.0.30-txsql
cpu_capacity100.9106.972.773.449.4163.1101.1118.4

云数据库的 MySQL 8.4 版本

目前,主流版本依旧还是8.0。在2024年04月,最新发布了 8.4 版本,该版本将是下一个稳定版(LTS版),所以也有部分云厂商开始这次该版本。目前,发布了 MySQL 8.4的云厂商有Amazon、Google云和Oracle云。这里也对8.4版本的性能做了测试,并对比如下:

各云厂商详细测试数据

关于各个云厂商更多的详细测试数据可以参考如下专题页面:

更多参考

Leave a Reply

Your email address will not be published. Required fields are marked *