{"id":2296,"date":"2025-11-20T15:12:51","date_gmt":"2025-11-20T07:12:51","guid":{"rendered":"https:\/\/www.nmking.io\/?p=2296"},"modified":"2026-01-17T14:43:02","modified_gmt":"2026-01-17T06:43:02","slug":"nodered-%e4%bd%bf%e7%94%a8sql%e7%9a%84connect-pool","status":"publish","type":"post","link":"https:\/\/www.nmking.io\/index.php\/2025\/11\/20\/2296\/","title":{"rendered":"Nodered \u4f7f\u7528SQL\u7684connect pool"},"content":{"rendered":"\n<p>\u4e4b\u524d\u4f7f\u7528nodered\u9023\u7d50SQL\u6642\uff0c\u6703\u64d4\u5fc3\u4f7f\u7528\u7684connect pool\u6703\u4e0d\u6703\u7206\u6389\uff0c\u56e0\u70ba\u5e7e\u4e4e\u6bcf\u4e00\u500b\u9801\u9762\u90fd\u4f7f\u7528\u4e86\u5f88\u591a\u500bSQL NODE\uff0c\u7b97\u8d77\u4f86\u53ef\u80fd\u6709\u6578\u5341\u500b\uff0c\u4f9d\u64da\u4ee5\u524d\u7684\u7d93\u9a57\uff0cconnect pool\u5f88\u5feb\u5c31\u7206\u6389\u4e86\uff0c\u4f46\u662f\u5be6\u969b\u4f7f\u7528\u6642\u537b\u6c92\u4ec0\u9ebc\u554f\u984c?<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"656\" height=\"599\" src=\"https:\/\/i0.wp.com\/www.nmking.io\/wp-content\/uploads\/2025\/11\/image.png?resize=656%2C599&#038;ssl=1\" alt=\"\" class=\"wp-image-2297\" style=\"aspect-ratio:1.0951585976627713;width:451px;height:auto\" srcset=\"https:\/\/i0.wp.com\/www.nmking.io\/wp-content\/uploads\/2025\/11\/image.png?w=656&amp;ssl=1 656w, https:\/\/i0.wp.com\/www.nmking.io\/wp-content\/uploads\/2025\/11\/image.png?resize=300%2C274&amp;ssl=1 300w\" sizes=\"auto, (max-width: 656px) 100vw, 656px\" \/><\/figure>\n\n\n\n<p>\u70ba\u4e86\u907f\u514d\u9019\u500b\u554f\u984c\uff0c\u6211\u4f7f\u7528\u4e86link in\u53calink out\uff0c\u7576\u4e0d\u540c\u9801\u9762\u9700\u8981SQL\u6307\u4ee4\u6642\uff0c\u5c31\u900f\u904elink\u65b9\u5f0f\u9023\u7d50\u5230\u540c\u4e00\u500bSQL\u7bc0\u9ede\uff0c\u81ea\u4ee5\u70ba\u8070\u660e\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"786\" height=\"313\" src=\"https:\/\/i0.wp.com\/www.nmking.io\/wp-content\/uploads\/2025\/11\/image-1.png?resize=786%2C313&#038;ssl=1\" alt=\"\" class=\"wp-image-2298\" srcset=\"https:\/\/i0.wp.com\/www.nmking.io\/wp-content\/uploads\/2025\/11\/image-1.png?w=786&amp;ssl=1 786w, https:\/\/i0.wp.com\/www.nmking.io\/wp-content\/uploads\/2025\/11\/image-1.png?resize=300%2C119&amp;ssl=1 300w\" sizes=\"auto, (max-width: 786px) 100vw, 786px\" \/><\/figure>\n\n\n\n<p>\u81ea\u4ee5\u70ba\u8070\u660e\u7684\u540c\u6642\uff0c\u5176\u5be6\u4e5f\u5728\u60f3\u6703\u4e0d\u6703\u5176\u5be6\u6bcf\u4e00\u500bSQL NODE\u5171\u7528\u540c\u4e00\u500bconnection\u5462? <\/p>\n\n\n\n<p>\u9a57\u8b49\u9019\u500b\u65b9\u5f0f\u6700\u7c21\u55ae\u7684\u5c31\u662f\u6aa2\u67e5SQL\u7684connection\u6578\u91cf\u4e86\uff0c\u9032\u5165SSH\u4e4b\u5f8c\u4e0b\u9054\u4ee5\u4e0b\u6307\u4ee4<\/p>\n\n\n\n<p><strong>SHOW PROCESSLIST;<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"173\" src=\"https:\/\/i0.wp.com\/www.nmking.io\/wp-content\/uploads\/2025\/11\/image-3.png?resize=1024%2C173&#038;ssl=1\" alt=\"\" class=\"wp-image-2300\" srcset=\"https:\/\/i0.wp.com\/www.nmking.io\/wp-content\/uploads\/2025\/11\/image-3.png?resize=1024%2C173&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.nmking.io\/wp-content\/uploads\/2025\/11\/image-3.png?resize=300%2C51&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.nmking.io\/wp-content\/uploads\/2025\/11\/image-3.png?w=1080&amp;ssl=1 1080w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\u6aa2\u67e5\u7d50\u679c\u5f8c\u5c31\u5b89\u5fc3\u4e86\uff0c\u9019\u9ebc\u591a\u500bSQL NODE\u53ea\u6709\u4e00\u500b\u9023\u7dda<\/p>\n\n\n\n<p>\u7d50\u8ad6\uff1a\u5927\u5bb6\u653e\u5fc3\u4f7f\u7528SQL NODE\u5427<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4e4b\u524d\u4f7f\u7528nodered\u9023\u7d50SQL\u6642\uff0c\u6703\u64d4\u5fc3\u4f7f\u7528\u7684connect pool\u6703\u4e0d\u6703\u7206\u6389\uff0c\u56e0\u70ba\u5e7e\u4e4e\u6bcf\u4e00\u500b\u9801\u9762\u90fd\u4f7f\u7528\u4e86 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":2297,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[6],"tags":[],"class_list":["post-2296","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-js"],"blocksy_meta":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.nmking.io\/wp-content\/uploads\/2025\/11\/image.png?fit=656%2C599&ssl=1","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.nmking.io\/index.php\/wp-json\/wp\/v2\/posts\/2296","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.nmking.io\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.nmking.io\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.nmking.io\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.nmking.io\/index.php\/wp-json\/wp\/v2\/comments?post=2296"}],"version-history":[{"count":1,"href":"https:\/\/www.nmking.io\/index.php\/wp-json\/wp\/v2\/posts\/2296\/revisions"}],"predecessor-version":[{"id":2301,"href":"https:\/\/www.nmking.io\/index.php\/wp-json\/wp\/v2\/posts\/2296\/revisions\/2301"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.nmking.io\/index.php\/wp-json\/wp\/v2\/media\/2297"}],"wp:attachment":[{"href":"https:\/\/www.nmking.io\/index.php\/wp-json\/wp\/v2\/media?parent=2296"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.nmking.io\/index.php\/wp-json\/wp\/v2\/categories?post=2296"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.nmking.io\/index.php\/wp-json\/wp\/v2\/tags?post=2296"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}