{"id":17016,"date":"2025-02-16T10:45:44","date_gmt":"2025-02-16T02:45:44","guid":{"rendered":"https:\/\/www.orczhou.com\/?p=17016"},"modified":"2025-03-18T13:50:49","modified_gmt":"2025-03-18T05:50:49","slug":"cloud-database-rds-mysql-performance","status":"publish","type":"post","link":"https:\/\/www.orczhou.com\/index.php\/2025\/02\/cloud-database-rds-mysql-performance\/","title":{"rendered":"\u4e91\u6570\u636e\u5e93RDS MySQL\u6027\u80fd\u6d4b\u8bd5\u4e0e\u5bf9\u6bd4@2025\u5e7401\u6708"},"content":{"rendered":"\n<p class=\"has-text-color has-link-color wp-elements-bf604e318f871e68d7cfe7b380ca0879\" style=\"color:#706868;font-size:0.75em\">\u672c\u6587\u662f\u4e00\u4e2a\u7cfb\u5217\u6587\u7ae0\u7684\u4e00\u90e8\u5206<em>\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<a href=\"https:\/\/www.orczhou.com\/index.php\/cloud-database-performance-rds-mysql\/\">\u4e91\u6570\u636e\u5e93RDS MySQL\u7684\u6027\u80fd<\/a>\u3002<\/em><\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"has-text-align-center\"><strong>\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<div>    <script type=\"text\/javascript\">\n      google.charts.load('current', {'packages':['corechart','line']});\n      google.charts.setOnLoadCallback(drawChart);\n      function drawChart() {\n        var data = google.visualization.arrayToDataTable([\n        ['threads\/qps', 'tencent',{type:'string', role:'annotation'},'aliyun',{type:'string', role:'annotation'},'huawei','aws','baidu','azure','google','oracle',{type:'string', role:'annotation'}],\n['4',5868,5868,5789,5789,2476,2183,2017,1517,1915,3032,3032],\n['8',10518,10518,8716,8716,4546,4335,3822,2964,3415,5046,5046],\n['16',16903,16903,14373,14373,8472,8272,6975,5489,6071,7839,7839],\n['32',23484,23484,20132,20132,14384,15377,11910,9111,8582,7717,7717],\n['48',26802,26802,23026,23026,18667,17862,15330,11439,9641,7747,7747],\n['64',30054,30054,24990,24990,21269,19947,18316,12623,9877,7889,7889],\n['96',35131,35131,26954,26954,22137,22461,20535,13578,10423,8529,8529],\n['128',36199,36199,26924,26924,21394,23200,21481,14057,10682,8230,8230],\n['192',36259,36259,26586,26586,22040,23309,21427,14484,11203,7958,7958],\n['256',35743,35743,25933,25933,22847,23396,21827,14640,11413,7438,7438],\n['384',35747,35747,27209,27209,24148,22924,21452,14638,11552,7690,7690],\n['512',36052,36052,27662,27662,24079,22778,21405,14674,11350,7196,7196],\n ]);\n        var options = {\n          title: 'Benchmark for Cloud MySQL at 202501',\n          titleTextStyle: { color: '#4285f4', fontSize: 20, bold: true},\n          subtitle: '4vCPU16GB-100GB-3000iops-Multi-az-by-Sysbench\/orczhou',\n          curveType: 'none',\n          lineWidth:1.5,\n          chartArea:{left:90,bottom:70,top:24},\n          hAxis:{\n            title: 'Sysbench concurrent threads',\n            titleTextStyle: {\n              fontSize:14\n            },\n            textStyle: {\n              fontSize:10,\n            }\n          },\n          vAxis: {\n            title: 'Sysbench QPS (Queries Per Seconds)',\n            titleTextStyle: {\n              fontSize:14\n            },\n            textStyle: {\n              fontSize:10,\n            }\n          },\n          legend: {\n            position: 'right',\n            textStyle: {fontSize: 18},\n            maxLines:8,\n            alignment:'start',\n          },\n          series: {             0: {\n                                  color: '#0052d9',\n                 pointShape:'circle',\n                 pointSize: 4,\n                 annotations: {\n                   textStyle: {\n                     fontSize: 10,\n                     color: '#0052d9',\n                     opacity: 0.8\n                   }\n                 },\n               },\n            1: {\n                                  color: '#ff6a00',\n                 pointShape:'star',\n                 pointSize: 7,\n                 annotations: {\n                   textStyle: {\n                     fontSize: 10,\n                     color: '#ff6a00',\n                     opacity: 0.8\n                   }\n                 },\n               },\n            2: {\n                                  color: '#cd0d2d',\n                 pointShape:'square',\n                 pointSize: 5,\n                 annotations: {\n                   textStyle: {\n                     fontSize: 10,\n                     color: '#cd0d2d',\n                     opacity: 0.8\n                   }\n                 },\n               },\n            3: {\n                                  color: '#141e2e',\n                 pointShape:'triangle',\n                 pointSize: 5,\n                 annotations: {\n                   textStyle: {\n                     fontSize: 10,\n                     color: '#141e2e',\n                     opacity: 0.8\n                   }\n                 },\n               },\n            4: {\n                                  color: '#2418dd',\n                 pointShape:'diamond',\n                 pointSize: 5,\n                 annotations: {\n                   textStyle: {\n                     fontSize: 10,\n                     color: '#2418dd',\n                     opacity: 0.8\n                   }\n                 },\n               },\n            5: {\n                                  color: '#0389d6',\n                 pointShape:{ type: 'star', sides: 4,rotation:45 },\n                 pointSize: 7,\n                 annotations: {\n                   textStyle: {\n                     fontSize: 10,\n                     color: '#0389d6',\n                     opacity: 0.8\n                   }\n                 },\n               },\n            6: {\n                                  color: '#34a853',\n                 pointShape:{ type: 'star', sides: 5,dent:0.8 },\n                 pointSize: 5,\n                 annotations: {\n                   textStyle: {\n                     fontSize: 10,\n                     color: '#34a853',\n                     opacity: 0.8\n                   }\n                 },\n               },\n            7: {\n                                  color: '#ff0000',\n                 pointShape:{ type: 'star', sides: 6,dent:0.8 },\n                 pointSize: 5,\n                 annotations: {\n                   textStyle: {\n                     fontSize: 10,\n                     color: '#ff0000',\n                     opacity: 0.8\n                   }\n                 },\n               },\n },\n          width: 1200,\n          height: 580,\n        };\n        var chart = new google.visualization.LineChart(document.getElementById('chart_div_202501'));\n\/*\n *      set subtitle, ref:\n *          https:\/\/stackoverflow.com\/questions\/41893055\/add-subtitle-in-areachart-in-google-chart\n *\n * *\/\n        var container = document.getElementById('chart_div_202501');\n        google.visualization.events.addListener(chart, 'ready', function () {\n          Array.prototype.forEach.call(container.getElementsByTagName('text'), function(label) {\n            if (label.innerHTML === options.title) {\n              var subtitle = label.parentNode.appendChild(label.cloneNode(true));\n              subtitle.innerHTML = '4vCPU16GB-100GB-3000iops-Multi-az-by-Sysbench\/orczhou';\n              subtitle.setAttribute('font-size', 10 );\n              subtitle.style.fontSize = \"10px\";\n              subtitle.style.fill = \"gray\";\n              \/\/subtitle.setAttribute(\"style\", \"color: green;\");\n              subtitle.setAttribute('y', parseFloat(label.getAttribute('y')) + 20);\n            }\n          });\n        });\n        chart.draw(data, options);\n      }\n    <\/script>\n    <div id=\"chart_div_202501\" style=\"\"><\/div><\/div>\n\n\n\n<p>\u672c\u6b21\u6d4b\u8bd5\u4e2d\uff0c\u6781\u9650\u6027\u80fd\uff08512\u5e76\u53d1\u4e0b\u7684QPS\uff09\u8868\u73b0\u5982\u4e0a\u56fe\uff1a\u817e\u8baf\u4e91\u6027\u80fd\u6700\u597d\uff0c\u8fbe3.6\u4e07\uff1b\u5176\u6b21\u662f\u963f\u91cc\u4e912.7\u4e07\uff0c\u76f8\u6bd4\u4e8e\u4e0a\u4e00\u6b21\u6d4b\u8bd5\u76844.0\u4e07\u6027\u80fd\u4e0b\u964d\u6bd4\u8f83\u660e\u663e\uff1b\u5176\u6b21\u662f\u534e\u4e3a\u3001AWS\u3001\u767e\u5ea6\uff0c\u518d\u6b21\u662fAzure\u3001Google\u4e91\u548cOracle\u4e91\u3002\u66f4\u591a\u8be6\u7ec6\u6570\u636e\u53c2\u8003\u5982\u4e0b\u3002<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Sysbench QPS \u8be6\u7ec6\u6570\u636e<\/h4>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-28f84493 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:5%\"><\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:90%\"><div><table class=\"pure-table pure-table-bordered\" style=\"font-size:0.8em;width:100%\"><thead><tr><th>data<\/th><th>aliyun<\/th><th>aws<\/th><th>azure<\/th><th>baidu<\/th><th>google<\/th><th>huawei<\/th><th>oracle<\/th><th>tencent<\/th><\/tr><\/thead><tbody><tr><td>4<\/td><td>5789<\/td><td>2183<\/td><td>1517<\/td><td>2017<\/td><td>1915<\/td><td>2476<\/td><td>3032<\/td><td>5868<\/td><tr><td>8<\/td><td>8716<\/td><td>4335<\/td><td>2964<\/td><td>3822<\/td><td>3415<\/td><td>4546<\/td><td>5046<\/td><td>10518<\/td><tr><td>16<\/td><td>14373<\/td><td>8272<\/td><td>5489<\/td><td>6975<\/td><td>6071<\/td><td>8472<\/td><td>7839<\/td><td>16903<\/td><tr><td>32<\/td><td>20132<\/td><td>15377<\/td><td>9111<\/td><td>11910<\/td><td>8582<\/td><td>14384<\/td><td>7717<\/td><td>23484<\/td><tr><td>48<\/td><td>23026<\/td><td>17862<\/td><td>11439<\/td><td>15330<\/td><td>9641<\/td><td>18667<\/td><td>7747<\/td><td>26802<\/td><tr><td>64<\/td><td>24990<\/td><td>19947<\/td><td>12623<\/td><td>18316<\/td><td>9877<\/td><td>21269<\/td><td>7889<\/td><td>30054<\/td><tr><td>96<\/td><td>26954<\/td><td>22461<\/td><td>13578<\/td><td>20535<\/td><td>10423<\/td><td>22137<\/td><td>8529<\/td><td>35131<\/td><tr><td>128<\/td><td>26924<\/td><td>23200<\/td><td>14057<\/td><td>21481<\/td><td>10682<\/td><td>21394<\/td><td>8230<\/td><td>36199<\/td><tr><td>192<\/td><td>26586<\/td><td>23309<\/td><td>14484<\/td><td>21427<\/td><td>11203<\/td><td>22040<\/td><td>7958<\/td><td>36259<\/td><tr><td>256<\/td><td>25933<\/td><td>23396<\/td><td>14640<\/td><td>21827<\/td><td>11413<\/td><td>22847<\/td><td>7438<\/td><td>35743<\/td><tr><td>384<\/td><td>27209<\/td><td>22924<\/td><td>14638<\/td><td>21452<\/td><td>11552<\/td><td>24148<\/td><td>7690<\/td><td>35747<\/td><tr><td>512<\/td><td>27662<\/td><td>22778<\/td><td>14674<\/td><td>21405<\/td><td>11350<\/td><td>24079<\/td><td>7196<\/td><td>36052<\/td><\/tr><\/tbody><\/table><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:5%\"><\/div>\n<\/div>\n\n\n\n<h4 class=\"wp-block-heading\">Latency (Event) \u8be6\u7ec6\u6570\u636e<\/h4>\n\n\n\n<p>\u5982\u4e0b\u8868\u683c\u5206\u522b\u4e3a\uff1a\u5e73\u5747\u5ef6\u8fdf \u548c 95%\u5ef6\u8fdf\u6570\u636e\u3002\u5355\u4f4d\u4e3a\uff1a\u6beb\u79d2\/ms\u3002<\/p>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-28f84493 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"font-size:12px\"><div><table class=\"pure-table pure-table-bordered\" style=\"font-size:0.8em;width:100%\"><thead><tr><th>data<\/th><th>aliyun<\/th><th>aws<\/th><th>azure<\/th><th>baidu<\/th><th>google<\/th><th>huawei<\/th><th>oracle<\/th><th>tencent<\/th><\/tr><\/thead><tbody><tr><td>4<\/td><td>12.44<\/td><td>32.98<\/td><td>47.45<\/td><td>35.70<\/td><td>37.60<\/td><td>29.08<\/td><td>23.74<\/td><td>12.27<\/td><tr><td>8<\/td><td>16.52<\/td><td>33.22<\/td><td>48.58<\/td><td>37.68<\/td><td>42.16<\/td><td>31.67<\/td><td>28.54<\/td><td>13.69<\/td><tr><td>16<\/td><td>20.04<\/td><td>34.81<\/td><td>52.46<\/td><td>41.29<\/td><td>47.43<\/td><td>33.99<\/td><td>36.74<\/td><td>17.04<\/td><tr><td>32<\/td><td>28.61<\/td><td>37.45<\/td><td>63.21<\/td><td>48.36<\/td><td>67.11<\/td><td>40.04<\/td><td>74.63<\/td><td>24.53<\/td><tr><td>48<\/td><td>37.52<\/td><td>48.37<\/td><td>75.52<\/td><td>56.35<\/td><td>89.61<\/td><td>46.28<\/td><td>111.52<\/td><td>32.23<\/td><tr><td>64<\/td><td>46.10<\/td><td>57.75<\/td><td>91.25<\/td><td>62.89<\/td><td>116.61<\/td><td>54.16<\/td><td>146.00<\/td><td>38.33<\/td><tr><td>96<\/td><td>64.11<\/td><td>76.92<\/td><td>127.25<\/td><td>84.14<\/td><td>165.76<\/td><td>78.04<\/td><td>202.56<\/td><td>49.18<\/td><tr><td>128<\/td><td>85.57<\/td><td>99.30<\/td><td>163.88<\/td><td>107.25<\/td><td>215.61<\/td><td>107.68<\/td><td>279.90<\/td><td>63.64<\/td><tr><td>192<\/td><td>129.99<\/td><td>148.24<\/td><td>238.56<\/td><td>161.27<\/td><td>308.43<\/td><td>156.77<\/td><td>434.12<\/td><td>95.30<\/td><tr><td>256<\/td><td>177.67<\/td><td>196.91<\/td><td>314.68<\/td><td>211.08<\/td><td>403.63<\/td><td>201.61<\/td><td>619.30<\/td><td>128.89<\/td><tr><td>384<\/td><td>254.00<\/td><td>301.39<\/td><td>472.05<\/td><td>322.16<\/td><td>598.09<\/td><td>286.09<\/td><td>898.19<\/td><td>193.28<\/td><tr><td>512<\/td><td>333.11<\/td><td>404.42<\/td><td>627.82<\/td><td>430.45<\/td><td>811.55<\/td><td>382.50<\/td><td>1279.61<\/td><td>255.51<\/td><\/tr><\/tbody><\/table><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"font-size:12px\"><div><table class=\"pure-table pure-table-bordered\" style=\"font-size:0.8em;width:100%\"><thead><tr><th>data<\/th><th>aliyun<\/th><th>aws<\/th><th>azure<\/th><th>baidu<\/th><th>google<\/th><th>huawei<\/th><th>oracle<\/th><th>tencent<\/th><\/tr><\/thead><tbody><tr><td>4<\/td><td>18.95<\/td><td>36.24<\/td><td>55.82<\/td><td>41.10<\/td><td>47.47<\/td><td>37.56<\/td><td>36.89<\/td><td>14.73<\/td><tr><td>8<\/td><td>25.74<\/td><td>36.24<\/td><td>57.87<\/td><td>44.98<\/td><td>61.08<\/td><td>39.65<\/td><td>46.63<\/td><td>17.01<\/td><tr><td>16<\/td><td>29.19<\/td><td>41.10<\/td><td>62.19<\/td><td>50.11<\/td><td>87.56<\/td><td>41.85<\/td><td>66.84<\/td><td>21.89<\/td><tr><td>32<\/td><td>44.17<\/td><td>45.79<\/td><td>78.60<\/td><td>62.19<\/td><td>147.61<\/td><td>49.21<\/td><td>121.08<\/td><td>31.94<\/td><tr><td>48<\/td><td>66.84<\/td><td>59.99<\/td><td>95.81<\/td><td>77.19<\/td><td>204.11<\/td><td>56.84<\/td><td>200.47<\/td><td>41.85<\/td><tr><td>64<\/td><td>86.00<\/td><td>71.83<\/td><td>121.08<\/td><td>90.78<\/td><td>219.36<\/td><td>68.05<\/td><td>267.41<\/td><td>49.21<\/td><tr><td>96<\/td><td>116.80<\/td><td>101.13<\/td><td>183.21<\/td><td>125.52<\/td><td>272.27<\/td><td>123.28<\/td><td>325.98<\/td><td>62.19<\/td><tr><td>128<\/td><td>147.61<\/td><td>142.39<\/td><td>248.83<\/td><td>164.45<\/td><td>331.91<\/td><td>150.29<\/td><td>442.73<\/td><td>77.19<\/td><tr><td>192<\/td><td>219.36<\/td><td>211.60<\/td><td>376.49<\/td><td>227.40<\/td><td>450.77<\/td><td>231.53<\/td><td>634.66<\/td><td>116.80<\/td><tr><td>256<\/td><td>282.25<\/td><td>272.27<\/td><td>511.33<\/td><td>292.60<\/td><td>569.67<\/td><td>320.17<\/td><td>1376.60<\/td><td>158.63<\/td><tr><td>384<\/td><td>376.49<\/td><td>411.96<\/td><td>802.05<\/td><td>427.07<\/td><td>831.46<\/td><td>539.71<\/td><td>2449.36<\/td><td>253.35<\/td><tr><td>512<\/td><td>484.44<\/td><td>549.52<\/td><td>1109.09<\/td><td>559.50<\/td><td>1129.24<\/td><td>549.52<\/td><td>3982.86<\/td><td>369.77<\/td><\/tr><\/tbody><\/table><\/div>\n<\/div>\n<\/div>\n\n\n\n<h4 class=\"wp-block-heading\">MySQL \u53c2\u6570\u5bf9\u6bd4\u8868\u683c<\/h4>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-28f84493 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column has-x-small-font-size is-layout-flow wp-block-column-is-layout-flow\"><div><table class=\"pure-table pure-table-bordered\" style=\"font-size:0.8em;width:100%\"><thead><tr><th>data<\/th><th>aliyun<\/th><th>aws<\/th><th>azure<\/th><th>baidu<\/th><th>google<\/th><th>huawei<\/th><th>oracle<\/th><th>tencent<\/th><\/tr><\/thead><tbody><tr><td>have_ssl<\/td><td>DISABLED<\/td><td>YES<\/td><td>YES<\/td><td>DISABLED<\/td><td>YES<\/td><td>DISABLED<\/td><td>YES<\/td><td>DISABLED<\/td><tr><td>innodb_buffer_pool_size<\/td><td>9.75GB<\/td><td>11GB<\/td><td>12GB<\/td><td>12GB<\/td><td>11GB<\/td><td>9GB<\/td><td>17GB<\/td><td>12GB<\/td><tr><td>innodb_doublewrite<\/td><td>ON<\/td><td>OFF<\/td><td>OFF<\/td><td>ON<\/td><td>ON<\/td><td>ON<\/td><td>ON<\/td><td>ON<\/td><tr><td>innodb_flush_log_at_trx_commit<\/td><td>1<\/td><td>1<\/td><td>1<\/td><td>1<\/td><td>1<\/td><td>1<\/td><td>1<\/td><td>1<\/td><tr><td>innodb_flush_method<\/td><td>O_DIRECT<\/td><td>O_DIRECT<\/td><td>fsync<\/td><td>fsync<\/td><td>O_DIRECT<\/td><td>O_DIRECT<\/td><td>O_DIRECT<\/td><td>O_DIRECT<\/td><tr><td>innodb_io_capacity<\/td><td>20000<\/td><td>200<\/td><td>200<\/td><td>2000<\/td><td>5000<\/td><td>12000<\/td><td>1250<\/td><td>20000<\/td><tr><td>innodb_read_io_threads<\/td><td>4<\/td><td>4<\/td><td>NA<\/td><td>8<\/td><td>4<\/td><td>4<\/td><td>2<\/td><td>4<\/td><tr><td>innodb_write_io_threads<\/td><td>4<\/td><td>4<\/td><td>NA<\/td><td>8<\/td><td>4<\/td><td>4<\/td><td>4<\/td><td>4<\/td><tr><td>log_bin<\/td><td>ON<\/td><td>OFF<\/td><td>ON<\/td><td>ON<\/td><td>ON<\/td><td>ON<\/td><td>ON<\/td><td>ON<\/td><tr><td>performance_schema<\/td><td>OFF<\/td><td>OFF<\/td><td>ON<\/td><td>OFF<\/td><td>ON<\/td><td>OFF<\/td><td>ON<\/td><td>OFF<\/td><tr><td>rpl_semi_sync_master_enabled<\/td><td>ON<\/td><td>NA<\/td><td>NA<\/td><td>ON<\/td><td>NA<\/td><td>ON<\/td><td>NA<\/td><td>ON<\/td><tr><td>rpl_semi_sync_master_timeout<\/td><td>1000<\/td><td>NA<\/td><td>NA<\/td><td>10000<\/td><td>NA<\/td><td>10000<\/td><td>NA<\/td><td>10000<\/td><tr><td>sync_binlog<\/td><td>1<\/td><td>1<\/td><td>1<\/td><td>1000<\/td><td>1<\/td><td>1<\/td><td>1<\/td><td>1<\/td><tr><td>thread_pool_size<\/td><td>8<\/td><td>NA<\/td><td>4<\/td><td>NA<\/td><td>NA<\/td><td>NA<\/td><td>16<\/td><td>4<\/td><tr><td>version<\/td><td>8.0.36<\/td><td>8.0.39<\/td><td>8.0.39-azure<\/td><td>8.0.32-2.0.0.2<\/td><td>8.0.31-google<\/td><td>8.0.28-231003<\/td><td>8.0.40-u3-cloud<\/td><td>8.0.30-txsql<\/td><tr><td>instance_type<\/td><td><\/td><td>db.m6i.xlarge<\/td><td>GP_Standard_D4ads_v5<\/td><td><\/td><td>db-custom-4-16384<\/td><td>m<\/td><td><\/td><td><\/td><tr><td>storage_type<\/td><td>cloud_essd<\/td><td>io1<\/td><td>NA<\/td><td><\/td><td>NA<\/td><td>m<\/td><td><\/td><td><\/td><tr><td>storage_size<\/td><td><\/td><td>100<\/td><td>100<\/td><td><\/td><td>100<\/td><td>m<\/td><td>100<\/td><td><\/td><tr><td>storage_iops<\/td><td><\/td><td>3000<\/td><td>3000<\/td><td><\/td><td>NA<\/td><td>m<\/td><td><\/td><td><\/td><tr><td>cpu_capacity<\/td><td>100.9<\/td><td>106.9<\/td><td>72.7<\/td><td>73.4<\/td><td>49.4<\/td><td>163.1<\/td><td>101.1<\/td><td>118.4<\/td><\/tr><\/tbody><\/table><\/div>\n<\/div>\n<\/div>\n\n\n\n<h4 class=\"wp-block-heading\">\u4e91\u6570\u636e\u5e93\u7684 MySQL 8.4 \u7248\u672c<\/h4>\n\n\n\n<p>\u76ee\u524d\uff0c\u4e3b\u6d41\u7248\u672c\u4f9d\u65e7\u8fd8\u662f8.0\u3002\u57282024\u5e7404\u6708\uff0c\u6700\u65b0\u53d1\u5e03\u4e86 8.4 \u7248\u672c\uff0c\u8be5\u7248\u672c\u5c06\u662f\u4e0b\u4e00\u4e2a\u7a33\u5b9a\u7248\uff08LTS\u7248\uff09\uff0c\u6240\u4ee5\u4e5f\u6709\u90e8\u5206\u4e91\u5382\u5546\u5f00\u59cb\u8fd9\u6b21\u8be5\u7248\u672c\u3002\u76ee\u524d\uff0c\u53d1\u5e03\u4e86 MySQL 8.4\u7684\u4e91\u5382\u5546\u6709Amazon\u3001Google\u4e91\u548cOracle\u4e91\u3002\u8fd9\u91cc\u4e5f\u5bf98.4\u7248\u672c\u7684\u6027\u80fd\u505a\u4e86\u6d4b\u8bd5\uff0c\u5e76\u5bf9\u6bd4\u5982\u4e0b\uff1a<\/p>\n\n\n<div>    <script type=\"text\/javascript\">\n      google.charts.load('current', {'packages':['corechart','line']});\n      google.charts.setOnLoadCallback(drawChart);\n      function drawChart() {\n        var data = google.visualization.arrayToDataTable([\n        ['threads\/qps', 'aws_m6i_8403','gcp_8403','oci_8403'],\n['4',2410,3208,2701],\n['8',4709,5413,4676],\n['16',8660,8130,6162],\n['32',15415,10526,6635],\n['48',17503,11442,7140],\n['64',18982,11462,7861],\n['96',18380,11790,8389],\n['128',20511,11862,8050],\n['192',21353,11726,7858],\n['256',21918,11926,7858],\n['384',21784,12031,7563],\n['512',21845,12046,7665],\n ]);\n        var options = {\n          title: 'Benchmark for Cloud MySQL',\n          titleTextStyle: { color: '#4285f4', fontSize: 20, bold: true},\n          subtitle: '4vCPU16GB-100GB-3000iops-Multi-az-by-Sysbench\/orczhou',\n          curveType: 'none',\n          lineWidth:1.5,\n          chartArea:{left:90,bottom:70,top:24},\n          hAxis:{\n            title: 'Sysbench concurrent threads',\n            titleTextStyle: {\n              fontSize:14\n            },\n            textStyle: {\n              fontSize:10,\n            }\n          },\n          vAxis: {\n            title: 'Sysbench QPS (Queries Per Seconds)',\n            titleTextStyle: {\n              fontSize:14\n            },\n            textStyle: {\n              fontSize:10,\n            }\n          },\n          legend: {\n            position: 'right',\n            textStyle: {fontSize: 18},\n            maxLines:8,\n            alignment:'start',\n          },\n          series: {             0: {\n                                  color: '#141e2e',\n                 pointShape:'triangle',\n                 pointSize: 5,\n                 annotations: {\n                   textStyle: {\n                     fontSize: 10,\n                     color: '#141e2e',\n                     opacity: 0.8\n                   }\n                 },\n               },\n            1: {\n                                  color: '#0052d9',\n                 pointShape:'circle',\n                 pointSize: 4,\n                 annotations: {\n                   textStyle: {\n                     fontSize: 10,\n                     color: '#0052d9',\n                     opacity: 0.8\n                   }\n                 },\n               },\n            2: {\n                                  color: '#ff6a00',\n                 pointShape:'star',\n                 pointSize: 7,\n                 annotations: {\n                   textStyle: {\n                     fontSize: 10,\n                     color: '#ff6a00',\n                     opacity: 0.8\n                   }\n                 },\n               },\n },\n          width: 1150,\n          height: 580,\n        };\n        var chart = new google.visualization.LineChart(document.getElementById('chart_div_8_4'));\n\/*\n *      set subtitle, ref:\n *          https:\/\/stackoverflow.com\/questions\/41893055\/add-subtitle-in-areachart-in-google-chart\n *\n * *\/\n        var container = document.getElementById('chart_div_8_4');\n        google.visualization.events.addListener(chart, 'ready', function () {\n          Array.prototype.forEach.call(container.getElementsByTagName('text'), function(label) {\n            if (label.innerHTML === options.title) {\n              var subtitle = label.parentNode.appendChild(label.cloneNode(true));\n              subtitle.innerHTML = '4vCPU16GB-100GB-3000iops-Multi-az-by-Sysbench\/orczhou';\n              subtitle.setAttribute('font-size', 10 );\n              subtitle.style.fontSize = \"10px\";\n              subtitle.style.fill = \"gray\";\n              \/\/subtitle.setAttribute(\"style\", \"color: green;\");\n              subtitle.setAttribute('y', parseFloat(label.getAttribute('y')) + 20);\n            }\n          });\n        });\n        chart.draw(data, options);\n      }\n    <\/script>\n    <div id=\"chart_div_8_4\" style=\"\"><\/div><\/div>\n\n\n\n<h4 class=\"wp-block-heading\">\u5404\u4e91\u5382\u5546\u8be6\u7ec6\u6d4b\u8bd5\u6570\u636e<\/h4>\n\n\n\n<p>\u5173\u4e8e\u5404\u4e2a\u4e91\u5382\u5546\u66f4\u591a\u7684\u8be6\u7ec6\u6d4b\u8bd5\u6570\u636e\u53ef\u4ee5\u53c2\u8003\u5982\u4e0b\u4e13\u9898\u9875\u9762\uff1a<\/p>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-28f84493 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:20%\">\n<figure class=\"wp-block-image aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"274\" src=\"https:\/\/www.orczhou.com\/wp-content\/uploads\/2024\/12\/image-26-1024x274.png\" alt=\"\" class=\"wp-image-16502\" style=\"width:146px;height:auto\" srcset=\"https:\/\/www.orczhou.com\/wp-content\/uploads\/2024\/12\/image-26-1024x274.png 1024w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2024\/12\/image-26-300x80.png 300w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2024\/12\/image-26-768x206.png 768w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2024\/12\/image-26.png 1214w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:20%\">\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"767\" height=\"210\" src=\"https:\/\/www.orczhou.com\/wp-content\/uploads\/2025\/01\/image-8-e1737699596489.png\" alt=\"\" class=\"wp-image-17269\" style=\"width:157px;height:auto\" srcset=\"https:\/\/www.orczhou.com\/wp-content\/uploads\/2025\/01\/image-8-e1737699596489.png 767w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2025\/01\/image-8-e1737699596489-300x82.png 300w\" sizes=\"auto, (max-width: 767px) 100vw, 767px\" \/><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:10%\">\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"256\" height=\"256\" src=\"https:\/\/www.orczhou.com\/wp-content\/uploads\/2024\/12\/image-19.png\" alt=\"\" class=\"wp-image-16487\" style=\"width:63px;height:auto\" srcset=\"https:\/\/www.orczhou.com\/wp-content\/uploads\/2024\/12\/image-19.png 256w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2024\/12\/image-19-150x150.png 150w\" sizes=\"auto, (max-width: 256px) 100vw, 256px\" \/><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:10%\">\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"794\" height=\"794\" src=\"https:\/\/www.orczhou.com\/wp-content\/uploads\/2024\/12\/image-56.png\" alt=\"\" class=\"wp-image-16584\" style=\"width:57px;height:auto\" srcset=\"https:\/\/www.orczhou.com\/wp-content\/uploads\/2024\/12\/image-56.png 794w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2024\/12\/image-56-300x300.png 300w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2024\/12\/image-56-150x150.png 150w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2024\/12\/image-56-768x768.png 768w\" sizes=\"auto, (max-width: 794px) 100vw, 794px\" \/><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:20%\">\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"205\" src=\"https:\/\/www.orczhou.com\/wp-content\/uploads\/2024\/12\/image-21.png\" alt=\"\" class=\"wp-image-16490\" style=\"width:132px;height:auto\" srcset=\"https:\/\/www.orczhou.com\/wp-content\/uploads\/2024\/12\/image-21.png 600w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2024\/12\/image-21-300x103.png 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:20%\">\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"181\" height=\"66\" src=\"https:\/\/www.orczhou.com\/wp-content\/uploads\/2025\/01\/image-9-e1737699666834.png\" alt=\"\" class=\"wp-image-17272\"\/><\/figure>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-28f84493 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"159\" src=\"https:\/\/www.orczhou.com\/wp-content\/uploads\/2025\/01\/image-7.png\" alt=\"\" class=\"wp-image-17265\" style=\"width:206px;height:auto\" srcset=\"https:\/\/www.orczhou.com\/wp-content\/uploads\/2025\/01\/image-7.png 1024w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2025\/01\/image-7-300x47.png 300w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2025\/01\/image-7-768x119.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"387\" height=\"130\" src=\"https:\/\/www.orczhou.com\/wp-content\/uploads\/2024\/12\/image-59.png\" alt=\"\" class=\"wp-image-16605\" style=\"width:143px;height:auto\" srcset=\"https:\/\/www.orczhou.com\/wp-content\/uploads\/2024\/12\/image-59.png 387w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2024\/12\/image-59-300x101.png 300w\" sizes=\"auto, (max-width: 387px) 100vw, 387px\" \/><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\"><\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\"><\/div>\n<\/div>\n\n\n\n<h4 class=\"wp-block-heading\">\u66f4\u591a\u53c2\u8003<\/h4>\n\n\n\n<ul class=\"wp-block-list is-style-no-disc\">\n<li>[1] <a href=\"https:\/\/www.orczhou.com\/index.php\/cloud-database-performance-rds-mysql\/\">\u4e91\u6570\u636e\u5e93 RDS MySQL \u7684\u6027\u80fd\u7efc\u8ff0<\/a><\/li>\n\n\n\n<li>[2] <a href=\"https:\/\/www.orczhou.com\/index.php\/2024\/09\/cloud-database-rds-mysql-performance-sysbench-benchmark\/\">\u4e91\u6570\u636e\u5e93RDS MySQL\u6027\u80fd\u6d4b\u8bd5\u4e0e\u5bf9\u6bd4@2024\u5e7409\u6708<\/a><\/li>\n\n\n\n<li>[3] <a href=\"https:\/\/www.orczhou.com\/index.php\/2024\/06\/cloud-database-rds-mysql-performance-benchmark-2024-06\/\">\u4e91\u6570\u636e\u5e93RDS MySQL\u6027\u80fd\u6d4b\u8bd5\u4e0e\u5bf9\u6bd4@2024\u5e7405\u6708<\/a><\/li>\n\n\n\n<li>[4] <a href=\"https:\/\/www.orczhou.com\/index.php\/2023\/12\/performance-of-all-the-cloud-database\/\">\u4e91\u6570\u636e\u5e93RDS MySQL\u6027\u80fd\u6d4b\u8bc4\u4e0e\u5bf9\u6bd4@2023\u5e7412\u6708<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\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 \u672c\u6b21\u6d4b\u8bd5\u4e2d\uff0c\u6781\u9650\u6027\u80fd\uff08512\u5e76\u53d1\u4e0b\u7684QPS\uff09\u8868\u73b0\u5982\u4e0a\u56fe\uff1a\u817e\u8baf\u4e91\u6027\u80fd\u6700\u597d\uff0c\u8fbe3.6\u4e07\uff1b\u5176\u6b21\u662f\u963f\u91cc\u4e912.7\u4e07\uff0c\u76f8\u6bd4\u4e8e\u4e0a\u4e00\u6b21\u6d4b\u8bd5\u76844.0\u4e07\u6027\u80fd\u4e0b\u964d\u6bd4\u8f83\u660e\u663e\uff1b\u5176\u6b21\u662f\u534e\u4e3a\u3001AWS\u3001\u767e\u5ea6\uff0c\u518d\u6b21\u662fAzure\u3001Google\u4e91\u548cOracle\u4e91\u3002\u66f4\u591a\u8be6\u7ec6\u6570\u636e\u53c2\u8003\u5982\u4e0b\u3002 Sysbench QPS \u8be6\u7ec6\u6570\u636e Latency (Event) \u8be6\u7ec6\u6570\u636e \u5982\u4e0b\u8868\u683c\u5206\u522b\u4e3a\uff1a\u5e73\u5747\u5ef6\u8fdf \u548c 95%\u5ef6\u8fdf\u6570\u636e\u3002\u5355\u4f4d\u4e3a\uff1a\u6beb\u79d2\/ms\u3002 MySQL \u53c2\u6570\u5bf9\u6bd4\u8868\u683c \u4e91\u6570\u636e\u5e93\u7684 MySQL 8.4 \u7248\u672c \u76ee\u524d\uff0c\u4e3b\u6d41\u7248\u672c\u4f9d\u65e7\u8fd8\u662f8.0\u3002\u57282024\u5e7404\u6708\uff0c\u6700\u65b0\u53d1\u5e03\u4e86 8.4 \u7248\u672c\uff0c\u8be5\u7248\u672c\u5c06\u662f\u4e0b\u4e00\u4e2a\u7a33\u5b9a\u7248\uff08LTS\u7248\uff09\uff0c\u6240\u4ee5\u4e5f\u6709\u90e8\u5206\u4e91\u5382\u5546\u5f00\u59cb\u8fd9\u6b21\u8be5\u7248\u672c\u3002\u76ee\u524d\uff0c\u53d1\u5e03\u4e86 MySQL 8.4\u7684\u4e91\u5382\u5546\u6709Amazon\u3001Google\u4e91\u548cOracle\u4e91\u3002\u8fd9\u91cc\u4e5f\u5bf98.4\u7248\u672c\u7684\u6027\u80fd\u505a\u4e86\u6d4b\u8bd5\uff0c\u5e76\u5bf9\u6bd4\u5982\u4e0b\uff1a \u5404\u4e91\u5382\u5546\u8be6\u7ec6\u6d4b\u8bd5\u6570\u636e \u5173\u4e8e\u5404\u4e2a\u4e91\u5382\u5546\u66f4\u591a\u7684\u8be6\u7ec6\u6d4b\u8bd5\u6570\u636e\u53ef\u4ee5\u53c2\u8003\u5982\u4e0b\u4e13\u9898\u9875\u9762\uff1a \u66f4\u591a\u53c2\u8003<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"wp-custom-template-a-1440-px-width-template","format":"standard","meta":{"_eb_attr":"","inline_featured_image":false,"_tocer_settings":[],"footnotes":""},"categories":[138],"tags":[],"class_list":["post-17016","post","type-post","status-publish","format-standard","hentry","category-cloud-mysql-performance-benchmark"],"_links":{"self":[{"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/posts\/17016","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/comments?post=17016"}],"version-history":[{"count":57,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/posts\/17016\/revisions"}],"predecessor-version":[{"id":17684,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/posts\/17016\/revisions\/17684"}],"wp:attachment":[{"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/media?parent=17016"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/categories?post=17016"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/tags?post=17016"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}