# MySql Node "Error: Pool Is closed"

**URL:** <https://discourse.nodered.org/t/mysql-node-error-pool-is-closed/56556>\
**Category:** General\
**Created:** [13 January 2022 01:42 UTC](https://discourse.nodered.org/t/mysql-node-error-pool-is-closed/56556 "2022-01-13T01:42:49Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![dynamicdave](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dynamicdave/32/96_2.png) [@dynamicdave](https://discourse.nodered.org/u/dynamicdave)\
**Post date:** [13 January 2022 08:14 UTC](https://discourse.nodered.org/t/mysql-node-error-pool-is-closed/56556/5 "2022-01-13T08:14:26Z")

</div>

I had a similar error when using the MySQL node last year (2021).

> [@\[Feedback wanted\] Update to mysql node](https://discourse.nodered.org/t/feedback-wanted-update-to-mysql-node/53936):
>
> I have just updated the node-red-node-mysql node to use the more maintained mysql2 library in response to [MySQL 8.0 needs new Auth mechanism · Issue #853 · node-red/node-red-nodes · GitHub](https://github.com/node-red/node-red-nodes/issues/853) - and it is on npm as node-red-node-mysql@next so can be manually installed... eg cd ~/.node-red && npm i node-red-node-mysql@next If anyone has any time to give it a whirl I would really appreciate it. It claims to be nearly compatible with the basic mysql library but there are some known differences, see-…

Are you using the latest version as @dceejay has done a lot of work improving this node, in fact there was an update a week ago.

 ![Screen Shot 01-13-22 at 08.07 AM](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/a/3/a3a1b8901598014427c51d62d64cf3c907db5e99.gif)  
One of my problems was the number of dB connections. I found when I reduced the number of connections the node behaved much better.

I'm also using this flow to perform a 'keep database alive' every 15-minutes.

> [@\[Feedback wanted\] Update to mysql node](https://discourse.nodered.org/t/feedback-wanted-update-to-mysql-node/53936/4):
>
> Upgrade MySQL - working like it suppose to.

---

_[View the full topic](https://discourse.nodered.org/t/mysql-node-error-pool-is-closed/56556)._