Home > database >  A large number of clients to connect mysql to perform insert, the client runs collapse after a perio
A large number of clients to connect mysql to perform insert, the client runs collapse after a perio

Time:10-08

Use MFC to do a small middleware software, the function is read at local access database and insert the new data to the mysql database server, the first test run only for middleware, have long run normally without error, but officially put into use, and extended to more than one hundred clients running at the same time, the results appeared to run a few hours later the middleware will collapse, this is what causes?
Mysql version for 5.7.28, maximum number of connections have been set up, is greater than the amount of connection, connection mysql using odbc middleware, perform a data synchronization per minute, will have a new local data into a mysql, why only a few client runtime, there is no problem, but once more will collapse, is a question of middleware or mysql setup is not correct, should be how to modify,
The key is when I was in writing middleware put all the wrong places may occur in the try catch, also will have any problems during the test pop-up error prompt, but the user is middleware run after a period of time no play window directly collapse automatically shut down, is very strange, want to ask the bosses,

CodePudding user response:

MFC client crash is likely to be the client and the server the abnormal, normal communication server under pressure from more than 100 clients hands are full? , you are the best server log, didn't know the problem,
  • Related