{"id":14364,"date":"2024-09-26T14:58:25","date_gmt":"2024-09-26T06:58:25","guid":{"rendered":"https:\/\/www.orczhou.com\/?p=14364"},"modified":"2025-03-12T12:09:34","modified_gmt":"2025-03-12T04:09:34","slug":"cloud-database-rds-mysql-performance-sysbench-benchmark","status":"publish","type":"post","link":"https:\/\/www.orczhou.com\/index.php\/2024\/09\/cloud-database-rds-mysql-performance-sysbench-benchmark\/","title":{"rendered":"\u4e91\u6570\u636e\u5e93RDS MySQL\u6027\u80fd\u6d4b\u8bd5\u4e0e\u5bf9\u6bd4@2024\u5e7409\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', 'aliyun',{type:'string', role:'annotation'},'tencent',{type:'string', role:'annotation'},'huawei','baidu','aws','azure','google','oracle',{type:'string', role:'annotation'}],\n['4',7102,7102,5592,5592,2557,2206,1639,2025,723,3551,3551],\n['8',9702,9702,9936,9936,4674,4101,3313,3654,1341,5936,5936],\n['16',14660,14660,16141,16141,8229,7298,6427,6548,2502,8054,8054],\n['32',22155,22155,22336,22336,13520,12022,12157,10363,4857,8317,8317],\n['48',27905,27905,24770,24770,17849,16448,16516,11973,6745,8130,8130],\n['64',32704,32704,26495,26495,20114,18187,18118,12761,8071,7838,7838],\n['96',36846,36846,29077,29077,20883,21007,20782,13300,9675,8504,8504],\n['128',39697,39697,29918,29918,20128,21029,22446,13388,10620,8198,8198],\n['192',38999,38999,30610,30610,20521,22091,22590,13478,11507,8043,8043],\n['256',38356,38356,31052,31052,21187,21665,22323,12985,11872,7907,7907],\n['384',39679,39679,31224,31224,21729,21167,21902,12904,12131,8209,8209],\n['512',40333,40333,31805,31805,22647,21627,21591,12930,12106,8386,8386],\n ]);\n        var options = {\n          title: 'Benchmark for MySQL on Cloud at 202409',\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: '#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            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: '#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: '#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            4: {\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            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: 1300,\n          height: 580,\n        };\n        var chart = new google.visualization.LineChart(document.getElementById('chart_div'));\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');\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\" style=\"\"><\/div><table class=\"pure-table pure-table-bordered\" style=\"font-size:0.8em;width:100%\"><thead><tr><th>data<\/th><th>aliyun<\/th><th>tencent<\/th><th>huawei<\/th><th>baidu<\/th><th>aws<\/th><th>azure<\/th><th>google<\/th><th>oracle<\/th><\/tr><\/thead><tbody><tr><td>4<\/td><td>7102<\/td><td>5592<\/td><td>2557<\/td><td>2206<\/td><td>1639<\/td><td>2025<\/td><td>723<\/td><td>3551<\/td><tr><td>8<\/td><td>9702<\/td><td>9936<\/td><td>4674<\/td><td>4101<\/td><td>3313<\/td><td>3654<\/td><td>1341<\/td><td>5936<\/td><tr><td>16<\/td><td>14660<\/td><td>16141<\/td><td>8229<\/td><td>7298<\/td><td>6427<\/td><td>6548<\/td><td>2502<\/td><td>8054<\/td><tr><td>32<\/td><td>22155<\/td><td>22336<\/td><td>13520<\/td><td>12022<\/td><td>12157<\/td><td>10363<\/td><td>4857<\/td><td>8317<\/td><tr><td>48<\/td><td>27905<\/td><td>24770<\/td><td>17849<\/td><td>16448<\/td><td>16516<\/td><td>11973<\/td><td>6745<\/td><td>8130<\/td><tr><td>64<\/td><td>32704<\/td><td>26495<\/td><td>20114<\/td><td>18187<\/td><td>18118<\/td><td>12761<\/td><td>8071<\/td><td>7838<\/td><tr><td>96<\/td><td>36846<\/td><td>29077<\/td><td>20883<\/td><td>21007<\/td><td>20782<\/td><td>13300<\/td><td>9675<\/td><td>8504<\/td><tr><td>128<\/td><td>39697<\/td><td>29918<\/td><td>20128<\/td><td>21029<\/td><td>22446<\/td><td>13388<\/td><td>10620<\/td><td>8198<\/td><tr><td>192<\/td><td>38999<\/td><td>30610<\/td><td>20521<\/td><td>22091<\/td><td>22590<\/td><td>13478<\/td><td>11507<\/td><td>8043<\/td><tr><td>256<\/td><td>38356<\/td><td>31052<\/td><td>21187<\/td><td>21665<\/td><td>22323<\/td><td>12985<\/td><td>11872<\/td><td>7907<\/td><tr><td>384<\/td><td>39679<\/td><td>31224<\/td><td>21729<\/td><td>21167<\/td><td>21902<\/td><td>12904<\/td><td>12131<\/td><td>8209<\/td><tr><td>512<\/td><td>40333<\/td><td>31805<\/td><td>22647<\/td><td>21627<\/td><td>21591<\/td><td>12930<\/td><td>12106<\/td><td>8386<\/td><tr><td>cpu_capacity<\/td><td>80.4<\/td><td>93.3<\/td><td>163.6<\/td><td>73.9<\/td><td>110.9<\/td><td>56.3<\/td><td>49.9<\/td><td>114.7<\/td><\/tr><\/tbody><\/table><\/div>\n\n\n\n<h4 class=\"wp-block-heading\">\u6d4b\u8bd5\u7ed3\u679c\u6982\u8ff0<\/h4>\n\n\n\n<p>\u5728\u672c\u6b21\u6d4b\u8bd5\u4e2d\uff1a\u963f\u91cc\u4e91RDS MySQL\u6027\u80fd\u8868\u73b0\u6700\u597d\uff0c\u6781\u9650\u7684QPS\u8fbe\u5230\u4e864\u4e07\uff1b\u5176\u6b21\u662f\u817e\u8baf\u4e91\uff0c\u8fbe\u5230\u4e863.2\u4e07\uff1b\u7b2c\u4e8c\u68af\u961f\u662f\u534e\u4e3a\u4e91\u3001\u767e\u5ea6\u4e91\u548cAWS\uff0c\u6781\u9650\u7684QPS\u7ea62.2\u4e07\uff1b\u4e4b\u540e\u662fAzure\u3001Google\u4e91\uff0c\u6781\u9650QPS\u7ea61.2\u4e07\uff1b\u6700\u540e\u662fOracle\u4e91\uff0c\u6781\u9650QPS\u7ea68500\u3002\u8be6\u7ec6\u7684\u6570\u636e\u548c\u8d8b\u52bf\u56fe\uff0c\u53ef\u4ee5\u53c2\u8003\u4ee5\u4e0a\u7684\u56fe\u3001\u8868\uff0c\u8fd9\u91cc\u4e0d\u518d\u8be6\u8ff0\u3002<\/p>\n\n\n\n<!--more-->\n\n\n\n\n\n\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">\u201c\u5355\u4f4dCPU\u8ba1\u7b97\u80fd\u529b\u201d\u63d0\u4f9b\u7684Sysbench QPS<\/h4>\n\n\n\n<p>\u201c\u5355\u4f4dCPU\u4e0a\u7684Sysbench QPS\u201d\uff08Sysbench QPS per CPU Capacity Unit\uff09\uff0c\u5f88\u5927\u7a0b\u5ea6\u7684\u5c55\u73b0\u4e86\u5404\u4e2a\u5382\u5546\u5728\u8be5\u6d4b\u8bd5\u6a21\u578b\u4e0b\uff0c\u5bf9MySQL\u5185\u6838\u6027\u80fd\u4f18\u5316\u7684\u6548\u679c\u5982\u4f55\u3002<\/p>\n\n\n\n<p>\u672c\u6b21\u6d4b\u8bd5\u4e2d\uff0c\u65b0\u589e\u4e86\u201cCPU\u8ba1\u7b97\u80fd\u529b\u6307\u6807\u201d\uff0c\u53c2\u8003\u4e0a\u56fe\u7684\u201ccpu_capacity\u201d\u6570\u636e\u3002\u201cCPU\u8ba1\u7b97\u80fd\u529b\u6307\u6807\u201d\uff0c\u8868\u793a\u8be5\u5b9e\u4f8b\u7684CPU\uff0c\u5728\u8f83\u9ad8\u5e76\u53d1\uff08\u7b49\u4e8e\u6216\u8d85\u8fc7CPU\u6838\u6570\/\u8d85\u7ebf\u7a0b\uff09\u60c5\u51b5\u4e0b\uff0c\u6bcf\u79d2\u80fd\u591f\u5b8c\u6210\u591a\u5c11\u4e07\u6b21\u7b80\u5355\u7684\u6563\u5217\u8ba1\u7b97\u3002\u4f8b\u5982\u963f\u91cc\u4e91\u7684\u201cCPU\u8ba1\u7b97\u80fd\u529b\u6307\u6807\u201d\u662f80.4\uff0c\u5219\u8868\u793a\u8be5CPU\u5e73\u5747\u6bcf\u79d2\u80fd\u591f\u5b8c\u621080.4\u4e07\u6b21\u7b80\u5355\u5b57\u7b26\u4e32\u6563\u5217\u8ba1\u7b97\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\">\n<p>\u6709\u4e86\u8fd9\u4e2a\u6307\u6807\uff0c\u6211\u4eec\u53ef\u4ee5\u5bf9\u4e0a\u8ff0\u7684\u6027\u80fd\u6307\u6807\u518d\u8fdb\u884c\u4e00\u6b21\u6df1\u5165\u7684\u89c2\u5bdf\u3002\u9996\u5148\uff0c\u53ef\u4ee5\u89c2\u5bdf\uff0c\u6bcf\u4e2a\u4e91\u5382\u5546\uff0c\u63d0\u4f9b\u7684\u8be5\u6807\u51c6\u89c4\u683c\u4e0bCPU\u8d44\u6e90\u5177\u4f53\u4e3a\u591a\u5c11\u3002\u8fd9\u4e5f\u5c31\u662f\u53f3\u56fe\u4e2d\u84dd\u8272\u7684\u67f1\u72b6\u56fe\u3002\u4f8b\u5982\uff0c\u8fd9\u91cc\u7684\u963f\u91cc\u4e91RDS MySQL\u7684\u201cCPU\u8ba1\u7b97\u80fd\u529b\u201d\u4e3a80.4\uff0c\u817e\u8baf\u4e91\u4e3a93.3\uff0c\u534e\u4e3a\u4e91\u4e3a163.6\u3002\u53ef\u4ee5\u770b\u5230\uff0c\u5404\u4e2a\u4e91\u5382\u5546\u5bf9\u4e8e\u201c\u76f8\u540c\u201d\uff084c16g\uff09\u7684\u5b9e\u4f8b\uff0c\u63d0\u4f9b\u4e86\u4e0d\u540c\u7684CPU\u8ba1\u7b97\u80fd\u529b\u3002\u800c\u8fd9\u4e9b\u8ba1\u7b97\u80fd\u529b\u4e5f\u5728\u5404\u4e2aRDS MySQL\u7684Sysbench QPS\u4e2d\u6709\u6240\u8868\u73b0\u3002<\/p>\n\n\n\n<p>\u66f4\u52a0\u6df1\u5165\u7684\uff0c\u8fd8\u53ef\u4ee5\u89c2\u5bdf\u5230\u6bcf\u4e2a\u4e91\u5382\u5546\u5728\u201c\u5355\u4f4dCPU\u8ba1\u7b97\u80fd\u529b\u201d\u6240\u80fd\u591f\u63d0\u4f9b\u7684Sysbench QPS\u3002\u8fd9\u91cc\uff0c\u5bf9\u201c\u5355\u4f4dCPU\u8ba1\u7b97\u80fd\u529b\u201d\u5b9a\u4e49\u662f\uff1a\u5728MySQL\u4e2d\u201c\u4e00\u4e07\u6b21\u7b80\u5355\u6563\u5217\u201d\u7684\u8ba1\u7b97\u8d44\u6e90\u3002\u53f3\u56fe\u4e2d\u7684\u7ea2\u8272\u67f1\u72b6\u56fe\uff0c\u5373\u8868\u793a\u201c\u5355\u4f4dCPU\u8ba1\u7b97\u80fd\u529b\u201d\u6240\u80fd\u591f\u63d0\u4f9b\u7684Sysbench QPS\u3002<\/p>\n\n\n<p>$$<br \/>\n\\text{Sysbench QPS per CPU Capacity Unit} = \\frac{\\text{Sysbench QPS}}{\\text{CPU capacity}}<br \/>\n$$<\/p>\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 size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"917\" src=\"https:\/\/www.orczhou.com\/wp-content\/uploads\/2024\/09\/image-69-1024x917.png\" alt=\"\" class=\"wp-image-14680\" srcset=\"https:\/\/www.orczhou.com\/wp-content\/uploads\/2024\/09\/image-69-1024x917.png 1024w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2024\/09\/image-69-300x269.png 300w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2024\/09\/image-69-768x688.png 768w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2024\/09\/image-69.png 1284w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n<\/div>\n\n\n\n<p>\u56e0\u4e3a\u8be5\u6307\u6807\u4e0d\u518d\u5173\u6ce8\u7edd\u5bf9CPU\u8868\u73b0\u4e0b\u7684Sysbench QPS\uff0c\u6240\u4ee5\uff0c\u8be5\u6307\u6807\u53ef\u4ee5\u53cd\u5e94\u5404\u4e2a\u5382\u5546\u5728\u8be5\u6d4b\u8bd5\u6a21\u578b\u4e0b\uff0c\u5bf9MySQL\u5185\u6838\u6027\u80fd\u4f18\u5316\u7684\u6548\u679c\u5982\u4f55\u3002<\/p>\n\n\n\n<p>\u5f53\u7136\uff0c\u5bf9\u4e8e\u5f00\u53d1\u8005\u9009\u62e9RDS MySQL\u6765\u8bf4\uff0c\u6709\u65f6\u5019\u53ea\u5173\u6ce8\u7edd\u5bf9Sysbench QPS\u5c31\u53ef\u4ee5\u4e86\u3002<\/p>\n\n\n\n<p>\u8fd8\u9700\u8981\u6ce8\u610f\u7684\u662f\uff0c\u56e0\u4e3a\u5404\u4e2a\u4e91\u5382\u5546\u7684\u67b6\u6784\u3001\u6027\u80fd\u53c2\u6570\u7b49\u5404\u4e0d\u76f8\u540c\uff0c\u6240\u4ee5\uff0c\u5728\u505a\u5bf9\u6bd4\u7684\u65f6\u5019\uff0c\u9700\u8981\u8003\u8651\u8fd9\u4e9b\u56e0\u7d20\u3002\u4f8b\u5982\uff0c\u767e\u5ea6\u7684RDS MySQL\u7684<code>sync_binlog<\/code>\u53c2\u6570\u662f1000\uff0c\u5176\u4ed6\u5382\u5546\u90fd\u662f1\uff1b\u518d\u6bd4\u5982\uff0cAWS RDS MySQL\u4f7f\u7528\u7684\u5b58\u50a8\u540c\u6b65\u590d\u5236\uff0c\u6240\u4ee5\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0cBinlog\u751a\u81f3\u662f\u5173\u95ed\u7684\uff08\u51c6\u786e\u7684\u8bf4\uff0c\u5e94\u8be5\u662f\u4e0e<a href=\"https:\/\/docs.aws.amazon.com\/AmazonRDS\/latest\/UserGuide\/USER_LogAccess.MySQL.BinaryFormat.html\"><code>automated backups<\/code>\u662f\u5426\u5f00\u542f\u6709\u5173<\/a>\uff09\u3002<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">\u5173\u4e8e\u8be5\u6d4b\u8bd5<\/h4>\n\n\n\n<p>\u5728\u6c47\u603b\u6587\u7ae0\uff1a<a href=\"https:\/\/www.orczhou.com\/index.php\/cloud-database-performance-rds-mysql\/\">\u4e91\u6570\u636e\u5e93RDS MySQL\u7684\u6027\u80fd\u6d4b\u8bd5<\/a>\u8f83\u4e3a\u8be6\u7ec6\u4ecb\u7ecd\u4e86\u8be5\u6d4b\u8bd5\uff0c\u5305\u62ec\u4e86\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u5982\u4f55\u91cd\u73b0\u8be5\u6d4b\u8bd5\uff1a<a href=\"https:\/\/www.orczhou.com\/index.php\/cloud-database-performance-rds-mysql\/#Sysbench\">\u6d4b\u8bd5\u5de5\u5177<\/a><\/li>\n\n\n\n<li>\u8be5\u6d4b\u8bd5\u4e2d\u5982\u4f55\u9009\u62e9\u5404\u4e2a\u4e91\u5382\u5546\u76844vCPU 16GB\u7684\u5b9e\u4f8b\uff1a<a href=\"https:\/\/www.orczhou.com\/index.php\/cloud-database-performance-rds-mysql\/#RDS_MySQL\">\u5b9e\u4f8b\u89c4\u683c\u7684\u9009\u62e9<\/a><\/li>\n\n\n\n<li>\u5982\u4f55\u7406\u89e3\u8be5\u6d4b\u8bd5\uff1a<a href=\"https:\/\/www.orczhou.com\/index.php\/2024\/01\/acmug-rds-mysql-performance\/\">\u4e91\u6570\u636e\u5e93RDS MySQL\u6027\u80fd\u6df1\u5ea6\u6d4b\u8bc4\u4e0e\u5bf9\u6bd4@ACMUG-202401<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.orczhou.com\/index.php\/cloud-database-performance-rds-mysql\/#i-4\">\u5173\u4e8e\u8be5\u6d4b\u8bd5\u7684\u9650\u5236<\/a><\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<p>\u4ee5\u4e0b\u6570\u636e\u4ece\u201c\u7eb5\u5411\u201d\u6c47\u603b\u4e86\u67d0\u4e00\u4e2a\u4e91\u5382\u5546\u4e4b\u524d\u5386\u6b21\u6d4b\u8bd5\u7684\u6570\u636e\uff0c\u5305\u62ec\u4e0d\u540c\u7684\u533a\u57df\uff0c\u65f6\u95f4\u7684\u6d4b\u8bd5\u3002<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">\u963f\u91cc\u4e91 RDS MySQL<\/h4>\n\n\n\n<p>\u672c\u6b21\u6d4b\u8bd5\u4e86\u676d\u5dde\u3001\u5317\u4eac\u4e24\u4e2a\u5730\u533aRDS MySQL\uff0c\u4e24\u4e2a\u5730\u533a\u7684\u5b9e\u4f8b\u6027\u80fd\u76f8\u5dee\u660e\u663e\uff1a4\u4e07 vs 3.2\u4e07\u3002\u5e76\u4e14\uff0c\u672c\u6b21\u6d4b\u8bd5\u6027\u80fd\u76f8\u6bd4\u4e8e\u4e4b\u524d\u7684\u6d4b\u8bd5\uff0c\u6027\u80fd\u589e\u957f\u660e\u663e\u3002\u4ece\u8fd9\u91cc\u7684\u89c2\u5bdf\u6765\u770b\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>CPU\u8ba1\u7b97\u80fd\u529b\u63d0\u5347\u660e\u663e<\/li>\n\n\n\n<li>\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u5173\u95ed\u4e86<code>performance_schema<\/code><\/li>\n\n\n\n<li>\u5f00\u542f\u6216\u4f18\u5316\u4e86<code>thread_pool<\/code> \uff0c\u6ce8\u610f\u5230\uff0cthread_pool_size\u53c2\u6570\u53d1\u751f\u4e86\u53d8\u5316<\/li>\n<\/ul>\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', '202409_hangzhou','202409_beijing','202405_hangzhou','202405_shenzhen','202405_beijing'],\n['4',7102,5166,4649,3101,3812],\n['8',9702,8045,7509,5234,5629],\n['16',14660,12211,10951,8461,7576],\n['32',22155,17946,13586,11498,10534],\n['48',27905,22734,15312,13603,10968],\n['64',32704,26520,15831,13427,11371],\n['96',36846,28843,16565,15104,11728],\n['128',39697,30261,16996,15416,11933],\n['192',38999,29380,17387,15723,12268],\n['256',38356,31131,17501,15965,12146],\n['384',39679,31601,17494,16805,12101],\n['512',40333,32472,18120,16880,11937],\n ]);\n        var options = {\n          title: 'Aliyun RDS MySQL',\n          titleTextStyle: { color: '#4285f4', fontSize: 20, bold: true},\n          subtitle: '4vCPU16GB-100GB-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: '#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            3: {\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            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 },\n          width: 1200,\n          height: 520,\n        };\n        var chart = new google.visualization.LineChart(document.getElementById('chart_div_aliyun'));\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_aliyun');\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-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_aliyun\" style=\"\"><\/div><table class=\"pure-table pure-table-bordered\" style=\"font-size:0.8em;width:100%\"><thead><tr><th>data<\/th><th>202409_hangzhou<\/th><th>202409_beijing<\/th><th>202405_hangzhou<\/th><th>202405_shenzhen<\/th><th>202405_beijing<\/th><\/tr><\/thead><tbody><tr><td>4<\/td><td>7102<\/td><td>5166<\/td><td>4649<\/td><td>3101<\/td><td>3812<\/td><tr><td>8<\/td><td>9702<\/td><td>8045<\/td><td>7509<\/td><td>5234<\/td><td>5629<\/td><tr><td>16<\/td><td>14660<\/td><td>12211<\/td><td>10951<\/td><td>8461<\/td><td>7576<\/td><tr><td>32<\/td><td>22155<\/td><td>17946<\/td><td>13586<\/td><td>11498<\/td><td>10534<\/td><tr><td>48<\/td><td>27905<\/td><td>22734<\/td><td>15312<\/td><td>13603<\/td><td>10968<\/td><tr><td>64<\/td><td>32704<\/td><td>26520<\/td><td>15831<\/td><td>13427<\/td><td>11371<\/td><tr><td>96<\/td><td>36846<\/td><td>28843<\/td><td>16565<\/td><td>15104<\/td><td>11728<\/td><tr><td>128<\/td><td>39697<\/td><td>30261<\/td><td>16996<\/td><td>15416<\/td><td>11933<\/td><tr><td>192<\/td><td>38999<\/td><td>29380<\/td><td>17387<\/td><td>15723<\/td><td>12268<\/td><tr><td>256<\/td><td>38356<\/td><td>31131<\/td><td>17501<\/td><td>15965<\/td><td>12146<\/td><tr><td>384<\/td><td>39679<\/td><td>31601<\/td><td>17494<\/td><td>16805<\/td><td>12101<\/td><tr><td>512<\/td><td>40333<\/td><td>32472<\/td><td>18120<\/td><td>16880<\/td><td>11937<\/td><tr><td>cpu_capacity<\/td><td>80.4<\/td><td>74.9<\/td><td>39.7<\/td><td>45.3<\/td><td>33.3<\/td><\/tr><\/tbody><\/table><\/div>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">\u817e\u8baf\u4e91 TencentDB for MySQL<\/h4>\n\n\n\n<p>\u672c\u6b21\u4ec5\u6d4b\u8bd5\u4e86\u817e\u8baf\u4e91\u5317\u4eac\u3001\u72ec\u4eab\u5b9e\u4f8b\uff0c\u6574\u4f53\u7684\u6027\u80fd\u8868\u73b0\u4f9d\u65e7\u975e\u5e38\u597d\u3002\u7eb5\u5411\u7684\uff0c\u4e0e5\u6708\u4efd\u7684\u6d4b\u8bd5\u5bf9\u6bd4\uff0c\u6027\u80fd\u8f83\u4e3a\u7a33\u5b9a\uff0c\u6ca1\u6709\u592a\u5927\u7684\u6ce2\u52a8\u3002\u503c\u5f97\u6ce8\u610f\u7684\u662f\uff0c\u76f8\u6bd4\u4e8e\u4e4b\u524d\uff08202405\u4e0a\u6d77\u533a\u57df\uff09\uff0c\u672c\u6b21\u6d4b\u8bd5\u817e\u8baf\u4e91\u7684\u5b9e\u4f8b\u4f7f\u7528\u4e86\u66f4\u5c11\u7684\u201cCPU\u8ba1\u7b97\u80fd\u529b\u201d\uff0c\u4f46\u4f9d\u65e7\u83b7\u5f97\u4e86\u4e0e\u4e4b\u524d\u6d4b\u8bd5\u8f83\u4e3a\u63a5\u8fd1\u7684\u6027\u80fd\u8868\u73b0\u3002<\/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', '202405_shanghai_exclusive','202405_beijing_universal','202405_beijing_exclusive','202409_beijing_exclusive'],\n['4',6960,5401,5783,5592],\n['8',11791,10148,10157,9936],\n['16',18661,18664,16557,16141],\n['32',24731,31668,22970,22336],\n['48',27420,35385,26083,24770],\n['64',29471,36336,27886,26495],\n['96',31167,36418,30337,29077],\n['128',31506,36257,31355,29918],\n['192',31747,36394,32323,30610],\n['256',31708,35955,32582,31052],\n['384',32574,34481,32803,31224],\n['512',33472,33164,32962,31805],\n ]);\n        var options = {\n          title: 'Tencent RDS MySQL',\n          titleTextStyle: { color: '#4285f4', fontSize: 20, bold: true},\n          subtitle: '4vCPU16GB-100GB-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: '#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            3: {\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 },\n          width: 1200,\n          height: 520,\n        };\n        var chart = new google.visualization.LineChart(document.getElementById('chart_div_tencent'));\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_tencent');\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-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_tencent\" style=\"\"><\/div><table class=\"pure-table pure-table-bordered\" style=\"font-size:0.8em;width:100%\"><thead><tr><th>data<\/th><th>202405_shanghai_exclusive<\/th><th>202405_beijing_universal<\/th><th>202405_beijing_exclusive<\/th><th>202409_beijing_exclusive<\/th><\/tr><\/thead><tbody><tr><td>4<\/td><td>6960<\/td><td>5401<\/td><td>5783<\/td><td>5592<\/td><tr><td>8<\/td><td>11791<\/td><td>10148<\/td><td>10157<\/td><td>9936<\/td><tr><td>16<\/td><td>18661<\/td><td>18664<\/td><td>16557<\/td><td>16141<\/td><tr><td>32<\/td><td>24731<\/td><td>31668<\/td><td>22970<\/td><td>22336<\/td><tr><td>48<\/td><td>27420<\/td><td>35385<\/td><td>26083<\/td><td>24770<\/td><tr><td>64<\/td><td>29471<\/td><td>36336<\/td><td>27886<\/td><td>26495<\/td><tr><td>96<\/td><td>31167<\/td><td>36418<\/td><td>30337<\/td><td>29077<\/td><tr><td>128<\/td><td>31506<\/td><td>36257<\/td><td>31355<\/td><td>29918<\/td><tr><td>192<\/td><td>31747<\/td><td>36394<\/td><td>32323<\/td><td>30610<\/td><tr><td>256<\/td><td>31708<\/td><td>35955<\/td><td>32582<\/td><td>31052<\/td><tr><td>384<\/td><td>32574<\/td><td>34481<\/td><td>32803<\/td><td>31224<\/td><tr><td>512<\/td><td>33472<\/td><td>33164<\/td><td>32962<\/td><td>31805<\/td><tr><td>cpu_capacity<\/td><td>169.3<\/td><td>170.5<\/td><td>92<\/td><td>93.3<\/td><\/tr><\/tbody><\/table><\/div>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">\u534e\u4e3a\u4e91 RDS MySQL<\/h4>\n\n\n\n<p>\u672c\u6b21\u6d4b\u8bd5\u534e\u4e3a\u4e91\u8868\u73b0\u7a33\u5b9a\uff0c\u4e0e\u4e4b\u524d\u7684\u6d4b\u8bd5\u8868\u73b0\u975e\u5e38\u63a5\u8fd1\uff1a\u6027\u80fd\u6570\u636e\u63a5\u8fd1\uff0c\u7248\u672c\u51e0\u4e4e\u76f8\u540c\uff08build\u53f7\u4ece\u201c8.0.28-231002\u201d\u5347\u4e3a\u4e86\u201c8.0.28-231003\u201d\uff09\uff0c\u6240\u63d0\u4f9b\u7684CPU\u8ba1\u7b97\u80fd\u529b\u4e5f\u51e0\u4e4e\u76f8\u540c\u3002\u6ce8\u610f\u5230\uff0c\u534e\u4e3a\u4e91RDS MySQL\u4e00\u76f4\u662f\u6240\u6709\u4e91\u5382\u5546\uff0c\u6240\u63d0\u4f9b\u7684\u8ba1\u7b97\u80fd\u529b\u6700\u9ad8\u7684\u5382\u5546\u3002\u4f3c\u4e4e\uff0c\u662f\u8fd9\u6837\uff0c\u522b\u7684\u4e91\u5382\u5546\u7684\u76844c16g\u901a\u5e38\u662f\uff0c4\u4e2a\u8d85\u7ebf\u7a0b\uff0c\u800c\u534e\u4e3a\u4e91\u4f3c\u4e4e\u771f\u7684\u662f\u63d0\u4f9b\u4e864\u4e2a\u6838(cores)\u3002<\/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', '202405_beijing_x86','202409_beijing_x86','202405_beijing_arm'],\n['4',2623,2557,1895],\n['8',4770,4674,3439],\n['16',8694,8229,6186],\n['32',14192,13520,9432],\n['48',17621,17849,11174],\n['64',19927,20114,12527],\n['96',20555,20883,12980],\n['128',20151,20128,13029],\n['192',20648,20521,13345],\n['256',21796,21187,14212],\n['384',22957,21729,15056],\n['512',23177,22647,15172],\n ]);\n        var options = {\n          title: 'Huawei RDS MySQL',\n          titleTextStyle: { color: '#4285f4', fontSize: 20, bold: true},\n          subtitle: '4vCPU16GB-100GB-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: '#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 },\n          width: 1200,\n          height: 520,\n        };\n        var chart = new google.visualization.LineChart(document.getElementById('chart_div_huawei'));\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_huawei');\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-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_huawei\" style=\"\"><\/div><table class=\"pure-table pure-table-bordered\" style=\"font-size:0.8em;width:100%\"><thead><tr><th>data<\/th><th>202405_beijing_x86<\/th><th>202409_beijing_x86<\/th><th>202405_beijing_arm<\/th><\/tr><\/thead><tbody><tr><td>4<\/td><td>2623<\/td><td>2557<\/td><td>1895<\/td><tr><td>8<\/td><td>4770<\/td><td>4674<\/td><td>3439<\/td><tr><td>16<\/td><td>8694<\/td><td>8229<\/td><td>6186<\/td><tr><td>32<\/td><td>14192<\/td><td>13520<\/td><td>9432<\/td><tr><td>48<\/td><td>17621<\/td><td>17849<\/td><td>11174<\/td><tr><td>64<\/td><td>19927<\/td><td>20114<\/td><td>12527<\/td><tr><td>96<\/td><td>20555<\/td><td>20883<\/td><td>12980<\/td><tr><td>128<\/td><td>20151<\/td><td>20128<\/td><td>13029<\/td><tr><td>192<\/td><td>20648<\/td><td>20521<\/td><td>13345<\/td><tr><td>256<\/td><td>21796<\/td><td>21187<\/td><td>14212<\/td><tr><td>384<\/td><td>22957<\/td><td>21729<\/td><td>15056<\/td><tr><td>512<\/td><td>23177<\/td><td>22647<\/td><td>15172<\/td><tr><td>cpu_capacity<\/td><td>167.6<\/td><td>163.6<\/td><td>89.5<\/td><\/tr><\/tbody><\/table><\/div>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">\u767e\u5ea6\u4e91 RDS MySQL<\/h4>\n\n\n\n<p>\u767e\u5ea6\u4e91RDS\u63d0\u4f9b\u975e\u5e38\u7a33\u5b9a\u7684\u6027\u80fd\u3002\u5982\u4e0b\u56fe\u6570\u636e\u6240\u793a\uff0c\u56db\u6b21\u6d4b\u8bd5\uff0c\u6574\u4f53\u7684\u6027\u80fd\u8868\u73b0\u975e\u5e38\u7a33\u5b9a\uff0c\u5730\u57df\u5dee\u5f02\u4e5f\u6bd4\u8f83\u5c0f\u3002<\/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', '202409_beijing','202405_beijing','202405_beijing_extra','202405_guangzhou'],\n['4',2206,2157,2178,2712],\n['8',4101,4041,4051,4837],\n['16',7298,7041,7292,8246],\n['32',12022,11816,11990,12785],\n['48',16448,16049,16243,16047],\n['64',18187,18554,17888,18618],\n['96',21007,20378,20387,19355],\n['128',21029,20135,20915,19797],\n['192',22091,20915,20556,19858],\n['256',21665,21098,21200,19406],\n['384',21167,21131,21125,20157],\n['512',21627,21204,20737,19542],\n ]);\n        var options = {\n          title: 'Baidu RDS MySQL',\n          titleTextStyle: { color: '#4285f4', fontSize: 20, bold: true},\n          subtitle: '4vCPU16GB-100GB-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: '#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            3: {\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 },\n          width: 1200,\n          height: 520,\n        };\n        var chart = new google.visualization.LineChart(document.getElementById('chart_div_baidu'));\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_baidu');\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-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_baidu\" style=\"\"><\/div><table class=\"pure-table pure-table-bordered\" style=\"font-size:0.8em;width:100%\"><thead><tr><th>data<\/th><th>202409_beijing<\/th><th>202405_beijing<\/th><th>202405_beijing_extra<\/th><th>202405_guangzhou<\/th><\/tr><\/thead><tbody><tr><td>4<\/td><td>2206<\/td><td>2157<\/td><td>2178<\/td><td>2712<\/td><tr><td>8<\/td><td>4101<\/td><td>4041<\/td><td>4051<\/td><td>4837<\/td><tr><td>16<\/td><td>7298<\/td><td>7041<\/td><td>7292<\/td><td>8246<\/td><tr><td>32<\/td><td>12022<\/td><td>11816<\/td><td>11990<\/td><td>12785<\/td><tr><td>48<\/td><td>16448<\/td><td>16049<\/td><td>16243<\/td><td>16047<\/td><tr><td>64<\/td><td>18187<\/td><td>18554<\/td><td>17888<\/td><td>18618<\/td><tr><td>96<\/td><td>21007<\/td><td>20378<\/td><td>20387<\/td><td>19355<\/td><tr><td>128<\/td><td>21029<\/td><td>20135<\/td><td>20915<\/td><td>19797<\/td><tr><td>192<\/td><td>22091<\/td><td>20915<\/td><td>20556<\/td><td>19858<\/td><tr><td>256<\/td><td>21665<\/td><td>21098<\/td><td>21200<\/td><td>19406<\/td><tr><td>384<\/td><td>21167<\/td><td>21131<\/td><td>21125<\/td><td>20157<\/td><tr><td>512<\/td><td>21627<\/td><td>21204<\/td><td>20737<\/td><td>19542<\/td><tr><td>cpu_capacity<\/td><td>73.9<\/td><td>76<\/td><td>73.6<\/td><td>74.3<\/td><\/tr><\/tbody><\/table><\/div>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">\u4e9a\u9a6c\u900aAmazon RDS MySQL<\/h4>\n\n\n\n<p>AWS\u662f\u6240\u6709\u4e91\u5382\u5546\u4e2d\uff0c\u6027\u80fd\u7ba1\u7406\u505a\u7684\u6700\u597d\u7684\uff0c\u5bf9\u4e8e\u4e0d\u540c\u4ee3\u9645\u7684CPU\u5728\u5b9e\u4f8b\u4ee3\u7801\u5c42\u9762\u80fd\u591f\u76f4\u63a5\u770b\u5230\u3002\u53ef\u4ee5\u770b\u5230\uff0c\u5176\u6027\u80fd\u6574\u4f53\u4e0a\u8f83\u4e3a\u7a33\u5b9a\uff0c\u4f46\u672c\u6b21\u8fdb\u884c\u4e24\u6b21\u6d4b\u8bd5\uff0c\u76f8\u6bd4\u4e4b\u524d\u8981\u66f4\u4f4e\u4e00\u4e9b\uff0c\u4ece\u914d\u7f6e\u548cCPU\u8ba1\u7b97\u80fd\u529b\u6307\u6807\u6765\u770b\uff0c\u5e76\u6ca1\u6709\u660e\u663e\u5dee\u522b\u3002<\/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', '202409_m7g_tokyo','202405_m6i_tokyo','202405_m6i_hk','202409_m6i_tokyo','202409_m6i_hk'],\n['4',1824,3607,3557,1639,3439],\n['8',3781,6821,6681,3313,6428],\n['16',7424,12470,12410,6427,12379],\n['32',14122,18022,18680,12157,18360],\n['48',18390,21092,20887,16516,20508],\n['64',21168,22540,22490,18118,22088],\n['96',23995,24937,23894,20782,23080],\n['128',24687,25214,24052,22446,23425],\n['192',25937,25296,24240,22590,23570],\n['256',25634,25390,24155,22323,23578],\n['384',25624,25313,24103,21902,23516],\n['512',25496,24975,23804,21591,null],\n ]);\n        var options = {\n          title: 'Amazon RDS MySQL',\n          titleTextStyle: { color: '#4285f4', fontSize: 20, bold: true},\n          subtitle: '4vCPU16GB-100GB-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: '#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            3: {\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            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 },\n          width: 1200,\n          height: 520,\n        };\n        var chart = new google.visualization.LineChart(document.getElementById('chart_div_aws'));\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_aws');\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-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_aws\" style=\"\"><\/div><table class=\"pure-table pure-table-bordered\" style=\"font-size:0.8em;width:100%\"><thead><tr><th>data<\/th><th>202409_m7g_tokyo<\/th><th>202405_m6i_tokyo<\/th><th>202405_m6i_hk<\/th><th>202409_m6i_tokyo<\/th><th>202409_m6i_hk<\/th><\/tr><\/thead><tbody><tr><td>4<\/td><td>1824<\/td><td>3607<\/td><td>3557<\/td><td>1639<\/td><td>3439<\/td><tr><td>8<\/td><td>3781<\/td><td>6821<\/td><td>6681<\/td><td>3313<\/td><td>6428<\/td><tr><td>16<\/td><td>7424<\/td><td>12470<\/td><td>12410<\/td><td>6427<\/td><td>12379<\/td><tr><td>32<\/td><td>14122<\/td><td>18022<\/td><td>18680<\/td><td>12157<\/td><td>18360<\/td><tr><td>48<\/td><td>18390<\/td><td>21092<\/td><td>20887<\/td><td>16516<\/td><td>20508<\/td><tr><td>64<\/td><td>21168<\/td><td>22540<\/td><td>22490<\/td><td>18118<\/td><td>22088<\/td><tr><td>96<\/td><td>23995<\/td><td>24937<\/td><td>23894<\/td><td>20782<\/td><td>23080<\/td><tr><td>128<\/td><td>24687<\/td><td>25214<\/td><td>24052<\/td><td>22446<\/td><td>23425<\/td><tr><td>192<\/td><td>25937<\/td><td>25296<\/td><td>24240<\/td><td>22590<\/td><td>23570<\/td><tr><td>256<\/td><td>25634<\/td><td>25390<\/td><td>24155<\/td><td>22323<\/td><td>23578<\/td><tr><td>384<\/td><td>25624<\/td><td>25313<\/td><td>24103<\/td><td>21902<\/td><td>23516<\/td><tr><td>512<\/td><td>25496<\/td><td>24975<\/td><td>23804<\/td><td>21591<\/td><td>null<\/td><tr><td>cpu_capacity<\/td><td>190.7<\/td><td>110.1<\/td><td>112.8<\/td><td>110.9<\/td><td>113.9<\/td><\/tr><\/tbody><\/table><\/div>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">\u5fae\u8f6fAzure Database for MySQL<\/h4>\n\n\n\n<p>Azure\u7684\u5b9e\u4f8b\u6709\u7740\u5f88\u591a\u5382\u5546\u7c7b\u4f3c\u7684CPU\u4ee3\u5dee\u5bfc\u81f4\u7684\u6027\u80fd\u6ce2\u52a8\u95ee\u9898\uff0c\u5728202409\u7684\u6d4b\u8bd5\u4e2dCPU\u8ba1\u7b97\u80fd\u529b\u6307\u6807\u4e3a56.3\uff0c\u76f8\u6bd4202405\u8868\u73b0\u768463.9\uff0c\u4e5f\u4e0b\u964d\u4e8612%\uff0cAzure Database for MySQL\u7684Sysbench QPS\u6027\u80fd\u4e5f\u968f\u4e4b\u4e0b\u964d\u3002<\/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', '202405_hk_4c16g','202409_hk_4c16g','202409_hk_2c8g'],\n['4',1734,2025,1563],\n['8',3293,3654,2725],\n['16',5975,6548,4713],\n['32',10048,10363,6859],\n['48',12973,11973,7796],\n['64',14341,12761,8060],\n['96',15451,13300,8237],\n['128',16162,13388,8258],\n['192',16663,13478,8171],\n['256',16613,12985,8338],\n['384',16605,12904,8552],\n['512',16613,12930,8882],\n ]);\n        var options = {\n          title: 'Azure Database for MySQL',\n          titleTextStyle: { color: '#4285f4', fontSize: 20, bold: true},\n          subtitle: '4vCPU16GB-100GB-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: '#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 },\n          width: 1000,\n          height: 480,\n        };\n        var chart = new google.visualization.LineChart(document.getElementById('chart_div_azure'));\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_azure');\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-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_azure\" style=\"\"><\/div><table class=\"pure-table pure-table-bordered\" style=\"font-size:0.8em;width:100%\"><thead><tr><th>data<\/th><th>202405_hk_4c16g<\/th><th>202409_hk_4c16g<\/th><th>202409_hk_2c8g<\/th><\/tr><\/thead><tbody><tr><td>4<\/td><td>1734<\/td><td>2025<\/td><td>1563<\/td><tr><td>8<\/td><td>3293<\/td><td>3654<\/td><td>2725<\/td><tr><td>16<\/td><td>5975<\/td><td>6548<\/td><td>4713<\/td><tr><td>32<\/td><td>10048<\/td><td>10363<\/td><td>6859<\/td><tr><td>48<\/td><td>12973<\/td><td>11973<\/td><td>7796<\/td><tr><td>64<\/td><td>14341<\/td><td>12761<\/td><td>8060<\/td><tr><td>96<\/td><td>15451<\/td><td>13300<\/td><td>8237<\/td><tr><td>128<\/td><td>16162<\/td><td>13388<\/td><td>8258<\/td><tr><td>192<\/td><td>16663<\/td><td>13478<\/td><td>8171<\/td><tr><td>256<\/td><td>16613<\/td><td>12985<\/td><td>8338<\/td><tr><td>384<\/td><td>16605<\/td><td>12904<\/td><td>8552<\/td><tr><td>512<\/td><td>16613<\/td><td>12930<\/td><td>8882<\/td><tr><td>cpu_capacity<\/td><td>63.9<\/td><td>56.3<\/td><td>31.6<\/td><\/tr><\/tbody><\/table><\/div>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">\u8c37\u6b4c\u4e91\u4e0a\u7684Cloud SQL Enterprise<\/h4>\n\n\n\n<p>Google\u4e91\u7684MySQL\u6258\u7ba1\u670d\u52a1\u5728\u6700\u8fd1\u4e24\u5e74\u91cc\u505a\u4e86\u975e\u5e38\u591a\u7684\u589e\u5f3a\uff0c\u4e00\u65b9\u9762\u63a8\u51fa\u4e86AlloyDB\uff0c\u6258\u7ba1MySQL\u4e5f\u63a8\u51fa\u4e86Enterprise Plus\u7248\u672c\u3002\u6027\u80fd\u4e0a\uff0c202409\u7684\u6d4b\u8bd5\u4e2d\uff0c\u4e0e202405\u7684\u6d4b\u8bd5\u6027\u80fd\u5e76\u6ca1\u6709\u592a\u5927\u7684\u5dee\u5f02\uff1b\u6b64\u5916\uff0c\u5b83\u7684<code>Enterprise Plus<\/code>\u7248\u672c\u7684\u6027\u80fd\u63d0\u5347\u4e5f\u975e\u5e38\u660e\u663e\uff0c\u6709\u7740\u66f4\u591a\u7684CPU\u8ba1\u7b97\u6027\u80fd\uff0c\u4e5f\u6709\u7740\u66f4\u591a\u7684\u5185\u5b58\u8d44\u6e90\u3002<\/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', '202405_plus_tokyo','202409_plus_tokyo','202405_hongkong','202409_tokyo'],\n['4',3078,1735,1428,723],\n['8',5733,3259,2551,1341],\n['16',9215,5952,4686,2502],\n['32',13463,9808,8042,4857],\n['48',15262,12578,10017,6745],\n['64',15637,14360,10837,8071],\n['96',16417,15540,11622,9675],\n['128',16576,16025,12112,10620],\n['192',17185,16938,12027,11507],\n['256',18064,17556,12403,11872],\n['384',19342,18471,12361,12131],\n['512',19361,18964,12379,12106],\n ]);\n        var options = {\n          title: 'GCP Cloud SQL MySQL Enterprise',\n          titleTextStyle: { color: '#4285f4', fontSize: 20, bold: true},\n          subtitle: '4vCPU16GB-100GB-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: '#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            3: {\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 },\n          width: 1000,\n          height: 480,\n        };\n        var chart = new google.visualization.LineChart(document.getElementById('chart_div_google'));\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_google');\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-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_google\" style=\"\"><\/div><table class=\"pure-table pure-table-bordered\" style=\"font-size:0.8em;width:100%\"><thead><tr><th>data<\/th><th>202405_plus_tokyo<\/th><th>202409_plus_tokyo<\/th><th>202405_hongkong<\/th><th>202409_tokyo<\/th><\/tr><\/thead><tbody><tr><td>4<\/td><td>3078<\/td><td>1735<\/td><td>1428<\/td><td>723<\/td><tr><td>8<\/td><td>5733<\/td><td>3259<\/td><td>2551<\/td><td>1341<\/td><tr><td>16<\/td><td>9215<\/td><td>5952<\/td><td>4686<\/td><td>2502<\/td><tr><td>32<\/td><td>13463<\/td><td>9808<\/td><td>8042<\/td><td>4857<\/td><tr><td>48<\/td><td>15262<\/td><td>12578<\/td><td>10017<\/td><td>6745<\/td><tr><td>64<\/td><td>15637<\/td><td>14360<\/td><td>10837<\/td><td>8071<\/td><tr><td>96<\/td><td>16417<\/td><td>15540<\/td><td>11622<\/td><td>9675<\/td><tr><td>128<\/td><td>16576<\/td><td>16025<\/td><td>12112<\/td><td>10620<\/td><tr><td>192<\/td><td>17185<\/td><td>16938<\/td><td>12027<\/td><td>11507<\/td><tr><td>256<\/td><td>18064<\/td><td>17556<\/td><td>12403<\/td><td>11872<\/td><tr><td>384<\/td><td>19342<\/td><td>18471<\/td><td>12361<\/td><td>12131<\/td><tr><td>512<\/td><td>19361<\/td><td>18964<\/td><td>12379<\/td><td>12106<\/td><tr><td>cpu_capacity<\/td><td>82.6<\/td><td>79<\/td><td>44.1<\/td><td>49.9<\/td><\/tr><\/tbody><\/table><\/div>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Oracle Cloud\u4e0a\u7684HeatWave MySQL<\/h4>\n\n\n\n<p>MySQL\u662f\u5c5e\u4e8eOracle\u7684\uff0cOracle\u4e5f\u4e00\u76f4\u5728\u6301\u7eed\u7684\u6295\u5165\u53d1\u5c55MySQL\u6570\u636e\u5e93\u4e0e\u793e\u533a\u7684\u5efa\u8bbe\u3002Oracle Cloud\u662f\u6700\u65e9\u63a8\u51faMySQL 8.4\u3001MySQL 9.0\u7684\u4e91\u5382\u5546\uff0c\u8fd9\u6b21\u4e5f\u4e00\u5e76\u6d4b\u8bd5\u8fd9\u4e24\u4e2a\u6700\u65b0\u7248\u672c\u5728Oracle Cloud\u4e0a\u7684\u8868\u73b0\u3002<\/p>\n\n\n\n<p>\u53ef\u4ee5\u770b\u5230\uff0c\u6574\u4e2a\u4e0a\u5404\u4e2a\u7248\u672c\u5728\u8be5\u6d4b\u8bd5\u6a21\u578b\u4e0b\u8868\u73b0\u8f83\u4e3a\u4e00\u81f4\u3002\u4ec5\uff0c8.4.0\uff08\u4e5f\u5c31\u662f8.4\u7684\u7b2c\u4e00\u4e2a\u7248\u672c\uff09\u5728\u8d85\u9ad8\u5e76\u53d1\u4e0b\uff0c\u6027\u80fd\u6709\u660e\u663e\u9000\u5316\uff0c\u800c\u8be5\u95ee\u9898\u4e5f\u5728\u6700\u65b0\u76848.4.2\u4fee\u590d\u4e86\u3002<\/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', 'oci_202409_8039','oci_202409_8402','oci_202404_80','oci_202409_9001','oci_202405_8400'],\n['4',3551,3606,3773,3360,3055],\n['8',5936,5378,5557,5256,4788],\n['16',8054,8186,8403,7287,6949],\n['32',8317,8029,8166,7817,7546],\n['48',8130,8204,8009,7911,6688],\n['64',7838,7981,7901,8060,7395],\n['96',8504,8430,8092,8172,7556],\n['128',8198,8286,8089,8000,7850],\n['192',8043,8053,7865,8112,1183],\n['256',7907,8034,7851,7536,1156],\n['384',8209,8055,7804,8151,1459],\n['512',8386,8030,7958,7872,1813],\n ]);\n        var options = {\n          title: 'Oracle Cloud HeatWave MySQL',\n          titleTextStyle: { color: '#4285f4', fontSize: 20, bold: true},\n          subtitle: '4vCPU16GB-100GB-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: '#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            3: {\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            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 },\n          width: 1000,\n          height: 480,\n        };\n        var chart = new google.visualization.LineChart(document.getElementById('chart_div_oci'));\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_oci');\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-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_oci\" style=\"\"><\/div><table class=\"pure-table pure-table-bordered\" style=\"font-size:0.8em;width:100%\"><thead><tr><th>data<\/th><th>oci_202409_8039<\/th><th>oci_202409_8402<\/th><th>oci_202404_80<\/th><th>oci_202409_9001<\/th><th>oci_202405_8400<\/th><\/tr><\/thead><tbody><tr><td>4<\/td><td>3551<\/td><td>3606<\/td><td>3773<\/td><td>3360<\/td><td>3055<\/td><tr><td>8<\/td><td>5936<\/td><td>5378<\/td><td>5557<\/td><td>5256<\/td><td>4788<\/td><tr><td>16<\/td><td>8054<\/td><td>8186<\/td><td>8403<\/td><td>7287<\/td><td>6949<\/td><tr><td>32<\/td><td>8317<\/td><td>8029<\/td><td>8166<\/td><td>7817<\/td><td>7546<\/td><tr><td>48<\/td><td>8130<\/td><td>8204<\/td><td>8009<\/td><td>7911<\/td><td>6688<\/td><tr><td>64<\/td><td>7838<\/td><td>7981<\/td><td>7901<\/td><td>8060<\/td><td>7395<\/td><tr><td>96<\/td><td>8504<\/td><td>8430<\/td><td>8092<\/td><td>8172<\/td><td>7556<\/td><tr><td>128<\/td><td>8198<\/td><td>8286<\/td><td>8089<\/td><td>8000<\/td><td>7850<\/td><tr><td>192<\/td><td>8043<\/td><td>8053<\/td><td>7865<\/td><td>8112<\/td><td>1183<\/td><tr><td>256<\/td><td>7907<\/td><td>8034<\/td><td>7851<\/td><td>7536<\/td><td>1156<\/td><tr><td>384<\/td><td>8209<\/td><td>8055<\/td><td>7804<\/td><td>8151<\/td><td>1459<\/td><tr><td>512<\/td><td>8386<\/td><td>8030<\/td><td>7958<\/td><td>7872<\/td><td>1813<\/td><tr><td>cpu_capacity<\/td><td>114.7<\/td><td>111.3<\/td><td>103.3<\/td><td>93.7<\/td><td>31.1<\/td><\/tr><\/tbody><\/table><\/div>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">\u6700\u540e<\/h4>\n\n\n\n<p>\u8fd9\u4e2a\u6d4b\u8bd5\u53ef\u4ee5\u5f88\u597d\u7684\u5e2e\u52a9\u5f00\u53d1\u8005\u7406\u89e3\u4e0d\u540c\u7684\u4e91\u5382\u5546\u4e4b\u95f4RDS MySQL\u6027\u80fd\u662f\u5b58\u5728\u5dee\u5f02\u7684\uff0c\u751a\u81f3\u5728\u540c\u4e00\u4e2a\u4e91\u5382\u5546\u7684\u4e0d\u540c\u533a\u57df\uff0c\u751a\u81f3\u5728\u540c\u4e00\u4e2a\u4e91\u5382\u5546\u7684\u540c\u4e00\u533a\u57df\u4e0d\u540c\u65f6\u95f4\u5efa\u7acb\u7684\u5b9e\u4f8b\uff0c\u5176\u6027\u80fd\u90fd\u53ef\u80fd\u4f1a\u6709\u4e00\u5b9a\u7684\u5dee\u5f02\u3002\u7406\u89e3\u4e86\u8fd9\u4e9b\uff0c\u4ece\u800c\u53ef\u4ee5\u5e2e\u52a9\u5f00\u53d1\u8005\u8fdb\u884c\u8fc1\u79fb\u6216\u53d8\u66f4\u65f6\uff0c\u66f4\u597d\u7684\u8fdb\u884c\u6570\u636e\u5e93\u7684\u5bb9\u91cf\u89c4\u5212\u3002<\/p>\n\n\n\n<p><\/p>\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 \u6d4b\u8bd5\u7ed3\u679c\u6982\u8ff0 \u5728\u672c\u6b21\u6d4b\u8bd5\u4e2d\uff1a\u963f\u91cc\u4e91RDS MySQL\u6027\u80fd\u8868\u73b0\u6700\u597d\uff0c\u6781\u9650\u7684QPS\u8fbe\u5230\u4e864\u4e07\uff1b\u5176\u6b21\u662f\u817e\u8baf\u4e91\uff0c\u8fbe\u5230\u4e863.2\u4e07\uff1b\u7b2c\u4e8c\u68af\u961f\u662f\u534e\u4e3a\u4e91\u3001\u767e\u5ea6\u4e91\u548cAWS\uff0c\u6781\u9650\u7684QPS\u7ea62.2\u4e07\uff1b\u4e4b\u540e\u662fAzure\u3001Google\u4e91\uff0c\u6781\u9650QPS\u7ea61.2\u4e07\uff1b\u6700\u540e\u662fOracle\u4e91\uff0c\u6781\u9650QPS\u7ea68500\u3002\u8be6\u7ec6\u7684\u6570\u636e\u548c\u8d8b\u52bf\u56fe\uff0c\u53ef\u4ee5\u53c2\u8003\u4ee5\u4e0a\u7684\u56fe\u3001\u8868\uff0c\u8fd9\u91cc\u4e0d\u518d\u8be6\u8ff0\u3002<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"wp-custom-template-a-wider-template","format":"standard","meta":{"_eb_attr":"","inline_featured_image":false,"_tocer_settings":[],"footnotes":""},"categories":[138,6,125,4,1],"tags":[],"class_list":["post-14364","post","type-post","status-publish","format-standard","hentry","category-cloud-mysql-performance-benchmark","category-mysql","category-125","category-code-detail","category-simplelife"],"_links":{"self":[{"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/posts\/14364","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=14364"}],"version-history":[{"count":171,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/posts\/14364\/revisions"}],"predecessor-version":[{"id":17589,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/posts\/14364\/revisions\/17589"}],"wp:attachment":[{"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/media?parent=14364"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/categories?post=14364"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/tags?post=14364"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}