MySQL giving “read ECONNRESET” error after idle time on node.js server

by

I reached out to the node-mysql folks on their Github page and got some firm answers.

  1. MySQL does indeed prune idle connections. There’s a MySQL variable “wait_timeout” that sets the number of second before timeout and the default is 8 hours. We can set the default to be much larger than that. Use show variables like 'wait_timeout'; to view your timeout setting and set wait_timeout=28800; to change it.

  2. According to this issue, node-mysql doesn’t prune pool connections after these sorts of disconnections. The module developers recommended using a heartbeat to keep the connection alive such as calling SELECT 1; on an interval. They also recommended using the node-pool module and its idleTimeoutMillis option to automatically prune idle connections.

More Related Contents:

  1. Use promise to process MySQL return value in node.js
  2. INSERT INTO fails with node-mysql
  3. How can i write in NodeJS with MongoDB the following MySQL Select?
  4. MySQL 8.0 – Client does not support authentication protocol requested by server; consider upgrading MySQL client
  5. MySQL with Node.js
  6. Preventing SQL injection in Node.js
  7. node-mysql multiple statements in one query
  8. nodejs mysql Error: Connection lost The server closed the connection
  9. How to grant remote access permissions to mysql server for user?
  10. How do I do a bulk insert in mySQL using node.js
  11. Node.js can’t authenticate to MySQL 8.0
  12. node.js mysql error: ECONNREFUSED
  13. MySQL show status – active or total connections?
  14. How to auto generate migrations with Sequelize CLI from Sequelize models?
  15. How to access a RowDataPacket object
  16. Retrieve last inserted id with Mysql
  17. How to pass parameters to mysql query callback in nodejs
  18. Making changes to multiple records based on change of single record with SQL
  19. node.js + mysql connection pooling
  20. connect ECONNREFUSED – node js , sql
  21. How to make join queries using Sequelize on Node.js
  22. NodeJS MySQL Dump
  23. Node.js connect to MySQL Docker container ECONNREFUSED
  24. mySQL Error 1040: Too Many Connection
  25. NodeJS responded MySQL timezone is different when I fetch directly from MySQL
  26. Which ORM should I use for Node.js and MySQL? [closed]
  27. How to kill MySQL connections
  28. find number of rows in returned mysql result (nodejs)
  29. Counting associated entries with Sequelize
  30. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)

Leave a Comment