Announcement

Collapse
No announcement yet.

Insane Server Load

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

  • Insane Server Load

    Over the past couple of months I've been having problems with my forums killing my server from excessive resource waste, which is kind of strange considering it's a dedicated Dual P3 700 with a gig of memory. I was running 2.0.0 and eventually deleted my 5700 member forum to install the latest version from scratch, hoping it'd help clear out these problems.

    My server should be eating the forums for breakfast. Unfortunately, it's the other way around.

    I installed 2.2.1 just last night. My new forums have been up and running for about 8 hours now and my load-killing-server problem has happened twice already. They run smoothly for a while, then at some random interval, the entire server becomes nonresponsive for a short period of time, then eventually comes back online. After the server comes back online, the forums are empty and users have to reconnect/relogin. After the second time this happened, I checked the CP and got this:

    Server Load Averages 87.12, 82.56, 45.26

    That is insane. Eventually the load averages returned to normal, but this is a constant problem and it only occurs when the forums are enabled (when disabling the forums, the server never has any problems). This shouldn't be happening. There are typically no more than 50-60 users online my forums at the same time and there are only a few hundred registered so far. This is a pretty serious issue, as it affects the operation of the general site itself, which also requires MySQL and PHP to function.

    Has anyone else had this problem and if so, can you help me figure out what to do? Thanks.
    Last edited by Mindflare; Wed 2 Jan '02, 3:31pm.

  • #2
    Sounds like you need to tweak your server out, what are the software specs, like apache, mysql, php, what versions...


    A server like that should handle that amount of users well....


    If the server admin isn't helping, and can't tweak a server, get a new one...

    Comment


    • #3
      to diagnose your problem 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?
      :: 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


      • #4
        Sorry for taking so long to reply. I've tried numerous times to get the server tech admin to either post that information or provide me with it and I've been given nothing, so here's what I can offer.

        We are running PHP 4.0.4 and MySQL 3.23.36. Along with the forums is a site that operates with databases via SQL.

        The following is the output of the extended status script during one of these server-owning-resource-killing events.

        11:14pm up 11 days, 7:10, 2 users, load average: 93.19, 96.16, 52.84
        267 processes: 206 sleeping, 61 running, 0 zombie, 0 stopped
        CPU0 states: 95.0% user, 4.11% system, 0.0% nice, 0.0% idle
        CPU1 states: 93.8% user, 6.2% system, 0.0% nice, 0.1% idle
        Mem: 771056K av, 762936K used, 8120K free, 0K shrd, 3080K buff
        Swap: 787416K av, 19596K used, 767820K free 261184K cached

        PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND
        13009 mysql 15 0 23548 15M 3652 R 3.7 2.0 0:00 mysqld
        13012 mysql 19 0 23548 15M 3652 R 3.5 2.0 0:00 mysqld
        12936 mysql 16 0 23548 15M 3652 R 3.1 2.0 0:01 mysqld
        12973 mysql 20 0 23548 15M 3652 R 3.0 2.0 0:01 mysqld
        12926 mysql 19 0 23548 15M 3652 R 2.8 2.0 0:01 mysqld
        12968 mysql 20 0 23548 15M 3652 R 2.8 2.0 0:01 mysqld
        12937 mysql 16 0 23548 15M 3652 R 2.7 2.0 0:01 mysqld
        12932 mysql 15 0 23548 15M 3652 R 2.6 2.0 0:01 mysqld
        12974 mysql 20 0 23548 15M 3652 R 2.6 2.0 0:00 mysqld
        12984 mysql 16 0 23548 15M 3652 R 2.6 2.0 0:00 mysqld
        26401 mysql 14 0 23592 15M 3652 R 2.5 2.0 7787m mysqld
        12894 mysql 14 0 23672 15M 3652 R 2.5 2.0 0:02 mysqld
        12914 mysql 14 0 23672 15M 3652 R 2.5 2.0 0:01 mysqld
        12964 mysql 18 0 23548 15M 3652 R 2.5 2.0 0:01 mysqld
        12915 mysql 18 0 23672 15M 3652 R 2.3 2.0 0:01 mysqld
        12918 mysql 20 0 23672 15M 3652 R 2.3 2.0 0:01 mysqld
        12922 mysql 20 0 23672 15M 3652 R 2.3 2.0 0:01 mysqld
        12965 mysql 16 0 23548 15M 3652 R 2.2 2.0 0:01 mysqld
        12987 mysql 15 0 23548 15M 3652 R 2.2 2.0 0:00 mysqld
        12737 mysql 14 0 23672 15M 3652 R 2.1 2.0 0:03 mysqld
        12979 mysql 16 0 23548 15M 3652 R 2.1 2.0 0:00 mysqld
        12994 mysql 15 0 23548 15M 3652 R 2.1 2.0 0:00 mysqld
        13026 mysql 14 0 23584 15M 3652 R 2.1 2.0 0:00 mysqld
        13027 mysql 14 0 23584 15M 3652 R 2.1 2.0 0:00 mysqld
        13028 mysql 20 0 23584 15M 3652 R 2.1 2.0 0:00 mysqld
        12781 mysql 14 0 23672 15M 3652 R 2.0 2.0 0:03 mysqld
        12912 mysql 14 0 23672 15M 3652 R 2.0 2.0 0:01 mysqld
        12921 mysql 14 0 23672 15M 3652 R 2.0 2.0 0:01 mysqld
        12966 mysql 16 0 23548 15M 3652 R 2.0 2.0 0:01 mysqld
        13000 mysql 19 0 23548 15M 3652 R 1.9 2.0 0:00 mysqld
        13005 mysql 14 0 23548 15M 3652 R 1.9 2.0 0:00 mysqld
        12982 mysql 16 0 23548 15M 3652 R 1.8 2.0 0:00 mysqld
        12991 mysql 16 0 23548 15M 3652 R 1.8 2.0 0:00 mysqld
        12992 mysql 16 0 23548 15M 3652 R 1.8 2.0 0:00 mysqld
        12995 mysql 15 0 23548 15M 3652 R 1.8 2.0 0:00 mysqld
        12996 mysql 19 0 23548 15M 3652 R 1.8 2.0 0:00 mysqld
        13018 mysql 18 0 23548 15M 3652 R 1.8 2.0 0:00 mysqld
        13025 mysql 16 0 23548 15M 3652 R 1.8 2.0 0:00 mysqld
        13014 mysql 17 0 23548 15M 3652 R 1.7 2.0 0:00 mysqld
        12997 mysql 15 0 23548 15M 3652 R 1.6 2.0 0:00 mysqld
        13008 mysql 16 0 23548 15M 3652 R 1.6 2.0 0:00 mysqld
        13015 mysql 16 0 23548 15M 3652 R 1.6 2.0 0:00 mysqld
        13023 mysql 14 0 23548 15M 3652 R 1.6 2.0 0:00 mysqld
        13029 mysql 14 0 23584 15M 3652 R 1.6 2.0 0:00 mysqld
        13031 mysql 19 0 23584 15M 3652 R 1.6 2.0 0:00 mysqld
        13032 mysql 20 0 23584 15M 3652 R 1.6 2.0 0:00 mysqld
        13030 mysql 14 0 23584 15M 3652 R 1.5 2.0 0:00 mysqld
        13033 mysql 20 0 23584 15M 3652 R 1.5 2.0 0:00 mysqld
        13035 mysql 15 0 23584 15M 3652 R 1.4 2.0 0:00 mysqld
        13021 mysql 15 0 23548 15M 3652 R 1.3 2.0 0:00 mysqld
        13036 mysql 17 0 23584 15M 3652 R 1.1 2.0 0:00 mysqld
        13037 mysql 18 0 23584 15M 3652 R 1.0 2.0 0:00 mysqld
        13039 mysql 19 0 23584 15M 3652 R 1.0 2.0 0:00 mysqld
        13038 mysql 17 0 23584 15M 3652 R 0.8 2.0 0:00 mysqld
        13041 mysql 18 0 23584 15M 3652 R 0.5 2.0 0:00 mysqld
        13040 mysql 15 0 23584 15M 3652 R 0.3 2.0 0:00 mysqld
        13042 mysql 15 0 23584 15M 3652 R 0.1 2.0 0:00 mysqld
        464 mysql 17 0 23592 15M 3652 R 0.0 2.0 11:42 mysqld
        13043 mysql 17 0 23584 15M 3652 R 0.0 2.0 0:00 mysqld

        Mon Jan 7 23:14:51 EST 2002
        Hopefully you can make sense of this. Any help would be greatly appreciated.

        Comment


        • #5
          i still need more info that i originally requested above in order to help you
          :: 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


          • #6
            I have analogic trouble

            Hello!

            I have analogic trouble with vbulletin 2.2.1.
            I have my own deducated server PIII-800 under Linux RedHat 7.1 with mySQL 3.26 and Apache 1.3.19 (mod_php is compiled in apache) and php 4.

            After installation of Vbulletin - my server is begin work extremely slow when more than 6-7 peoples on the forums.

            Average loads of my server is ~ same as on server of this thread author.

            I am reoptimized vbulletin mysql databases - but no luck.

            Where can be trouble?

            PS: Before installation of vbulletin I recompile kernel to 2.4.14 kernel with ext3 filesystem and convert filesystem to ext3 - but not was be same trouble.

            Best Regards,
            Alex

            Comment

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