{"id":16066,"date":"2024-11-10T15:45:48","date_gmt":"2024-11-10T07:45:48","guid":{"rendered":"https:\/\/www.orczhou.com\/?p=16066"},"modified":"2024-12-18T15:14:03","modified_gmt":"2024-12-18T07:14:03","slug":"oracle-cloud-mysql-9-0-performance-benchmark","status":"publish","type":"post","link":"https:\/\/www.orczhou.com\/index.php\/2024\/11\/oracle-cloud-mysql-9-0-performance-benchmark\/","title":{"rendered":"Oracle Cloud\u4e0a\u7684MySQL 9.0\u7684\u6027\u80fd"},"content":{"rendered":"\n<p>Oracle Cloud \u662f\u6240\u6709\u4e91\u5e73\u53f0\u6700\u5148\u652f\u6301 9.0 \u7248\u672c\u7684\u3002\u8fd9\u91cc\uff0c\u6211\u4eec\u6765\u770b\u770b\u8be5\u7248\u672c\u7684\u201c\u6807\u51c6\u6027\u80fd\u201d\u8868\u73b0\u5982\u4f55\u3002<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">\u6d4b\u8bd5\u5b9e\u4f8b\u4e0e\u73af\u5883\u8bf4\u660e<\/h4>\n\n\n\n<p>\u8fd9\u91cc\u4f7f\u7528\u7684\u5b9e\u4f8b\u7c7b\u578b\u662f\uff1a<code>MySQL.4<\/code>\uff0c\u5355\u4e2a\u8282\u70b9\u4e3a<code>4 ecpu 32gb<\/code>\uff0c\u6d4b\u8bd5\u533a\u57df\u9009\u62e9\u7684\u662f\u201c\u4e1c\u4eac\u201d\uff08ap-tokyo-1\uff09\uff0c\u591a\u53ef\u7528\u533a\uff08FAULT DOMAIN\uff09\u7684\u7248\u672c\uff0c\u6d4b\u8bd5\u5b9e\u4f8b\u5b58\u50a8\u7a7a\u95f4\u5927\u5c0f\u4e3a 100 gb\u3002\u5373\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"apacheconf\" class=\"language-apacheconf\">instance_type=MySQL.4\nvcpu_per_node=4\nmemory_size_per_node=32\nregion=tokyo\navailability=multi-az\nstorage_size=100\ndb_version=8.0.39\/8.4.2\/9.0.1<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">\u6027\u80fd\u5bf9\u6bd4<\/h4>\n\n\n\n<p>\u672c\u6b21\u6d4b\u8bd5\u5206\u522b\u6d4b\u8bd5\u4e86  8.0.39\/8.4.2\/9.0.1 \u8fd9\u4e09\u4e2a\u7248\u672c\u3002\u8be6\u7ec6\u7684\u6027\u80fd\u5bf9\u6bd4\u5982\u4e0b\uff1a<\/p>\n\n\n<div>    <script type=\"text\/javascript\">\n      google.charts.load('current', {'packages':['corechart','line']});\n      google.charts.setOnLoadCallback(drawChart);\n      function drawChart() {\n        var data = google.visualization.arrayToDataTable([\n        ['threads\/qps', 'MySQL80','MySQL84','MySQL90'],\n['4',3551,3606,3360],\n['8',5936,5378,5256],\n['16',8054,8186,7287],\n['32',8317,8029,7817],\n['48',8130,8204,7911],\n['64',7838,7981,8060],\n['96',8504,8430,8172],\n['128',8198,8286,8000],\n['192',8043,8053,8112],\n['256',7907,8034,7536],\n['384',8209,8055,8151],\n['512',8386,8030,7872],\n ]);\n        var options = {\n          title: 'Benchmark for MySQL on Oracle Cloud',\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 },\n          width: 900,\n          height: 580,\n        };\n        var chart = new google.visualization.LineChart(document.getElementById('chart_div_aws_std'));\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_std');\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_aws_std\" style=\"\"><\/div><table class=\"pure-table pure-table-bordered\" style=\"font-size:0.8em;width:100%\"><thead><tr><th>data<\/th><th>MySQL80<\/th><th>MySQL84<\/th><th>MySQL90<\/th><\/tr><\/thead><tbody><tr><td>4<\/td><td>3551<\/td><td>3606<\/td><td>3360<\/td><tr><td>8<\/td><td>5936<\/td><td>5378<\/td><td>5256<\/td><tr><td>16<\/td><td>8054<\/td><td>8186<\/td><td>7287<\/td><tr><td>32<\/td><td>8317<\/td><td>8029<\/td><td>7817<\/td><tr><td>48<\/td><td>8130<\/td><td>8204<\/td><td>7911<\/td><tr><td>64<\/td><td>7838<\/td><td>7981<\/td><td>8060<\/td><tr><td>96<\/td><td>8504<\/td><td>8430<\/td><td>8172<\/td><tr><td>128<\/td><td>8198<\/td><td>8286<\/td><td>8000<\/td><tr><td>192<\/td><td>8043<\/td><td>8053<\/td><td>8112<\/td><tr><td>256<\/td><td>7907<\/td><td>8034<\/td><td>7536<\/td><tr><td>384<\/td><td>8209<\/td><td>8055<\/td><td>8151<\/td><tr><td>512<\/td><td>8386<\/td><td>8030<\/td><td>7872<\/td><\/tr><\/tbody><\/table><\/div>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">\u6027\u80fd\u6982\u8ff0<\/h4>\n\n\n\n<p>\u4ece\u8be5\u201c\u6807\u51c6\u201d\u6d4b\u8bd5\u6765\u770b\uff0c9.0.1\u7684\u6027\u80fd\u8f83\u4e3a\u7a33\u5b9a\u3002\u4ece\u4e0a\u8ff0\u6570\u636e\u4e2d\u6765\u770b\uff0c\u4f3c\u4e4e\u7565\u5fae\u4f4e\u4e8e 8.0\u548c8.4 \u7248\u672c\uff0c\u4f46\u7ecf\u8fc7\u8c03\u67e5\uff0c\u4e3b\u8981\u539f\u56e0\u662f\u7531\u4e8e\u4e91\u5e73\u53f0 CPU \u8d44\u6e90\u591a\u5c11\u6240\u5bfc\u81f4\u7684\uff0c\u800c\u5e76\u4e0d\u662f\u6570\u636e\u5e93\u672c\u8eab\u7684\u95ee\u9898\u3002<\/p>\n\n\n\n<p>\u6b64\u5916\uff0c\u5728\u4eca\u5e745\u6708\u4efd\u89c2\u5bdf\u5230\u76848.4\u6027\u80fd\u9000\u5316\u95ee\u9898\uff08<a href=\"https:\/\/www.orczhou.com\/index.php\/2024\/05\/mysql8-4-performance-benchmark-at-oracle-cloud\/\">\u53c2\u8003<\/a>\uff09\uff0c\u76ee\u524d\u4e5f\u5df2\u7ecf\u89e3\u51b3\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Oracle Cloud \u662f\u6240\u6709\u4e91\u5e73\u53f0\u6700\u5148\u652f\u6301 9.0 \u7248\u672c\u7684\u3002\u8fd9\u91cc\uff0c\u6211\u4eec\u6765\u770b\u770b\u8be5\u7248\u672c\u7684\u201c\u6807\u51c6\u6027\u80fd\u201d\u8868\u73b0\u5982\u4f55\u3002 \u6d4b\u8bd5\u5b9e\u4f8b\u4e0e\u73af\u5883\u8bf4\u660e \u8fd9\u91cc\u4f7f\u7528\u7684\u5b9e\u4f8b\u7c7b\u578b\u662f\uff1aMySQL.4\uff0c\u5355\u4e2a\u8282\u70b9\u4e3a4 ecpu 32gb\uff0c\u6d4b\u8bd5\u533a\u57df\u9009\u62e9\u7684\u662f\u201c\u4e1c\u4eac\u201d\uff08ap-tokyo-1\uff09\uff0c\u591a\u53ef\u7528\u533a\uff08FAULT DOMAIN\uff09\u7684\u7248\u672c\uff0c\u6d4b\u8bd5\u5b9e\u4f8b\u5b58\u50a8\u7a7a\u95f4\u5927\u5c0f\u4e3a 100 gb\u3002\u5373\uff1a \u6027\u80fd\u5bf9\u6bd4 \u672c\u6b21\u6d4b\u8bd5\u5206\u522b\u6d4b\u8bd5\u4e86 8.0.39\/8.4.2\/9.0.1 \u8fd9\u4e09\u4e2a\u7248\u672c\u3002\u8be6\u7ec6\u7684\u6027\u80fd\u5bf9\u6bd4\u5982\u4e0b\uff1a \u6027\u80fd\u6982\u8ff0 \u4ece\u8be5\u201c\u6807\u51c6\u201d\u6d4b\u8bd5\u6765\u770b\uff0c9.0.1\u7684\u6027\u80fd\u8f83\u4e3a\u7a33\u5b9a\u3002\u4ece\u4e0a\u8ff0\u6570\u636e\u4e2d\u6765\u770b\uff0c\u4f3c\u4e4e\u7565\u5fae\u4f4e\u4e8e 8.0\u548c8.4 \u7248\u672c\uff0c\u4f46\u7ecf\u8fc7\u8c03\u67e5\uff0c\u4e3b\u8981\u539f\u56e0\u662f\u7531\u4e8e\u4e91\u5e73\u53f0 CPU \u8d44\u6e90\u591a\u5c11\u6240\u5bfc\u81f4\u7684\uff0c\u800c\u5e76\u4e0d\u662f\u6570\u636e\u5e93\u672c\u8eab\u7684\u95ee\u9898\u3002 \u6b64\u5916\uff0c\u5728\u4eca\u5e745\u6708\u4efd\u89c2\u5bdf\u5230\u76848.4\u6027\u80fd\u9000\u5316\u95ee\u9898\uff08\u53c2\u8003\uff09\uff0c\u76ee\u524d\u4e5f\u5df2\u7ecf\u89e3\u51b3\u3002<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_eb_attr":"","inline_featured_image":false,"_tocer_settings":[],"footnotes":""},"categories":[138,6,13,1],"tags":[],"class_list":["post-16066","post","type-post","status-publish","format-standard","hentry","category-cloud-mysql-performance-benchmark","category-mysql","category-oracle","category-simplelife"],"_links":{"self":[{"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/posts\/16066","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=16066"}],"version-history":[{"count":5,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/posts\/16066\/revisions"}],"predecessor-version":[{"id":16071,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/posts\/16066\/revisions\/16071"}],"wp:attachment":[{"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/media?parent=16066"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/categories?post=16066"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/tags?post=16066"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}