Hi, I am observing an odd thing that I wanted to highlight. I'll briefly highlight my setup. I have multiple flows that use the MYSQL node as follows (in similar ways). Cron Plus Timer (30m interval) --> HTTP Request (returns array) --> function --> split --> delay (ratelimit 2/s) --> function -->…

There are multiple flows with repeating scheduled at 30-60 minute intervals. Some lists have 500 items, while others have 5000. We have a delay (rate limit) node of 2/second between the array of items and MySQL node so we are not triggering 100s of queries at a single point at least. I believe No…

Seems related to mysqlConnectionLimit node-red/node-red-nodes/blob/master/storage/mysql/68-mysql.js#L44 if (!node.pool) { node.pool = mysqldb.createPool({ host : node.host, port : node.port, user : n…

How many elements are there in the array that you split? Also which versions of node red, node.js and the mysql node are you using?

[image] Prathamesh_Gharat: There are multiple flows with repeating scheduled at 30-60 minute intervals. Some lists have 500 items, while others have 5000. If you have just two flows with 5000 items, at 2/sec that would take 5000 seconds which is more than 60 minutes, so it will not keep up w…

[image] Prathamesh_Gharat: There are multiple flows with repeating scheduled at 30-60 minute intervals. Some lists have 500 items, while others have 5000. Sorry, I should have been more accurate with the figures considering the problem we are describing. I don't have the flow with 5000 item…

MySQL - Too many connections

General

madhouse 12 October 2022 21:15 4

Related to Colin's questioning above, what are you using to connect and handle your SQL querying? Does it handle automatic disconnection upon query completion? There are some options to fix your problem. But what you have needs to be identified first.

Topic		Replies	Views
Reducing Database Connections General	9	1478	9 September 2020
How to release MySQL connection General	15	3074	4 June 2018
Max_user_connections error in node-red-node-mysql General database	1	235	28 August 2022
MysqlDBNode reuses the same connection for all access Feature Requests	2	536	14 November 2018
MySQL fails after an hour or so General	18	1913	19 June 2021

MySQL - Too many connections

Related topics