{"id":8119,"date":"2021-09-29T10:23:53","date_gmt":"2021-09-29T02:23:53","guid":{"rendered":"https:\/\/www.gbase8.cn\/?p=8119"},"modified":"2021-09-29T10:23:54","modified_gmt":"2021-09-29T02:23:54","slug":"gbase-8a-%e7%9a%84%e5%a0%86%e6%a0%88%e5%8f%82%e6%95%b0thread_stack","status":"publish","type":"post","link":"https:\/\/www.gbase8.cn\/en\/8119","title":{"rendered":"\u5357\u5927\u901a\u7528GBase 8a \u7684\u5806\u6808\u53c2\u6570thread_stack"},"content":{"rendered":"<p>GBase 8a \u5728SQL\u8bed\u53e5\u5305\u542b\u5f88\u591aor, in\u7b49\u9700\u8981\u5927\u91cf\u5806\u6808\u64cd\u4f5c\u7684\u7684\u60c5\u51b5\u4e0b\uff0c\u53ef\u80fd\u56e0\u4e3a\u7ebf\u7a0b\u6808\uff08thread_stack\uff09\u592a\u5c0f\u5bfc\u81f4\u7206\u6808\u5b95\u673a\u3002\u9700\u8981\u914d\u7f6egcluster\u53cagnode\u7684\u7ebf\u7a0b\u6808\u5927\u5c0f\u3002<\/p>\n\n\n\n<p>\u7c7b\u4f3cSQL\u6bd4\u5982\uff0c\u6709\u5927\u91cf\u7684 or \u6761\u4ef6\uff08a=1 or a=2 or a=3 or a=3 .... \uff09\uff0c in \u503c\u6761\u4ef6(a in (1,2,3,4,5......)\u7684SQL\uff0c\u53c2\u6570\u5728\u51e0\u5343\uff0c\u51e0\u4e07\u4e2a\u751a\u81f3\u66f4\u591a\u7684SQL\u3002<\/p>\n\n\n\n<p>\u63a8\u8350gcluster\u7684thread_stack\u4e3a4M\uff08\u65b0\u7248\u7248\u672c\u9ed8\u8ba4\u5927\u5c0f\uff0c\u8001\u7248\u672c\u9ed8\u8ba4\u4e3a2M\uff09\uff1b\u63a8\u8350gnode\u7684thread_stack\u4e3a512K\uff08\u9ed8\u8ba4256K\uff09\u3002\u5982\u4f9d\u7136\u53d1\u751f\u7206\u6808\u95ee\u9898\uff0c\u5219\u7ee7\u7eed\u8c03\u5927\u8be5\u53c2\u6570\u3002<\/p>\n\n\n\n<p>\u5728gcluster\u548cgnode\u7684\u914d\u7f6e\u6587\u4ef6\u4e2d\uff0c\u5982\u5728gnode\u914d\u7f6e\u6587\u4ef6\u4e2d\u589e\u52a0\u914d\u7f6ethread_stack = 524288\u3002\u914d\u7f6e\u540e\u9700\u8981\u91cd\u542f\u670d\u52a1\u3002<\/p>","protected":false},"excerpt":{"rendered":"<p>\u5357\u5927\u901a\u7528GBase 8a \u5728SQL\u8bed\u53e5\u5305\u542b\u5f88\u591aor, in\u7b49\u9700\u8981\u5927\u91cf\u5806\u6808\u64cd\u4f5c\u7684\u7684\u60c5\u51b5\u4e0b\uff0c\u53ef\u80fd\u56e0\u4e3a\u7ebf\u7a0b\u6808\uff08thread_stack\uff09\u592a\u5c0f\u5bfc\u81f4\u7206\u6808\u5b95\u673a\u3002\u9700\u8981\u914d\u7f6egcluster\u53cagnode\u7684\u7ebf\u7a0b\u6808\u5927\u5c0f\u3002<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[],"class_list":["post-8119","post","type-post","status-publish","format-standard","hentry","category-gbase8a"],"_links":{"self":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/8119","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=8119"}],"version-history":[{"count":3,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/8119\/revisions"}],"predecessor-version":[{"id":8122,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/8119\/revisions\/8122"}],"wp:attachment":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/media?parent=8119"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/categories?post=8119"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/tags?post=8119"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}