Re: Mysql suddenly stop all connections during operation

[Jerry Leung]

Hi,

Continue the question, I has monitored the mysql server connection state, I found that on some stated MYSQL Administrator --> Server Connections --> User Connections, the listing of all active connection threads will increase during my system operate,but on some stated the connection threads will not increase. It is so strange.

and other question, if the active threads were represented the active opening connections from my program to mysql server which active when connection.open() tiggered, so why the thread will not disappear during connection.close()?

I have found that during I using the tool "Mysql Query Browser" a new Thread will create, and when I close the tool, the thread will be disappear. why?

Thanks for any powerful programmer to help me solve the problem.

Jerry