The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Server load problem.

Discussion in 'General Discussion' started by rvbalraj, May 29, 2008.

  1. rvbalraj

    rvbalraj Member

    Joined:
    Aug 28, 2006
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    1
    Hello,

    We have a drupal.org based flash online arcade games website

    when online visitors reach 1050+ server gets crash

    flash files size 300 Kb to 1 MB files ( when 1000+ users there will be 50 to 70 request for flash files ).

    images 25 kb to 50 kb ( when 1000+ users there will be 50 to 70 request for image files ).

    ==== server spec

    Intel 2.13 GHz 1066FSB - Kentsfield Xeon 3210 (Quad Core)

    Dell Single socket 1067FSB - Quad Core Capable PowerEdge 840

    Generic 4 GB DDR2 667 ECC

    Western Digital 250GBATA:7200RPM WD2500JD sda

    single proc multi core Kentsfield system

    ===================

    DB is shifted to another server ( after this crash started )

    ===================

    First server had 2 GB ram ( after this crash we changed to 4 GB, after RAM increase there is no difference at all).

    ==========

    This server is not capable of handling this request or we have other problems ?

    Server TOP report:
    ==================

    (1-a) Top command (2 intervals)
    top - 16:46:02 up 11 min, 3 users, load average: 0.71, 0.32, 0.15
    Tasks: 286 total, 1 running, 284 sleeping, 0 stopped, 1 zombie
    Cpu(s): 27.7% us, 4.2% sy, 0.0% ni, 67.4% id, 0.6% wa, 0.2% hi, 0.0% si
    Mem: 4151256k total, 722828k used, 3428428k free, 28928k buffers
    Swap: 2048276k total, 0k used, 2048276k free, 176212k cached

    PID USER PR NI %CPU TIME+ %MEM VIRT RES SHR S COMMAND
    5046 nobody 15 0 12 0:01.59 0.2 25000 9768 3004 S httpd
    5246 nobody 15 0 12 0:00.36 0.2 25108 9816 3024 S httpd
    5257 nobody 15 0 12 0:00.66 0.2 24996 9768 3008 S httpd
    5166 nobody 15 0 11 0:00.34 0.2 24992 9760 3004 S httpd
    5065 nobody 15 0 11 0:00.33 0.2 24988 9756 3004 S httpd
    5231 nobody 15 0 10 0:00.68 0.2 25812 9936 3028 S httpd
    5241 nobody 15 0 10 0:00.62 0.2 25144 9908 3000 S httpd
    5032 nobody 15 0 10 0:00.98 0.2 25152 9920 3004 S httpd
    5035 nobody 15 0 10 0:01.68 0.2 25000 9772 3008 S httpd
    5245 nobody 15 0 10 0:01.19 0.2 24988 9756 3004 S httpd
    5248 nobody 15 0 10 0:00.95 0.2 24988 9760 3008 S httpd
    5115 nobody 15 0 3 0:00.93 0.2 24988 9760 3008 S httpd

    (1-b)
    top - 16:54:23 up 19 min, 3 users, load average: 2.35, 1.78, 0.91
    Tasks: 363 total, 2 running, 361 sleeping, 0 stopped, 0 zombie
    Cpu(s): 15.6% us, 2.5% sy, 0.0% ni, 80.9% id, 1.0% wa, 0.1% hi, 0.0% si
    Mem: 4151256k total, 1001484k used, 3149772k free, 30764k buffers
    Swap: 2048276k total, 0k used, 2048276k free, 280196k cached

    PID USER PR NI %CPU TIME+ %MEM VIRT RES SHR S COMMAND
    5109 nobody 16 0 50 0:03.77 0.6 39720 23m 3012 S httpd
    5122 nobody 15 0 46 0:03.38 0.2 25160 9936 3012 S httpd
    5062 nobody 15 0 19 0:04.13 0.2 24996 9772 3012 S httpd
    5949 nobody 15 0 17 0:00.38 0.2 25144 9860 2988 S httpd
    5015 nobody 16 0 12 0:05.77 0.3 27864 12m 3008 R httpd
    5931 nobody 15 0 6 0:00.37 0.2 25144 9872 3000 S httpd
    5954 nobody 15 0 6 0:00.58 0.6 39712 23m 2992 S httpd
    5019 nobody 15 0 2 0:04.91 0.2 25112 9912 3036 S httpd
    5115 nobody 15 0 2 0:03.90 0.2 25012 9784 3008 S httpd
    5148 nobody 15 0 2 0:04.61 0.2 25008 9776 3004 S httpd
    5431 nobody 15 0 2 0:03.15 0.2 25008 9780 3008 S httpd
    5923 nobody 15 0 2 0:00.61 0.2 24988 9756 3004 S httpd



    (2)Mysql report (Read/Writes)
    =============================


    | 1234268 | Sleep | 964 |
    | 1234270 | Connect | | Reading from net
    | 1234271 | unauthenticated user | | Connect | | Reading from net
    | 1237287 | Query | 0 | Sorting result | SELECT g.id, g.anonname, g.author, g.recipient,
    | 1247882 | Query | 0 | freeing items | SELECT * FROM votingapi_cache v WHERE
    content_type='node' AND content_id=417 AND value_type='percent |
    | 1247884 | Query | 0 | Writing to net | SELECT data, created, headers, expire FROM
    cache_menu WHERE cid = '0:en' |
    | 1247885 | Query | 0 | Writing to net | SELECT data, created, headers, expire FROM
    cache_menu WHERE cid = '0:en'


    Uptime: 2 days 2 hours 43 min 2 sec
    Threads: 758 Questions: 204944742 Slow queries: 31 Opens: 492 Flush tables: 1 Open tables: 454 Queries per second avg: 1122.481

    (3)
    RSS column shows non-swapped physical memory usage by Apache

    S UID PID PPID C PRI NI RSS SZ WCHAN TTY TIME CMD
    S 99 7104 4998 0 75 0 8444 6084 408622 ? 00:00:00 httpd
    S 99 7117 4998 0 76 0 8444 6090 - ? 00:00:00 httpd
    S 99 6902 4998 0 75 0 8456 6084 408120 ? 00:00:00 httpd
    S 99 7116 4998 0 75 0 8456 6084 409176 ? 00:00:00 httpd
    S 99 6171 4998 0 75 0 8460 6084 410032 ? 00:00:00 httpd
    S 99 6940 4998 0 75 0 9748 6246 408121 ? 00:00:00 httpd
    S 99 6932 4998 0 75 0 9756 6248 408653 ? 00:00:00 httpd
    S 99 5514 4998 0 75 0 9760 6247 410069 ? 00:00:03 httpd
    S 99 6160 4998 0 75 0 9760 6247 410056 ? 00:00:01 httpd
    S 99 5109 4998 0 75 0 9764 6247 409886 ? 00:00:05 httpd
    S 99 5918 4998 0 75 0 9764 6248 409675 ? 00:00:03 httpd
    S 99 6754 4998 1 75 0 9764 6248 408559 ? 00:00:01 httpd
    S 99 6784 4998 1 75 0 9764 6249 408106 ? 00:00:01 httpd
    S 99 6819 4998 0 75 0 9764 6249 408105 ? 00:00:00 httpd
    S 99 6936 4998 0 75 0 9764 6249 408917 ? 00:00:00 httpd
    S 99 5020 4998 0 75 0 9768 6249 413012 ? 00:00:09 httpd
    S 99 5028 4998 0 75 0 9768 6249 412929 ? 00:00:06 httpd
    S 99 5045 4998 0 75 0 9768 6249 412814 ? 00:00:08 httpd
    S 99 5059 4998 0 76 0 9768 6249 410461 ? 00:00:06 httpd


    (4) Apache netstat Report
    ===========================

    netstat -n | grep :80 |wc -l - Report

    Number of Http active connections : 537
    Details....

    235 ESTABLISHED
    199 TIME_WAIT
    60 FIN_WAIT2
    19 SYN_RECV
    19 FIN_WAIT1
    5 LAST_ACK
    1 LISTEN
    1 CLOSE_WAIT

    (5) Load Average
    =================

    17:09:28 up 34 min, 3 users, load average: 3.76, 2.90, 1.96

    (6) Free Memory (RAM Now 4GB)
    total used free shared buffers cached
    Mem: 4053 1392 2661 0 33 371

    (7) process status of apache
    nobody 7736 0.7 0.2 25160 9928 ? S 17:11 0:00 /usr/local/apache/bin/httpd
    nobody 7737 0.9 0.2 25004 9776 ? S 17:11 0:01 /usr/local/apache/bin/httpd
    nobody 7738 0.7 0.2 24996 9768 ? S 17:11 0:00 /usr/local/apache/bin/httpd
    nobody 7739 0.5 0.2 24996 9764 ? S 17:11 0:00 /usr/local/apache/bin/httpd
    nobody 7741 0.5 0.2 24988 9756 ? S 17:11 0:00 /usr/local/apache/bin/httpd
    nobody 7742 1.0 0.2 25152 9924 ? S 17:11 0:01 /usr/local/apache/bin/httpd
    nobody 7743 1.3 0.2 25160 9932 ? S 17:11 0:01 /usr/local/apache/bin/httpd
    nobody 7746 1.1 0.2 25144 9912 ? S 17:11 0:01 /usr/local/apache/bin/httpd
    nobody 7750 0.5 0.2 25144 9908 ? S 17:11 0:00 /usr/local/apache/bin/httpd
    nobody 7751 0.2 0.2 24988 9756 ? S 17:11 0:00 /usr/local/apache/bin/httpd
    nobody 7768 0.7 0.2 25352 10088 ? S 17:11 0:00 /usr/local/apache/bin/httpd
    nobody 7797 0.8 0.2 25004 9772 ? S 17:11 0:00 /usr/local/apache/bin/httpd
    nobody 7798 2.0 0.2 24996 9764 ? S 17:11 0:01 /usr/local/apache/bin/httpd
    nobody 7799 0.8 0.2 24996 9764 ? S 17:11 0:00 /usr/local/apache/bin/httpd
    nobody 7800 1.7 0.2 25412 9988 ? S 17:11 0:01 /usr/local/apache/bin/httpd
    nobody 7826 1.4 0.2 25384 9940 ? S 17:12 0:00 /usr/local/apache/bin/httpd
    nobody 7827 0.6 0.2 24996 9760 ? S 17:12 0:00 /usr/local/apache/bin/httpd
    nobody 7835 2.4 0.2 25004 9772 ? S 17:12 0:01 /usr/local/apache/bin/httpd
     
  2. ramprage

    ramprage Well-Known Member

    Joined:
    Jul 21, 2002
    Messages:
    667
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Canada
    You're not running out of 4 gigs of ram - you're not even using any of your swap space.

    The server load is also extremely low.

    I think you need to adjust your apache/mysql configurations. It looks like your hardware isn't even breaking a sweat.
     
Loading...

Share This Page