{"id":202,"date":"2020-06-09T18:59:01","date_gmt":"2020-06-09T10:59:01","guid":{"rendered":"http:\/\/www.gbase8.cn\/?p=202"},"modified":"2023-02-01T15:58:54","modified_gmt":"2023-02-01T07:58:54","slug":"gbase-8a%e9%9b%86%e7%be%a4%e5%b8%b8%e8%a7%81%e5%86%85%e5%ad%98%e9%85%8d%e7%bd%ae%e5%8f%82%e6%95%b0","status":"publish","type":"post","link":"https:\/\/www.gbase8.cn\/en\/202","title":{"rendered":"\u5357\u5927\u901a\u7528GBase 8a\u96c6\u7fa4\u5e38\u89c1\u5185\u5b58\u914d\u7f6e\u53c2\u6570"},"content":{"rendered":"

\u914d\u7f6e\u5728gnode\u7684\u914d\u7f6e\u6587\u4ef6\u4e2d\uff0c\u7ba1\u7406\u8282\u70b9\u4e00\u822c\u4e0d\u7528\u4fee\u6539\u3002<\/p>\n\n\n\n

gbase_memory_pct_target \u6700\u5927\u5141\u8bb8\u7684\u5185\u5b58\u5360\u7528\u6bd4\u4f8b\uff0c\u9ed8\u8ba40.8\u7b49\u4e8e80%\u3002 \u5185\u5b58\u603b\u91cf=\u7269\u7406\u5185\u5b58+SWAP\u5185\u5b58\u3002\u5982\u8d85\u8fc7\uff0cSQL\u4f1a\u8fd4\u56demalloc\u5206\u914d\u5185\u5b58\u5931\u8d25\u9519\u8bef\u3002<\/p>\n\n\n\n

gbase_heap_large \u5982\u679c\u6709\u5927\u91cf\u7684\u805a\u5408group\uff0cjoin\u7b49\u64cd\u4f5c\uff0c\u5efa\u8bae\u63d0\u9ad8,\u5305\u62ec\u5185\u90e8\u7684\u51e0\u4e2a\u9488\u5bf9\u7279\u5b9a\u64cd\u4f5c\u7684\u53c2\u6570\uff1a<\/p>\n\n\n\n

\u5982\u4e0b\u51e0\u4e2a\u9ed1\u4f53\u7684\u7b97\u5b50BUFFER\u662f\u53ef\u4ee5set global\u7684<\/p>\n\n\n\n

gbase_buffer_hgrby<\/strong>\uff1a\u7528\u4e8e\u8bbe\u7f6e\u6570\u636e\u5e93\u505aGROUP\u65f6\u4f7f\u7528\u7684BUFFER\u5927\u5c0f\uff1b<\/p>\n\n\n\n

gbase_buffer_distgrby<\/strong>\uff1a\u7528\u4e8e\u8bbe\u7f6e\u6570\u636e\u5e93\u505aDISTINCT GROUP\u65f6\u4f7f\u7528\u7684BUFFER\u5927\u5c0f\uff1b<\/p>\n\n\n\n

gbase_buffer_hj<\/strong>\uff1a\u7528\u4e8e\u8bbe\u7f6e\u6570\u636e\u5e93\u505aHASH JOIN\u65f6\u4f7f\u7528\u7684BUFFER\u5927\u5c0f\uff1b<\/p>\n\n\n\n

gbase_buffer_sj<\/strong>\uff1a\u7528\u4e8e\u8bbe\u7f6e\u6570\u636e\u5e93\u505aSORT MERGE JOIN\u65f6\u4f7f\u7528\u7684BUFFER\u5927\u5c0f\uff1b<\/p>\n\n\n\n

gbase_buffer_sort <\/strong>\uff1a\u7528\u4e8e\u8bbe\u7f6e\u6570\u636e\u5e93\u505aSORT\u65f6\u4f7f\u7528\u7684BUFFER\u5927\u5c0f<\/p>\n\n\n\n

gbase_buffer_rowset <\/strong>\uff1a\u7528\u4e8e\u914d\u7f6e\u7f13\u5b58join\u4e2d\u95f4\u7ed3\u679c\u6240\u4f7f\u7528\u7684BUFFRER\u5927\u5c0f<\/p>\n\n\n\n

gbase_buffer_result <\/strong>\uff1a\u7528\u4e8e\u914d\u7f6e\u7269\u5316\u7ed3\u679c\u96c6BUFFER\u5927\u5c0f\uff1b<\/p>\n\n\n\n

gbase> set global gbase_buffer_hgrby=12345;\r\nQuery OK, 0 rows affected (Elapsed: 00:00:00.00)\r\n\r\ngbase> set global gbase_buffer_distgrby=12345;\r\nQuery OK, 0 rows affected (Elapsed: 00:00:00.00)\r\n\r\ngbase> set global gbase_buffer_hj=12345;\r\nQuery OK, 0 rows affected (Elapsed: 00:00:00.01)\r\n\r\ngbase> set global gbase_buffer_sort=123456;\r\nQuery OK, 0 rows affected (Elapsed: 00:00:00.01)\r\n\r\ngbase> set global gbase_buffer_rowset=123456;\r\nQuery OK, 0 rows affected (Elapsed: 00:00:00.01)\r\n\r\ngbase> set global gbase_buffer_result=123456;\r\nQuery OK, 0 rows affected (Elapsed: 00:00:00.00)\r\n\ngbase> set global gbase_buffer_insert=123456;\r\nERROR 1238 (HY000): Variable 'gbase_buffer_insert' is a read only variable<\/code><\/pre>\n\n\n\n
gbase_buffer_insert\uff1a\u7528\u4e8e\u8bbe\u7f6e\u6279\u91cfINSERT\u6570\u636e\u65f6\uff0c\u4e2d\u95f4BUFFER\u7684\u5927\u5c0f\uff1b<\/p>\n\n\n\n
_gbase_express_table_metadata_limit \u5143\u6570\u636e\u7f13\u51b2\u53c2\u6570<\/p>\n\n\n\n
gbase_heap_data, \u70ed\u6570\u636e\u7f13\u51b2<\/p>\n\n\n\n
gbase_heap_temp \u4e34\u65f6\u7684\u7f13\u51b2\uff0c\u6bd4\u5982\u5143\u6570\u636e\uff0c\u5806\u6808\u7b49\u3002<\/p>\n\n\n\n
_gbase_memory_turn_to_heap<\/strong> \u4e0d\u518d\u4ece\u64cd\u4f5c\u7cfb\u7edfmallco\u5185\u5b58\uff0c\u800c\u662f\u4eceheap\u4e0a\u5206\u914d\uff0c\u907f\u514d\u5185\u5b58\u4f7f\u7528\u8d85\u9650\u5bfc\u81f4\u88abOOM\u3002<\/p>","protected":false},"excerpt":{"rendered":"
\u5357\u5927\u901a\u7528GBase 8a\u96c6\u7fa4\u5e38\u89c1\u5185\u5b58\u914d\u7f6e\u53c2\u6570<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[39],"class_list":["post-202","post","type-post","status-publish","format-standard","hentry","category-gbase8a","tag-39"],"_links":{"self":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/202","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=202"}],"version-history":[{"count":9,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/202\/revisions"}],"predecessor-version":[{"id":10702,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/202\/revisions\/10702"}],"wp:attachment":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/media?parent=202"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/categories?post=202"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/tags?post=202"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}