Hi,

We are using mysql 3 version database, and now keep get "too many connection" . We still tracing our code on the problem. For temporary solve the problem, we try to kill connection using mysqladmin process list, however, we found that after kill the connection, it still pending on the list with status ="killed", and user still get "too many connection".
Only after we restart mysql services, then the problem solved.

do we able to restart mysql services from remote side?

any help on this?

depends on what front end you are using. check to see if the front end allows the sharing/pooling of connections
check that your front end is closing connections as soon as they have finished with it

if all else fails investigate if you can increase the number of connections

Unless you know you have that many users Id be very reluctant to alter the max_connections parameter in the MySQL setup on the grounds that you are fixing the symptoms without curing the problem.

sorry, i not quite familiar on that.

What do you mean for "frontend"? mean our program or server?

again, thanks for your fast response.

what is the software that you are using to connect to MySQL. is it PHP, ASP, VC, VB, .NET........
what is it that is creating the connection(s) in the first place.
the front end is the application software that the users interacts with, the back end is the server(s) that provide the data