Announcement

Collapse
No announcement yet.

Mysql "too many connections" problems constant -need help

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Mysql "too many connections" problems constant -need help

    Warning: Too many connections in /usr/local/psa/home/vhosts/site.com/httpdocs/board/admin/db_mysql.php on line 40

    It happend couple of time already, restarting the server works as a temp solution but how can I avoid this problem without having to constantly restart server every week or so.

    I don't know to much about mysql other then how to use it. I guess it's just a matter of opening up a few more connections and changing the settings.

    Can someone guide me a bit on how to do this, please try to give a detail description if possible and you have the time. Like how and what to edit and how to restart the mysql server alone.

    Hope you can help.

    Thanks

    Dom

  • #2
    http://www.mysql.com/doc/T/o/Too_many_connections.html

    ask your host to increase mysql's max_connections setting or if you have your own server you can edit or create a my.cnf in /etc/my.cnf and add the entries yourself
    :: Always Back Up Forum Database + Attachments BEFORE upgrading !
    :: Nginx SPDY SSL - World Flags Demo [video results]
    :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

    Comment


    • #3
      I have my own server what should I put in this cnf file and what is the exact command for restarting mysql alone?

      Thanks eva2000

      Comment


      • #4
        let's see can you please provide the following

        1. your server specs, such as mysql and php version
        2. if possible how mysql was compiled/installed
        3. your top stats
        4. your mysql configuration variables located at /etc/my.cnf or c:\my.cnf if on Windows server if you don't have that file you need to log into telnet and as root user type

        mysqladmin -u root -p variables

        copy and paste output here

        5. your mysql extended-status output either still telnet as root user type

        mysqladmin -u root -p extended-status

        copy and paste output here

        or preferred is to installed extended-status output script which is located at http://vbulletin.com/forum/showthread.php?threadid=3477

        and post url to that here

        6. oh and is your vB the only thing on the server? or other scripts? sites?

        7. how many average and max concurrent users on your vB forum ?
        :: Always Back Up Forum Database + Attachments BEFORE upgrading !
        :: Nginx SPDY SSL - World Flags Demo [video results]
        :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

        Comment

        widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
        Working...
        X