{"id":10302,"date":"2023-12-18T08:45:11","date_gmt":"2023-12-18T00:45:11","guid":{"rendered":"https:\/\/www.orczhou.com\/?p=10302"},"modified":"2025-03-12T12:07:24","modified_gmt":"2025-03-12T04:07:24","slug":"performance-of-all-the-cloud-database","status":"publish","type":"post","link":"https:\/\/www.orczhou.com\/index.php\/2023\/12\/performance-of-all-the-cloud-database\/","title":{"rendered":"\u4e91\u6570\u636e\u5e93(RDS MySQL)\u6027\u80fd\u6df1\u5ea6\u6d4b\u8bc4\u4e0e\u5bf9\u6bd4@2023\u5e7412\u6708"},"content":{"rendered":"\n<p class=\"has-text-color has-link-color wp-elements-bf604e318f871e68d7cfe7b380ca0879\" style=\"color:#706868;font-size:0.75em\">\u672c\u6587\u662f\u4e00\u4e2a\u7cfb\u5217\u6587\u7ae0\u7684\u4e00\u90e8\u5206<em>\uff0c\u8be5\u7cfb\u5217\u8f83\u4e3a\u5b8c\u6574\u7684\u5bf9\u5404\u4e2a\u4e91\u5382\u5546\u7684RDS MySQL\u8fdb\u884c\u4e86\u6d4b\u8bd5\uff0c\u5305\u62ec\u4e86\u963f\u91cc\u4e91\u3001\u817e\u8baf\u4e91\u3001\u534e\u4e3a\u4e91\u3001\u767e\u5ea6\u4e91\u3001AWS\u3001Azure\u3001GCP\u3001Oracle Cloud\u7b49\uff0c\u6700\u65b0\u7684\u6d4b\u8bd5\uff1a<a href=\"https:\/\/www.orczhou.com\/index.php\/cloud-database-performance-rds-mysql\/\">\u4e91\u6570\u636e\u5e93RDS MySQL\u7684\u6027\u80fd<\/a>\u3002<\/em><\/p>\n\n\n\n\n\n\n<p>\u4e00\u76f4\u90fd\u5728\u975e\u5e38\u6df1\u5ea6\u8c03\u7814\u3001\u5173\u6ce8\u548c\u4f7f\u7528\u4e91\u6570\u636e\u5e93\uff0c\u5176\u4e2d\u6027\u80fd\u662f\u5173\u6ce8\u7684\u91cd\u70b9\u4e4b\u4e00\u3002\u4e00\u65b9\u9762\u6027\u80fd\u662f\u6700\u7ec8\u6210\u672c\u7684\u91cd\u8981\u5f71\u54cd\u56e0\u7d20\uff0c\u66f4\u597d\u7684\u6027\u80fd\uff0c\u901a\u5e38\u610f\u5473\u7740\u4f7f\u7528\u66f4\u5c11\u7684\u8d44\u6e90\u652f\u6491\u66f4\u9ad8\u7684\u4e1a\u52a1\u91cf\uff0c\u4ece\u800c\u964d\u4f4e\u6574\u4f53\u6210\u672c\u3002\u53e6\u5916\uff0c\u6027\u80fd\u8fd8\u610f\u5473\u7740\u5728\u6781\u7aef\u573a\u666f\u4e0b\uff0c\u6570\u636e\u5e93\u7684\u4e0a\u9650\u652f\u6491\u80fd\u529b\u3002<\/p>\n\n\n\n<p>\u6240\u4ee5\uff0c\u8fd1\u671f\u5bf9\u5404\u4e2a\u4e91\u6570\u636e\u5e93\u5382\u5546\u505a\u4e86\u4e00\u4e2a\u8f83\u4e3a\u7cfb\u7edf\u7684\u6027\u80fd\u5bf9\u6bd4\uff0c\u4f9b\u5f00\u53d1\u8005\u548c\u4f01\u4e1a\u5728\u4e91\u6570\u636e\u5e93\u9009\u578b\u65f6\u7684\u53c2\u8003\u3002<\/p>\n\n\n\n<h4 class=\"wp-block-heading has-text-align-center has-text-color has-link-color wp-elements-e27d8f220867f1f7628dbace1bca519c\" style=\"color:#0000ff\"><strong>\u603b\u89c8\uff1a\u4e91\u6570\u636e\u5e93\u6027\u80fd\u5bf9\u6bd4<\/strong><\/h4>\n\n\n\n<p>\u5728\u8fdb\u884c\u5927\u91cf\u6d4b\u8bd5\u4e4b\u540e\uff0c\u5bf9\u4e3b\u8981\u7684\u4e91\u5382\u5546\u5206\u522b\u9009\u62e9\u4e86\u4e00\u4e2a\u201c\u4f01\u4e1a\u7ea7\u89c4\u683c\u201d\uff08\u9002\u5408\u751f\u4ea7\u73af\u5883\u914d\u7f6e\u7684\uff09\u8fdb\u884c\u4e86\u5bf9\u6bd4\u3002\u5148\u770b\u6027\u80fd\u5bf9\u6bd4\u5982\u4e0b\u56fe\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"663\" src=\"https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-45-1024x663.png\" alt=\"\" class=\"wp-image-10445\" srcset=\"https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-45-1024x663.png 1024w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-45-300x194.png 300w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-45-768x498.png 768w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-45-1536x995.png 1536w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-45-2048x1327.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\u53ef\u4ee5\u770b\u5230\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u534e\u4e3a\u4e91\u6570\u636e\u5e93\uff08\u7ea2\u8272\uff09\uff0c\u5728\u4e2d\u9ad8\u5e76\u53d1\u5ea6\u65f6\uff08&gt;=16\uff09\uff0c\u6027\u80fd\u6700\u5f3a\uff0c\u4e14\u9ad8\u4e8e\u7b2c\u4e8c\u540d\u7ea618%\uff1b<\/li>\n\n\n\n<li>\u817e\u8baf\u4e91\u6570\u636e\u5e93\uff08\u7d2b\u8272\uff09\uff0c\u5728\u4f4e\u5e76\u53d1\u65f6\uff08&lt;=8\uff09\uff0c\u6027\u80fd\u6700\u5f3a\uff0c\u9ad8\u4e8e\u7b2c\u4e8c\u540d\u7ea615%\uff1b<\/li>\n\n\n\n<li>\u767e\u5ea6\u4e91\u6570\u636e\u5e93\uff08\u6de1\u84dd\u8272\uff09\uff0c\u5728\u4e2d\u9ad8\u5e76\u53d1\u65f6\uff08&gt;16\uff09\uff0c\u6027\u80fd\u8dc3\u5c45\u7b2c\u4e8c\uff0c\u4ec5\u6b21\u4e8e\u534e\u4e3a\u4e91\uff1b<\/li>\n\n\n\n<li>\u963f\u91cc\u4e91\u6570\u636e\u5e93\uff08\u9ec4\u8272\uff09\u548c\u8c37\u6b4c\u4e91\u6570\u636e\u5e93\uff08\u7eff\u8272\uff09\u5728\u4f4e\u5e76\u53d1\u65f6\u4e5f\u90fd\u6709\u4e0d\u9519\u7684\u8868\u73b0\uff0c\u9ad8\u5e76\u53d1\u4e4b\u540e\u6027\u80fd\u5219\u6301\u7eed\u7a33\u5b9a\u5728850 tps\u3002\u8fd9\u4e24\u5bb6\u4e91\u6570\u636e\u5e93\u7684\u54cd\u5e94\u5ef6\u8fdf\uff0c\u8868\u73b0\u5f97\u4e5f\u975e\u5e38\u63a5\u8fd1\u3002<\/li>\n\n\n\n<li>\u4e9a\u9a6c\u900a\u4e91\u6570\u636e\u5e93\uff08Amazon RDS\uff0c\u84dd\u8272\uff09\u548c\u5fae\u8f6fAzure\u4e91\u5728\u4e2d\u4f4e\u5e76\u53d1\u65f6\uff0c\u8868\u73b0\u51fa\u4e86\u8f83\u4e3a\u76f8\u8fd1\u7684\u6027\u80fd\u8d8b\u52bf\uff0c\u4e14\u6027\u80fd\u8f83\u4f4e\u3002\u4f46\u662f\u5728\u9ad8\u5e76\u53d1\u65f6\uff0c\u4e24\u8005\u90fd\u8868\u73b0\u51fa\u4e86\u975e\u5e38\u5f3a\u7684\u6269\u5c55\u6027\uff0cAWS RDS\u572896\u548c128\u5e76\u53d1\u65f6\uff0c\u6027\u80fd\u8d85\u8fc7\u963f\u91cc\u4e91\u3001\u817e\u8baf\u4e91\u3001\u8c37\u6b4c\u4e91\u7b49\uff0c\u8dc3\u5c45\u7b2c\u4e09\uff1b\u540c\u6837\u7684\uff0c\u5fae\u8f6fAzure\u4e91\u7684\u6570\u636e\u5e93\u5728\u9ad8\u5e76\u53d1\u65f6\u4e5f\u8d85\u8fc7\u4e86\u963f\u91cc\u4e91\u3001\u8c37\u6b4c\u4e91\uff0c\u4e5f\u6709\u4e0d\u9519\u7684\u6027\u80fd\u8868\u73b0\u3002<\/li>\n<\/ul>\n\n\n\n<!--more-->\n\n\n\n<p>\u4e0b\u56fe\u662f\u5bf9\u5e94\u7684\u5e73\u5747\u5ef6\u8fdf\u8d8b\u52bf\u56fe\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"646\" src=\"https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-37-1024x646.png\" alt=\"\" class=\"wp-image-10386\" srcset=\"https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-37-1024x646.png 1024w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-37-300x189.png 300w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-37-768x484.png 768w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-37-1536x969.png 1536w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-37.png 1804w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p class=\"has-text-align-center has-text-color has-link-color wp-elements-e9b489d2a7f322052d0e370890fa03bb\" style=\"color:#0000ff\"><strong>\u201c\u4f01\u4e1a\u7ea7\u89c4\u683c\u201d\u7684\u5b9a\u4e49<\/strong><\/p>\n\n\n\n<p>\u4e3a\u4e86\u65b9\u4fbf\u8de8\u4e91\u5bf9\u6bd4\uff0c\u7b14\u8005\u6839\u636e\u5e38\u89c1\u7684\u4f01\u4e1a\u6838\u5fc3\u6570\u636e\u5e93\u914d\u7f6e\uff0c\u5728\u6bcf\u6735\u4e91\u7684RDS\u7684\u4e2d\u9009\u62e9\u4e86\u4e00\u4e2a\u9002\u5408\u7684\u89c4\u683c\u4f5c\u4e3a\u5bf9\u6bd4\u4ee3\u8868\uff0c\u5e76\u5c06\u8be5\u89c4\u683c\u79f0\u4e4b\u4e3a<strong>\u201c\u4f01\u4e1a\u7ea7\u89c4\u683c\u201d<\/strong>\u3002\u5728\u4f17\u591a\u914d\u7f6e\u9009\u9879\u4e2d\uff0c\u201c<strong>\u4f01\u4e1a\u7ea7\u89c4\u683c<\/strong>\u201d\u9700\u6ee1\u8db3\u5982\u4e0b\u6761\u4ef6\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u5177\u5907\u654f\u6377\u7684\u9ad8\u53ef\u7528\u80fd\u529b\u3002\u9700\u8981\u662f\u53cc\u8282\u70b9\u6216\u66f4\u591a\uff0c\u5728\u5176\u4e2d\u4e00\u4e2a\u8282\u70b9\u51fa\u73b0\u6545\u969c\u65f6\uff0c\u80fd\u591f\u5feb\u901f\u7684\u8fdb\u884c\u5207\u6362\uff08Switchover\u6216failover\uff09\uff1b<\/li>\n\n\n\n<li>\u9700\u8981\u5177\u5907\u975e\u5e38\u9ad8\u7684\u6570\u636e\u53ef\u9760\u6027\u4fdd\u969c\u3002\u81f3\u5c11\u9700\u8981\u8de8\u53ef\u7528\u533a\uff08\u540c\u57ce\uff09\u7684\u5bb9\u707e\uff0c\u4e14\u6570\u636e\u5728\u4e0d\u540c\u53ef\u7528\u533a<em><strong>\u540c\u6b65\u6301\u4e45\u5316<\/strong><\/em>\u3002\u5373\u9700\u8981\u4f7f\u7528\u540c\u6b65\u6216\u201c\u63a5\u8fd1\u540c\u6b65\u201d\uff08\u5982\u534a\u540c\u6b65\uff09\u7684\u590d\u5236\uff1b<\/li>\n\n\n\n<li>\u5177\u5907\u8f83\u597d\u7684\u6027\u80fd\u4e00\u81f4\u6027\u3002\u6838\u5fc3\u6570\u636e\u5e93\u5bf9\u4e8e\u7a33\u5b9a\u6027\u6709\u7740\u66f4\u9ad8\u7684\u8981\u6c42\uff0c\u9700\u8981\u4f7f\u7528\u72ec\u4eab\u7684\u8ba1\u7b97\u3001\u5b58\u50a8\u3001\u5185\u5b58\u7b49\u8d44\u6e90\u3002\u4e0d\u5141\u8bb8\u56e0\u4e3a\u8d44\u6e90\u4e89\u62a2\u5bfc\u81f4\u7684\uff0c\u6545\u6570\u636e\u5e93\u7684\u6027\u80fd\u8868\u73b0\u9700\u8981\u8f83\u4e3a\u4e00\u81f4\uff0c\u4e0d\u80fd\u6709\u592a\u5927\u7684\u6ce2\u52a8\uff0c\u6216\u8005\u672a\u77e5\u7684\u4e0d\u53ef\u9884\u6d4b\u7684\u8d44\u6e90\u4e89\u62a2\u3002<\/li>\n\n\n\n<li>\u5173\u4e8e\u89c4\u683c\u7684\u5927\u5c0f\uff0c\u8fd9\u91cc\u9009\u62e9\u4e2d\u7b49\u89c4\u683c4vCPU16GB\u5185\u5b58\/100GB\u5b58\u50a8\/3000 IOPS\u3002\u4e3b\u8981\u8003\u8651\u662f\uff0c\u4e00\u65b9\u9762\u662f\u6539\u89c4\u683c\u4e3a\u6838\u5fc3\u4e1a\u52a1\u4f7f\u7528\u7684\u8d77\u6b65\u89c4\u683c\uff0c\u53e6\u5916\uff0c\u8003\u8651\u5c06\u6d4b\u8bd5\u7a0b\u5e8f\u8bbe\u8ba1\u7684\u8f83\u4e3a\u7b80\u6d01\uff0c\u4fbf\u4e8e\u540e\u7eed\u6301\u7eed\u6d4b\u8bd5\u4e0e\u6301\u7eed\u5bf9\u6bd4\u3002<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading has-text-align-center has-text-color has-link-color wp-elements-55cab6f36e3e55326257d7ef5d966f91\" style=\"color:#0000ff\"><strong>\u534e\u4e3a\u4e91RDS\u6027\u80fd\u8be6\u60c5<\/strong><\/h4>\n\n\n\n<p>\u534e\u4e3a\u4e91\u7684\u89c4\u683c\u9009\u62e9\u4e0e\u914d\u7f6e\u90fd\u5f88\u7b80\u6d01\u3002\u4e3b\u8981\u652f\u6301\u901a\u7528\u578b\u3001\u9cb2\u9e4f\u589e\u5f3a\u578b\u3001\u72ec\u4eab\u578b\u5b9e\u4f8b\u3002\u6211\u4eec\u770b\u770b\u8fd9\u4e09\u79cd\u89c4\u683c\u7684\u6027\u80fd\u60c5\u51b5\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"731\" height=\"439\" src=\"https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-21.png\" alt=\"\" class=\"wp-image-10311\" style=\"width:903px;height:auto\" srcset=\"https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-21.png 731w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-21-300x180.png 300w\" sizes=\"auto, (max-width: 731px) 100vw, 731px\" \/><\/figure>\n\n\n\n<p>\u5728\u524d\u9762\uff0c\u201c\u4f01\u4e1a\u7ea7\u89c4\u683c\u201d\u5bf9\u6bd4\u4e2d\uff0c\u9009\u62e9\u4e86\u4f01\u4e1a\u7ea7\u7528\u66f4\u4e3a\u5e38\u7528\u7684\u201c\u72ec\u4eab\u578b\u201d\u3002\u8be5\u89c4\u683c\u4e5f\u5728\u5168\u90e8\u201c\u4f01\u4e1a\u7ea7\u89c4\u683c\u201d\u7684\u5bf9\u6bd4\u4e2d\uff0c\u8868\u73b0\u51fa\u4e86\u6700\u5f3a\u7684\u6027\u80fd\u3002\u5728\u9ad8\u5e76\u53d1\u7684\u60c5\u51b5\u4e0b\uff0c\u6027\u80fd\u9ad8\u51fa\u4e86\u5176\u4ed6\u4e91\u6570\u636e\u5e93\u5382\u5546\u7ea630%~100%\u3002<\/p>\n\n\n\n<p>\u534e\u4e3a\u4e91\u901a\u7528\u89c4\u683c\u901a\u8fc7\u66f4\u591a\u7684\u8d44\u6e90\u5171\u4eab\uff0c\u53ef\u4ee5\u83b7\u5f97\u66f4\u597d\u7684\u6027\u80fd\uff0c\u4f46\u662f\u4e5f\u56e0\u4e3a\u5171\u4eab\u7684\u539f\u56e0\uff0c\u6027\u80fd\u4f1a\u6709\u65f6\u5019\u4e0d\u7a33\u5b9a\u3002\u5728\u8fd9\u91cc\u7684\u6d4b\u8bd5\u4e2d\uff0c\u5982\u679c\u4f7f\u7528\u901a\u7528\u578b\u89c4\u683c\uff0c\u5728\u9ad8\u5e76\u53d1\u65f6\uff0c\u7528\u6237\u53c8\u53ef\u4ee5\u83b7\u5f97\u7ea615%~20%\u7684\u6027\u80fd\u3002<\/p>\n\n\n\n<p>\u9cb2\u9e4f\u589e\u5f3a\u578b\uff0c\u4f7f\u7528\u7684\u662f\u534e\u4e3a\u81ea\u7814\u7684\u9cb2\u9e4f\u82af\u7247\uff08\u57fa\u4e8eARM\uff09\u3002\u8be5\u82af\u7247\u7684\u81ea\u4e3b\u5316\u7387\u662f\u975e\u5e38\u9ad8\u7684\uff0c\u5728\u56fd\u4ea7\u5316\u82af\u7247\u4e2d\uff0c\u5c5e\u4e8e\u4f7c\u4f7c\u8005\u3002\u4f46\uff0c\u4e5f\u56e0\u4e3a\u590d\u6742\u7684\u73af\u5883\u548c\u6280\u672f\u7684\u5dee\u5f02\uff0c\u76f8\u6bd4Intel\u7684x86\u6709\u7740\u7ea620%~30%\u7684\u6027\u80fd\u9000\u5316\u3002\u8003\u8651\u5230\u9cb2\u9e4f\u82af\u7247\u5728\u56fd\u4ea7\u82af\u7247\u4e2d\u7684\u5730\u4f4d\uff0c\u5728\u56fd\u4ea7\u5316\u573a\u666f\u4e2d\uff0c\u91c7\u7528\u8be5\u89c4\u683c\u662f\u975e\u5e38\u4e0d\u9519\u7684\u9009\u62e9\u3002<\/p>\n\n\n\n<h4 class=\"wp-block-heading has-text-align-center has-text-color has-link-color wp-elements-cd94d36974cb9039b9b82236595f53dc\" style=\"color:#0000ff\"><strong>\u767e\u5ea6\u4e91\u6570\u636e\u5e93\uff08RDS\uff09\u6027\u80fd<\/strong><\/h4>\n\n\n\n<p>\u5728\u524d\u9762\u7684\u6574\u4f53\u5bf9\u6bd4\u4e2d\u770b\u5230\uff0c\u767e\u5ea6\u667a\u80fd\u4e91RDS\u7684\u201c\u4f01\u4e1a\u7ea7\u89c4\u683c\u201d\u5728\u4e2d\u9ad8\u5e76\u53d1\u65f6\uff0c\u8868\u73b0\u51fa\u4e86\u975e\u5e38\u5f3a\u7684\u6027\u80fd\uff0c\u4f4d\u5c45\u699c\u773c\u3002\u767e\u5ea6\u4e91RDS\u7684\u9009\u9879\u4e5f\u6bd4\u8f83\u7b80\u5355\uff0c\u6027\u80fd\u76f8\u5173\u4e3b\u8981\u662f\u201c\u5f02\u6b65\/\u534a\u540c\u6b65\u590d\u5236\u201d\u3001\u201c\u9ad8\u6027\u80fd\/\u9ed8\u8ba4\u53c2\u6570\u6a21\u677f\u201d\u3002\u5176\u4e2d\uff0c\u201c\u5f02\u6b65\/\u534a\u540c\u6b65\u590d\u5236\u201d\u4e0e\u963f\u91cc\u4e91\u3001\u817e\u8baf\u4e91\u7b49\u7c7b\u4f3c\uff0c\u8fd9\u91cc\u4e0d\u518d\u8d58\u8ff0\u3002<\/p>\n\n\n\n<p>\u201c\u9ad8\u6027\u80fd\/\u9ed8\u8ba4\u53c2\u6570\u6a21\u677f\u201d\u7684\u914d\u7f6e\u5404\u4e2a\u4e91\u5382\u5546\u7565\u6709\u4e00\u4e9b\u4e0d\u540c\uff0c\u5728\u7b14\u8005\u6d4b\u8bd5\u65f6\uff0c\u767e\u5ea6\u4e91RDS\u5bf9\u5e94\u7684\u90e8\u5206\u53c2\u6570\u5982\u4e0b\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u9ad8\u6027\u80fd\uff1async_binlog=1000\u3001innodb_flush_log_at_trx_commit=2<\/li>\n\n\n\n<li>\u9ed8\u8ba4\u53c2\u6570\u6a21\u677f\uff1async_binlog=1000\u3001innodb_flush_log_at_trx_commit=1<\/li>\n<\/ul>\n\n\n\n<p>\u5728\u5b9e\u9645\u6d4b\u8bd5\u4e2d\uff0c\u6211\u4eec\u4e5f\u770b\u5230\uff0c\u4e0d\u540c\u53c2\u6570\u6a21\u677f\u5bf9\u4e8e\u6027\u80fd\u6709\u4e00\u4e9b\u5f71\u54cd\uff0c\u4f46\u662f\u5e76\u4e0d\u660e\u663e\u3002\u5177\u4f53\u6027\u80fd\u5982\u4e0b\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"849\" src=\"https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-43-1024x849.png\" alt=\"\" class=\"wp-image-10432\" srcset=\"https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-43-1024x849.png 1024w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-43-300x249.png 300w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-43-768x637.png 768w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-43-1536x1273.png 1536w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-43.png 1602w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\u518d\u6765\u5355\u72ec\u5bf9\u6bd4\u4e00\u4e0b\u201c\u9ed8\u8ba4\u53c2\u6570\u6a21\u677f\u201d\u548c\u201c\u9ad8\u6027\u80fd\u53c2\u6570\u6a21\u677f\u201d\u7684\u6027\u80fd\u60c5\u51b5\u3002\u4ece\u5982\u4e0b\u4e24\u5e45\u5bf9\u6bd4\u56fe\u4e2d\uff0c\u5219\u53ef\u4ee5\u66f4\u52a0\u6e05\u6670\u7684\u770b\u5230\uff0c\u65e0\u8bba\u662f\u534a\u540c\u6b65\u8fd8\u662f\u5f02\u6b65\u6a21\u5f0f\u4e0b\uff0c\u8fd9\u4e24\u7c7b\u53c2\u6570\u6a21\u677f\u90fd\u5e76\u6ca1\u6709\u8868\u73b0\u51fa\u592a\u5927\u7684\u6027\u80fd\u5dee\u522b\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"383\" src=\"https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-44-1024x383.png\" alt=\"\" class=\"wp-image-10433\" srcset=\"https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-44-1024x383.png 1024w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-44-300x112.png 300w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-44-768x287.png 768w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-44-1536x575.png 1536w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-44-2048x766.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading has-text-align-center has-text-color has-link-color wp-elements-9e35520be2b8cecd13dd3c64e83db1f3\" style=\"color:#0000ff\"><strong>\u817e\u8baf\u4e91RDS\u6027\u80fd\u8be6\u60c5<\/strong><\/h4>\n\n\n\n<p>\u817e\u8baf\u4e91\u5728\u8d2d\u4e70\u65f6\uff0c\u4e0e\u963f\u91cc\u4e91\u7c7b\u4f3c\uff0c\u4e5f\u63d0\u4f9b\u4e86\u6bd4\u8f83\u4e30\u5bcc\u7684\u9009\u9879\u4f9b\u7528\u6237\u9009\u62e9\u3002\u7528\u6237\u53ef\u4ee5\u5728\u6570\u636e\u5e93\u53ef\u9760\u6027\u4e0e\u6027\u80fd\u3001\u6027\u80fd\u7a33\u5b9a\u6027\u4e0e\u6027\u80fd\u5cf0\u503c\u4e4b\u95f4\u8fdb\u884c\u5e73\u8861\u7684\u9009\u62e9\u3002\u8fd9\u4e9b\u9009\u9879\u5206\u522b\u662f\u201c\u901a\u7528\/\u72ec\u4eab\u201d\u3001\u201c\u5f02\u6b65\/\u534a\u540c\u6b65\u590d\u5236\u201d\u3001\u201c\u9ad8\u6027\u80fd\/\u9ad8\u7a33\u5b9a\u6027\u53c2\u6570\u6a21\u677f\u201d\u3002\u5176\u4e2d\u201c\u901a\u7528\/\u72ec\u4eab\u201d\u9009\u9879\u4e0e\u963f\u91cc\u4e91\u76f8\u540c\uff0c\u8fd9\u91cc\u4e0d\u518d\u8d58\u8ff0\u3002<\/p>\n\n\n\n<p>\u201c\u5f02\u6b65\/\u534a\u540c\u6b65\u590d\u5236\u201d\u914d\u7f6e\u7684\u662f\u4e3b\u5907\u590d\u5236\u65f6\u7684\u540c\u6b65\u7b56\u7565\uff0c\u5f02\u6b65\u5219\u610f\u5473\u7740\u4e3b\u5907\u53ef\u80fd\u5b58\u5728\u4e00\u5b9a\u7684\u5ef6\u8fdf\uff0c\u4e0d\u8fc7\u6839\u636e\u7ecf\u9a8c\u6765\u770b\u8fd9\u4e2a\u5ef6\u8fdf\u4e00\u822c\u662f\u6beb\u79d2\u7ea7\u522b\u7684\uff0c\u6709\u65f6\u5019\u751a\u81f3\u66f4\u4f4e\u3002\u201c\u534a\u540c\u6b65\u201d\u540c\u6b65\u590d\u5236\u4e0b\uff0c\u4e3b\u5e93\u9700\u8981\u518d\u5907\u5e93\u63a5\u53d7\u5b8c\u65e5\u5fd7\u540e\uff0c\u624d\u5b8c\u6210\u65e5\u5fd7\u7684\u63d0\u4ea4\uff0c\u6570\u636e\u53ef\u9760\u6027\u6709\u66f4\u597d\u7684\u4fdd\u969c\u3002<\/p>\n\n\n\n<p>\u201c\u9ad8\u6027\u80fd\/\u9ad8\u7a33\u5b9a\u6027\u53c2\u6570\u6a21\u677f\u201d\u7684\u533a\u522b\u5728\u4e8eMySQL \/ InnoDB\u7684\u4e00\u4e9b\u4e0e\u65e5\u5fd7\u76f8\u5173\u7684\u53c2\u6570\u7684\u914d\u7f6e\u3002\u5176\u4e2d\u201c\u9ad8\u7a33\u5b9a\u201d\u5728\u6570\u636e\u53ef\u9760\u6027\u4e0a\uff0c\u6709\u7740\u66f4\u4e25\u683c\u7684\u914d\u7f6e\uff0c\u4f8b\u5982<code>sync_binlog=1<\/code>\u3001<code>innodb_flush_log_at_trx_commit=1<\/code>\u3002\u800c\u201c\u9ad8\u6027\u80fd\u201d\u53c2\u6570\u6a21\u677f\uff0c\u4ee5\u4e0a\u4e24\u4e2a\u53c2\u6570\u5206\u522b\u4e3a1000\u548c2\uff0c\u662f\u5728\u6570\u636e\u7684\u53ef\u9760\u6027\u4e0a\u505a\u4e86\u9002\u5f53\u7684\u8ba9\u6b65\uff0c\u4ee5\u6362\u53d6\u66f4\u597d\u7684\u6027\u80fd\u3002<\/p>\n\n\n\n<p>\u4ee5\u4e0a\uff0c\u4e09\u7ec4\u9009\u62e9\u7684\u7ec4\u5408\uff0c\u4e00\u5171\u6709\u5982\u4e0b\u516b\u4e2a\u7c7b\u578b\u7684\u5b9e\u4f8b\uff0c\u6d4b\u8bd5\u7684\u6027\u80fd\u8868\u73b0\u5982\u4e0b\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"711\" src=\"https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-30-1024x711.png\" alt=\"\" class=\"wp-image-10349\" style=\"width:847px;height:auto\" srcset=\"https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-30-1024x711.png 1024w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-30-300x208.png 300w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-30-768x533.png 768w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-30-1536x1066.png 1536w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-30.png 1856w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\u53ef\u4ee5\u770b\u5230\uff1a<\/p>\n\n\n\n<p>\u9996\u5148\uff0c\u901a\u7528\u578b\u5b9e\u4f8b\u56e0\u4e3a\u80fd\u591f\u83b7\u5f97\u989d\u5916\u7684\u5171\u4eab\u7684CPU\u8d44\u6e90\uff0c\u8868\u73b0\u51fa\u4e86\u666e\u904d\u7684\u66f4\u9ad8\u7684\u6027\u80fd\uff0c\u5728\u8f83\u9ad8\u7684\u5e76\u53d1\u538b\u529b\u4e4b\u4e0b\uff0c\u9ad8\u51fa\u7ea6100~200%\u3002\u5f02\u6b65\u4e0e\u534a\u540c\u6b65\u590d\u5236\u7684\u5b9e\u4f8b\u7684\u6027\u80fd\u76f8\u5dee\u4e5f\u975e\u5e38\u660e\u663e\uff0c\u6709\u66f4\u5f3a\u53ef\u9760\u6027\u7684\u201c\u534a\u540c\u6b65\u590d\u5236\u201d\u6027\u80fd\u8981\u4f4e20%~35%\u4e4b\u95f4\u3002<\/p>\n\n\n\n<p>\u5728\u8fd9\u4e00\u6b21\u7684\u6d4b\u8bd5\u4e2d\uff0c\u817e\u8baf\u4e91\u7684\u72ec\u4eab\u5b9e\u4f8b\uff0c\u4e5f\u8868\u73b0\u51fa\u4e86\u4e00\u4e9b\u5f02\u5e38\u60c5\u51b5\u3002\u9ad8\u7a33\u5b9a\u548c\u9ad8\u6027\u80fd\u8fd9\u4e24\u4e2a\u53c2\u6570\u6a21\u677f\u4e4b\u95f4\uff0c\u5728\u72ec\u4eab\u5b9e\u4f8b\u6d4b\u8bd5\u7ec4\u4e2d\uff0c\u8fd9\u4e24\u7ec4\u6a21\u677f\u7684\u6027\u80fd\u8868\u73b0\u4e0e\u5176\u540d\u79f0\u8868\u73b0\u5f97\u5e76\u4e0d\u540c\u3002\u5728\u72ec\u4eab\u5b9e\u4f8b\u7684\u6d4b\u8bd5\u4e2d\uff0c\u9ad8\u7a33\u5b9a\u7684\u53c2\u6570\u6a21\u677f\u5728\u9ad8\u5e76\u53d1\u7684\u65f6\u5019\uff0c\u90fd\u8868\u73b0\u51fa\u4e86\u66f4\u9ad8\u7684\u6027\u80fd\u3002\u5373\u201c\u72ec\u4eab-\u5f02\u6b65-\u9ad8\u7a33\u5b9a\u201d &gt; \u201c\u72ec\u4eab-\u5f02\u6b65-\u9ad8\u6027\u80fd\u201d  \u4ee5\u53ca  \u201c\u72ec\u4eab-\u534a\u540c\u6b65-\u9ad8\u7a33\u5b9a\u201d &gt; \u201c\u72ec\u4eab-\u534a\u540c\u6b65-\u9ad8\u6027\u80fd\u201d\u3002\u8fd9\u4e00\u70b9\u4e0e\u9884\u671f\u5f97\u662f\u975e\u5e38\u4e0d\u540c\u7684\u3002<\/p>\n\n\n\n<h4 class=\"wp-block-heading has-text-align-center has-text-color has-link-color wp-elements-c23c6cd2a26c8b3687316afb0ef91bd2\" style=\"color:#0000ff\"><strong>\u963f\u91cc\u4e91RDS\u6027\u80fd\u8be6\u60c5<\/strong><\/h4>\n\n\n\n<p>\u963f\u91cc\u4e91RDS\u63d0\u4f9b\u4e86\u975e\u5e38\u4e30\u5bcc\u7684\u9009\u9879\uff0c\u7ed9\u4e86\u5f00\u53d1\u8005\u66f4\u5927\u7684\u9009\u62e9\u7a7a\u95f4\uff0c\u8ba9\u5f00\u53d1\u8005\u53ef\u4ee5\u5728\u6027\u80fd\u7684\u7a33\u5b9a\u6027\u3001\u6570\u636e\u53ef\u9760\u6027\u3001\u6027\u80fd\u9ad8\u4f4e\u4e4b\u95f4\u505a\u66f4\u591a\u7684\u5e73\u8861\u4e0e\u9009\u62e9\u3002\u53e6\u5916\uff0c\u65b0\u63a8\u51fa\u7684\u201c\u7ecf\u6d4e\u578b\u201d\uff08\u4e4b\u524d\u7684ARM\u89c4\u683c\uff09\u5b9e\u4f8b\u53c8\u7ed9\u4e86\u5f00\u53d1\u8005\u66f4\u9ad8\u6027\u4ef7\u6bd4\u7684RDS\u65b9\u6848\u3002\u4f46\uff0c\u53e6\u4e00\u65b9\u9762\uff0c\u4e5f\u8ba9\u5bb9\u6613\u8ba9\u5f00\u53d1\u8005\u975e\u5e38\u56f0\u60d1\uff0c\u96be\u4ee5\u9009\u62e9\u3002<\/p>\n\n\n\n<p>\u8fd9\u91cc\u6211\u4eec\u6765\u770b\u770b\u8fd9\u4e9b\u89c4\u683c\u3001\u9009\u9879\u5bf9\u6027\u80fd\u7684\u5f71\u54cd\u60c5\u51b5\uff1a\uff08\u6ce8\uff1a\u5404\u79cd\u7c7b\u578b\u7684\u67b6\u6784\u4e0e\u533a\u522b\u53ef\u4ee5\u53c2\u8003\u4e4b\u524d\u7684\u6587\u7ae0\uff1a<a href=\"https:\/\/www.orczhou.com\/index.php\/a-graph-of-alibaba-cloud-database-rds-architecture\/\">\u4e00\u5f20\u56fe\u8bfb\u61c2\u963f\u91cc\u4e91\u6570\u636e\u5e93RDS\u67b6\u6784\u4e0e\u9009\u578b<\/a>\uff09<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"611\" src=\"https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-23-1024x611.png\" alt=\"\" class=\"wp-image-10319\" srcset=\"https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-23-1024x611.png 1024w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-23-300x179.png 300w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-23-768x458.png 768w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-23-1536x916.png 1536w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-23.png 2008w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\u963f\u91cc\u4e91\u63d0\u4f9b\u4e86\u901a\u7528\/\u72ec\u4eab\u3001\u7ecf\u6d4e\/\u6807\u51c6\u3001\u9ad8\u6027\u80fd\/\u9ed8\u8ba4\u53c2\u6570\u6a21\u677f\u7b49\u9009\u9879\uff0c\u4e00\u5171\u6709\u516b\u79cd\u5982\u4e0a\u7684\u7ec4\u5408\u3002\u201c\u901a\u7528\/\u72ec\u4eab\u201d\u4ee3\u8868\u4e86\u8d44\u6e90\u7684\u5171\u4eab\u7a0b\u5ea6\uff1b\u7ecf\u6d4e\/\u6807\u51c6\u5219\u4ee3\u8868\u4e0d\u540c\u7684CPU\u7c7b\u578b\uff08ARM vs x86\uff09\uff1b\u9ad8\u6027\u80fd\/\u9ed8\u8ba4\u53c2\u6570\u6a21\u677f\u5219\u662f\u4ee3\u8868\u6570\u636e\u53ef\u9760\u6027\u7684\u4e25\u683c\u7a0b\u5ea6\u3002\u66f4\u591a\u8be6\u7ec6\u8bf4\u660e\u53ef\u4ee5\u53c2\u8003\uff1a<a href=\"https:\/\/www.orczhou.com\/index.php\/a-graph-of-alibaba-cloud-database-rds-architecture\/\">\u4e00\u5f20\u56fe\u8bfb\u61c2\u963f\u91cc\u4e91\u6570\u636e\u5e93RDS\u67b6\u6784\u4e0e\u9009\u578b<\/a>\u3002<\/p>\n\n\n\n<p>\u6574\u4f53\u4e0a\uff0c\u901a\u7528\u89c4\u683c\uff0c\u51ed\u501f\u5176\u66f4\u591a\u7684CPU\u8d44\u6e90\u5171\u4eab\uff0c\u6574\u4f53\u8868\u73b0\u51fa\u4e86\u66f4\u5f3a\u52b2\u7684\u6027\u80fd\u3002\u4e00\u822c\u7684\uff0c\u901a\u7528\u89c4\u683c\u6027\u80fd\u6bd4\u72ec\u4eab\u89c4\u683c\u7684\u6027\u80fd\u7684\u8981\u9ad850%~150%\u3002\u6240\u4ee5\uff0c\u5f53\u4f7f\u7528\u901a\u7528\u89c4\u683c\u9047\u5230\u4e86\u6027\u80fd\u6ce2\u52a8\u7684\u95ee\u9898\u7684\u65f6\u5019\uff0c\u5982\u679c\u5347\u7ea7\u5230\u72ec\u4eab\u89c4\u683c\uff0c\u5219\u9700\u8981\u6ce8\u610f\uff0c\u5373\u4f7f\u662f\u770b\u4f3c\u540c\u6837\u5927\u5c0f\u7684\u89c4\u683c\u7684\u5b9e\u4f8b\uff0c\u6027\u80fd\u53ef\u80fd\u4f1a\u76f8\u5dee\u5f88\u591a\u3002\u8fd9\u5c31\u662f\u9700\u8981\u83b7\u5f97\u66f4\u7a33\u5b9a\u6027\u80fd\u7684\u4ee3\u4ef7\uff0c\u4e0b\u56fe\u53ef\u4ee5\u66f4\u52a0\u6e05\u6670\u7684\u8be0\u91ca\u8fd9\u4e00\u70b9\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"610\" src=\"https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-38-1024x610.png\" alt=\"\" class=\"wp-image-10414\" style=\"width:619px;height:auto\" srcset=\"https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-38-1024x610.png 1024w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-38-300x179.png 300w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-38-768x458.png 768w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-38-1536x916.png 1536w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-38.png 1624w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\u963f\u91cc\u4e91\u7684\u6570\u636e\u5e93\u9009\u9879\u4e2d\uff0c\u8fd8\u53ef\u4ee5\u9009\u62e9\u6807\u51c6\u578b\u3001\u7ecf\u6d4e\u578b\u3002\u5173\u4e8e\u7ecf\u6d4e\u7248\u662f\u5982\u4f55\u201c\u7ecf\u6d4e\u7684\u201d\uff0c\u76ee\u524d\u963f\u91cc\u4e91\u5e76\u6ca1\u6709\u592a\u591a\u9610\u8ff0\u3002\u4e0d\u8fc7\uff0c\u6bd4\u8f83\u786e\u5b9a\u7684\u662f\uff0c\u7ecf\u6d4e\u7248\u5e76\u4e0d\u662f\u7b80\u5355\u4ec5\u5305\u542bARM\u5b9e\u4f8b\uff08<a href=\"https:\/\/help.aliyun.com\/zh\/rds\/product-overview\/product-types?spm=a2c4g.11186623.0.i11\">\u53c2\u8003<\/a>\uff09\u3002\u7ecf\u6d4e\u7248\u672c\uff0c\u5c1d\u8bd5\u901a\u8fc7\u66f4\u4f4e\u7684\u4ef7\u683c\u63d0\u4f9b\u66f4\u5f3a\u7684\u8ba1\u7b97\u80fd\u529b\uff0c\u4ed8\u51fa\u7684\u4ee3\u4ef7\u662f\u4ec0\u4e48\uff0c\u5e76\u6ca1\u6709\u592a\u591a\u8be6\u7ec6\u7684\u9610\u8ff0\uff0c\u53ef\u80fd\u4f1a\u5305\u62ec\u66f4\u6fc0\u70c8\u7684\u8d44\u6e90\u7ade\u4e89\u7b49\u3002\u5173\u4e8e\u6807\u51c6\u7248\u548c\u7ecf\u6d4e\u7248\u7684\u8be6\u7ec6\u7684\u5bf9\u6bd4\u53ef\u4ee5\u53c2\u8003\uff1a<a href=\"https:\/\/www.orczhou.com\/index.php\/2023\/11\/aliababa-cloud-rds-x86-vs-arm\/\">\u963f\u91cc\u4e91RDS\u6807\u51c6\u7248(x86) vs \u7ecf\u6d4e\u7248(ARM)\u6027\u80fd\u5bf9\u6bd4<\/a>\u3002<\/p>\n\n\n\n<p>\u5728\u963f\u91cc\u4e91\u5b9e\u4f8b\u7684\u8d2d\u4e70\u8fc7\u7a0b\u4e2d\uff0c\u8fd8\u6709\u4e00\u4e2a\u53c2\u6570\u6a21\u677f\u7684\u9009\u9879\u3002\u5171\u6709\u4e09\u7ec4\uff1a\u201c\u9ed8\u8ba4\u53c2\u6570\u6a21\u677f\u201d\u3001\u201c\u5f02\u6b65\u53c2\u6570\u6a21\u677f\u201d\u3001\u201c\u9ad8\u6027\u80fd\u53c2\u6570\u6a21\u677f\u201d\uff08<a href=\"https:\/\/help.aliyun.com\/zh\/rds\/apsaradb-rds-for-mysql\/use-a-parameter-template-to-configure-the-parameters-of-apsaradb-rds-for-mysql-instances\">\u53c2\u8003<\/a>\uff09\u3002\u5411\u7528\u6237\u63d0\u4f9b\u4e86\u53ef\u9760\u6027\u4e0e\u6027\u80fd\u7684\u5e73\u8861\u9009\u62e9\u3002\u6570\u636e\u53ef\u9760\u6027\u4e0a\uff1a\u201c\u9ed8\u8ba4\u53c2\u6570\u6a21\u677f\u201d &gt; \u201c\u5f02\u6b65\u53c2\u6570\u6a21\u677f\u201d &gt; \u201c\u9ad8\u6027\u80fd\u53c2\u6570\u6a21\u677f\u201d\uff0c\u6027\u80fd\u5219\u662f\u53cd\u8fc7\u6765\u7684\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"312\" src=\"https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-39-1024x312.png\" alt=\"\" class=\"wp-image-10416\" srcset=\"https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-39-1024x312.png 1024w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-39-300x91.png 300w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-39-768x234.png 768w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-39-1536x468.png 1536w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-39.png 1738w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"309\" src=\"https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-40-1024x309.png\" alt=\"\" class=\"wp-image-10417\" srcset=\"https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-40-1024x309.png 1024w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-40-300x90.png 300w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-40-768x231.png 768w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-40-1536x463.png 1536w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-40.png 1752w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading has-text-align-center has-text-color has-link-color wp-elements-9acb166e592c23f23f9718b9607bf211\" style=\"color:#0000ff\"><strong>Amazon RDS\u6027\u80fd\u8be6\u60c5<\/strong><\/h4>\n\n\n\n<p>Amazon RDS\u63d0\u4f9b\u4e86m6i\uff08<a href=\"https:\/\/aws.amazon.com\/ec2\/instance-types\/m6i\/\">\u7b2c\u4e09\u4ee3Intel Xeon\/Ice Lake\u5b9e\u4f8b<\/a>\uff09\u3001m5\uff08Xeon\u00ae Platinum 8175M or 8259CL\uff09\u3001Graviton 2\uff08\u5373m6g\uff09\u3001Graviton 3\uff08\u5373m7g\uff09\u8fd9\u56db\u79cd\u67b6\u6784\u9009\u62e9\uff0c\u5728\u6027\u80fd\u4e0a\u4e5f\u6709\u7740\u8f83\u4e3a\u76f4\u63a5\u7684\u5bf9\u5e94\u5173\u7cfb\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"896\" height=\"535\" src=\"https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-22.png\" alt=\"\" class=\"wp-image-10315\" srcset=\"https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-22.png 896w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-22-300x179.png 300w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-22-768x459.png 768w\" sizes=\"auto, (max-width: 896px) 100vw, 896px\" \/><\/figure>\n\n\n\n<p>\u6574\u4f53\u4e0a\uff0c\u4e2d\u3001\u4f4e\u5e76\u53d1\u65f6\uff0cm6g\u5b9e\u4f8b\uff08Graviton2\uff0c\u7b2c\u4e8c\u4ee3\u81ea\u7814ARM\u82af\u7247\u5b9e\u4f8b\uff09\u6027\u80fd\u7565\u5fae\u5dee\u4e00\u4e9b\u3002\u5176\u4ed6\u4e09\u4e2a\u89c4\u683c\u6027\u80fd\u8f83\u4e3a\u63a5\u8fd1\u3002\u5728\u9ad8\u5e76\u53d1\uff0c\u5c24\u5176\u662f\u8d85\u9ad8\u5e76\u53d1\u65f6\uff0cm7g\u5b9e\u4f8b\uff08Graviton3\uff0c\u7b2c\u4e09\u4ee3\u81ea\u7814ARM\u82af\u7247\u5b9e\u4f8b\uff09\u8868\u73b0\u51fa\u4e86\u66f4\u5f3a\u5927\u6269\u5c55\u6027\uff0c\u6027\u80fd\u76f8\u6bd4\u4e8em6g\u9ad8\u51fa\u7ea645%\u5de6\u53f3\u3002<\/p>\n\n\n\n<p>\u975e\u5e38\u660e\u663e\u7684\uff0c\u65e0\u8bba\u662fx86\u8fd8\u662fARM\uff08Graviton\uff09\uff0c\u65b0\u4e00\u4ee3\u7684\u5b9e\u4f8b\u603b\u662f\u6709\u7740\u66f4\u597d\u7684\u6027\u80fd\u8868\u73b0\uff0c\u5e76\u4e14\u901a\u5e38\u65b0\u3001\u65e7\u5b9e\u4f8b\u4ef7\u683c\u662f\u5dee\u4e0d\u591a\u7684\uff0c\u6709\u65f6\u5019\u65b0\u4e00\u4ee3\u4ef7\u683c\u8fd8\u4f1a\u66f4\u52a0\u4fbf\u5b9c\u3002\u6240\u4ee5\uff0c<strong>\u9009\u62e9\u65b0\u4e00\u4ee3\u5b9e\u4f8b\u603b\u662f\u53ef\u4ee5\u83b7\u5f97\u66f4\u597d\u7684\u6027\u4ef7\u6bd4<\/strong>\u3002\u5373m7g\u51e0\u4e4e\u5168\u9762\u4f18\u4e8em6g\uff0cx6i\u5168\u9762\u4f18\u4e8em5\u3002\u867d\u7136\u8fd9\u4f3c\u4e4e\u662f\u4e00\u4e2a\u201c\u5e73\u51e1\u201d\u7684\u7ed3\u8bba\uff0c\u4f46\u8fd9\u91cc\u4f9d\u65e7\u901a\u8fc7benchmark\u7684\u65b9\u5f0f\u786e\u5b9a\u4e86\u8fd9\u4e00\u70b9\u3002<\/p>\n\n\n\n<p>\u6b64\u5916\uff0c\u4ece\u5f53\u524d\u7684\u6d4b\u8bd5\u6765\u770b\uff0c\u5728RDS\u7684\u573a\u666f\u4e0b\uff0c\u4f9d\u65e7\u662fx86\u89c4\u683c\uff08\u5bf9\u6bd4Graviton\/ARM\uff09\u66f4\u52a0\u5408\u9002\u3002\u65e0\u8bba\u662f\u6027\u80fd\u8fd8\u662f\u6298\u7b97\u540e\u7684\u6027\u4ef7\u6bd4\uff0c<strong>Intel x86\u89c4\u683c\u90fd\u662f\u66f4\u597d\u7684\u9009\u62e9\uff0c\u5bf9\u5e94\u7684\uff0c\u4e5f\u5c31\u662f<code>db.m6i<\/code>\u89c4\u683c\u662f\u5f53\u524dAmazon RDS\u6700\u5177\u6027\u4ef7\u6bd4\u7684\u89c4\u683c<\/strong>\u3002<\/p>\n\n\n\n<p>\u53e6\u5916\uff0c\u4e5f\u6ce8\u610f\u5230\uff0cAmazon RDS\u5728\u524d\u9762\u7684\u201c\u4f01\u4e1a\u7ea7\u89c4\u683c\u201d\u6027\u80fd\u5bf9\u6bd4\u4e2d\uff0c\u8868\u73b0\u7684\u5e76\u4e0d\u7b97\u597d\u3002\u5c24\u5176\u662f\u5728\u4f4e\u5e76\u53d1\u65f6\uff0c\u51e0\u4e4e\u662f\u6027\u80fd\u57ab\u5e95\u7684\uff0c\u8fd9\u4e0e\u5176\u5728\u662f\u4e91\u8ba1\u7b97\u8001\u5927\u7684\u5730\u4f4d\u4f3c\u4e4e\u662f\u4e0d\u7b26\u5408\u7684\u3002\u8fd9\u80cc\u540e\u7684\u539f\u56e0\uff0c\u540e\u7eed\u8fd8\u5c06\u518d\u505a\u66f4\u591a\u89e3\u6790\u3002<\/p>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading has-text-align-center has-text-color has-link-color wp-elements-2058aadcf6f757bd5925b5264d0728c2\" style=\"color:#0000ff\"><strong>Google\u4e91Cloud SQL(RDS)\u7684\u6027\u80fd<\/strong><\/h4>\n\n\n\n<p>\u8c37\u6b4c\u4e91\u63d0\u4f9b\u7684RDS\uff08\u5728Google\u4e91\u53ebCloud SQL\uff09\u9009\u9879\u6bd4\u8f83\u7b80\u5355\uff0c\u4e3b\u8981\u7684\u9009\u9879\u4e2d\uff0c\u4ec5\u6709\u201cEnterprise\u201d\u7248\u548c\u201cEnterprise Plus\u201d\u7248\uff0c\u8fd9\u4e24\u4e2a\u7248\u672c\u6700\u4e3b\u8981\u7684\u533a\u522b\u662f\u201cPlus\u201d\u7248\u63d0\u4f9b\u4e86\u989d\u5916\u7684\u201cData Cache\u80fd\u529b\u201d\uff0c\u8be5\u80fd\u529b\u901a\u8fc7\u672c\u5730\u7684SSD\u53ef\u4ee5\u52a0\u901f\u6570\u636e\u5e93\u66f4\u591a\u7684\u201c\u51b7\u201d\u6570\u636e\u8bbf\u95ee\uff0c\u5173\u4e8e\u8fd9\u4e24\u4e2a\u7248\u672c\u7684\u8be6\u7ec6\u8bf4\u660e\u53ef\u4ee5\u53c2\u8003\u4e4b\u524d\u7684\u6587\u7ae0\uff1a<a href=\"https:\/\/www.orczhou.com\/index.php\/2023\/08\/google-cloud-sql-enterprise-enterprise-plus\/\">Google Cloud SQL for MySQL\u7684\u201dEnterprise\u201d\u548c\u201dEnterprise Plus\u201d\u7248\u672c<\/a>\u3002\u6839\u636e\u8fd9\u7bc7\u6587\u7ae0\u7684\u5bf9\u6bd4\uff0c\u4e5f\u6ce8\u610f\u5230Plus\u7684\u4ef7\u683c\u4e5f\u8981\u9ad8\u51fa30%\u5de6\u53f3\u3002\u8fd9\u91cc\uff0c\u6211\u4eec\u6765\u770b\u770b\u4ed6\u4eec\u7684\u6027\u80fd\u5dee\u522b\u3002<\/p>\n\n\n\n<p>\u9700\u8981\u7279\u522b\u63d0\u5230\u7684\u662f\uff0cEnterprise\u7684\u6d4b\u8bd5\u4f7f\u7528\u76844vCPU16GB\u7684\u89c4\u683c\uff0c\u4e0e\u5176\u4ed6\u4e91\u7684\u6d4b\u8bd5\u89c4\u683c\u662f\u4e00\u81f4\u7684\u3002\u4f46\uff0c\u56e0\u4e3a\u201cEnterprise Plus\u201d\u6ca1\u6709\u8be5\u89c4\u683c\u7684\uff0c\u4e8e\u662f\u4f7f\u7528\u4e86\u6700\u4e3a\u63a5\u8fd1\u76844vCPU32GB\u89c4\u683c\u66ff\u4ee3\u3002\u56e0\u4e3a\u8fd9\u91cc\u7684\u6d4b\u8bd5\uff0c\u4e3b\u8981\u74f6\u9888\u5728\u4e8eCPU\u548cIO\uff0c\u5185\u5b58\u589e\u52a0\u7684\u5bf9\u4e8e\u6027\u80fd\u7684\u5f71\u54cd\u662f\u6709\u9650\u7684\u3002<\/p>\n\n\n\n<p>\u8be6\u7ec6\u7684\u6027\u80fd\u5bf9\u6bd4\u53c2\u8003\u4e0b\u56fe\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"724\" height=\"435\" src=\"https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-31.png\" alt=\"\" class=\"wp-image-10359\" srcset=\"https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-31.png 724w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-31-300x180.png 300w\" sizes=\"auto, (max-width: 724px) 100vw, 724px\" \/><\/figure>\n\n\n\n<p>\u53ef\u4ee5\u770b\u5230\uff0c\u5728\u4f4e\u5e76\u53d1\u65f6\uff0c\u666e\u901a\u7684Enterprise\u7248\u672c\u6027\u80fd\u53cd\u800c\u66f4\u597d\u3002\u53ea\u6709\u5728\u4e2d\u3001\u9ad8\u5e76\u53d1\u65f6\uff08\u5e76\u53d1\u9ad8\u4e8e24\uff09\uff0cEnterprise Plus\u7248\u672c\u624d\u8868\u73b0\u66f4\u597d\u7684\u6027\u80fd\uff0c\u6700\u540e\uff0c\u572864\u5e76\u53d1\u4ee5\u4e0a\u7684\u65f6\u5019\uff0cEnterprise Plus\u6027\u80fd\u76f8\u6bd4\u4e0eEnterprise\u7248\u672c\uff0c\u8981\u9ad8\u51fa\u7ea675%\u4ee5\u4e0a\u3002<\/p>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading has-text-align-center has-text-color has-link-color wp-elements-9fd7653248c7d1aa66922b8e065d113e\" style=\"color:#0000ff\"><strong>Azure Database for MySQL<\/strong>\uff08RDS\uff09\u7684\u6027\u80fd<\/h4>\n\n\n\n<p>\u5fae\u8f6f\u7684MySQL\u6258\u7ba1\u670d\u52a1\u5b8c\u6574\u540d\u79f0\u53eb\uff1a\u201cAzure Database for MySQL flexible server\u201d\uff0c\u81f3\u4e8e\u4e3a\u4ec0\u4e48\u53eb\u201cFlexible Server\u201d\uff0c\u53ef\u4ee5\u4ee5\u53c2\u8003\uff1a<a href=\"https:\/\/www.orczhou.com\/index.php\/2021\/11\/about-azure-oss-flexible-server\/\">Azure\u6570\u636e\u5e93\u7684Flexible Server<\/a>\u3002<\/p>\n\n\n\n<p>\u5fae\u8f6f\u7684Azure\u4e91\u53d1\u5c55\u8981\u7565\u5fae\u665a\u4e00\u4e9b\uff0c\u4e0d\u8fc7\u52bf\u5934\u662f\u975e\u5e38\u731b\u7684\uff0c\u7b97\u662f\u540e\u6765\u5c45\u4e0a\u3002\u5728\u6700\u65b0\u7684Gartner\u4e91\u9b54\u529b\u8c61\u9650\u4e2d\uff0c\u51ed\u501f\u5176\u5728AI\u9886\u57df\u7684\u6295\u8d44\u4e0e\u5e03\u5c40\uff0c\u5927\u6709\u5168\u9762\u8d76\u8d85AWS\u7684\u8d8b\u52bf\u3002\u8fd9\u6b21\uff0c\u6211\u4eec\u4e5f\u4e00\u8d77\u6765\u770b\u770bAzure\u6258\u7ba1MySQL\u7684\u6027\u80fd\u5982\u4f55\u3002<\/p>\n\n\n\n<p>Azure\u4e91\u4e0a\u8d2d\u4e70\u6258\u7ba1MySQL\u7684\u9009\u9879\uff08\u4e0e\u6570\u636e\u5e93\u6709\u5173\u7684\uff09\u5e94\u8be5\u662f\u6bd4\u8f83\u7b80\u5355\u7684\u3002\u4e3b\u8981\u7684\u9009\u578b\u5305\u62ec\uff0c\u662f\u5426\u9700\u8981\u53ef\u7528\u533a\u5bb9\u707e\u3001IOPS\u7c7b\u578b\u9009\u62e9\u3001Intel\u8fd8\u662fAMD\u5e73\u53f0\u3002\u5728\u672c\u6b21\u6d4b\u8bd5\u4e2d\uff0c\u9009\u62e9\u4e86US East\u5730\u533a\uff0c\u9009\u62e9\u4e86\u8de8\u53ef\u7528\u533a\u7684\u5bb9\u707e\uff08Zone redundant\uff09\uff0c\u4f7f\u7528\u9884\u7559\u7684IOPS\uff0c\u9884\u7559\u503c\u4e3a3000\uff0c\u4f7f\u7528\u7684Intel\u7684CPU\uff0c\u5b9e\u4f8b\u89c4\u683c\u4e3a4vCPU16GB\u5185\u5b58\u3002\u89c4\u683c\u4ee3\u7801\u4e3a<code>D4ds_v4<\/code>\u3002\u8be6\u7ec6\u7684\u6d4b\u8bd5\u6027\u80fd\u8d8b\u52bf\u56fe\u5982\u4e0b\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<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"780\" src=\"https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-33.png\" alt=\"\" class=\"wp-image-10374\" srcset=\"https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-33.png 1024w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-33-300x229.png 300w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-33-768x585.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"785\" src=\"https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-34-1024x785.png\" alt=\"\" class=\"wp-image-10375\" srcset=\"https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-34-1024x785.png 1024w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-34-300x230.png 300w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-34-768x589.png 768w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2023\/12\/image-34.png 1028w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n<\/div>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading has-text-align-center has-text-color has-link-color wp-elements-c74d73a94d9f0d7c1ab8ed101268bc32\" style=\"color:#0000ff\"><strong>\u8de8\u4e91\u8fc1\u79fb\u65f6\u7684\u6027\u80fd\u8003\u8651<\/strong><\/h4>\n\n\n\n<p>\u6ce8\u610f\u5230\uff0c\u4e0d\u540c\u7684\u4e91\u5382\u5546\u6027\u80fd\u5dee\u5f02\u662f\u975e\u5e38\u5927\u7684\u3002\u4f8b\u5982\uff0c\u5728\u6700\u524d\u9762\u7684\u6027\u80fd\u5bf9\u6bd4\u56fe\u4e2d\u53ef\u4ee5\u770b\u5230\uff0c\u534e\u4e3a\u4e91\u7684\u201c\u4f01\u4e1a\u7ea7\u89c4\u683c\u201d\u6027\u80fd\u76f8\u5f53\u4e8e\u963f\u91cc\u4e91\u6216\u8c37\u6b4c\u4e91\u7684\u4e24\u500d\u3002\u90a3\u4e48\uff0c\u5f53\u8003\u8651\u6570\u636e\u5e93\u5728\u534e\u4e3a\u4e91\u548c\u963f\u91cc\u4e91\u4e4b\u95f4\u8fc1\u79fb\u7684\u65f6\u5019\uff0c\u5219\u9700\u8981\u7ed3\u5408\u6570\u636e\u5e93\u7684\u4e1a\u52a1\u652f\u6491\u80fd\u529b\u4e0e\u6210\u672c\u8fdb\u884c\u7efc\u5408\u8bc4\u4f30\uff0c\u518d\u5f00\u59cb\u505a\u8fc1\u79fb\u89c4\u5212\u3002<\/p>\n\n\n\n<p>\u5728\u8003\u8651\u8fc1\u79fb\u5230\u963f\u91cc\u4e91\u65f6\uff0c\u9664\u4e86\u8003\u8651\u201c\u4f01\u4e1a\u7ea7\u89c4\u683c\u201d\u7684\u6027\u80fd\u5916\uff0c\u963f\u91cc\u4e91\u8fd8\u63d0\u4f9b\u4e86\u975e\u5e38\u4e30\u5bcc\u7684\u5b9e\u4f8b\u7c7b\u578b\u9009\u62e9\u3002\u5f00\u53d1\u8005\u548c\u4f01\u4e1a\u53ef\u4ee5\u6839\u636e\u4e0d\u540c\u7684\u4e1a\u52a1\u7c7b\u578b\uff0c\u53ef\u4ee5\u8003\u8651\u5728\u6570\u636e\u53ef\u9760\u6027\u4e0a\u505a\u6781\u5176\u8f7b\u5fae\u7684\u8ba9\u6b65\uff0c\u4ee5\u83b7\u5f97\u6570\u500d\u7684\u6027\u80fd\u63d0\u5347\u3002<\/p>\n\n\n\n<h4 class=\"wp-block-heading has-text-align-center has-text-color has-link-color wp-elements-205b2893eb2de5760709f7463cac52ad\" style=\"color:#0000ff\"><strong>\u6d4b\u8bd5\u4e0e\u5bf9\u6bd4\u89c4\u683c\u9009\u62e9\u8bf4\u660e<\/strong><\/h4>\n\n\n\n<p>\u6bcf\u4e2a\u4e91\u6570\u636e\u5e93\u5382\u5546\u90fd\u6709\u7740\u4e0d\u540c\u7684\u7248\u672c\u548c\u5b9a\u5236\u53c2\u6570\uff0c\u5bf9\u4e8e\u4f01\u4e1a\u6765\u8bf4\uff0c\u6bd4\u8f83\u5e38\u7528\u7684\u89c4\u683c\u7c7b\u578b\u5305\u542b\u5982\u4e0b\u5171\u540c\u70b9\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u662f\u4e3b\u6d41\u7684\u6570\u636e\u5e93\u7248\u672c\uff0c\u8fd9\u91cc\u9009\u62e9\u4e86\u4e0d\u540c\u5382\u5546\u7684MySQL 8.0\u8fdb\u884c\u6d4b\u8bd5<\/li>\n\n\n\n<li>\u5728CPU\u67b6\u6784\u4e0a\uff0c\u5219\u9009\u62e9\u4e86\u66f4\u4e3a\u901a\u7528\u7684x86\u67b6\u6784<\/li>\n\n\n\n<li>\u5177\u5907\u9ad8\u53ef\u7528\u80fd\u529b\uff0c\u6240\u4ee5\u963f\u91cc\u4e91\u534e\u4e3a\u4e91\u90fd\u9009\u62e9\u4e86\u9ad8\u53ef\u7528\/\u4e3b\u5907\u7248\u672c\uff0cAWS\/\u8c37\u6b4c\u4e91\u90fd\u5219\u9009\u62e9\u4e86\u591a\u53ef\u7528\u533a\u7248\u672c<\/li>\n\n\n\n<li>\u6570\u636e\u5e93\u53ef\u9760\u6027\u548c\u201c\u96f6\u6570\u636e\u4e22\u5931\u201d\u90fd\u8981\u6709\u975e\u5e38\u5f3a\u7684\u4fdd\u969c\uff0c\u6240\u4ee5\u963f\u91cc\u4e91\u9009\u62e9\u4e86\u4f7f\u7528&#8221;\u9ed8\u8ba4\u53c2\u6570\u6a21\u677f&#8221;\uff1bAWS\u548c\u8c37\u6b4c\u4e91\u7684\u591a\u53ef\u7528\u533a\u7248\u672c\uff0c\u5df2\u7ecf\u5177\u5907\u4e86\u8fd9\u4e9b\u80fd\u529b<\/li>\n\n\n\n<li>\u5bf9\u4e8e\u4f01\u4e1a\u6765\u8bf4\uff0c\u5c24\u5176\u662f\u8f83\u4e3a\u6838\u5fc3\u7684\u6570\u636e\u5e93\uff0c\u9009\u62e9\u4e00\u4e2a\u6027\u80fd\u7a33\u5b9a\u7684\u6570\u636e\u5e93\u4e5f\u975e\u5e38\u91cd\u8981\uff0c\u6240\u4ee5\u8fd9\u91cc\u963f\u91cc\u4e91\u548c\u534e\u4e3a\u4e91\u5747\u9009\u62e9\u4e86\u72ec\u4eab\u89c4\u683c\u8fdb\u884c\u6bd4\u8f83<\/li>\n<\/ul>\n\n\n\n<p>\u5f53\u7136\uff0c\u4e0d\u540c\u4e91\u5382\u5546\u4f7f\u7528\u7684\u7cfb\u7edf\u67b6\u6784\u3001\u6570\u636e\u5e93\u7248\u672c\u3001\u5b89\u88c5\u53c2\u6570\u7b49\u5404\u6709\u4e0d\u540c\uff0c\u5e76\u6ca1\u6709\u4e00\u4e2a\u7edf\u4e00\u7684\u6807\u51c6\u3002\u8fd9\u91cc\u6311\u9009\u7684\u89c4\u683c\u7c7b\u578b\u4e0e\u53c2\u6570\u4e5f\u662f\u8f83\u591a\u4f01\u4e1a\u7684\u9009\u62e9\u7684\u7248\u672c\uff0c\u6240\u4ee5\uff0c\u8fd9\u4e2a\u6d4b\u8bd5\u4f9d\u65e7\u6709\u7740\u975e\u5e38\u5f3a\u7684\u53c2\u52a0\u4ef7\u503c\u3002<\/p>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading has-text-align-center has-text-color has-link-color wp-elements-3fe4208abbb3c2ff4ef22f3456d36a30\" style=\"color:#0000ff\"><strong>\u6d4b\u8bd5\u65b9\u6cd5\u8bf4\u660e<\/strong><\/h4>\n\n\n\n<p>\u8fd9\u91cc\u4f7f\u7528\u4e86sysbench\u7684\u8bfb\u5199\u6df7\u5408\u6a21\u578b\uff08oltp_read_write\uff09\u8fdb\u884c\u6d4b\u8bd5\uff0c\u5355\u8868\u5927\u5c0f\u4e3a100\u4e07\uff0c\u5171\u5341\u4e2a\u8868\uff0c\u5355\u6b21\u6d4b\u8bd5\u65f6\u957f\u4e3a300\u79d2\uff0c\u5206\u522b\u6d4b\u8bd5\u4e86\u5982\u4e0b\u7684\u5e76\u53d1\u5ea6\u7684\u6027\u80fd\u8868\u73b0\uff1a2\u30014\u30018\u300116\u300124\u300132\u300148\u300164\u300196\u3001128\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">        sysbench oltp_read_write --threads=$conthread --time=$run_time \\\n        --report-interval=3 --percentile=95 --histogram=on \\\n        --table_size=$table_size --tables=$tables run<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading has-text-align-center has-text-color has-link-color wp-elements-8e5d32344a6bcb5b2f8fc8e9680b7bae\" style=\"color:#0000ff\"><strong>\u9650\u5236\u4e0e\u8865\u5145\u8bf4\u660e<\/strong><\/h4>\n\n\n\n<p>\u672c\u8282\u5bf9\u5728\u6d4b\u8bd5\u8fc7\u7a0b\u4e2d\u7684\u4e00\u4e9b\u9650\u5236\u8fdb\u884c\u8865\u5145\u8bf4\u660e\uff0c\u4f9b\u53c2\u8003\u3002<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u672c\u6b21\u6d4b\u8bd5\uff0c\u5730\u57df\u9009\u62e9\u8f83\u4e3a\u968f\u673a\uff0c\u4f8b\u5982\u963f\u91cc\u4e91\u9009\u62e9\u4e86\u676d\u5dde\u3001\u767e\u5ea6\u4e91\u9009\u62e9\u5317\u4eac\u3001AWS\/\u8c37\u6b4c\u4e91\u9009\u62e9\u4e86\u4e1c\u4eac\u3001Azure\u4e91\u9009\u62e9\u4e86\u7f8e\u4e1c\u7b49\u3002\u8fd9\u91cc\u7684\u4e00\u4e2a\u5047\u8bbe\u662f\uff0c\u5404\u4e2a\u533a\u57df\u7684\u6027\u80fd\u5e94\u8be5\u662f\u76f8\u540c\u6216\u8005\u63a5\u8fd1\u7684\u3002<\/li>\n\n\n\n<li>\u9650\u5236\u65f6\u95f4\u4e0e\u8d44\u6e90\u9650\u5236\uff0c\u8fd9\u91cc\u4ec5\u5bf9\u8f83\u4e3a\u5e38\u7528\u76844vCPU16GB\u7684\u89c4\u683c\u8fdb\u884c\u6d4b\u8bd5\uff0c\u5355\u6b21\u5e76\u53d1\u6d4b\u8bd5\u6301\u7eed\u65f6\u95f4\u4e3a300\u79d2\u3002<\/li>\n\n\n\n<li>\u867d\u7136\u90fd\u662f\u7528MySQL 8.0\u7248\u672c\uff0c\u4f46\u662f\u4e0d\u540c\u7684\u5382\u5546\u7684\u6570\u636e\u5e93\u5c0f\u7248\u672c\u4e5f\u4f1a\u4e0d\u540c\u3002<\/li>\n\n\n\n<li>\u4e0d\u540c\u5382\u5546\u7684CPU\u3001\u78c1\u76d8\u7c7b\u578b\u3001\u4ef7\u683c\u7b49\u5404\u6709\u4e0d\u540c\uff0c\u6240\u4ee5\u8fd9\u4e0d\u662f\u4e00\u4e2a\u5b8c\u5168\u5bf9\u7b49\u7684\u6d4b\u8bd5\uff0c\u4e5f\u4e0d\u53ef\u80fd\u662f\u3002<\/li>\n\n\n\n<li>\u4e0d\u540c\u5382\u5546\u7684RDS\u5b9e\u4f8b\u7684\u9ed8\u8ba4\u53c2\u6570\u6a21\u677f\u4e5f\u5404\u6709\u4e0d\u540c\uff0c\u751a\u81f3\u540c\u4e00\u4e2a\u5382\u5546\u5728\u4e0d\u540c\u9636\u6bb5\u7684\u53c2\u6570\u4e5f\u53ef\u80fd\u4f1a\u6709\u8c03\u6574\u3002<\/li>\n\n\n\n<li>\u6709\u7684\u4e91\u5382\u5546\u7684\u78c1\u76d8\u5b58\u50a8\u6709\u7740\u591a\u79cd\u4e0d\u540c\u7684\u9009\u62e9\uff0c\u4f8b\u5982\u963f\u91cc\u4e91\u652f\u6301ESSD PL1\/2\/3\uff0cAWS\u4e5f\u652f\u6301gp3\/io1\u7c7b\u578b\u7684\u5b58\u50a8\u9009\u62e9\uff0c\u4e0d\u540c\u7684\u5b58\u50a8\u9009\u62e9\u4e5f\u4f1a\u5bf9\u5e94\u8fd9\u4e2a\u4e0d\u540c\u7684\u6027\u80fd\u3002<\/li>\n\n\n\n<li>\u5173\u4e8e\u53ef\u7528\u533a\u7684\u9009\u62e9\uff1a\u5728\u6d4b\u8bd5\u4e2d\uff0c\u6211\u5c3d\u91cf\u4f1a\u5c06\u6d4b\u8bd5\u7684ECS\/EC2\/VM\u7b49\u4e0e\u6570\u636e\u5e93\u4e3b\u8282\u70b9\u653e\u5728\u540c\u4e00\u4e2a\u53ef\u7528\u533a\u3002\u4f46\u4f9d\u65e7\u6709\u4e00\u4e9b\u60c5\u51b5\u505a\u4e0d\u5230\u8fd9\u4e00\u70b9\u3002\u4f8b\u5982\u5728\u8fd9\u6b21\u7684\u6d4b\u8bd5\u8fc7\u7a0b\u4e2d\uff0cGCP\u5728\u4e1c\u4eac\u5730\u533ab\u53ef\u7528\u533a\uff0c\u867d\u7136\u53ef\u4ee5\u521b\u5efa\u6570\u636e\u5e93\uff0c\u4f46\u662f\u5374\u6ca1\u6709\u8d44\u6e90\u521b\u5efaVM\u8282\u70b9\uff08\u201cA n2-highcpu-8 VM instance is currently unavailable in the asia-northeast1-b zone.\u201d\uff09\u3002<\/li>\n<\/ul>\n\n\n\n<p>\u867d\u7136\uff0c\u6709\u8fd9\u4e9b\u9650\u5236\uff0c\u4f46\u662f\u7b14\u8005\u4f9d\u65e7\u8ba4\u4e3a\uff0c\u975e\u5e38\u660e\u663e\u7684\uff0c\u8fd9\u4e9b\u6d4b\u8bd5\u7684\u6570\u636e\u4f9d\u65e7\u53ef\u4ee5\u7ed9\u4e0e\u5f00\u53d1\u8005\/\u4f01\u4e1a\u5728\u505a\u6570\u636e\u5e93\u9009\u578b\u65f6\u4ee5\u975e\u5e38\u91cd\u8981\u7684\u53c2\u8003\u3002\u5982\u679c\u6709\u66f4\u591a\u5efa\u8bae\uff0c\u53ef\u4ee5\u5728\u672c\u6587\u540e\u7559\u4e0b\u4f60\u7684\u5efa\u8bae\uff0c\u4ee5\u4f9b\u540e\u7eed\u53c2\u8003\u4e0e\u6539\u8fdb\u3002<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>\u53c2\u8003\u6587\u6863\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/help.aliyun.com\/zh\/rds\/product-overview\/instance-families\">\u4e91\u6570\u636e\u5e93 RDS \u5b9e\u4f8b\u89c4\u683c\u65cf@\u963f\u91cc\u4e91<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/cloud.tencent.com\/document\/product\/236\/30304\" target=\"_blank\" rel=\"noreferrer noopener\">\u4e91\u6570\u636e\u5e93-\u4f7f\u7528\u53c2\u6570\u6a21\u677f@\u817e\u8baf\u4e91<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/cloud.tencent.com\/document\/product\/236\/93462\">\u4e91\u6570\u636e\u5e93MySQL \u9009\u578b\u6307\u5357@\u817e\u8baf\u4e91<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.orczhou.com\/index.php\/a-graph-of-alibaba-cloud-database-rds-architecture\/\">\u4e00\u5f20\u56fe\u8bfb\u61c2\u963f\u91cc\u4e91\u6570\u636e\u5e93RDS\u67b6\u6784\u4e0e\u9009\u578b<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.orczhou.com\/index.php\/2023\/11\/aliababa-cloud-rds-x86-vs-arm\/\">\u963f\u91cc\u4e91RDS\u6807\u51c6\u7248(x86) vs \u7ecf\u6d4e\u7248(ARM)\u6027\u80fd\u5bf9\u6bd4<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/aws.amazon.com\/ec2\/instance-types\/m6i\/\">Amazon EC2 M6i Instances<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.orczhou.com\/index.php\/2023\/08\/google-cloud-sql-enterprise-enterprise-plus\/\">Google Cloud SQL for MySQL\u7684\u201dEnterprise\u201d\u548c\u201dEnterprise Plus\u201d\u7248\u672c<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.orczhou.com\/index.php\/2021\/11\/about-azure-oss-flexible-server\/\">Azure\u6570\u636e\u5e93\u7684Flexible Server<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\u4e00\u76f4\u90fd\u5728\u975e\u5e38\u6df1\u5ea6\u8c03\u7814\u3001\u5173\u6ce8\u548c\u4f7f\u7528\u4e91\u6570\u636e\u5e93\uff0c\u5176\u4e2d\u6027\u80fd\u662f\u5173\u6ce8\u7684\u91cd\u70b9\u4e4b\u4e00\u3002\u4e00\u65b9\u9762\u6027\u80fd\u662f\u6700\u7ec8\u6210\u672c\u7684\u91cd\u8981\u5f71\u54cd\u56e0\u7d20\uff0c\u66f4\u597d\u7684\u6027\u80fd\uff0c\u901a\u5e38\u610f\u5473\u7740\u4f7f\u7528\u66f4\u5c11\u7684\u8d44\u6e90\u652f\u6491\u66f4\u9ad8\u7684\u4e1a\u52a1\u91cf\uff0c\u4ece\u800c\u964d\u4f4e\u6574\u4f53\u6210\u672c\u3002\u53e6\u5916\uff0c\u6027\u80fd\u8fd8\u610f\u5473\u7740\u5728\u6781\u7aef\u573a\u666f\u4e0b\uff0c\u6570\u636e\u5e93\u7684\u4e0a\u9650\u652f\u6491\u80fd\u529b\u3002 \u6240\u4ee5\uff0c\u8fd1\u671f\u5bf9\u5404\u4e2a\u4e91\u6570\u636e\u5e93\u5382\u5546\u505a\u4e86\u4e00\u4e2a\u8f83\u4e3a\u7cfb\u7edf\u7684\u6027\u80fd\u5bf9\u6bd4\uff0c\u4f9b\u5f00\u53d1\u8005\u548c\u4f01\u4e1a\u5728\u4e91\u6570\u636e\u5e93\u9009\u578b\u65f6\u7684\u53c2\u8003\u3002 \u603b\u89c8\uff1a\u4e91\u6570\u636e\u5e93\u6027\u80fd\u5bf9\u6bd4 \u5728\u8fdb\u884c\u5927\u91cf\u6d4b\u8bd5\u4e4b\u540e\uff0c\u5bf9\u4e3b\u8981\u7684\u4e91\u5382\u5546\u5206\u522b\u9009\u62e9\u4e86\u4e00\u4e2a\u201c\u4f01\u4e1a\u7ea7\u89c4\u683c\u201d\uff08\u9002\u5408\u751f\u4ea7\u73af\u5883\u914d\u7f6e\u7684\uff09\u8fdb\u884c\u4e86\u5bf9\u6bd4\u3002\u5148\u770b\u6027\u80fd\u5bf9\u6bd4\u5982\u4e0b\u56fe\uff1a \u53ef\u4ee5\u770b\u5230\uff1a<\/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,1],"tags":[],"class_list":["post-10302","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\/10302","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=10302"}],"version-history":[{"count":81,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/posts\/10302\/revisions"}],"predecessor-version":[{"id":17586,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/posts\/10302\/revisions\/17586"}],"wp:attachment":[{"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/media?parent=10302"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/categories?post=10302"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/tags?post=10302"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}