Connections problem

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • glob2
    New Member
    • Feb 2003
    • 16

    Connections problem

    Hi,
    I have UNIX server and host some clients that they are using the vBulletin 2.2.9
    And for some times i have all the sites will freeze and database will not working.
    after i checked everything i found that all the databases are opening the connections and not close the connections
    so the sleeping time will be to high, and the server will freeze.
    once i restart the MySql server or the server, it will work again fine, but after some time it will happend again

    Please tell me what i have to do

    Regards,

    MKD
  • Joe Gronlund
    Senior Member
    • Nov 2001
    • 5789
    • 3.8.x

    #2
    make sure

    // use persistant connections to the database
    // 0 = don't use
    // 1 = use
    $usepconnect = 0;



    is disabled , = 0

    in admin/config.php
    MCSE, MVP, CCIE
    Microsoft Beta Team

    Comment

    • glob2
      New Member
      • Feb 2003
      • 16

      #3
      problem still with one user only

      Thank you, i did that for all the users and all of them are ok now...

      // use persistant connections to the database
      // 0 = don't use
      // 1 = use
      $usepconnect=0;

      BUT i have only one user which his database still make the same problem

      sulaiman | localhost | vb | Sleep | 392 | | |
      | 42 | sulaiman | localhost | vb | Sleep | 361 | | |
      | 83 | sulaiman | localhost | vb | Sleep | 217 | | |
      | 143 | sulaiman | localhost | vb | Sleep | 227 | | |
      | 195 | sulaiman | localhost | vb | Sleep | 19 | | |
      | 231 | sulaiman | localhost | vb | Sleep | 1 | | |
      | 372 | sulaiman | localhost | vb | Sleep | 4 | | |
      | 439 | sulaiman | localhost | vb | Sleep | 231 | | |
      | 599 | sulaiman | localhost | vb | Sleep | 169 | | |
      | 624 | sulaiman | localhost | vb | Sleep | 224

      Please advice

      Regards,

      MKD



      Originally posted by Asendin
      make sure

      // use persistant connections to the database
      // 0 = don't use
      // 1 = use
      $usepconnect = 0;



      is disabled , = 0

      in admin/config.php

      Comment

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