High Traffic Drupal Sites

Discussion in 'Drupal' started by superpump, Mar 14, 2007.

  1. #1
    Does anyone with a high traffic drupal site ever have their site crash due to "limited connection strings" (data base error)
     
    superpump, Mar 14, 2007 IP
  2. sadcox66

    sadcox66 Spirit Walker

    Messages:
    496
    Likes Received:
    16
    Best Answers:
    0
    Trophy Points:
    0
    #2
    create a file called phpinfo.php with
     <?php phpinfo(); ?>
    Code (markup):
    and execute it /yourdomain.com/phpinfo.php

    Look at the lines
    
    mysql.max_links	Unlimited	Unlimited
    mysql.max_persistent	Unlimited	Unlimited
    mysql.trace_mode	Off	Off
    
    Code (markup):
    see if there is any limits placed on your site. Also turn or Persistant connection in your software if you have it set.
    Depending on your permissions and your webhosting setup you may be able to change mysql.max_links from phpMyAdmin
    or contact your webhost
     
    sadcox66, Mar 16, 2007 IP
  3. sadcox66

    sadcox66 Spirit Walker

    Messages:
    496
    Likes Received:
    16
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Superpump, post your setting of
    
    mysql.max_links
    mysql.max_persistent
    
    Code (markup):
    when you run phpinfo();

    Another thing you can do - if you do not want to write phpinfo() is
    locate phpMyAdmin from your database console and look at the resources
    and processes. If you mention your web hosting console i can give your more accurate information.
     
    sadcox66, Mar 18, 2007 IP
  4. Tearabite

    Tearabite Prominent Member

    Messages:
    4,628
    Likes Received:
    429
    Best Answers:
    0
    Trophy Points:
    300
    #4
    SuperPump;
    i'm curious - how "high" is high-traffic?
     
    Tearabite, Mar 23, 2007 IP