Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Ask a Question
Welcome To Ask or Share your Answers For Others

Categories

nodejs连接mysql会断开

0 votes
149 views
in Technique[技术] by (71.8m points)

nodejs连接mysql会断开

之前用nodejs连接mysql每隔几分钟就会断开一次
然后按照stackoverflow上的回答将连接改成了连接池
image.png
image.png
虽然可以保持长时间连接不断开，但是一旦有十分钟左右的时间没与数据库通信，第一次的通信时间就会显著变长
而且一旦几天内没进行通信(具体时间不清楚 超过八个小时)依旧会无法连接到数据库


与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)

不都是这样子的吗，用到的时候连下，不用了就断开连接。不然mysql会一直被占用着别人就没法用了呀


与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

Just Browsing Browsing

2.1m questions

2.1m answers

60 comments

56.6k users

Most popular tags

Powered by Question2Answer
Donate
Theme by Q2A Market&&OStack.cn
...