{"id":11236,"date":"2024-04-14T19:28:59","date_gmt":"2024-04-14T11:28:59","guid":{"rendered":"https:\/\/www.orczhou.com\/?p=11236"},"modified":"2024-12-18T15:14:52","modified_gmt":"2024-12-18T07:14:52","slug":"oracle-ecpu-vs-ocpu-performance-benchmark","status":"publish","type":"post","link":"https:\/\/www.orczhou.com\/index.php\/2024\/04\/oracle-ecpu-vs-ocpu-performance-benchmark\/","title":{"rendered":"Oracle Cloud\u4e0a\u7684ECPU\u4e0eOCPU\u89c4\u683c\u7684MySQL\u6027\u80fd\u5bf9\u6bd4"},"content":{"rendered":"\n

\u672c\u95ee\u662f\u4e00\u4e2a\u7cfb\u5217\u6587\u7ae0\u7684\u4e00\u90e8\u5206\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\u66f4\u591a\u53c2\u8003\uff1a\u4e91\u6570\u636e\u5e93RDS MySQL\u7684\u6027\u80fd<\/a>\u3002<\/em><\/p>\n\n\n\n\n\n\n

\u6982\u8ff0\u4e0e\u7ed3\u8bba<\/h3>\n\n\n\n

Oracle\u5728\u53bb\u5e74\u5f15\u5165\u4e86ECPU\uff08\u76f8\u5bf9\u4e8e\u4e4b\u524d\u7684OCPU\uff09\uff0c\u5728\u524d\u9762\u4ecb\u7ecd\u4e86\u4ec0\u4e48\u662fECPU<\/a>\uff0c\u672c\u6587\u5219\u4ece\u6027\u80fd\u7684\u89d2\u5ea6\uff0c\u770b\u770bECPU\u4e0e\u4e4b\u524d\u7684OCPU\u7684\u5bf9\u6bd4\uff0c\u4ee5\u9a8c\u8bc1ECPU\u5c31\u662f\u5bf9\u5e94\u4e86\u5176\u4ed6\u4e91\u5382\u5546vCPU\u7684\u6982\u5ff5\u3002<\/p>\n\n\n\n

\u8fd9\u91cc\u9009\u62e9\u4e864 ECPU<\/code>\u7684\u89c4\u683cMySQL.4<\/code>\uff08\u5185\u5b58\u4e3a32GB\uff09\uff0c\u4ee5\u53ca 2 OCPU<\/code>\u7684\u89c4\u683cMySQL.VM.Standard.E4.2.32GB<\/code>\u8fdb\u884c\u5bf9\u6bd4\u3002\u4ece\u5982\u4e0b\u7684\u6027\u80fd\u8d8b\u52bf\u56fe\u53ef\u4ee5\u770b\u5230\uff0c\u4e24\u8005\u8868\u73b0\u51fa\u4e86\u51e0\u4e4e\u76f8\u540c\u7684\u6027\u80fd\u3002<\/strong>\u4ece\u4ef7\u683c\u4e0a\uff0c\u4e24\u8005\u7684\u5355\u4ef7\u5206\u522b\u662fSGD 0.050578 vs 0.055552 ( \u8ba1\u7b970.052512+0.00304\u5185\u5b58 )\uff0c\u5373ECPU\u5728\u8be5\u89c4\u683c\u4e0b\uff0cECPU\u62e5\u6709\u51e0\u4e4e\u76f8\u540c\u7684CPU\u548c\u5185\u5b58\uff0c\u4ee5\u53ca\u6027\u80fd\u8868\u73b0\u7684\u60c5\u51b5\u4e0b\uff0cECPU\u89c4\u683c\u8981\u6bd4OCPU\u89c4\u683c\u4ef7\u683c\u8981\u4f4e8.9%<\/strong> \uff1b<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n\n\n\n\n

\u6027\u80fd\u6d4b\u8bd5\u8bf4\u660e<\/h3>\n\n\n\n

\u6570\u636e\u5e93\u4e0e\u6d4b\u8bd5\u5b9e\u4f8b\u7684\u89c4\u683c<\/h4>\n\n\n\n

ECPU\u7684MySQL.4\u5b9e\u4f8b\u4e3b\u8981\u53c2\u6570\u5305\u62ec\uff1a<\/p>\n\n\n\n

    \n
  • 4 ECPU 32 GB\u5185\u5b58 100GB\u5b58\u50a8\uff083\u7ec4\u517112 ECPU\/96GB\u5185\u5b58\/300GB\u5b58\u50a8\uff09<\/li>\n\n\n\n
  • \u4f7f\u7528\u4e86\u4e3b\u53ef\u7528\u533a\u4e3aAP-TOKYO-1-AD-1 (preferred)<\/li>\n<\/ul>\n\n\n\n

    OCPU\u7684MySQL.VM.Standard.E4.2.32GB<\/code>\u4e3b\u8981\u53c2\u6570\u5305\u62ec\uff1a<\/p>\n\n\n\n

      \n
    • 2 OCPU 32GB\u5185\u5b58 100GB\u5b58\u50a8\uff083\u7ec4\u51716 OCPU\/96GB\u5185\u5b58\/300GB\u5b58\u50a8\uff09<\/li>\n\n\n\n
    • \u4f7f\u7528\u4e86\u4e3b\u53ef\u7528\u533a\u4e3aAP-TOKYO-1-AD-1 (preferred)<\/li>\n<\/ul>\n\n\n\n
      \n
      \n
      \"\"
      ECPU<\/figcaption><\/figure>\n<\/div>\n\n\n\n
      \n
      \"\"
      OCPU<\/figcaption><\/figure>\n<\/div>\n<\/div>\n\n\n\n

      \u6d4b\u8bd5\u7684VM\u4e3b\u8981\u53c2\u6570\u5305\u62ec\uff1a<\/p>\n\n\n\n

        \n
      • 4 OCPU 16GB\u5185\u5b58<\/li>\n\n\n\n
      • \u53ef\u7528\u533a\u4e3a AP-TOKYO-1-AD-1<\/li>\n\n\n\n
      • CentOS 7<\/li>\n<\/ul>\n\n\n\n
        \n
        \n
        \"\"<\/figure>\n<\/div>\n\n\n\n
        \n
        \"\"<\/figure>\n<\/div>\n<\/div>\n\n\n\n

        Sysbench\u6d4b\u8bd5\u53c2\u6570<\/h4>\n\n\n\n

        \u4f7f\u7528sysbench\u8fdb\u884c\u6d4b\u8bd5\uff0c\u4e3b\u8981\u53c2\u6570\u5305\u62ec\uff1a<\/p>\n\n\n\n

        --table_size=1000000\n--tables=10\n--time=300\n--report-interval=3 \n--percentile=95 \n--histogram=on\n--skip_trx=on\n--db-ps-mode\n--rand-type=uniform\nwork load type: oltp_read_write_with_hook\n<\/code><\/pre>\n\n\n\n
        \u4ea7\u54c1\u4ef7\u683c\u4e0e\u8d26\u5355 <\/h3>\n\n\n\n
        \u4ece\u8d26\u5355\u53ef\u4ee5\u770b\u5230\uff1a<\/p>\n\n\n\n
          \n
        • MySQL.4<\/code>\uff08\u5185\u5b58\u4e3a32GB\uff09\u89c4\u683c\uff0c\u5bf9\u5e94\u7684ECPU\u7684\u5355\u4ef7\u4e3a0.050578\uff0c\u5b9e\u4f8b\u521b\u5efa\u603b\u8ba1\u7ea616.4\u5c0f\u65f6\uff0c\u6240\u4ee5\u7528\u91cf\u7ea6\u4e3a16.4*4 = 65.6<\/code>,\u518d\u4e58\u4ee5\u5355\u4ef7\u4e5f\u5c31\u662f\u603b\u4ef7\u3002<\/li>\n\n\n\n
        • MySQL.VM.Standard.E4.2.32GB<\/code> \u5355\u4ef7\u4e3a 0.052512 \uff08OCPU PER HOUR\uff09 + 0.00304\uff08Memory GP PER HOUR\uff09\uff0c\u7528\u65f6\u7ea6\u4e3a16.13\u5c0f\u65f6\uff0c\u6240\u4ee5\u7528\u91cf\u5206\u522b\u4e3a\uff1a16.13*2<\/code> \u548c 16.13*32<\/code>,\u518d\u4e58\u4ee5\u5355\u4ef7\u4e5f\u5c31\u662f\u603b\u4ef7\u3002<\/li>\n<\/ul>\n\n\n\n
          \u521d\u6b21\u63a5\u89e6\u8fd9\u4e2a\u8d26\u5355\uff0c\u8fd8\u662f\u8981\u53cd\u5e94\u4e00\u4e0b\uff0c\u624d\u80fd\u7406\u89e3\u5927\u6982\u662f\u4ec0\u4e48\u610f\u601d\u7684\u3002\u54ce\uff0c\u6d77\u5916\u7684\u5404\u4e2a\u4e91\uff0c\u771f\u7684\u662f\uff0c\u5404\u81ea\u90fd\u6709\u4e00\u4e9b\u4e0d\u540c\uff0c\u6700\u540e\u5b66\u4e60\u6210\u672c\u5c31\u90fd\u7ed9\u5230\u4e86\u5404\u4e2a\u5f00\u53d1\u8005\u4eec\u3002<\/p>\n\n\n\n
          \"\"<\/figure>\n\n\n\n
          \u6027\u80fd\u8be6\u7ec6\u6570\u636e<\/h3>\n\n\n
          2024-04-13@Performance of MySQL on ECPU vs OCPU<\/h5>\n
          host : mysql_on_4_ecpu \nsub_dir : 10.0.0.82 \nshape : MySQL.4 \nha_type : Multi-FD \npreferred_ad : AP-TOKYO-1-AD-1 \nregion : tokyo \nstorage_size : 100 \n<\/pre>
          sysbench for host :10.0.0.82\nthreads|transactions| queries| time |avg\/Latency|95%\/Latency\n      4|       62893| 1132074|300.01|      19.08|      21.89 \n      8|       92622| 1667196|300.02|      25.91|      31.37 \n     16|      140057| 2521026|300.02|      34.27|      38.25 \n     32|      136112| 2450016|300.04|      70.53|      82.96 \n     48|      133506| 2403108|300.06|     107.87|     350.33 \n     64|      131702| 2370636|300.06|     145.79|     427.07 \n     96|      134909| 2428362|300.11|     213.52|     601.29 \n    128|      134868| 2427624|300.11|     284.78|     590.56 \n    192|      131251| 2362518|300.38|     439.31|     773.68 \n    256|      130984| 2357712|300.31|     586.67|    1032.01 \n    384|      130204| 2343689|300.32|     885.29|    3982.86 \n    512|      132859| 2391462|300.52|    1157.27|    5033.35 \n<\/pre>
          host : mysql_on_2_ocpu_E4 \nsub_dir : 10.0.0.214 \nshape : MySQL.VM.Standard.E4.2.32GB \nha_type : Multi-FD \npreferred_ad : AP-TOKYO-1-AD-1 \nregion : tokyo \nstorage_size : 100 \n<\/pre>
          sysbench for host :10.0.0.214\nthreads|transactions| queries| time |avg\/Latency|95%\/Latency\n      4|       57867| 1041606|300.01|      20.74|      22.28 \n      8|       97378| 1752804|300.01|      24.65|      26.20 \n     16|      137017| 2466306|300.02|      35.03|      36.24 \n     32|      140269| 2524842|300.04|      68.44|      80.03 \n     48|      131308| 2363544|300.05|     109.68|     235.74 \n     64|      136938| 2464884|300.08|     140.23|     427.07 \n     96|      134370| 2418677|300.10|     214.37|     549.52 \n    128|      137043| 2466791|300.09|     280.24|     623.33 \n    192|      132473| 2384514|300.16|     434.93|     719.92 \n    256|      136375| 2454767|300.24|     563.39|     893.56 \n    384|      129291| 2327238|300.36|     891.57|    3982.86 \n    512|      133804| 2408472|300.50|    1149.22|    5033.35 \n<\/pre><\/div>\n\n\n\n
          <\/p>\n","protected":false},"excerpt":{"rendered":"
          \u672c\u95ee\u662f\u4e00\u4e2a\u7cfb\u5217\u6587\u7ae0\u7684\u4e00\u90e8\u5206\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\u66f4\u591a\u53c2\u8003\uff1a\u4e91\u6570\u636e\u5e93RDS MySQL\u7684\u6027\u80fd\u3002 \u6982\u8ff0\u4e0e\u7ed3\u8bba Oracle\u5728\u53bb\u5e74\u5f15\u5165\u4e86ECPU\uff08\u76f8\u5bf9\u4e8e\u4e4b\u524d\u7684OCPU\uff09\uff0c\u5728\u524d\u9762\u4ecb\u7ecd\u4e86\u4ec0\u4e48\u662fECPU\uff0c\u672c\u6587\u5219\u4ece\u6027\u80fd\u7684\u89d2\u5ea6\uff0c\u770b\u770bECPU\u4e0e\u4e4b\u524d\u7684OCPU\u7684\u5bf9\u6bd4\uff0c\u4ee5\u9a8c\u8bc1ECPU\u5c31\u662f\u5bf9\u5e94\u4e86\u5176\u4ed6\u4e91\u5382\u5546vCPU\u7684\u6982\u5ff5\u3002 \u8fd9\u91cc\u9009\u62e9\u4e864 ECPU\u7684\u89c4\u683cMySQL.4\uff08\u5185\u5b58\u4e3a32GB\uff09\uff0c\u4ee5\u53ca 2 OCPU\u7684\u89c4\u683cMySQL.VM.Standard.E4.2.32GB\u8fdb\u884c\u5bf9\u6bd4\u3002\u4ece\u5982\u4e0b\u7684\u6027\u80fd\u8d8b\u52bf\u56fe\u53ef\u4ee5\u770b\u5230\uff0c\u4e24\u8005\u8868\u73b0\u51fa\u4e86\u51e0\u4e4e\u76f8\u540c\u7684\u6027\u80fd\u3002\u4ece\u4ef7\u683c\u4e0a\uff0c\u4e24\u8005\u7684\u5355\u4ef7\u5206\u522b\u662fSGD 0.050578 vs 0.055552 ( \u8ba1\u7b970.052512+0.00304\u5185\u5b58 )\uff0c\u5373ECPU\u5728\u8be5\u89c4\u683c\u4e0b\uff0cECPU\u62e5\u6709\u51e0\u4e4e\u76f8\u540c\u7684CPU\u548c\u5185\u5b58\uff0c\u4ee5\u53ca\u6027\u80fd\u8868\u73b0\u7684\u60c5\u51b5\u4e0b\uff0cECPU\u89c4\u683c\u8981\u6bd4OCPU\u89c4\u683c\u4ef7\u683c\u8981\u4f4e8.9% \uff1b<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"a-temp-temp","format":"standard","meta":{"_eb_attr":"","inline_featured_image":false,"_tocer_settings":[],"footnotes":""},"categories":[138,1],"tags":[],"class_list":["post-11236","post","type-post","status-publish","format-standard","hentry","category-cloud-mysql-performance-benchmark","category-simplelife"],"_links":{"self":[{"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/posts\/11236","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=11236"}],"version-history":[{"count":26,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/posts\/11236\/revisions"}],"predecessor-version":[{"id":11393,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/posts\/11236\/revisions\/11393"}],"wp:attachment":[{"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/media?parent=11236"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/categories?post=11236"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/tags?post=11236"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}