Made a small program of monitoring database on the server, will often go to the database, test whether can normal connection, the server and a system that will connect to the database, and database has to read and write operations, such as frequent to connect the database can have what problem? Thank you very much!

CodePudding user response:

The servers will certainly increase the pressure; Consider the business busy period, to adjust the monitoring frequency smaller;

Such as 5 minutes collecting data at a time, at ordinary times busy when taken 30 minutes;

CodePudding user response:

I now heals, connection is always connected, by querying the data to detect abnormal, such frequent than even the database can be better

CodePudding user response:

In general, it is suggested that connection, and use it every time you don't have to, immediately disconnect,

You can test and see which is more suitable for watching;