mysql

mysql copied to clipboard

If you are using a connection pool and suddenly handle more traffic than usual, the size of the connection pool increases. And the increased connections will survive because of the wait_timeout setting. (It usually set as 10-30 seconds) Keeping unnecessary connections is not good for running multiple servers.

However, this problem can not be solved because the mysql module only supports round-robin styles. So I added a pool option called stackCycle.

config.mysqlConfig.options = { host: '10.255.0.128', user: 'linkredit_devs', password: 'KBBSK0znnqMf7ZOv', database: 'linkredit', port: 3318, connectTimeout: 1000 } const pool = mysql.createPool(commonConfig.mysqlConfig.options); is it correct to configure the connection poo？

@Robert-lihouyi What's your point? If you just want to listen answer, you can check out more information https://github.com/mysqljs/mysql#pooling-connections

issue resolved, thanks very much

姓名:李厚毅 联系电话：18101082232 职位：高级前端工程师

---

From: Sangmin, Shim [email protected] Sent: Thursday, August 24, 2017 8:13:51 PM To: mysqljs/mysql Cc: Robert; Mention Subject: Re: [mysqljs/mysql] Add stackCycle feature for decrease useless connections (#1805)

@Robert-lihouyihttps://github.com/robert-lihouyi What's your point? If you just want to listen answer, you can check out more information https://github.com/mysqljs/mysql#pooling-connections

― You are receiving this because you were mentioned. Reply to this email directly, view it on GitHubhttps://github.com/mysqljs/mysql/pull/1805#issuecomment-324617812, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AOqYFktaxy6BLZOnI1nMh8CdPvje_nc8ks5sbWj_gaJpZM4O7yo6.