{"id":10865,"date":"2024-06-02T21:46:53","date_gmt":"2024-06-02T13:46:53","guid":{"rendered":"https:\/\/www.orczhou.com\/?p=10865"},"modified":"2025-03-12T12:09:08","modified_gmt":"2025-03-12T04:09:08","slug":"cloud-database-rds-mysql-performance-benchmark-2024-06","status":"publish","type":"post","link":"https:\/\/www.orczhou.com\/index.php\/2024\/06\/cloud-database-rds-mysql-performance-benchmark-2024-06\/","title":{"rendered":"\u4e91\u6570\u636e\u5e93RDS MySQL\u6027\u80fd\u6d4b\u8bd5\u4e0e\u5bf9\u6bd4@2024\u5e7405\u6708"},"content":{"rendered":"\n

\u672c\u6587\u662f\u4e00\u4e2a\u7cfb\u5217\u6587\u7ae0\u7684\u4e00\u90e8\u5206\uff0c\u8be5\u7cfb\u5217\u8f83\u4e3a\u5b8c\u6574\u7684\u5bf9\u5404\u4e2a\u4e91\u5382\u5546\u7684RDS MySQL\u8fdb\u884c\u4e86\u6d4b\u8bd5\uff0c\u5305\u62ec\u4e86\u963f\u91cc\u4e91\u3001\u817e\u8baf\u4e91\u3001\u534e\u4e3a\u4e91\u3001\u767e\u5ea6\u4e91\u3001AWS\u3001Azure\u3001GCP\u3001Oracle Cloud\u7b49\uff0c\u6700\u65b0\u7684\u6d4b\u8bd5\uff1a\u4e91\u6570\u636e\u5e93RDS MySQL\u7684\u6027\u80fd<\/a>\u3002<\/em><\/p>\n\n\n\n

\n

\u5728\u4e0d\u540c\u7684\u4e91\u5382\u5546\uff0c\u8d2d\u4e70\u76f8\u540c\u89c4\u683c\u7684MySQL\u5b9e\u4f8b(\u59824vCPU-16GB)\uff0c\u83b7\u5f97\u7684\u6027\u80fd\u76f8\u540c\u5417\uff1f<\/strong><\/p>\n<\/blockquote>\n\n\n\n

\u4e3a\u4e86\u56de\u7b54\u4e0a\u9762\u7684\u7591\u95ee\uff0c\u4e8e\u662f\u5c31\u5f00\u542f\u4e86\u6211\u7684\u6570\u636e\u5e93\u6027\u80fd\u6d4b\u8bd5\u4e4b\u65c5\u3002\u8fd9\u662f\u7b2c\u4e8c\u6b21\u6d4b\u8bd5\uff0c\u4e0a\u4e00\u6b21\u662f\u57282023\u5e7412\u6708\uff08\u53c2\u8003\uff1a\u4e91\u6570\u636e\u5e93(RDS MySQL)\u6027\u80fd\u6df1\u5ea6\u6d4b\u8bc4\u4e0e\u5bf9\u6bd4<\/a>\uff09\u3002<\/p>\n\n\n\n

\u6027\u80fd\u6d4b\u8bd5\u7ed3\u679c\u4e0e\u6982\u8ff0<\/h4>\n\n\n\n
\"\"<\/figure>\n\n\n\n\n\n\n\n\n\n\n

\u8be6\u7ec6\u7684\u6027\u80fd\u6570\u636e<\/h4>\n\n\n\n

QPS\u8be6\u7ec6\u6570\u636e\uff1a<\/p>\n\n\n\n

data<\/th>Tencent<\/th>AWS<\/th>Huawei<\/th>Baidu<\/th>Aliyun_HZ<\/th>Azure<\/th>GCP<\/th>Oracle<\/th><\/tr><\/thead>
4<\/td>5783<\/td>3607<\/td>2623<\/td>2157<\/td>4649<\/td>1716<\/td>1428<\/td>3773<\/td>
8<\/td>10157<\/td>6821<\/td>4770<\/td>4041<\/td>7509<\/td>3050<\/td>2551<\/td>5557<\/td>
16<\/td>16557<\/td>12470<\/td>8694<\/td>7041<\/td>10951<\/td>5579<\/td>4686<\/td>8403<\/td>
32<\/td>22970<\/td>18022<\/td>14192<\/td>11816<\/td>13586<\/td>9352<\/td>8042<\/td>8166<\/td>
48<\/td>26083<\/td>21092<\/td>17621<\/td>16049<\/td>15312<\/td>12148<\/td>10017<\/td>8009<\/td>
64<\/td>27886<\/td>22540<\/td>19927<\/td>18554<\/td>15831<\/td>13516<\/td>10837<\/td>7901<\/td>
96<\/td>30337<\/td>24937<\/td>20555<\/td>20378<\/td>16565<\/td>14672<\/td>11622<\/td>8092<\/td>
128<\/td>31355<\/td>25214<\/td>20151<\/td>20135<\/td>16996<\/td>15210<\/td>12112<\/td>8089<\/td>
192<\/td>32323<\/td>25296<\/td>20648<\/td>20915<\/td>17387<\/td>15498<\/td>12027<\/td>7865<\/td>
256<\/td>32582<\/td>25390<\/td>21796<\/td>21098<\/td>17501<\/td>15419<\/td>12403<\/td>7851<\/td>
384<\/td>32803<\/td>25313<\/td>22957<\/td>21131<\/td>17494<\/td>15487<\/td>12361<\/td>7804<\/td>
512<\/td>32962<\/td>24975<\/td>23177<\/td>21204<\/td>18120<\/td>15582<\/td>12379<\/td>7958<\/td><\/tr><\/tbody><\/table><\/div>\n\n\n\n

<\/p>\n\n\n\n

95%\u5ef6\u8fdf\u8be6\u7ec6\u6570\u636e\uff08\u5355\u4f4d\uff1ams\uff0c\u6b21\u5ef6\u8fdf\u6570\u636e\u4e3a\u7ea620\u4e2aquery\u5408\u5e76\u7edf\u8ba1\u7684\u5ef6\u8fdf\uff09\uff1a<\/p>\n\n\n\n

data<\/th>Oracle<\/th>Azure<\/th>GCP<\/th>Aliyun_HZ<\/th>Baidu<\/th>Huawei<\/th>AWS<\/th>Tencent<\/th><\/tr><\/thead>
4<\/td>21.89<\/td>49.21<\/td>69.29<\/td>21.11<\/td>41.85<\/td>33.72<\/td>22.28<\/td>15.83<\/td>
8<\/td>31.37<\/td>54.83<\/td>87.56<\/td>25.74<\/td>45.79<\/td>37.56<\/td>23.52<\/td>18.61<\/td>
16<\/td>38.25<\/td>61.08<\/td>99.33<\/td>36.24<\/td>53.85<\/td>41.10<\/td>29.19<\/td>24.38<\/td>
32<\/td>82.96<\/td>75.82<\/td>112.67<\/td>70.55<\/td>68.05<\/td>51.02<\/td>41.85<\/td>35.59<\/td>
48<\/td>350.33<\/td>89.16<\/td>142.39<\/td>104.84<\/td>77.19<\/td>62.19<\/td>53.85<\/td>44.98<\/td>
64<\/td>427.07<\/td>110.66<\/td>173.58<\/td>144.97<\/td>90.78<\/td>73.13<\/td>68.05<\/td>54.83<\/td>
96<\/td>601.29<\/td>167.44<\/td>223.34<\/td>193.38<\/td>123.28<\/td>137.35<\/td>97.55<\/td>73.13<\/td>
128<\/td>590.56<\/td>223.34<\/td>277.21<\/td>244.38<\/td>161.51<\/td>176.73<\/td>130.13<\/td>92.42<\/td>
192<\/td>773.68<\/td>350.33<\/td>411.96<\/td>314.45<\/td>227.40<\/td>253.35<\/td>186.54<\/td>134.90<\/td>
256<\/td>1032.01<\/td>502.20<\/td>530.08<\/td>383.33<\/td>297.92<\/td>363.18<\/td>244.38<\/td>176.73<\/td>
384<\/td>3982.86<\/td>787.74<\/td>773.68<\/td>539.71<\/td>434.83<\/td>475.79<\/td>369.77<\/td>287.38<\/td>
512<\/td>5033.35<\/td>1069.86<\/td>1032.01<\/td>657.93<\/td>569.67<\/td>549.52<\/td>502.20<\/td>450.77<\/td><\/tr><\/tbody><\/table><\/div>\n\n\n\n

<\/p>\n\n\n\n

\u5982\u4f55\u91cd\u590d\u8be5\u6d4b\u8bd5<\/h4>\n\n\n\n

\u91cd\u73b0\u8be5\u6d4b\u8bd5\u5305\u542b\u4e86\u4e24\u4e2a\u65b9\u9762\uff0c\u4e00\u4e2a\u662f\u6d4b\u8bd5\u5de5\u5177\u4e0e\u4e3b\u8981\u53c2\u6570\uff0c\u53e6\u4e00\u4e2a\u662f\u6d4b\u8bd5\u5b9e\u4f8b\u7684\u9009\u62e9\u3002<\/p>\n\n\n\n

\u8be5\u6d4b\u8bd5\u9009\u62e9\u4e86\u6a21\u578b\u7b80\u5355\u3001\u6613\u4e8e\u91cd\u73b0\u7684Sysbench\uff08oltp_read_write\uff09\uff0c\u5176\u4e3b\u8981\u53c2\u6570\u5305\u62ec\uff1a<\/p>\n\n\n\n