Too many connection error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • mvjohn100
    New Member
    • Mar 2008
    • 57

    Too many connection error

    When I found " Too many connection error" may occur because of mysql default allowed maximum connection of 100. I changed it to a big value. but even my fedora shows the same error what are the other causes for "Too many connection error"

    Thanks in advance
    john
  • ashitpro
    Recognized Expert Contributor
    • Aug 2007
    • 542

    #2
    Originally posted by mvjohn100
    When I found " Too many connection error" may occur because of mysql default allowed maximum connection of 100. I changed it to a big value. but even my fedora shows the same error what are the other causes for "Too many connection error"

    Thanks in advance
    john
    If you've modified my.conf, have you tried restarting the mysql service?

    Comment

    • mvjohn100
      New Member
      • Mar 2008
      • 57

      #3
      Thanks for the suggestion, I done that, but the problem exists. Is there any other things cause for "too many connections"

      john

      Comment

      • ashitpro
        Recognized Expert Contributor
        • Aug 2007
        • 542

        #4
        It looks like some process is utilizing your resources without controll
        you can list out the processes which are using mysql...
        just hit "[FONT=courtier,m onospace]show processlist" command at mysql command prompt and see whats going wrong...

        Regards,
        Ash
        [/FONT]

        Comment

        Working...