Too many connections error in 3.5

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • rreyes1
    New Member
    • Nov 2003
    • 4

    Too many connections error in 3.5

    Hello all

    I get the following error after upgrading to 3.5

    mysql_connect(): Too many connections
    /home/www/latazzinacafe/forums/includes/class_core.php on line 273

    any help will be appreciated....
    Bob
  • George L
    Former vBulletin Support
    • May 2000
    • 32996
    • 3.8.x

    #2
    Please read http://dev.mysql.com/doc/mysql/en/to...nnections.html. Would be best if you can provide the info asked at http://www.vbulletin.com/forum/showthread.php?t=70117 ask your web host for the info if you don't have a dedicated server or root server ssh telnet access. For shared hosted users you will need your web host to make the changes.

    If you get a Too many connections error when you try to connect to the mysqld server, this means that all available connections are in use by other clients.

    The number of connections allowed is controlled by the max_connections system variable. Its default value is 100. If you need to support more connections, you should restart mysqld with a larger value for this variable.

    The maximum number of connections MySQL can support depends on the quality of the thread library on a given platform. Linux or Solaris should be able to support 500-1000 simultaneous connections, depending on how much RAM you have and what your clients are doing. Static Linux binaries provided by MySQL AB can support up to 4000 connections.

    There's a few things to note:

    1. vB user online concurrently is based on default 15 min or 900 second cookie time out and is different from mysql concurrent connections ( max_connections / max_used_connections limit)

    2. MySQL regardless of forum software, provided it has the right hardware and mysql, php and apache configuration is good for theoretically 1000 - 1500 and even 4,000 mysql concurrent connections (4,000 with the mysql staticly compiled rpm binaries) based on single dual cpu server setup (excluding dual, quad p4 xeons which could handle more)

    3. this means you can have 1000 vB users online displayed but they actually can use 200 - 700 concurrent mysql max connections since vB shows those 1000 vB users over 15 mins / 900s and not the exact same second, you can have any combination

    i.e.

    300 members + 700 guests = 1000 vb users online past 15 min, with only 300 - 500 mysql concurrent connections in use

    or

    500 members + 500 guests = 1000 vb users online past 15min, with 500 - 800 mysql concurrent connections in use

    both examples show 1,000 vb users online past 15mins but the latter example could place more load on the server due to more mysql concurrent connection usage
    :: 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...