MySQL - Too many connections

Prathamesh_Gharat · 12 October 2022 19:35

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 : node.credentials.user,
                  password : node.credentials.password,
                  database : node.dbname,
                  timezone : node.tz,
                  insecureAuth: true,
                  multipleStatements: true,
                  connectionLimit: RED.settings.mysqlConnectionLimit || 50,
                  connectTimeout: 30000,
                  charset: node.charset,
                  decimalNumbers: true
              });
          }
          
          
// connection test
          node.pool.getConnection(function(err, connection) {
              node.connecting = false;
              if (err) {

I will try setting it to 20 and check back in a few hours.

Topic		Replies	Views
Reducing Database Connections General	9	1427	9 September 2020
How to release MySQL connection General	15	2986	4 June 2018
Node-red-node-mysql stops working after some time General database	14	1049	14 February 2022
Max_user_connections error in node-red-node-mysql General database	1	211	28 August 2022
MysqlDBNode reuses the same connection for all access Feature Requests	2	512	14 November 2018

MySQL - Too many connections

Related topics