MySQL Error: Too Many Connections

Discussion in 'MySQL' started by Dragonkiller, Aug 8, 2006.

0
  1. #1
    Hi,

    Sometimes during busy parts of the day, my site shows a 'Too Many Connections' error.

    I know it's to do with the maximum default being 100, and that I need to change the 'max_connections' in the my.cnf file. I am on a dedicated Linux server.

    How can I change the max_connections to a higher number?
    When I type '/etc/my.cnf' in SSH, I get '/etc/my.cnf: Permission denied'

    -Thanks
     
    Dragonkiller, Aug 8, 2006 IP
  2. DanInManchester

    DanInManchester Active Member

    Messages:
    116
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    53
    #2
    I don't know if php is the same as asp/asp.net but 100 concurrent connections is one hell of a lot of traffic if they are being used correctly.

    I think more likely from past experiences this is likely to because you are not closing and disposing of your connection objects correctly.

    open late, close early ... (my kind of job :p)
     
    DanInManchester, Aug 8, 2006 IP