{"id":3308,"date":"2021-01-11T17:12:41","date_gmt":"2021-01-11T09:12:41","guid":{"rendered":"https:\/\/www.gbase8.cn\/?p=3308"},"modified":"2021-04-07T10:11:25","modified_gmt":"2021-04-07T02:11:25","slug":"gbase-8a%e8%b5%84%e6%ba%90%e7%ae%a1%e6%8e%a7%e8%b5%84%e6%ba%90%e7%ae%a1%e7%90%86%e7%9a%84%e4%bb%8b%e7%bb%8d","status":"publish","type":"post","link":"https:\/\/www.gbase8.cn\/en\/3308","title":{"rendered":"\u5357\u5927\u901a\u7528GBase 8a\u8d44\u6e90\u7ba1\u63a7\u8d44\u6e90\u7ba1\u7406\u7684\u4ecb\u7ecd"},"content":{"rendered":"\n<p>\u672c\u6587\u4ecb\u7ecdGBase 8a\u6570\u636e\u5e93\u96c6\u7fa4\u91cc\uff0c\u5bf9\u8d44\u6e90\u7ba1\u7406\u7684\u529f\u80fd\u4ecb\u7ecd\u3002\u901a\u8fc7\u5bf9\u7cfb\u7edfCPU\uff0c\u5185\u5b58\uff0c\u78c1\u76d8\u7b49\u8d44\u6e90\u7684\u4f7f\u7528\u63a7\u5236\uff0c\u5728\u591a\u7528\u6237\u4e0b\u5b9e\u73b0\u8d44\u6e90\u8c03\u5ea6\u548c\u5e73\u8861\u3002<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">\u76ee\u5f55\u5bfc\u822a<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a2a9d5786738\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a2a9d5786738\"  aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.gbase8.cn\/en\/3308\/#%E5%8F%82%E8%80%83\" >\u53c2\u8003<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.gbase8.cn\/en\/3308\/#%E8%B5%84%E6%BA%90%E7%AE%A1%E6%8E%A7%E7%9A%84%E5%AF%B9%E8%B1%A1\" >\u8d44\u6e90\u7ba1\u63a7\u7684\u5bf9\u8c61<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.gbase8.cn\/en\/3308\/#%E8%B5%84%E6%BA%90%E7%AE%A1%E6%8E%A7%E6%9E%B6%E6%9E%84\" >\u8d44\u6e90\u7ba1\u63a7\u67b6\u6784<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.gbase8.cn\/en\/3308\/#%E8%B5%84%E6%BA%90%E7%AE%A1%E7%90%86%E4%BD%BF%E7%94%A8%E6%B5%81%E7%A8%8B\" >\u8d44\u6e90\u7ba1\u7406\u4f7f\u7528\u6d41\u7a0b<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.gbase8.cn\/en\/3308\/#%E7%8E%AF%E5%A2%83%E8%A6%81%E6%B1%82\" >\u73af\u5883\u8981\u6c42<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.gbase8.cn\/en\/3308\/#%E5%88%9B%E5%BB%BA%E5%92%8C%E7%AE%A1%E7%90%86_Consumer_Group\" >\u521b\u5efa\u548c\u7ba1\u7406 Consumer Group<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.gbase8.cn\/en\/3308\/#%E5%88%9B%E5%BB%BA\" >\u521b\u5efa<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.gbase8.cn\/en\/3308\/#%E6%9B%B4%E6%94%B9%E5%90%8D%E7%A7%B0\" >\u66f4\u6539\u540d\u79f0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.gbase8.cn\/en\/3308\/#%E6%9B%B4%E6%94%B9%E6%8F%8F%E8%BF%B0\" >\u66f4\u6539\u63cf\u8ff0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.gbase8.cn\/en\/3308\/#%E5%88%A0%E9%99%A4\" >\u5220\u9664<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/www.gbase8.cn\/en\/3308\/#%E7%94%A8%E6%88%B7%E6%89%80%E5%B1%9E%E6%B6%88%E8%B4%B9%E8%80%85%E7%BB%84%E9%85%8D%E7%BD%AE\" >\u7528\u6237\u6240\u5c5e\u6d88\u8d39\u8005\u7ec4\u914d\u7f6e<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/www.gbase8.cn\/en\/3308\/#%E5%A2%9E%E5%8A%A0%E6%88%90%E5%91%98\" >\u589e\u52a0\u6210\u5458<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/www.gbase8.cn\/en\/3308\/#%E5%88%A0%E9%99%A4%E6%88%90%E5%91%98\" >\u5220\u9664\u6210\u5458<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/www.gbase8.cn\/en\/3308\/#%E7%AE%A1%E7%90%86_Resource_Pool\" >\u7ba1\u7406 Resource Pool<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/www.gbase8.cn\/en\/3308\/#%E5%88%9B%E5%BB%BA-2\" >\u521b\u5efa<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/www.gbase8.cn\/en\/3308\/#%E6%9B%B4%E6%94%B9\" >\u66f4\u6539<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/www.gbase8.cn\/en\/3308\/#%E6%9B%B4%E6%94%B9%E5%90%8D%E7%A7%B0-2\" >\u66f4\u6539\u540d\u79f0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/www.gbase8.cn\/en\/3308\/#%E6%9B%B4%E6%94%B9%E5%8F%82%E6%95%B0\" >\u66f4\u6539\u53c2\u6570<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/www.gbase8.cn\/en\/3308\/#%E5%88%A0%E9%99%A4-2\" >\u5220\u9664<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-20\" href=\"https:\/\/www.gbase8.cn\/en\/3308\/#%E5%B1%9E%E6%80%A7%E5%88%97%E8%A1%A8\" >\u5c5e\u6027\u5217\u8868<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-21\" href=\"https:\/\/www.gbase8.cn\/en\/3308\/#priority\" >priority<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-22\" href=\"https:\/\/www.gbase8.cn\/en\/3308\/#cpu_percent\" >cpu_percent<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-23\" href=\"https:\/\/www.gbase8.cn\/en\/3308\/#max_memory\" >max_memory<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-24\" href=\"https:\/\/www.gbase8.cn\/en\/3308\/#max_disk_space\" >max_disk_space<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-25\" href=\"https:\/\/www.gbase8.cn\/en\/3308\/#max_temp_diskspace\" >max_temp_diskspace<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-26\" href=\"https:\/\/www.gbase8.cn\/en\/3308\/#max_disk_writeio\" >max_disk_writeio<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-27\" href=\"https:\/\/www.gbase8.cn\/en\/3308\/#max_disk_readio\" >max_disk_readio<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-28\" href=\"https:\/\/www.gbase8.cn\/en\/3308\/#max_activetask\" >max_activetask<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-29\" href=\"https:\/\/www.gbase8.cn\/en\/3308\/#task_max_parallel_degree\" >task_max_parallel_degree<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-30\" href=\"https:\/\/www.gbase8.cn\/en\/3308\/#task_waiting_timeout\" >task_waiting_timeout<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-31\" href=\"https:\/\/www.gbase8.cn\/en\/3308\/#task_running_timeout\" >task_running_timeout<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-32\" href=\"https:\/\/www.gbase8.cn\/en\/3308\/#%E9%9D%99%E6%80%81%E8%B5%84%E6%BA%90%E6%B1%A0%E5%BF%85%E9%A1%BB%E5%8F%82%E6%95%B0\" >\u9759\u6001\u8d44\u6e90\u6c60\u5fc5\u987b\u53c2\u6570<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-33\" href=\"https:\/\/www.gbase8.cn\/en\/3308\/#%E5%8A%A8%E6%80%81%E8%B5%84%E6%BA%90%E6%B1%A0%E5%BF%85%E9%A1%BB%E5%8F%82%E6%95%B0\" >\u52a8\u6001\u8d44\u6e90\u6c60\u5fc5\u987b\u53c2\u6570<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-34\" href=\"https:\/\/www.gbase8.cn\/en\/3308\/#%E8%B5%84%E6%BA%90%E8%AE%A1%E5%88%92Resource_Plan\" >\u8d44\u6e90\u8ba1\u5212Resource Plan<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-35\" href=\"https:\/\/www.gbase8.cn\/en\/3308\/#%E5%88%9B%E5%BB%BA-3\" >\u521b\u5efa<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-36\" href=\"https:\/\/www.gbase8.cn\/en\/3308\/#%E6%9B%B4%E6%94%B9%E5%90%8D%E7%A7%B0-3\" >\u66f4\u6539\u540d\u79f0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-37\" href=\"https:\/\/www.gbase8.cn\/en\/3308\/#%E6%9B%B4%E6%94%B9%E6%8F%8F%E8%BF%B0-2\" >\u66f4\u6539\u63cf\u8ff0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-38\" href=\"https:\/\/www.gbase8.cn\/en\/3308\/#%E5%88%A0%E9%99%A4-3\" >\u5220\u9664<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-39\" href=\"https:\/\/www.gbase8.cn\/en\/3308\/#%E8%B5%84%E6%BA%90%E6%8C%87%E4%BB%A4Resource_Directive\" >\u8d44\u6e90\u6307\u4ee4Resource Directive<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-40\" href=\"https:\/\/www.gbase8.cn\/en\/3308\/#%E5%88%9B%E5%BB%BA-4\" >\u521b\u5efa<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-41\" href=\"https:\/\/www.gbase8.cn\/en\/3308\/#%E5%88%A0%E9%99%A4-4\" >\u5220\u9664<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-42\" href=\"https:\/\/www.gbase8.cn\/en\/3308\/#%E6%BF%80%E6%B4%BB%E8%B5%84%E6%BA%90%E7%AE%A1%E7%90%86\" >\u6fc0\u6d3b\u8d44\u6e90\u7ba1\u7406<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-43\" href=\"https:\/\/www.gbase8.cn\/en\/3308\/#V8%E7%89%88%E6%9C%AC\" >V8\u7248\u672c<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-44\" href=\"https:\/\/www.gbase8.cn\/en\/3308\/#V9%E7%89%88%E6%9C%AC\" >V9\u7248\u672c<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-45\" href=\"https:\/\/www.gbase8.cn\/en\/3308\/#%E5%85%B3%E9%97%AD%E8%B5%84%E6%BA%90%E7%AE%A1%E7%90%86\" >\u5173\u95ed\u8d44\u6e90\u7ba1\u7406<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-46\" href=\"https:\/\/www.gbase8.cn\/en\/3308\/#V8%E7%89%88%E6%9C%AC-2\" >V8\u7248\u672c<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-47\" href=\"https:\/\/www.gbase8.cn\/en\/3308\/#V9%E7%89%88%E6%9C%AC-2\" >V9\u7248\u672c<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-48\" href=\"https:\/\/www.gbase8.cn\/en\/3308\/#%E5%8F%82%E8%80%83-2\" >\u53c2\u8003<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%8F%82%E8%80%83\"><\/span>\u53c2\u8003<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u67e5\u770b\u5f53\u524d\u8d44\u6e90\u7ba1\u7406\u4f7f\u7528\u60c5\u51b5\uff0c\u8bf7\u53c2\u8003  <a href=\"https:\/\/www.gbase8.cn\/3436\">GBase 8a\u8d44\u6e90\u901a\u8fc7\u7ba1\u7406\u5143\u6570\u636e\u67e5\u770b\u5f53\u524d\u914d\u7f6e<\/a><\/p>\n\n\n\n<p>\u5355\u7eaf\u57fa\u4e8e\u7528\u6237\u7684\uff0c\u4e0d\u60f3\u542f\u7528\u8d44\u6e90\u7ba1\u63a7\u529f\u80fd\uff0c\u8bf7\u53c2\u8003 <a href=\"https:\/\/www.gbase8.cn\/2386\">GBase 8a\u5b9e\u73b0\u7528\u6237\u78c1\u76d8\u7a7a\u95f4\u914d\u989d\u9650\u5236<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E8%B5%84%E6%BA%90%E7%AE%A1%E6%8E%A7%E7%9A%84%E5%AF%B9%E8%B1%A1\"><\/span>\u8d44\u6e90\u7ba1\u63a7\u7684\u5bf9\u8c61<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>GBase 8a MPP Cluster \u8d44\u6e90\u7ba1\u7406\u529f\u80fd\u53ef\u4ee5\u5bf9 SELECT \u548c DML \u7b49\u53d7\u63a7 SQL \u5728\u8fd0\u884c\u8fc7\u7a0b\u4e2d\u4f7f\u7528\u7684 CPU\u3001\u5185\u5b58\u3001I\/O \u548c\u78c1\u76d8\u7a7a\u95f4\u7b49\u8d44\u6e90\u8fdb\u884c\u5408\u7406\u7ba1\u63a7\uff0c\u4ee5\u8fbe\u5230\u8d44\u6e90\u5408\u7406\u5229\u7528\uff0c\u7cfb\u7edf\u7a33\u5b9a\u6027\u8fd0\u884c\u7684\u8981\u6c42\u3002\u5176\u4e2d\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>CPU\uff1a\u5b9e\u73b0\u5bf9\u53d7\u63a7 SQL \u4f7f\u7528 CPU \u4f18\u5148\u7ea7\u548c\u767e\u5206\u6bd4\u63a7\u5236\uff0c\u4ee5\u53ca SQL \u5e76\u53d1\u6570\u53ca\u5e76\u884c\u5ea6\u7684\u7ba1\u7406\u3002<\/li><li>\u5185\u5b58\uff1a\u5b9e\u73b0\u5bf9\u53d7\u63a7 SQL \u4f7f\u7528\u7684\u7b97\u5b50 buffer \u5185\u5b58\u4f7f\u7528\u4e0a\u9650\u7684\u63a7\u5236\u3002<\/li><li>I\/O\uff1a\u5b9e\u73b0\u5bf9\u53d7\u63a7 SQL \u4f7f\u7528\u7684 direct I\/O \u78c1\u76d8\u8bfb\u5199\u901f\u7387\u4e0a\u9650\u7684\u63a7\u5236\uff08\u901a\u91cf\u63a7\u5236\uff0c\u4e0d\u5305\u62eciops\uff09\u3002<\/li><li>\u78c1\u76d8\u7a7a\u95f4\uff1a\u5b9e\u73b0\u5bf9\u8868\u6570\u636e\u6587\u4ef6\u5360\u7528\u78c1\u76d8\u7a7a\u95f4\u5927\u5c0f\u7684\u7ba1\u63a7(\u4e0d\u5305\u62ec\u7d22\u5f15)\u3002<\/li><\/ol>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E8%B5%84%E6%BA%90%E7%AE%A1%E6%8E%A7%E6%9E%B6%E6%9E%84\"><\/span>\u8d44\u6e90\u7ba1\u63a7\u67b6\u6784<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u6d88\u8d39\u8005\u7ec4\uff1a\u7528\u6237\u662f\u901a\u8fc7\u6d88\u8d39\u8005\u7ec4\u6765\u6210\u6279\u7ba1\u7406\u3002<\/p>\n\n\n\n<p>\u8d44\u6e90\u6c60\uff1a\u901a\u8fc7\u8d44\u6e90\u6c60\u914d\u7f6e\uff0c\u5305\u542b\u4e86\u9759\u6001\u548c\u52a8\u6001\u8d44\u6e90\u6c60\u3002<\/p>\n\n\n\n<p>\u8d44\u6e90\u8ba1\u5212\uff1a\u5c06\u4e0d\u540c\u7684\u8d44\u6e90\u65b9\u6848\u6574\u5408\u5230\u4e00\u8d77\uff0c\u53ef\u4ee5\u5305\u542b\u591a\u4e2a\u8d44\u6e90\u6307\u4ee4(\u6d88\u8d39\u8005\u7ec4\u548c\u8d44\u6e90\u6c60\u7684\u5bf9\u7167\u5173\u7cfb)\u3002\u540c\u4e00\u65f6\u523b\u53ea\u80fd\u75311\u4e2a\u8d44\u6e90\u8ba1\u5212\u6fc0\u6d3b\uff0c\u3002<\/p>\n\n\n\n<p>\u8d44\u6e90\u6307\u4ee4\uff1a\u901a\u8fc7\u7ec4\u5408\u6d88\u8d39\u8005\u7ec4\u548c\u8d44\u6e90\u6c60\uff0c\u5f62\u6210\u5bf9\u8fd9\u4e2a\u7ec4\u7528\u6237\u7684\u8d44\u6e90\u7ba1\u7406\uff0c\u5e76\u52a0\u5165\u67d0\u4e2a\u8d44\u6e90\u8ba1\u5212\u91cc\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"503\" height=\"300\" src=\"https:\/\/www.gbase8.cn\/wp-content\/uploads\/2021\/01\/image-1.png\" alt=\"GBase 8a \u6570\u636e\u5e93\u96c6\u7fa4\u8d44\u6e90\u7ba1\u63a7\u67b6\u6784\u56fe\" class=\"wp-image-3310\"\/><figcaption>GBase 8a \u6570\u636e\u5e93\u96c6\u7fa4\u8d44\u6e90\u7ba1\u63a7\u67b6\u6784<\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E8%B5%84%E6%BA%90%E7%AE%A1%E7%90%86%E4%BD%BF%E7%94%A8%E6%B5%81%E7%A8%8B\"><\/span>\u8d44\u6e90\u7ba1\u7406\u4f7f\u7528\u6d41\u7a0b<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u6309\u7167\u524d\u9762\u7684\u4ecb\u7ecd\uff0c\u9010\u6b65\u521b\u5efa\u9700\u8981\u7684\u5185\u5bb9\u3002\u4e00\u4e2a\u7b80\u5355\u7684\u6837\u4f8b\uff0c\u53ef\u4ee5\u53c2\u8003 <\/p>\n\n\n\n<p><a href=\"https:\/\/www.gbase8.cn\/3292\">GBase 8a\u901a\u8fc7\u8d44\u6e90\u7ba1\u63a7\u9650\u5236\u96c6\u7fa4SQL\u5e76\u884c\u6570\u91cf<\/a><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"403\" height=\"445\" src=\"https:\/\/www.gbase8.cn\/wp-content\/uploads\/2021\/01\/image-2.png\" alt=\"GBase 8a\u6570\u636e\u5e93\u96c6\u7fa4\u8d44\u6e90\u7ba1\u7406\u4f7f\u7528\u6d41\u7a0b\u56fe\" class=\"wp-image-3312\"\/><figcaption>GBase 8a\u6570\u636e\u5e93\u96c6\u7fa4\u8d44\u6e90\u7ba1\u7406\u4f7f\u7528\u6d41\u7a0b<\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E7%8E%AF%E5%A2%83%E8%A6%81%E6%B1%82\"><\/span>\u73af\u5883\u8981\u6c42<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u96c6\u7fa4\u6240\u6709\u8282\u70b9\u5fc5\u987b\u5b89\u88c5 libcgroup \u548c libcgroup-devel rpm \u5305\u3002\u540c\u65f6\u64cd\u4f5c\u7cfb\u7edf\u7248\u672c\u8981\u6c42redhat 7.3+\u6216suse 11 sp3+\u3002<\/p>\n\n\n\n<p>\u7cfb\u7edfcgconfig\u670d\u52a1\u5fc5\u987b\u662f\u6b63\u5e38\u8fd0\u884c\u72b6\u6001\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%88%9B%E5%BB%BA%E5%92%8C%E7%AE%A1%E7%90%86_Consumer_Group\"><\/span>\u521b\u5efa\u548c\u7ba1\u7406 Consumer Group<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u4e0d\u540c VC \u4e2d\u7684 group_name \u5141\u8bb8\u91cd\u540d\u3002<br>\u96c6\u7fa4\u5b89\u88c5\u5b8c\u6210\u540e\uff0c\u5b58\u5728\u4e00\u4e2a\u9ed8\u8ba4\u8d44\u6e90\u6d88\u8d39\u7ec4 default_consumer_group\uff0c\u8be5\u6d88\u8d39\u7ec4\u7684 id=1\u3002<br>\u4efb\u4f55\u8ba1\u5212\u5185 default_consumer_group \u5fc5\u987b\u5173\u8054\u52a8\u6001\u8d44\u6e90\u6c60\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%88%9B%E5%BB%BA\"><\/span>\u521b\u5efa<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE CONSUMER GROUP &#91;vc_name.]&lt;group_name&gt; &#91;COMMENT = 'comment'];\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%9B%B4%E6%94%B9%E5%90%8D%E7%A7%B0\"><\/span>\u66f4\u6539\u540d\u79f0<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>ALTER CONSUMER GROUP &#91;vc_name.]&lt;group_name&gt; RENAME &#91;TO] &lt;new_name&gt;;\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%9B%B4%E6%94%B9%E6%8F%8F%E8%BF%B0\"><\/span>\u66f4\u6539\u63cf\u8ff0<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>ALTER CONSUMER GROUP &#91;vc_name.]&lt;group_name&gt; COMMENT = 'comment';<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%88%A0%E9%99%A4\"><\/span>\u5220\u9664<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>DROP CONSUMER GROUP &#91;vc_name.]&lt;group_name&gt;;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E7%94%A8%E6%88%B7%E6%89%80%E5%B1%9E%E6%B6%88%E8%B4%B9%E8%80%85%E7%BB%84%E9%85%8D%E7%BD%AE\"><\/span>\u7528\u6237\u6240\u5c5e\u6d88\u8d39\u8005\u7ec4\u914d\u7f6e<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u540c\u4e00 vc \u4e0b\uff0cconsumer group \u4e0e user \u4e4b\u95f4\u662f\u4e00\u5bf9\u591a\u7684\u5173\u7cfb\uff0c\u5373\u4e00\u4e2a consumer group \u4e2d\u53ef\u4ee5\u5305\u542b\u591a\u4e2a user\uff0c\u4e00\u4e2a user \u53ea\u80fd\u96b6\u5c5e\u4e8e\u4e00\u4e2a consumer group\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%A2%9E%E5%8A%A0%E6%88%90%E5%91%98\"><\/span>\u589e\u52a0\u6210\u5458<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>ALTER CONSUMER GROUP &#91;vc_name.]&lt;group_name&gt; ADD USER &lt;user_name&gt;;<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%88%A0%E9%99%A4%E6%88%90%E5%91%98\"><\/span>\u5220\u9664\u6210\u5458<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>ALTER CONSUMER GROUP &#91;vc_name.]&lt;group_name&gt; REMOVE USER &lt;user_name&gt;;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E7%AE%A1%E7%90%86_Resource_Pool\"><\/span>\u7ba1\u7406 Resource Pool<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u8d44\u6e90\u6c60\u4e3a\u96c6\u7fa4\u4efb\u52a1\u6267\u884c\u8fc7\u7a0b\u4e2d\u7684\u8d44\u6e90\u4f9b\u7ed9\u8005\u4e0e\u7ba1\u7406\u8005\uff0c\u5206\u4e3a\u9759\u6001\u8d44\u6e90\u6c60\u4e0e\u52a8\u6001\u8d44\u6e90\u6c60\u4e24\u79cd\uff0c\u9759\u6001\u8d44\u6e90\u6c60\u4e3a\u8d44\u6e90\u4f9b\u7ed9\u8005\uff0c\u800c\u52a8\u6001\u8d44\u6e90\u6c60\u4e3a\u8d44\u6e90\u7ba1\u7406\u8005\uff0c\u7ea6\u675f\u4efb\u52a1\u5bf9\u8d44\u6e90\u7684\u4f7f\u7528\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%88%9B%E5%BB%BA-2\"><\/span>\u521b\u5efa<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u5176\u4e2d\uff0cbase on \u5728\u521b\u5efa\u52a8\u6001\u8d44\u6e90\u6c60\u65f6\u4f7f\u7528\uff0cparent_pool_name \u4e3a \u52a8\u6001\u8d44\u6e90\u6c60\u96b6\u5c5e\u7684\u9759\u6001\u8d44\u6e90\u6c60\u540d\u79f0\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE RESOURCE POOL &#91;vc_name.]&lt;resource_pool_name&gt; (pool_attribute=value &#91;, ...]) \nTYPE {static|dynamic} &#91;BASE ON &lt;parent_pool_name&gt;]<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%9B%B4%E6%94%B9\"><\/span>\u66f4\u6539<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%9B%B4%E6%94%B9%E5%90%8D%E7%A7%B0-2\"><\/span>\u66f4\u6539\u540d\u79f0<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>ALTER RESOURCE POOL &#91;vc_name.]&lt;resource_pool_name&gt; RENAME &#91;TO]\n &lt;new_resource_pool_name&gt;;<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%9B%B4%E6%94%B9%E5%8F%82%E6%95%B0\"><\/span>\u66f4\u6539\u53c2\u6570<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>ALTER RESOURCE POOL &#91;vc_name.]&lt;resource_pool_name&gt; SET (pool_attribute=value &#91;, ...]);<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%88%A0%E9%99%A4-2\"><\/span>\u5220\u9664<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>DROP RESOURCE POOL &#91;vc_name.]&lt;resource_pool_name&gt;;<\/code><\/pre>\n\n\n\n<p>\u5220\u9664\u9759\u6001\u8d44\u6e90\u6c60\uff0c\u5fc5\u987b\u5148\u5220\u9664\u5176\u6302\u63a5\u7684\u52a8\u6001\u8d44\u6e90\u6c60\u3002<br>\u82e5\u4e00\u4e2a\u52a8\u6001\u8d44\u6e90\u6c60\u5728 directive \u4e2d\u88ab\u5f15\u7528\uff0c\u5219\u65e0\u6cd5\u5220\u9664\u8be5\u52a8\u6001\u8d44\u6e90\u6c60\u3002\u9700\u8981\u5220\u9664 directive \u89e3\u9664\u52a8\u6001\u8d44\u6e90\u6c60\u7684\u5173\u8054\u5173\u7cfb\u540e\uff0c\u52a8\u6001\u8d44\u6e90\u6c60\u624d\u53ef\u4ee5\u88ab\u5220\u9664\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%B1%9E%E6%80%A7%E5%88%97%E8%A1%A8\"><\/span>\u5c5e\u6027\u5217\u8868<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>DC\uff08Data Cell\uff09\u540c\u6b65 I\/O \u63a7\u5236\u901a\u8fc7\u53c2\u6570_gbase_dc_sync_size\uff08\u5355\u4f4d\uff1a\u5b57\u8282\uff09\u63a7\u5236\uff0c\u5f53\u5217\u6570\u636e\u6587\u4ef6\u5728 Buffer \u4e2d\u672a\u5237\u51fa\u7684 DC \u5927\u5c0f\u8d85\u8fc7\u6307\u5b9a\u503c\u65f6\uff0c\u6267\u884c\u540c\u6b65\u5199 I\/O \u64cd\u4f5c\u3002\u6b64\u53c2\u6570\u9ed8\u8ba4\u503c\u4e3a 1TB\uff0c\u6b64\u65f6 I\/O \u64cd\u4f5c\u5c06\u7531\u7cfb\u7edf\u5468\u671f\u56de\u5199\u673a\u5236\u5b8c\u6210\u3002\u6b64\u53c2\u6570\u6700\u5c0f\u503c\u4e3a 0\uff0c\u8868\u793a\u6bcf\u6b21\u53d7\u63a7 SQL \u90fd\u8c03\u7528\u540c\u6b65 I\/O \u64cd\u4f5c\u3002<br>\u4e00\u4e2a\u9759\u6001\u8d44\u6e90\u6c60\u4e2d\u53ef\u4ee5\u5305\u542b\u591a\u4e2a\u52a8\u6001\u8d44\u6e90\u6c60\u3002<br>\u4e00\u4e2a\u52a8\u6001\u8d44\u6e90\u6c60\u53ea\u80fd\u4e14\u5fc5\u987b\u96b6\u5c5e\u4e8e\u4e00\u4e2a\u9759\u6001\u8d44\u6e90\u6c60\u3002<br>\u52a8\u6001\u6c60\u4e0e\u5176\u96b6\u5c5e\u7684\u9759\u6001\u6c60\u5fc5\u987b\u5728\u540c\u4e00\u4e2a VC \u5185\u3002<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"priority\"><\/span>priority<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<ol class=\"wp-block-list\"><li>\u4f18\u5148\u7ea7\uff0c\u5171\u5206 8 \u7ea7\uff0c1 \u4e3a\u6700\u9ad8\uff0c8 \u4e3a\u6700\u4f4e\uff0c\u89c6\u4e3a\u4fdd\u7559\u53c2\u6570\uff0c\u5efa\u8bae\u7edf\u4e00\u914d\u7f6e\u4e3a 1\uff1b<\/li><li>\u6b64\u4f18\u5148\u7ea7\u53ea\u9488\u5bf9 CPU \u8bbe\u7f6e\u3002<\/li><\/ol>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"cpu_percent\"><\/span>cpu_percent<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<ol class=\"wp-block-list\"><li>\u4f7f\u7528 CPU \u8d44\u6e90\u7684\u767e\u5206\u6bd4\uff0c\u4ee5\u6574\u6570\u8868\u793a\uff0c\u8303\u56f4\u4e3a[1\uff0c100]\uff1b<\/li><li>\u5bf9\u4e8e\u9759\u6001\u8d44\u6e90\u6c60\u4e3a CPU \u767e\u5206\u6bd4\u5e26\u5bbd\u63a7\u5236\uff08 \u53ef\u53c2\u8003 linux cgroup\/cpu \u4e2d cpu.cfs_quota_us \u53c2\u6570\u8bf4\u660e\uff0c\u8ba1\u7b97\u516c\u5f0f\u4e3a cpu.cfs_quota_us = (cpu_cores *cpu.cfs_period_us) * cpu_percent \uff09\uff1b<\/li><li>\u5bf9\u4e8e\u52a8\u6001\u6c60\u4e3a CPU \u4f7f\u7528\u6743\u91cd\u63a7\u5236 (\u53ef\u53c2\u8003linux\/cgroup \u4e2d cpu.shares \u53c2\u6570\u8bf4\u660e\uff0c \u8ba1\u7b97\u516c\u5f0f\u4e3a cpu.shares = 1024 * cpu_percent)\u3002<\/li><\/ol>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"max_memory\"><\/span>max_memory<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<ol class=\"wp-block-list\"><li>\u6700\u5927\u4f7f\u7528\u5185\u5b58\u91cf\uff0c\u8bbe\u7f6e\u5355\u4f4d\u4e3a M\uff0c\u52a8\u6001\u6c60\u603b\u503c\u5e94\u5c0f\u4e8e\u6216\u7b49\u4e8e\u5176\u6240\u5728\u9759\u6001\u6c60\u8bbe\u5b9a\uff1b<\/li><li>\u82e5\u4e0d\u63a7\u5236\u5185\u5b58\uff0c\u5efa\u8bae\u8bbe\u7f6e\u503c\u5927\u4e8e\uff08\u7269\u7406\u5185\u5b58+SWAP\uff09\u7684\u548c\u503c\u3002<\/li><\/ol>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"max_disk_space\"><\/span>max_disk_space<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<ol class=\"wp-block-list\"><li>\u8be5\u8d44\u6e90\u6c60\u5173\u8054\u7684\u6240\u6709\u7528\u6237\u7684\u8868\u7a7a\u95f4\u5360\u7528\u78c1\u76d8\u603b\u548c\uff0c\u8bbe\u7f6e\u5355\u4f4d\u4e3a M\uff1b<\/li><li>\u82e5\u4e0d\u63a7\u5236\u78c1\u76d8\u7a7a\u95f4\uff0c\u5efa\u8bae\u8bbe\u7f6e\u503c\u5927\u4e8e\u7269\u7406\u78c1\u76d8\u7a7a\u95f4\u5927\u5c0f\uff1b<\/li><li>\u8be5\u53c2\u6570\u4e3a\u5fc5\u586b\u53c2\u6570\uff0c\u8bbe\u7f6e\u7684\u52a8\u6001\u6c60\u53c2\u6570\u603b\u548c\u4e0d\u80fd\u8d85\u8fc7\u9759\u6001\u6c60\u53c2\u6570\u3002<\/li><\/ol>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"max_temp_diskspace\"><\/span>max_temp_diskspace<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<ol class=\"wp-block-list\"><li>\u6c60\u4e2d\u5355\u4e2a\u4efb\u52a1\u6267\u884c\u8fc7\u7a0b\u4e2d\u53ef\u4f7f\u7528\u4e34\u65f6\u78c1\u76d8\u91cf\uff0c\u8bbe\u7f6e\u5355\u4f4d\u4e3a M\uff1b<\/li><li>\u82e5\u4e0d\u63a7\u5236\u5360\u7528\u4e34\u65f6\u78c1\u76d8\u5927\u5c0f\uff0c\u5efa\u8bae\u8bbe\u7f6e\u503c\u5927\u4e8e\u7269\u7406\u78c1\u76d8\u7a7a\u95f4\u5927\u5c0f\uff1b<\/li><li>\u8be5\u53c2\u6570\u4e3a\u5fc5\u586b\u53c2\u6570\uff0c\u8bbe\u7f6e\u5f97\u52a8\u6001\u6c60\u53c2\u6570\u603b\u548c\u4e0d\u80fd\u8d85\u8fc7\u9759\u6001\u6c60\u53c2\u6570\u3002<\/li><\/ol>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"max_disk_writeio\"><\/span>max_disk_writeio<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<ol class=\"wp-block-list\"><li>\u6c60\u4e2d\u4efb\u52a1\u5bf9\u6240\u6709\u78c1\u76d8\u8bbf\u95ee\u7684\u5199\u901f\u7387\u9650\u5236\uff0c\u8bbe\u7f6e\u5355\u4f4d\u4e3a MB\/S\uff0c\u6b64\u53c2\u6570\u5fc5\u987b\u4e0e DC \u540c\u6b65 I\/O \u63a7\u5236\u53c2\u6570_gbase_dc_sync_size \u914d\u5408\u4f7f\u7528\u624d\u751f\u6548\uff1b<\/li><li>gbase_dc_sync_size \u987b\u5c0f\u4e8e\u7b49\u4e8e\u6240\u6709\u52a8\u6001\u6c60\u4e2d\u8bbe\u7f6e\u7684max_disk_writeio \u503c\uff0c\u5efa\u8bae_gbase_dc_sync_size=1M (DC \u540c\u6b65 I\/O \u63a7\u5236\u8be6\u7ec6\u4ecb\u7ecd\u8bf7\u53c2\u770b\u672c\u5c0f\u8282\u7684\u8bf4\u660e\u90e8\u5206)\uff1b<\/li><li>\u82e5\u4e0d\u63a7\u5236\u6b64\u9879\uff0c\u5efa\u8bae\u8bbe\u503c\u7f6e\u5927\u4e8e\u7269\u7406\u78c1\u76d8\u5199\u6027\u80fd\u7406\u8bba\u503c\uff1b<\/li><li>\u8bbe\u7f6e\u52a8\u6001\u6c60\u603b\u503c\u5e94\u5c0f\u4e8e\u6216\u7b49\u4e8e\u5176\u6240\u5728\u9759\u6001\u6c60\u8bbe\u5b9a\u3002<\/li><\/ol>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"max_disk_readio\"><\/span>max_disk_readio<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<ol class=\"wp-block-list\"><li>\u6c60\u4e2d\u4efb\u52a1\u5bf9\u6240\u6709\u78c1\u76d8\u8bbf\u95ee\u7684\u8bfb\u901f\u7387\u9650\u5236\uff0c\u8bbe\u7f6e\u5355\u4f4d\u4e3a MB\/S\uff1b<\/li><li>\u82e5\u4e0d\u63a7\u5236\u6b64\u9879\uff0c\u5efa\u8bae\u8bbe\u7f6e\u503c\u5927\u4e8e\u7269\u7406\u78c1\u76d8\u8bfb\u6027\u80fd\u7406\u8bba\u503c\uff1b<\/li><li>\u52a8\u6001\u6c60\u603b\u503c\u5e94\u5c0f\u4e8e\u6216\u7b49\u4e8e\u5176\u6240\u5728\u9759\u6001\u6c60\u8bbe\u5b9a\u3002<\/li><\/ol>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"max_activetask\"><\/span>max_activetask<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<ol class=\"wp-block-list\"><li>\u6b64\u53c2\u6570\u4e3a\u52a8\u6001\u8d44\u6e90\u6c60\u4e13\u5c5e\uff0c\u8868\u660e\u540c\u65f6\u6c60\u4e2d\u53ef\u5e76\u53d1\u4efb\u52a1\u6570\uff0c\u7f3a\u7701\u503c\u4e3a 20\uff0c\u53ef\u6839\u636e\u5185\u5b58\u8bbe\u7f6e\u8be5\u53c2\u6570\uff0c\u6bcf\u4e2a\u4efb\u52a1\u7684\u5185\u5b58\u4f7f\u7528\u91cf\u9650\u5236 = max_memory \/max_activetask\uff1b<\/li><li>\u8be5\u53c2\u6570\u5982\u679c\u8fc7\u5927\u4f1a\u4f7f\u5f97\u6bcf\u4e2a\u4efb\u52a1\u5185\u5b58\u4f7f\u7528\u91cf\u4e0b\u964d\uff0c\u5bfc\u81f4\u4efb\u52a1\u6267\u884c\u5931\u8d25\uff1b<\/li><li>\u5982\u679c\u4e0b\u53d1\u4efb\u52a1\u6570\u5927\u4e8e\u6b64\u53c2\u6570\u503c\uff0c\u5219\u591a\u51fa\u7684\u4efb\u52a1\u8fdb\u5165\u7b49\u5f85\u961f\u5217\u3002<\/li><\/ol>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"task_max_parallel_degree\"><\/span>task_max_parallel_degree<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<ol class=\"wp-block-list\"><li>\u6c60\u4e2d\u4efb\u52a1\u6267\u884c\u5e76\u53d1\u5ea6\uff0c\u7f3a\u7701\u4e3a 16\uff1b<\/li><li>\u6ce8\uff1aone pass group\u3001\u5e76\u884c hash group\u3001\u5e76\u884c update\u3001\u5e76\u884c order by\uff0c\u5728\u5e76\u884c\u7269\u5316\u9636\u6bb5\u4f1a\u5360\u7528 2 \u500d\u7684\u5e76\u884c\u5ea6\u3002\u5e94\u5206\u914d 2 \u500d\u4ee5\u4e0a\u7684\u5e76\u884c\u5ea6\u6765\u907f\u514d\u53d1\u751f\u4e32\u884c\u3002<br>\u6b64\u5e76\u884c\u5ea6\u5e76\u4e0d\u5f71\u54cd\u52a0\u8f7d\u7684\u5e76\u884c\u5ea6\u8bbe\u7f6e\u3002<\/li><\/ol>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"task_waiting_timeout\"><\/span>task_waiting_timeout<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<ol class=\"wp-block-list\"><li>\u6c60\u4e2d\u4efb\u52a1\u7b49\u5f85\u6267\u884c\u8d85\u65f6\u65f6\u95f4\uff0c\u8bbe\u7f6e\u5355\u4f4d\u4e3a\u79d2\uff0c\u5176\u7ecf\u9a8c\u503c\u4e3a task_waiting_timeout = \u6700\u5927\u5bb9\u5fcd\u7b49\u5f85\u961f\u5217\u957f\u5ea6 * \uff08task_running_timeout * \u8c03\u6574\u7cfb\u6570\uff09\uff1b<\/li><li>\u7531\u4e8e task_running_timeout \u4e00\u822c\u4f1a\u9ad8\u4e8e\u6c60\u4e2d\u4efb\u52a1\u5b9e\u9645\u6267\u884c\u65f6\u957f\uff0c\u6240\u4ee5\u53ef\u505a\u9002\u5f53\u8c03\u6574\uff0c\u7f3a\u7701\u4e3a2592000s\u3002<\/li><\/ol>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"task_running_timeout\"><\/span>task_running_timeout<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<ol class=\"wp-block-list\"><li>\u6c60\u4e2d\u4efb\u52a1\u6267\u884c\u8d85\u65f6\u65f6\u95f4\uff0c\u8bbe\u7f6e\u5355\u4f4d\u4e3a\u79d2\uff0c\u53ef\u53c2\u8003\u96c6\u7fa4\u4e2d\u5bf9\u4e8e\u6c60\u4e2d\u4efb\u52a1\u5e73\u5747\u6267\u884c\u7edf\u8ba1\u503c\u8fdb\u884c\u8c03\u6574\uff0c\u7f3a\u7701\u4e3a 2592000s\u3002<\/li><\/ol>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E9%9D%99%E6%80%81%E8%B5%84%E6%BA%90%E6%B1%A0%E5%BF%85%E9%A1%BB%E5%8F%82%E6%95%B0\"><\/span>\u9759\u6001\u8d44\u6e90\u6c60\u5fc5\u987b\u53c2\u6570<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>cpu_percent<br>max_memory<br>max_temp_diskspace<br>max_disk_space<br>max_disk_writeio<br>max_disk_readio<br>\u56e0\u5176\u5b83\u53c2\u6570\u9488\u5bf9\u9759\u6001\u8d44\u6e90\u6c60\u65e0\u6548\uff0c\u5efa\u8bae\u4e0d\u7528\u51fa\u73b0\u5728\u5b9a\u4e49\u8bed\u53e5\u4e2d\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%8A%A8%E6%80%81%E8%B5%84%E6%BA%90%E6%B1%A0%E5%BF%85%E9%A1%BB%E5%8F%82%E6%95%B0\"><\/span>\u52a8\u6001\u8d44\u6e90\u6c60\u5fc5\u987b\u53c2\u6570<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>cpu_percent<br>max_memory<br>max_temp_diskspace<br>max_disk_space<br>max_disk_writeio<br>max_disk_readio<br>\u52a8\u6001\u8d44\u6e90\u6c60\u53c2\u6570\u8bbe\u5b9a\u4e4b\u548c\u4e0d\u80fd\u8d85\u8fc7\u6302\u63a5\u7684\u9759\u6001\u6c60\u5bf9\u5e94\u53c2\u6570\uff0c\u5176\u4ed6\u53c2\u6570\u9009\u586b\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E8%B5%84%E6%BA%90%E8%AE%A1%E5%88%92Resource_Plan\"><\/span>\u8d44\u6e90\u8ba1\u5212Resource Plan<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Resource Plan\uff08\u8d44\u6e90\u8ba1\u5212\uff09\u4e3a\u6309\u7167\u4e00\u5b9a\u89c4\u5f8b\u89c4\u5212\u96c6\u7fa4\u4e2d\u8d44\u6e90\u4f7f\u7528\u7684\u65b9\u6848\uff0c\u5728\u8d44\u6e90\u8ba1\u5212\u4e2d\u5c06\u8d44\u6e90\u6d88\u8d39\u7ec4\u6302\u63a5\u5230\u5408\u7406\u7684\u8d44\u6e90\u6c60\u4e2d\uff0c\u4ee5\u4fdd\u8bc1\u66f4\u6709\u6548\u5730\u5229\u7528\u96c6\u7fa4\u8d44\u6e90\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%88%9B%E5%BB%BA-3\"><\/span>\u521b\u5efa<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u5728\u6240\u5c5e VC \u8303\u56f4\u5185\uff0cResource Plan \u540d\u5b57\u662f\u552f\u4e00\u7684\uff0c\u4e0d\u540c VC \u4e2d\u7684 Resource Plan \u5141\u8bb8\u91cd\u540d\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE RESOURCE PLAN &#91;vc_name.]&lt;plan_name&gt; &#91;COMMENT\n='comment'];<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%9B%B4%E6%94%B9%E5%90%8D%E7%A7%B0-3\"><\/span>\u66f4\u6539\u540d\u79f0<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>ALTER RESOURCE PLAN &#91;vc_name.]&lt;plan_name&gt; RENAME &#91;TO] &lt;new_plan_name&gt;;<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%9B%B4%E6%94%B9%E6%8F%8F%E8%BF%B0-2\"><\/span>\u66f4\u6539\u63cf\u8ff0<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>ALTER RESOURCE PLAN &#91;vc_name.]&lt;plan_name&gt; COMMENT ='comment';\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%88%A0%E9%99%A4-3\"><\/span>\u5220\u9664<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>DROP RESOURCE PLAN &#91;vc_name.]&lt;plan_name&gt;;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E8%B5%84%E6%BA%90%E6%8C%87%E4%BB%A4Resource_Directive\"><\/span>\u8d44\u6e90\u6307\u4ee4Resource Directive<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Resource Directive\uff08\u8d44\u6e90\u6307\u4ee4\uff09\u6307\u5b9a\u5728\u8d44\u6e90\u8ba1\u5212\u4e2d\u8d44\u6e90\u6d88\u8d39\u7ec4\u4e0e\u52a8\u6001\u8d44\u6e90\u6c60\u7684\u6302\u63a5\u5173\u7cfb\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%88%9B%E5%BB%BA-4\"><\/span>\u521b\u5efa<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u521b\u5efa\u8d44\u6e90\u6307\u4ee4\u4e2d\u6d89\u53ca\u7684 plan\u3001pool\u3001group \u5fc5\u987b\u5df2\u7ecf\u521b\u5efa\u3002<br>\u82e5\u5f53\u524d VC \u5b58\u5728\u6fc0\u6d3b\u7684 plan\uff0c\u4e0d\u5141\u8bb8\u6267\u884c\u521b\u5efa directive \u64cd\u4f5c\u3002<br>\u540c\u4e00\u8d44\u6e90\u8ba1\u5212\u5185\u4e00\u4e2a\u8d44\u6e90\u6d88\u8d39\u7ec4\u53ea\u80fd\u6302\u63a5\u5230\u4e00\u4e2a\u52a8\u6001\u8d44\u6e90\u6c60\u3002<br>\u540c\u4e00\u8d44\u6e90\u8ba1\u5212\u5185\u4e00\u4e2a\u52a8\u6001\u8d44\u6e90\u6c60\u5219\u53ef\u6302\u63a5\u591a\u4e2a\u8d44\u6e90\u6d88\u8d39\u7ec4\u3002<br>\u4efb\u4f55\u8ba1\u5212\u5185 default consumer group \u5fc5\u987b\u5173\u8054\u52a8\u6001\u8d44\u6e90\u6c60\uff0c\u5373\u521b\u5efa\u5bf9\u5e94\u7684 directive\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE RESOURCE DIRECTIVE &#91;vc_name.]&lt;directive_name&gt; (\nPLAN_NAME = 'plan_name',\nGROUP_NAME = 'group_name',\nPOOL_NAME = 'resource_pool_name',\n&#91;COMMENT = 'comment']\n);\n<\/code><\/pre>\n\n\n\n<p>vc_name \u865a\u62df\u96c6\u7fa4\u540d\u5b57\uff0c\u53ef\u9009\u53c2\u6570\uff0c\u4e0d\u8f93\u5165\u7684\u60c5\u51b5\u4e0b\u53d6\u5f53\u524d\u9ed8\u8ba4 VC<br>directive_name \u8d44\u6e90\u6307\u4ee4\u540d\u5b57<br>PLAN_NAME \u8d44\u6e90\u8ba1\u5212\u540d\u5b57\u3002<br>GROUP_NAME \u6d88\u8d39\u7ec4\u540d\u5b57\u3002<br>POOL_NAME \u8d44\u6e90\u6c60\u540d\u5b57\u3002<br>COMMENT \u6ce8\u91ca<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%88%A0%E9%99%A4-4\"><\/span>\u5220\u9664<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u82e5\u5f53\u524d VC \u5b58\u5728\u6fc0\u6d3b\u7684 resource plan\uff0c\u4e0d\u5141\u8bb8\u6267\u884c\u5220\u9664 directive \u64cd\u4f5c\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>DROP RESOURCE DIRECTIVE &#91;vc_name.]&lt;directive_name&gt;;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%BF%80%E6%B4%BB%E8%B5%84%E6%BA%90%E7%AE%A1%E7%90%86\"><\/span>\u6fc0\u6d3b\u8d44\u6e90\u7ba1\u7406<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u540c\u4e00 VC \u4e0b\uff0c\u540c\u4e00\u65f6\u6bb5\u53ea\u80fd\u6709\u4e00\u4e2a plan \u88ab\u6fc0\u6d3b\uff1b<br>\u5728\u4efb\u4f55 resource plan \u4e2d\uff0cdefault consumer group \u5fc5\u987b\u4e0e\u52a8\u6001\u6c60\u5173\u8054\uff0c\u624d\u53ef\u4ee5\u6fc0\u6d3b\u8be5resource plan\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"V8%E7%89%88%E6%9C%AC\"><\/span>V8\u7248\u672c<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>set global active_resource_plan='&lt;resource_plan_name&gt;';<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"V9%E7%89%88%E6%9C%AC\"><\/span>V9\u7248\u672c<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>ACTIVE RESOURCE PLAN &lt;resource_plan_name&gt; ON VC &lt;vc_name&gt;;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%85%B3%E9%97%AD%E8%B5%84%E6%BA%90%E7%AE%A1%E7%90%86\"><\/span>\u5173\u95ed\u8d44\u6e90\u7ba1\u7406<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"V8%E7%89%88%E6%9C%AC-2\"><\/span>V8\u7248\u672c<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>set global active_resource_plan='';<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"V9%E7%89%88%E6%9C%AC-2\"><\/span>V9\u7248\u672c<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>DEACTIVE RESOURCE PLAN ON VC &lt;vc_name&gt;;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%8F%82%E8%80%83-2\"><\/span>\u53c2\u8003<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-\u8001\u7d2b\u7af9\u7684\u5bb6 wp-block-embed-\u8001\u7d2b\u7af9\u7684\u5bb6\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"7N8dDG6axI\"><a href=\"https:\/\/www.gbase8.cn\/3292\">GBase 8a\u901a\u8fc7\u8d44\u6e90\u7ba1\u63a7\u6837\u4f8b\u9650\u5236\u96c6\u7fa4SQL\u5e76\u884c\u6570\u91cf<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"\u300aGBase 8a\u901a\u8fc7\u8d44\u6e90\u7ba1\u63a7\u6837\u4f8b\u9650\u5236\u96c6\u7fa4SQL\u5e76\u884c\u6570\u91cf\u300b\u2014\u8001\u7d2b\u7af9\u7684\u5bb6\" src=\"https:\/\/www.gbase8.cn\/3292\/embed#?secret=7N8dDG6axI\" data-secret=\"7N8dDG6axI\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>\u672c\u6587\u4ecb\u7ecdGBase 8a\u6570\u636e\u5e93\u96c6\u7fa4\u91cc\uff0c\u5bf9\u8d44\u6e90\u7ba1\u7406\u7684\u529f\u80fd\u4ecb\u7ecd\u3002\u901a\u8fc7\u5bf9\u7cfb\u7edfCPU\uff0c\u5185\u5b58\uff0c\u78c1\u76d8\u7b49\u8d44\u6e90\u7684\u4f7f\u7528\u63a7\u5236\uff0c\u5728\u591a\u7528\u6237\u4e0b\u5b9e\u73b0\u8d44\u6e90\u8c03\u5ea6\u548c\u5e73\u8861\u3002<\/p>","protected":false},"author":1,"featured_media":3310,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-3308","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-gbase8a"],"_links":{"self":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/3308","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/comments?post=3308"}],"version-history":[{"count":27,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/3308\/revisions"}],"predecessor-version":[{"id":5275,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/3308\/revisions\/5275"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/media\/3310"}],"wp:attachment":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/media?parent=3308"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/categories?post=3308"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/tags?post=3308"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}