Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2004
    Posts
    57

    Unanswered: too many connection

    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?
    Last edited by GongXi; 10-23-08 at 10:34.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    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.
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jun 2004
    Posts
    57
    sorry, i not quite familiar on that.

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

    again, thanks for your fast response.

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    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
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •