{"id":19088,"date":"2025-08-03T18:41:00","date_gmt":"2025-08-03T10:41:00","guid":{"rendered":"https:\/\/www.orczhou.com\/?p=19088"},"modified":"2025-10-26T18:42:57","modified_gmt":"2025-10-26T10:42:57","slug":"cloud-database-rds-mysql-performance-benchmark","status":"publish","type":"post","link":"https:\/\/www.orczhou.com\/index.php\/2025\/08\/cloud-database-rds-mysql-performance-benchmark\/","title":{"rendered":"\u4e91\u6570\u636e\u5e93RDS MySQL\u6027\u80fd\u6d4b\u8bd5\u4e0e\u5bf9\u6bd4@2025\u5e7407\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'},'aws','aliyun',{type:'string', role:'annotation'},'baidu','huawei','azure','oracle',{type:'string', role:'annotation'},'google'],\n['4',6439,6439,3365,6934,6934,2164,2351,1615,3701,3701,1449],\n['8',11999,11999,6685,9842,9842,4079,4284,3018,6387,6387,2832],\n['16',19864,19864,13028,15597,15597,7360,7626,5511,10120,10120,4767],\n['32',29928,29928,22766,23331,23331,12633,13282,9761,11355,11355,7333],\n['48',32940,32940,26362,26740,26740,16442,17030,12245,11601,11601,9780],\n['64',34154,34154,28181,29284,29284,19505,19441,13261,12557,12557,11144],\n['96',33711,33711,30829,31033,31033,22066,19805,14418,12282,12282,11166],\n['128',32735,32735,32467,31450,31450,22912,19826,15066,13030,13030,11191],\n['192',35476,35476,32558,32287,32287,23386,20453,15314,12677,12677,11244],\n['256',36917,36917,31954,31571,31571,23291,21489,15470,12910,12910,10963],\n['384',37473,37473,32047,31419,31419,23045,22894,15892,13242,13242,11212],\n['512',37992,37992,32221,31382,31382,22987,22750,15978,12643,12643,11399],\n ]);\n        var options = {\n          title: 'Benchmark for Cloud MySQL at 202507',\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: '#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            2: {\n                                  color: '#ff6a00',\n                 pointShape:'star',\n                 pointSize: 7,\n                 annotations: {\n                   textStyle: {\n                     fontSize: 10,\n                     color: '#ff6a00',\n                     opacity: 0.8\n                   }\n                 },\n               },\n            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: '#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            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_202507'));\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_202507');\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_202507\" 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>6934<\/td><td>3365<\/td><td>1615<\/td><td>2164<\/td><td>1449<\/td><td>2351<\/td><td>3701<\/td><td>6439<\/td><tr><td>8<\/td><td>9842<\/td><td>6685<\/td><td>3018<\/td><td>4079<\/td><td>2832<\/td><td>4284<\/td><td>6387<\/td><td>11999<\/td><tr><td>16<\/td><td>15597<\/td><td>13028<\/td><td>5511<\/td><td>7360<\/td><td>4767<\/td><td>7626<\/td><td>10120<\/td><td>19864<\/td><tr><td>32<\/td><td>23331<\/td><td>22766<\/td><td>9761<\/td><td>12633<\/td><td>7333<\/td><td>13282<\/td><td>11355<\/td><td>29928<\/td><tr><td>48<\/td><td>26740<\/td><td>26362<\/td><td>12245<\/td><td>16442<\/td><td>9780<\/td><td>17030<\/td><td>11601<\/td><td>32940<\/td><tr><td>64<\/td><td>29284<\/td><td>28181<\/td><td>13261<\/td><td>19505<\/td><td>11144<\/td><td>19441<\/td><td>12557<\/td><td>34154<\/td><tr><td>96<\/td><td>31033<\/td><td>30829<\/td><td>14418<\/td><td>22066<\/td><td>11166<\/td><td>19805<\/td><td>12282<\/td><td>33711<\/td><tr><td>128<\/td><td>31450<\/td><td>32467<\/td><td>15066<\/td><td>22912<\/td><td>11191<\/td><td>19826<\/td><td>13030<\/td><td>32735<\/td><tr><td>192<\/td><td>32287<\/td><td>32558<\/td><td>15314<\/td><td>23386<\/td><td>11244<\/td><td>20453<\/td><td>12677<\/td><td>35476<\/td><tr><td>256<\/td><td>31571<\/td><td>31954<\/td><td>15470<\/td><td>23291<\/td><td>10963<\/td><td>21489<\/td><td>12910<\/td><td>36917<\/td><tr><td>384<\/td><td>31419<\/td><td>32047<\/td><td>15892<\/td><td>23045<\/td><td>11212<\/td><td>22894<\/td><td>13242<\/td><td>37473<\/td><tr><td>512<\/td><td>31382<\/td><td>32221<\/td><td>15978<\/td><td>22987<\/td><td>11399<\/td><td>22750<\/td><td>12643<\/td><td>37992<\/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.38<\/td><td>21.39<\/td><td>44.56<\/td><td>33.26<\/td><td>49.68<\/td><td>30.62<\/td><td>19.49<\/td><td>11.18<\/td><tr><td>8<\/td><td>14.63<\/td><td>21.54<\/td><td>47.71<\/td><td>35.30<\/td><td>50.83<\/td><td>33.61<\/td><td>22.54<\/td><td>12.00<\/td><tr><td>16<\/td><td>18.46<\/td><td>22.10<\/td><td>52.25<\/td><td>39.13<\/td><td>60.41<\/td><td>37.76<\/td><td>28.46<\/td><td>14.50<\/td><tr><td>32<\/td><td>24.69<\/td><td>25.30<\/td><td>59.00<\/td><td>45.59<\/td><td>78.53<\/td><td>43.36<\/td><td>50.72<\/td><td>19.24<\/td><tr><td>48<\/td><td>32.31<\/td><td>32.77<\/td><td>70.55<\/td><td>52.54<\/td><td>88.32<\/td><td>50.73<\/td><td>74.46<\/td><td>26.23<\/td><tr><td>64<\/td><td>39.34<\/td><td>40.87<\/td><td>86.86<\/td><td>59.05<\/td><td>103.34<\/td><td>59.25<\/td><td>91.73<\/td><td>33.73<\/td><tr><td>96<\/td><td>55.68<\/td><td>56.04<\/td><td>119.82<\/td><td>78.30<\/td><td>154.70<\/td><td>87.24<\/td><td>140.65<\/td><td>51.24<\/td><tr><td>128<\/td><td>73.25<\/td><td>70.95<\/td><td>152.89<\/td><td>100.54<\/td><td>205.82<\/td><td>116.19<\/td><td>176.76<\/td><td>70.37<\/td><tr><td>192<\/td><td>107.02<\/td><td>106.13<\/td><td>225.58<\/td><td>147.74<\/td><td>307.27<\/td><td>168.93<\/td><td>272.55<\/td><td>97.40<\/td><tr><td>256<\/td><td>145.92<\/td><td>144.17<\/td><td>297.73<\/td><td>197.78<\/td><td>420.05<\/td><td>214.36<\/td><td>356.72<\/td><td>124.79<\/td><tr><td>384<\/td><td>219.91<\/td><td>215.58<\/td><td>434.67<\/td><td>299.81<\/td><td>615.95<\/td><td>301.73<\/td><td>521.43<\/td><td>184.41<\/td><tr><td>512<\/td><td>293.55<\/td><td>285.85<\/td><td>576.35<\/td><td>400.66<\/td><td>807.65<\/td><td>404.86<\/td><td>727.98<\/td><td>242.43<\/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>12.30<\/td><td>22.28<\/td><td>51.94<\/td><td>42.61<\/td><td>75.82<\/td><td>37.56<\/td><td>28.67<\/td><td>12.75<\/td><tr><td>8<\/td><td>19.29<\/td><td>22.28<\/td><td>56.84<\/td><td>45.79<\/td><td>82.96<\/td><td>40.37<\/td><td>36.24<\/td><td>13.46<\/td><tr><td>16<\/td><td>24.83<\/td><td>24.83<\/td><td>63.32<\/td><td>51.02<\/td><td>104.84<\/td><td>45.79<\/td><td>48.34<\/td><td>16.71<\/td><tr><td>32<\/td><td>35.59<\/td><td>31.94<\/td><td>71.83<\/td><td>62.19<\/td><td>132.49<\/td><td>52.89<\/td><td>94.10<\/td><td>23.95<\/td><tr><td>48<\/td><td>48.34<\/td><td>44.17<\/td><td>89.16<\/td><td>73.13<\/td><td>144.97<\/td><td>62.19<\/td><td>130.13<\/td><td>33.72<\/td><tr><td>64<\/td><td>61.08<\/td><td>53.85<\/td><td>116.80<\/td><td>86.00<\/td><td>161.51<\/td><td>74.46<\/td><td>155.80<\/td><td>44.17<\/td><tr><td>96<\/td><td>84.47<\/td><td>74.46<\/td><td>173.58<\/td><td>116.80<\/td><td>215.44<\/td><td>134.90<\/td><td>235.74<\/td><td>82.96<\/td><tr><td>128<\/td><td>106.75<\/td><td>108.68<\/td><td>235.74<\/td><td>147.61<\/td><td>277.21<\/td><td>155.80<\/td><td>267.41<\/td><td>153.02<\/td><tr><td>192<\/td><td>144.97<\/td><td>164.45<\/td><td>369.77<\/td><td>207.82<\/td><td>411.96<\/td><td>253.35<\/td><td>404.61<\/td><td>173.58<\/td><tr><td>256<\/td><td>189.93<\/td><td>219.36<\/td><td>511.33<\/td><td>267.41<\/td><td>569.67<\/td><td>356.70<\/td><td>502.20<\/td><td>186.54<\/td><tr><td>384<\/td><td>292.60<\/td><td>314.45<\/td><td>787.74<\/td><td>390.30<\/td><td>802.05<\/td><td>511.33<\/td><td>694.45<\/td><td>257.95<\/td><tr><td>512<\/td><td>390.30<\/td><td>411.96<\/td><td>1050.76<\/td><td>511.33<\/td><td>1050.76<\/td><td>569.67<\/td><td>960.30<\/td><td>331.91<\/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.41<\/td><td>8.0.41-azure<\/td><td>8.0.32-4.0.0.5<\/td><td>8.0.41-google<\/td><td>8.0.28-231003<\/td><td>8.0.40-u6-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>97<\/td><td>146.6<\/td><td>73.6<\/td><td>74.5<\/td><td>53.8<\/td><td>154.8<\/td><td>118.8<\/td><td>107.3<\/td><\/tr><\/tbody><\/table><\/div>\n<\/div>\n<\/div>\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','oracle',{type:'string', role:'annotation'},'google','aliyun',{type:'string', role:'annotation'},'huawei','aws','azure'],\n['4',5689,5689,1800,754,754,1449,4027,4027,2004,1499,946],\n['8',10257,10257,3288,3570,3570,2702,4717,4717,3749,2980,1798],\n['16',17248,17248,5722,7127,7127,4275,5642,5642,6848,3588,2810],\n['32',24535,24535,8380,7482,7482,5729,6464,6464,12139,3689,2987],\n['48',26788,26788,8789,7716,7716,6651,6854,6854,14857,3733,3007],\n['64',27617,27617,8982,8067,8067,6990,7052,7052,15630,3724,3065],\n['96',26969,26969,9204,8293,8293,7259,7292,7292,15960,3722,3076],\n['128',26215,26215,9324,8380,8380,7598,7421,7421,16162,3861,3065],\n['192',27930,27930,9675,8528,8528,7474,7556,7556,16291,4030,3090],\n['256',28165,28165,9545,8676,8676,7603,7588,7588,16336,4017,3080],\n['384',28725,28725,10147,8723,8723,7641,7635,7635,10285,4159,3100],\n['512',28922,28922,10602,8809,8809,7802,7693,7693,5391,4363,3113],\n ]);\n        var options = {\n          title: 'Benchmark for Cloud MySQL at 202507 (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: '#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            3: {\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            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_202507_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_202507_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_202507_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>4027<\/td><td>1499<\/td><td>946<\/td><td>1800<\/td><td>1449<\/td><td>2004<\/td><td>754<\/td><td>5689<\/td><tr><td>8<\/td><td>4717<\/td><td>2980<\/td><td>1798<\/td><td>3288<\/td><td>2702<\/td><td>3749<\/td><td>3570<\/td><td>10257<\/td><tr><td>16<\/td><td>5642<\/td><td>3588<\/td><td>2810<\/td><td>5722<\/td><td>4275<\/td><td>6848<\/td><td>7127<\/td><td>17248<\/td><tr><td>32<\/td><td>6464<\/td><td>3689<\/td><td>2987<\/td><td>8380<\/td><td>5729<\/td><td>12139<\/td><td>7482<\/td><td>24535<\/td><tr><td>48<\/td><td>6854<\/td><td>3733<\/td><td>3007<\/td><td>8789<\/td><td>6651<\/td><td>14857<\/td><td>7716<\/td><td>26788<\/td><tr><td>64<\/td><td>7052<\/td><td>3724<\/td><td>3065<\/td><td>8982<\/td><td>6990<\/td><td>15630<\/td><td>8067<\/td><td>27617<\/td><tr><td>96<\/td><td>7292<\/td><td>3722<\/td><td>3076<\/td><td>9204<\/td><td>7259<\/td><td>15960<\/td><td>8293<\/td><td>26969<\/td><tr><td>128<\/td><td>7421<\/td><td>3861<\/td><td>3065<\/td><td>9324<\/td><td>7598<\/td><td>16162<\/td><td>8380<\/td><td>26215<\/td><tr><td>192<\/td><td>7556<\/td><td>4030<\/td><td>3090<\/td><td>9675<\/td><td>7474<\/td><td>16291<\/td><td>8528<\/td><td>27930<\/td><tr><td>256<\/td><td>7588<\/td><td>4017<\/td><td>3080<\/td><td>9545<\/td><td>7603<\/td><td>16336<\/td><td>8676<\/td><td>28165<\/td><tr><td>384<\/td><td>7635<\/td><td>4159<\/td><td>3100<\/td><td>10147<\/td><td>7641<\/td><td>10285<\/td><td>8723<\/td><td>28725<\/td><tr><td>512<\/td><td>7693<\/td><td>4363<\/td><td>3113<\/td><td>10602<\/td><td>7802<\/td><td>5391<\/td><td>8809<\/td><td>28922<\/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>17.88<\/td><td>48.04<\/td><td>76.05<\/td><td>40.00<\/td><td>49.68<\/td><td>35.93<\/td><td>95.62<\/td><td>12.66<\/td><tr><td>8<\/td><td>30.52<\/td><td>48.32<\/td><td>80.09<\/td><td>43.79<\/td><td>53.29<\/td><td>38.41<\/td><td>40.33<\/td><td>14.04<\/td><tr><td>16<\/td><td>51.04<\/td><td>80.29<\/td><td>102.49<\/td><td>50.32<\/td><td>67.36<\/td><td>42.05<\/td><td>40.44<\/td><td>16.70<\/td><tr><td>32<\/td><td>89.10<\/td><td>156.14<\/td><td>192.80<\/td><td>68.73<\/td><td>100.53<\/td><td>47.44<\/td><td>77.06<\/td><td>23.47<\/td><tr><td>48<\/td><td>126.02<\/td><td>231.39<\/td><td>287.27<\/td><td>98.29<\/td><td>129.86<\/td><td>58.15<\/td><td>111.94<\/td><td>32.25<\/td><tr><td>64<\/td><td>163.32<\/td><td>309.23<\/td><td>375.70<\/td><td>128.24<\/td><td>164.75<\/td><td>73.71<\/td><td>142.76<\/td><td>41.71<\/td><tr><td>96<\/td><td>236.90<\/td><td>463.84<\/td><td>561.46<\/td><td>187.66<\/td><td>237.92<\/td><td>108.25<\/td><td>208.32<\/td><td>64.07<\/td><tr><td>128<\/td><td>310.35<\/td><td>596.25<\/td><td>751.37<\/td><td>247.10<\/td><td>302.96<\/td><td>142.51<\/td><td>275.00<\/td><td>87.88<\/td><tr><td>192<\/td><td>457.04<\/td><td>856.60<\/td><td>1117.62<\/td><td>356.97<\/td><td>462.11<\/td><td>212.04<\/td><td>405.03<\/td><td>123.71<\/td><tr><td>256<\/td><td>606.96<\/td><td>1145.53<\/td><td>1494.61<\/td><td>482.24<\/td><td>605.40<\/td><td>281.92<\/td><td>531.03<\/td><td>163.56<\/td><tr><td>384<\/td><td>904.34<\/td><td>1659.37<\/td><td>2226.85<\/td><td>680.65<\/td><td>903.58<\/td><td>671.53<\/td><td>792.11<\/td><td>240.53<\/td><tr><td>512<\/td><td>1196.51<\/td><td>2109.12<\/td><td>2954.89<\/td><td>867.32<\/td><td>1179.10<\/td><td>1705.20<\/td><td>1044.82<\/td><td>318.47<\/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>55.82<\/td><td>104.84<\/td><td>58.92<\/td><td>78.60<\/td><td>43.39<\/td><td>787.74<\/td><td>14.73<\/td><tr><td>8<\/td><td>33.72<\/td><td>53.85<\/td><td>102.97<\/td><td>73.13<\/td><td>99.33<\/td><td>47.47<\/td><td>45.79<\/td><td>16.71<\/td><tr><td>16<\/td><td>150.29<\/td><td>227.40<\/td><td>142.39<\/td><td>97.55<\/td><td>170.48<\/td><td>52.89<\/td><td>102.97<\/td><td>21.89<\/td><tr><td>32<\/td><td>297.92<\/td><td>325.98<\/td><td>262.64<\/td><td>139.85<\/td><td>240.02<\/td><td>63.32<\/td><td>344.08<\/td><td>33.12<\/td><tr><td>48<\/td><td>350.33<\/td><td>397.39<\/td><td>397.39<\/td><td>193.38<\/td><td>287.38<\/td><td>81.48<\/td><td>450.77<\/td><td>48.34<\/td><tr><td>64<\/td><td>390.30<\/td><td>467.30<\/td><td>520.62<\/td><td>235.74<\/td><td>303.33<\/td><td>215.44<\/td><td>484.44<\/td><td>62.19<\/td><tr><td>96<\/td><td>458.96<\/td><td>612.21<\/td><td>802.05<\/td><td>325.98<\/td><td>363.18<\/td><td>331.91<\/td><td>559.50<\/td><td>137.35<\/td><tr><td>128<\/td><td>530.08<\/td><td>759.88<\/td><td>1109.09<\/td><td>411.96<\/td><td>427.07<\/td><td>376.49<\/td><td>612.21<\/td><td>167.44<\/td><tr><td>192<\/td><td>669.89<\/td><td>1352.03<\/td><td>1678.14<\/td><td>569.67<\/td><td>634.66<\/td><td>467.30<\/td><td>707.07<\/td><td>196.89<\/td><tr><td>256<\/td><td>831.46<\/td><td>1973.38<\/td><td>2238.47<\/td><td>787.74<\/td><td>816.63<\/td><td>539.71<\/td><td>802.05<\/td><td>235.74<\/td><tr><td>384<\/td><td>1191.92<\/td><td>3095.38<\/td><td>3326.55<\/td><td>1050.76<\/td><td>1191.92<\/td><td>1836.24<\/td><td>1013.60<\/td><td>320.17<\/td><tr><td>512<\/td><td>1589.90<\/td><td>3911.79<\/td><td>4437.27<\/td><td>1327.91<\/td><td>1561.52<\/td><td>2082.91<\/td><td>1376.60<\/td><td>411.96<\/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.41<\/td><td>8.0.41-azure<\/td><td>8.0.32-4.0.0.5<\/td><td>8.0.41-google<\/td><td>8.0.28-231003<\/td><td>8.0.40-u6-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>96.6<\/td><td>152.1<\/td><td>73.2<\/td><td>72.8<\/td><td>49.3<\/td><td>163.4<\/td><td>119.9<\/td><td>108<\/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-19088","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\/19088","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=19088"}],"version-history":[{"count":17,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/posts\/19088\/revisions"}],"predecessor-version":[{"id":19124,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/posts\/19088\/revisions\/19124"}],"wp:attachment":[{"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/media?parent=19088"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/categories?post=19088"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/tags?post=19088"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}