{"id":20697,"date":"2025-11-15T11:19:04","date_gmt":"2025-11-15T03:19:04","guid":{"rendered":"https:\/\/www.orczhou.com\/?p=20697"},"modified":"2025-12-02T09:13:26","modified_gmt":"2025-12-02T01:13:26","slug":"cloud-rds-mysql-performance-at-2025-11","status":"publish","type":"post","link":"https:\/\/www.orczhou.com\/index.php\/2025\/11\/cloud-rds-mysql-performance-at-2025-11\/","title":{"rendered":"\u4e91\u6570\u636e\u5e93RDS MySQL\u6027\u80fd\u6d4b\u8bd5\u4e0e\u5bf9\u6bd4@2025\u5e7411\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<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'},'aws','huawei','baidu','azure','oracle',{type:'string', role:'annotation'},'google'],\n['4',6413,6413,6581,6581,1705,2823,1972,1459,3675,3675,1752],\n['8',10496,10496,10542,10542,3383,5163,3844,2870,6578,6578,3058],\n['16',19062,19062,16609,16609,6670,9360,7066,5319,10456,10456,5398],\n['32',26871,26871,26390,26390,13032,16089,12289,9246,11707,11707,8626],\n['48',30822,30822,30422,30422,18889,21067,16274,11743,12221,12221,9817],\n['64',32500,32500,32888,32888,23324,24319,19153,13101,12921,12921,10872],\n['96',35771,35771,35463,35463,27979,25905,21635,14267,12841,12841,10899],\n['128',39228,39228,36192,36192,30681,24634,22208,14550,13542,13542,11006],\n['192',44717,44717,38391,38391,33402,25048,22735,14528,12785,12785,10874],\n['256',46125,46125,37543,37543,34080,25462,23009,14160,13680,13680,10888],\n['384',46413,46413,37513,37513,34071,25848,22600,14598,13860,13860,10865],\n['512',46814,46814,38590,38590,33612,26936,22652,14777,13452,13452,10928],\n ]);\n        var options = {\n          title: 'Benchmark for Cloud MySQL at 202511',\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: '#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            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: '#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            7: {\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 },\n          width: 1100,\n          height: 580,\n        };\n        var chart = new google.visualization.LineChart(document.getElementById('chart_div_202511'));\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_202511');\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_202511\" style=\"\"><\/div><\/div>\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>6581<\/td><td>1705<\/td><td>1459<\/td><td>1972<\/td><td>1752<\/td><td>2823<\/td><td>3675<\/td><td>6413<\/td><tr><td>8<\/td><td>10542<\/td><td>3383<\/td><td>2870<\/td><td>3844<\/td><td>3058<\/td><td>5163<\/td><td>6578<\/td><td>10496<\/td><tr><td>16<\/td><td>16609<\/td><td>6670<\/td><td>5319<\/td><td>7066<\/td><td>5398<\/td><td>9360<\/td><td>10456<\/td><td>19062<\/td><tr><td>32<\/td><td>26390<\/td><td>13032<\/td><td>9246<\/td><td>12289<\/td><td>8626<\/td><td>16089<\/td><td>11707<\/td><td>26871<\/td><tr><td>48<\/td><td>30422<\/td><td>18889<\/td><td>11743<\/td><td>16274<\/td><td>9817<\/td><td>21067<\/td><td>12221<\/td><td>30822<\/td><tr><td>64<\/td><td>32888<\/td><td>23324<\/td><td>13101<\/td><td>19153<\/td><td>10872<\/td><td>24319<\/td><td>12921<\/td><td>32500<\/td><tr><td>96<\/td><td>35463<\/td><td>27979<\/td><td>14267<\/td><td>21635<\/td><td>10899<\/td><td>25905<\/td><td>12841<\/td><td>35771<\/td><tr><td>128<\/td><td>36192<\/td><td>30681<\/td><td>14550<\/td><td>22208<\/td><td>11006<\/td><td>24634<\/td><td>13542<\/td><td>39228<\/td><tr><td>192<\/td><td>38391<\/td><td>33402<\/td><td>14528<\/td><td>22735<\/td><td>10874<\/td><td>25048<\/td><td>12785<\/td><td>44717<\/td><tr><td>256<\/td><td>37543<\/td><td>34080<\/td><td>14160<\/td><td>23009<\/td><td>10888<\/td><td>25462<\/td><td>13680<\/td><td>46125<\/td><tr><td>384<\/td><td>37513<\/td><td>34071<\/td><td>14598<\/td><td>22600<\/td><td>10865<\/td><td>25848<\/td><td>13860<\/td><td>46413<\/td><tr><td>512<\/td><td>38590<\/td><td>33612<\/td><td>14777<\/td><td>22652<\/td><td>10928<\/td><td>26936<\/td><td>13452<\/td><td>46814<\/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>10.94<\/td><td>42.23<\/td><td>49.34<\/td><td>36.51<\/td><td>41.09<\/td><td>25.51<\/td><td>19.60<\/td><td>11.23<\/td><tr><td>8<\/td><td>13.66<\/td><td>42.56<\/td><td>50.16<\/td><td>37.46<\/td><td>47.08<\/td><td>27.89<\/td><td>21.89<\/td><td>13.72<\/td><tr><td>16<\/td><td>17.34<\/td><td>43.17<\/td><td>54.13<\/td><td>40.75<\/td><td>53.35<\/td><td>30.77<\/td><td>27.54<\/td><td>15.11<\/td><tr><td>32<\/td><td>21.82<\/td><td>44.19<\/td><td>62.29<\/td><td>46.87<\/td><td>66.76<\/td><td>35.80<\/td><td>49.20<\/td><td>21.42<\/td><tr><td>48<\/td><td>28.40<\/td><td>45.73<\/td><td>73.56<\/td><td>53.09<\/td><td>87.98<\/td><td>41.01<\/td><td>70.70<\/td><td>28.03<\/td><tr><td>64<\/td><td>35.02<\/td><td>49.38<\/td><td>87.91<\/td><td>60.14<\/td><td>105.94<\/td><td>47.36<\/td><td>89.16<\/td><td>35.44<\/td><tr><td>96<\/td><td>48.72<\/td><td>61.75<\/td><td>121.09<\/td><td>79.86<\/td><td>158.51<\/td><td>66.69<\/td><td>134.54<\/td><td>48.30<\/td><tr><td>128<\/td><td>63.65<\/td><td>75.08<\/td><td>158.31<\/td><td>103.73<\/td><td>209.26<\/td><td>93.51<\/td><td>170.09<\/td><td>58.72<\/td><tr><td>192<\/td><td>90.01<\/td><td>103.44<\/td><td>237.81<\/td><td>151.97<\/td><td>317.68<\/td><td>137.94<\/td><td>270.22<\/td><td>77.27<\/td><tr><td>256<\/td><td>122.71<\/td><td>135.18<\/td><td>325.28<\/td><td>200.21<\/td><td>423.12<\/td><td>180.92<\/td><td>336.67<\/td><td>99.88<\/td><tr><td>384<\/td><td>184.18<\/td><td>202.80<\/td><td>473.18<\/td><td>305.70<\/td><td>635.50<\/td><td>267.27<\/td><td>498.30<\/td><td>148.89<\/td><tr><td>512<\/td><td>238.72<\/td><td>274.02<\/td><td>623.17<\/td><td>406.61<\/td><td>842.19<\/td><td>341.93<\/td><td>684.53<\/td><td>196.77<\/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>14.21<\/td><td>44.98<\/td><td>56.84<\/td><td>39.65<\/td><td>52.89<\/td><td>29.72<\/td><td>26.68<\/td><td>13.22<\/td><tr><td>8<\/td><td>17.01<\/td><td>44.17<\/td><td>56.84<\/td><td>41.85<\/td><td>69.29<\/td><td>32.53<\/td><td>32.53<\/td><td>16.41<\/td><tr><td>16<\/td><td>20.74<\/td><td>44.98<\/td><td>62.19<\/td><td>46.63<\/td><td>81.48<\/td><td>36.89<\/td><td>44.98<\/td><td>18.61<\/td><tr><td>32<\/td><td>31.37<\/td><td>48.34<\/td><td>71.83<\/td><td>57.87<\/td><td>116.80<\/td><td>43.39<\/td><td>89.16<\/td><td>27.66<\/td><tr><td>48<\/td><td>41.10<\/td><td>51.02<\/td><td>87.56<\/td><td>69.29<\/td><td>139.85<\/td><td>50.11<\/td><td>118.92<\/td><td>37.56<\/td><tr><td>64<\/td><td>52.89<\/td><td>58.92<\/td><td>108.68<\/td><td>81.48<\/td><td>161.51<\/td><td>57.87<\/td><td>153.02<\/td><td>49.21<\/td><tr><td>96<\/td><td>77.19<\/td><td>80.03<\/td><td>155.80<\/td><td>114.72<\/td><td>219.36<\/td><td>102.97<\/td><td>215.44<\/td><td>66.84<\/td><tr><td>128<\/td><td>97.55<\/td><td>94.10<\/td><td>200.47<\/td><td>150.29<\/td><td>282.25<\/td><td>123.28<\/td><td>248.83<\/td><td>82.96<\/td><tr><td>192<\/td><td>125.52<\/td><td>147.61<\/td><td>303.33<\/td><td>211.60<\/td><td>427.07<\/td><td>196.89<\/td><td>383.33<\/td><td>108.68<\/td><tr><td>256<\/td><td>164.45<\/td><td>207.82<\/td><td>419.45<\/td><td>277.21<\/td><td>559.50<\/td><td>282.25<\/td><td>458.96<\/td><td>139.85<\/td><tr><td>384<\/td><td>248.83<\/td><td>308.84<\/td><td>612.21<\/td><td>397.39<\/td><td>831.46<\/td><td>502.20<\/td><td>657.93<\/td><td>204.11<\/td><tr><td>512<\/td><td>320.17<\/td><td>404.61<\/td><td>787.74<\/td><td>520.62<\/td><td>1089.30<\/td><td>502.20<\/td><td>893.56<\/td><td>267.41<\/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>4<\/td><td>NA<\/td><td>16<\/td><td>4<\/td><tr><td>version<\/td><td>8.0.36<\/td><td>8.0.43<\/td><td>8.0.42-azure<\/td><td>8.0.32-4.0.0.5<\/td><td>8.0.41-google<\/td><td>8.0.41-250900<\/td><td>8.0.40-u8-cloud<\/td><td>8.0.30-txsql<\/td><tr><td>instance_type<\/td><td>mysql.x4.large.2c<\/td><td>db.m7i.xlarge<\/td><td>GP_Standard_D4ads_v5<\/td><td>4<\/td><td>db-custom-4-16384<\/td><td>rds.mysql.x1.xlarge.4.ha<\/td><td>MySQL.4<\/td><td>4c<\/td><tr><td>storage_type<\/td><td>cloud_essd<\/td><td>io1<\/td><td>NA<\/td><td>cloud_enha<\/td><td>NA<\/td><td>CLOUDSSD<\/td><td>NA<\/td><td>EXCLUSIVE<\/td><tr><td>storage_size<\/td><td>100<\/td><td>100<\/td><td>100<\/td><td>100<\/td><td>100<\/td><td>100<\/td><td>100<\/td><td>100<\/td><tr><td>storage_iops<\/td><td>NA<\/td><td>3000<\/td><td>3000<\/td><td>NA<\/td><td>NA<\/td><td>NA<\/td><td>NA<\/td><td>NA<\/td><tr><td>cpu_capacity<\/td><td>123.9<\/td><td>145.3<\/td><td>73.6<\/td><td>74.2<\/td><td>54.6<\/td><td>148.3<\/td><td>120.9<\/td><td>138.1<\/td><\/tr><\/tbody><\/table><\/div>\n<\/div>\n<\/div>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">\u8865\u5145\u6d4b\u8bd5<\/h4>\n\n\n\n<p>\u5728\u6700\u8fd1\u7684\u4e24\u6b21 MySQL \u6d4b\u8bd5\u4e2d\uff0c\u90fd\u8865\u5145\u8fdb\u884c\u4e86\u6570\u636e\u91cf\u66f4\u5927\u7684\u6d4b\u8bd5\u3002\u5728\u539f\u6d4b\u8bd5\u7684\u57fa\u7840\u4e0a\uff0c\u4fee\u6539\u4e86sysbench\u7684\u6570\u636e\u51c6\u5907\u53c2\u6570\uff0c\u8865\u5145\u6d4b\u8bd5\u53c2\u6570\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\">\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">    # cpu-io mixed benchmark\n    tables=16\n    run_time=300\n    table_size=5000000<\/code><\/pre>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">    # cpu intensive benchmark\n    tables=10\n    run_time=300\n    table_size=1000000<\/code><\/pre>\n<\/div>\n<\/div>\n\n\n\n<p>\u6839\u636e\u4e4b\u524d\u7684\u8ba1\u7b97\uff0c\u5728\u8be5\u201ccpu-io mixed benchmark\u201d\u4e0b\uff0c\u6570\u636e\u603b\u91cf\u7ea6<code>18.4 GB<\/code>\uff0c\u5373\uff0c\u8be5\u538b\u529b\u6d4b\u8bd5\u5219\u4f1a\u6210\u4e3a\u4e00\u4e2a\u8bfbIO\u5bc6\u96c6\u578b\u7684\u6d4b\u8bd5\u3002\u5404\u4e2a\u4e91\u5382\u5546\u5728\u8be5\u6a21\u578b\u4e0b\u7684\u6027\u80fd\u8868\u73b0\u5982\u4e0b\u56fe\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', 'tencent',{type:'string', role:'annotation'},'baidu','google','oracle',{type:'string', role:'annotation'},'aliyun',{type:'string', role:'annotation'},'huawei','aws','azure'],\n['4',6034,6034,1800,1482,758,758,3895,3895,1686,2814,1156],\n['8',10777,10777,3288,2635,3410,3410,4528,4528,3147,3671,2172],\n['16',18142,18142,5722,4195,7046,7046,5366,5366,5819,3637,2768],\n['32',26922,26922,8380,5982,7471,7471,6178,6178,10161,3704,2829],\n['48',31615,31615,8789,6877,7642,7642,6508,6508,13682,3737,2830],\n['64',33636,33636,8982,7520,8069,8069,6719,6719,15359,3727,2868],\n['96',36293,36293,9204,7862,8292,8292,6901,6901,15811,3726,2893],\n['128',39359,39359,9324,8465,8388,8388,7030,7030,16050,3896,2885],\n['192',41586,41586,9675,8761,8577,8577,7127,7127,16210,4031,2916],\n['256',41557,41557,9545,8698,8648,8648,7154,7154,16279,4060,2918],\n['384',41212,41212,10147,8923,8677,8677,7212,7212,16280,4199,2927],\n['512',40997,40997,10602,9099,8797,8797,7243,7243,5400,4406,2936],\n ]);\n        var options = {\n          title: 'Benchmark for Cloud MySQL at 202511 (cpu-io mixed)',\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: '#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            2: {\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            3: {\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            4: {\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            5: {\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            6: {\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            7: {\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 },\n          width: 1100,\n          height: 580,\n        };\n        var chart = new google.visualization.LineChart(document.getElementById('chart_div_202511_cpu_io_mix'));\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_202511_cpu_io_mix');\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_202511_cpu_io_mix\" style=\"\"><\/div><\/div>\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>3895<\/td><td>2814<\/td><td>1156<\/td><td>1800<\/td><td>1482<\/td><td>1686<\/td><td>758<\/td><td>6034<\/td><tr><td>8<\/td><td>4528<\/td><td>3671<\/td><td>2172<\/td><td>3288<\/td><td>2635<\/td><td>3147<\/td><td>3410<\/td><td>10777<\/td><tr><td>16<\/td><td>5366<\/td><td>3637<\/td><td>2768<\/td><td>5722<\/td><td>4195<\/td><td>5819<\/td><td>7046<\/td><td>18142<\/td><tr><td>32<\/td><td>6178<\/td><td>3704<\/td><td>2829<\/td><td>8380<\/td><td>5982<\/td><td>10161<\/td><td>7471<\/td><td>26922<\/td><tr><td>48<\/td><td>6508<\/td><td>3737<\/td><td>2830<\/td><td>8789<\/td><td>6877<\/td><td>13682<\/td><td>7642<\/td><td>31615<\/td><tr><td>64<\/td><td>6719<\/td><td>3727<\/td><td>2868<\/td><td>8982<\/td><td>7520<\/td><td>15359<\/td><td>8069<\/td><td>33636<\/td><tr><td>96<\/td><td>6901<\/td><td>3726<\/td><td>2893<\/td><td>9204<\/td><td>7862<\/td><td>15811<\/td><td>8292<\/td><td>36293<\/td><tr><td>128<\/td><td>7030<\/td><td>3896<\/td><td>2885<\/td><td>9324<\/td><td>8465<\/td><td>16050<\/td><td>8388<\/td><td>39359<\/td><tr><td>192<\/td><td>7127<\/td><td>4031<\/td><td>2916<\/td><td>9675<\/td><td>8761<\/td><td>16210<\/td><td>8577<\/td><td>41586<\/td><tr><td>256<\/td><td>7154<\/td><td>4060<\/td><td>2918<\/td><td>9545<\/td><td>8698<\/td><td>16279<\/td><td>8648<\/td><td>41557<\/td><tr><td>384<\/td><td>7212<\/td><td>4199<\/td><td>2927<\/td><td>10147<\/td><td>8923<\/td><td>16280<\/td><td>8677<\/td><td>41212<\/td><tr><td>512<\/td><td>7243<\/td><td>4406<\/td><td>2936<\/td><td>10602<\/td><td>9099<\/td><td>5400<\/td><td>8797<\/td><td>40997<\/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>18.49<\/td><td>25.58<\/td><td>62.29<\/td><td>40.00<\/td><td>48.59<\/td><td>42.70<\/td><td>95.21<\/td><td>11.93<\/td><tr><td>8<\/td><td>31.80<\/td><td>39.22<\/td><td>66.28<\/td><td>43.79<\/td><td>54.65<\/td><td>45.76<\/td><td>42.31<\/td><td>13.36<\/td><tr><td>16<\/td><td>53.66<\/td><td>79.18<\/td><td>104.03<\/td><td>50.32<\/td><td>68.66<\/td><td>49.48<\/td><td>40.87<\/td><td>15.87<\/td><tr><td>32<\/td><td>93.22<\/td><td>155.48<\/td><td>203.59<\/td><td>68.73<\/td><td>96.28<\/td><td>56.68<\/td><td>77.04<\/td><td>21.39<\/td><tr><td>48<\/td><td>132.74<\/td><td>231.10<\/td><td>305.26<\/td><td>98.29<\/td><td>125.61<\/td><td>63.14<\/td><td>113.05<\/td><td>27.33<\/td><tr><td>64<\/td><td>171.41<\/td><td>309.04<\/td><td>401.59<\/td><td>128.24<\/td><td>153.15<\/td><td>75.00<\/td><td>142.72<\/td><td>34.24<\/td><tr><td>96<\/td><td>250.32<\/td><td>463.37<\/td><td>597.12<\/td><td>187.66<\/td><td>219.72<\/td><td>109.28<\/td><td>208.34<\/td><td>47.61<\/td><tr><td>128<\/td><td>327.59<\/td><td>590.76<\/td><td>798.08<\/td><td>247.10<\/td><td>272.08<\/td><td>143.51<\/td><td>274.66<\/td><td>58.53<\/td><tr><td>192<\/td><td>484.68<\/td><td>856.01<\/td><td>1184.42<\/td><td>356.97<\/td><td>394.31<\/td><td>213.12<\/td><td>402.78<\/td><td>83.09<\/td><tr><td>256<\/td><td>643.52<\/td><td>1132.87<\/td><td>1577.49<\/td><td>482.24<\/td><td>529.42<\/td><td>282.89<\/td><td>532.57<\/td><td>110.86<\/td><tr><td>384<\/td><td>957.26<\/td><td>1644.81<\/td><td>2357.54<\/td><td>680.65<\/td><td>773.74<\/td><td>424.27<\/td><td>795.02<\/td><td>167.66<\/td><tr><td>512<\/td><td>1270.07<\/td><td>2089.47<\/td><td>3132.14<\/td><td>867.32<\/td><td>1011.22<\/td><td>1706.29<\/td><td>1045.78<\/td><td>224.69<\/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>20.74<\/td><td>29.19<\/td><td>86.00<\/td><td>58.92<\/td><td>71.83<\/td><td>57.87<\/td><td>802.05<\/td><td>15.00<\/td><tr><td>8<\/td><td>34.95<\/td><td>132.49<\/td><td>87.56<\/td><td>73.13<\/td><td>95.81<\/td><td>62.19<\/td><td>49.21<\/td><td>17.32<\/td><tr><td>16<\/td><td>153.02<\/td><td>223.34<\/td><td>150.29<\/td><td>97.55<\/td><td>161.51<\/td><td>70.55<\/td><td>95.81<\/td><td>21.11<\/td><tr><td>32<\/td><td>297.92<\/td><td>314.45<\/td><td>277.21<\/td><td>139.85<\/td><td>253.35<\/td><td>86.00<\/td><td>277.21<\/td><td>28.67<\/td><tr><td>48<\/td><td>350.33<\/td><td>390.30<\/td><td>434.83<\/td><td>193.38<\/td><td>303.33<\/td><td>94.10<\/td><td>450.77<\/td><td>36.89<\/td><tr><td>64<\/td><td>390.30<\/td><td>467.30<\/td><td>569.67<\/td><td>235.74<\/td><td>314.45<\/td><td>123.28<\/td><td>511.33<\/td><td>45.79<\/td><tr><td>96<\/td><td>475.79<\/td><td>612.21<\/td><td>877.61<\/td><td>325.98<\/td><td>356.70<\/td><td>277.21<\/td><td>569.67<\/td><td>63.32<\/td><tr><td>128<\/td><td>539.71<\/td><td>759.88<\/td><td>1191.92<\/td><td>411.96<\/td><td>397.39<\/td><td>356.70<\/td><td>634.66<\/td><td>78.60<\/td><tr><td>192<\/td><td>694.45<\/td><td>1352.03<\/td><td>1771.29<\/td><td>569.67<\/td><td>539.71<\/td><td>467.30<\/td><td>719.92<\/td><td>108.68<\/td><tr><td>256<\/td><td>846.57<\/td><td>1973.38<\/td><td>2405.65<\/td><td>787.74<\/td><td>707.07<\/td><td>549.52<\/td><td>816.63<\/td><td>144.97<\/td><tr><td>384<\/td><td>1191.92<\/td><td>3095.38<\/td><td>3574.99<\/td><td>1050.76<\/td><td>1013.60<\/td><td>657.93<\/td><td>1013.60<\/td><td>219.36<\/td><tr><td>512<\/td><td>1589.90<\/td><td>4055.23<\/td><td>4768.67<\/td><td>1327.91<\/td><td>1304.21<\/td><td>2082.91<\/td><td>1376.60<\/td><td>292.60<\/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>4<\/td><td>NA<\/td><td>16<\/td><td>4<\/td><tr><td>version<\/td><td>8.0.36<\/td><td>8.0.43<\/td><td>8.0.42-azure<\/td><td>8.0.32-4.0.0.5<\/td><td>8.0.41-google<\/td><td>8.0.41-250900<\/td><td>8.0.40-u8-cloud<\/td><td>8.0.30-txsql<\/td><tr><td>instance_type<\/td><td>mysql.x4.large.2c<\/td><td>db.m7i.xlarge<\/td><td>GP_Standard_D4ads_v5<\/td><td>4<\/td><td>db-custom-4-16384<\/td><td>rds.mysql.x1.xlarge.4.ha<\/td><td>MySQL.4<\/td><td>4c<\/td><tr><td>storage_type<\/td><td>cloud_essd<\/td><td>io1<\/td><td>NA<\/td><td>cloud_enha<\/td><td>NA<\/td><td>CLOUDSSD<\/td><td>NA<\/td><td>EXCLUSIVE<\/td><tr><td>storage_size<\/td><td>100<\/td><td>100<\/td><td>100<\/td><td>100<\/td><td>100<\/td><td>100<\/td><td>100<\/td><td>100<\/td><tr><td>storage_iops<\/td><td>NA<\/td><td>3000<\/td><td>3000<\/td><td>NA<\/td><td>NA<\/td><td>NA<\/td><td>NA<\/td><td>NA<\/td><tr><td>cpu_capacity<\/td><td>130.9<\/td><td>125.4<\/td><td>74.9<\/td><td>72.8<\/td><td>55.9<\/td><td>147<\/td><td>121.3<\/td><td>139.3<\/td><\/tr><\/tbody><\/table><\/div>\n<\/div>\n<\/div>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 \u8865\u5145\u6d4b\u8bd5 \u5728\u6700\u8fd1\u7684\u4e24\u6b21 MySQL \u6d4b\u8bd5\u4e2d\uff0c\u90fd\u8865\u5145\u8fdb\u884c\u4e86\u6570\u636e\u91cf\u66f4\u5927\u7684\u6d4b\u8bd5\u3002\u5728\u539f\u6d4b\u8bd5\u7684\u57fa\u7840\u4e0a\uff0c\u4fee\u6539\u4e86sysbench\u7684\u6570\u636e\u51c6\u5907\u53c2\u6570\uff0c\u8865\u5145\u6d4b\u8bd5\u53c2\u6570\uff1a \u6839\u636e\u4e4b\u524d\u7684\u8ba1\u7b97\uff0c\u5728\u8be5\u201ccpu-io mixed benchmark\u201d\u4e0b\uff0c\u6570\u636e\u603b\u91cf\u7ea618.4 GB\uff0c\u5373\uff0c\u8be5\u538b\u529b\u6d4b\u8bd5\u5219\u4f1a\u6210\u4e3a\u4e00\u4e2a\u8bfbIO\u5bc6\u96c6\u578b\u7684\u6d4b\u8bd5\u3002\u5404\u4e2a\u4e91\u5382\u5546\u5728\u8be5\u6a21\u578b\u4e0b\u7684\u6027\u80fd\u8868\u73b0\u5982\u4e0b\u56fe\uff1a 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<\/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-20697","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\/20697","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=20697"}],"version-history":[{"count":2,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/posts\/20697\/revisions"}],"predecessor-version":[{"id":20700,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/posts\/20697\/revisions\/20700"}],"wp:attachment":[{"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/media?parent=20697"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/categories?post=20697"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/tags?post=20697"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}