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.

How to Reduce VPS Load ?

Discussion in 'Workarounds and Optimization' started by Kenpachi, Jun 13, 2012.

  1. Kenpachi

    Kenpachi Member

    Joined:
    Nov 28, 2010
    Messages:
    22
    Likes Received:
    0
    Trophy Points:
    1
    Hi

    I've received warning email from my hosting to reduce the server load.

    Code:
    Hi Sir,
    
    Please be informed that, after checked from our monitoring system we have found out the node keep on rebooting was due to your VPS has overloaded the node refers to attachment file.
    
    15807 nobody 16 0 120m 33m 10m S 40.3 1.6 0:10.79 /usr/local/apache/bin/httpd -k start -DSSL
    15804 nobody 16 0 119m 32m 11m S 39.6 1.6 0:11.68 /usr/local/apache/bin/httpd -k start -DSSL
    15958 nobody 15 0 119m 31m 10m S 31.6 1.5 0:04.23 /usr/local/apache/bin/httpd -k start -DSSL
    16060 nobody 16 0 118m 30m 9m S 30.3 1.5 0:01.15 /usr/local/apache/bin/httpd -k start -DSSL
    15805 nobody 15 0 118m 31m 11m S 27.6 1.6 0:09.18 /usr/local/apache/bin/httpd -k start -DSSL
    15797 nobody 16 0 120m 34m 12m S 24.6 1.7 0:11.02 /usr/local/apache/bin/httpd -k start -DSSL
    15800 nobody 16 0 122m 35m 10m S 22.6 1.7 0:08.81 /usr/local/apache/bin/httpd -k start -DSSL
    15798 nobody 16 0 118m 32m 11m S 20.6 1.6 0:09.59 /usr/local/apache/bin/httpd -k start -DSSL
    15802 nobody 15 0 121m 33m 10m S 18.3 1.6 0:12.44 /usr/local/apache/bin/httpd -k start -DSSL
    15806 nobody 15 0 121m 34m 11m S 17.6 1.7 0:11.37 /usr/local/apache/bin/httpd -k start -DSSL
    16095 nobody 16 0 121m 31m 9560 R 16.6 1.6 0:00.50 /usr/local/apache/bin/httpd -k start -DSSL
    15820 nobody 16 0 118m 31m 11m R 16.3 1.6 0:07.69 /usr/local/apache/bin/httpd -k start -DSSL
    15832 nobody 16 0 120m 32m 10m S 13.3 1.6 0:06.55 /usr/local/apache/bin/httpd -k start -DSSL
    16007 nobody 15 0 116m 28m 10m S 5.7 1.4 0:02.32 /usr/local/apache/bin/httpd -k start -DSSL
    15763 nobody 15 0 26708 12m 828 S 2.7 0.6 0:00.54 nginx: worker process
    32720 mysql 17 0 220m 67m 3460 S 1.3 3.3 1:40.47 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/vps2660.pun
    15808 nobody 15 0 118m 31m 10m S 0.7 1.5 0:11.03 /usr/local/apache/bin/httpd -k start -DSSL
    15819 nobody 16 0 118m 30m 10m S 0.7 1.5 0:09.24 /usr/local/apache/bin/httpd -k start -DSSL
    1 root 15 0 2072 656 560 S 0.0 0.0 0:00.02 init [3]
    1736 root 18 0 1664 424 352 S 0.0 0.0 0:00.00 /usr/sbin/courierlogger -pid=/var/run/imapd.pid -start -name=imapd /usr/lib/courier-imap/libexec/courier
    1737 root 15 0 1772 536 460 S 0.0 0.0 0:00.00 /usr/lib/courier-imap/libexec/couriertcpd -address=0 -maxprocs=50 -maxperip=30 -nodnslookup -noidentlook
    1743 root 25 0 1664 332 276 S 0.0 0.0 0:00.00 /usr/sbin/courierlogger -pid=/var/run/imapd-ssl.pid -start -name=imapd-ssl /usr/lib/courier-imap/libexec
    1744 root 18 0 1772 520 440 S 0.0 0.0 0:00.00 /usr/lib/courier-imap/libexec/couriertcpd -address=0 -maxprocs=50 -maxperip=30 -nodnslookup -noidentlook
    1750 root 18 0 1664 424 352 S 0.0 0.0 0:00.00 /usr/sbin/courierlogger -pid=/var/run/pop3d.pid -start -name=pop3d /usr/lib/courier-imap/libexec/courier
    1751 root 18 0 1772 536 460 S 0.0 0.0 0:00.01 /usr/lib/courier-imap/libexec/couriertcpd -address=0 -maxprocs=50 -maxperip=30 -nodnslookup -noidentlook
    1760 root 18 0 1664 332 276 S 0.0 0.0 0:00.00 /usr/sbin/courierlogger -pid=/var/run/pop3d-ssl.pid -start -name=pop3d-ssl /usr/lib/courier-imap/libexec
    1768 root 20 0 1772 516 440 S 0.0 0.0 0:00.00 /usr/lib/courier-imap/libexec/couriertcpd -address=0 -maxprocs=50 -maxperip=30 -nodnslookup -noidentlook
    
    
    Kindly do reduce the resources usage immediately or ask your programmer to check the scripts, below is the details of applications name being consuming high resources:
    
    
    3 nginx:
    3 /usr/libexec/courier-authlib/authdaemond
    4 /usr/lib/courier-imap/libexec/couriertcpd
    5 /usr/sbin/courierlogger
    18 /usr/local/apache/bin/httpd
    
    Do check immediately before we do suspend the VPS and update us the result.

    VPS is with 2gb ram

    Mysql confi is as following:

    Code:
    [mysqld]
    local-infile=0
    datadir = /var/lib/mysql
    log-slow-queries=/var/lib/mysql/slow.log
    log-queries-not-using-indexes=var/lib/mysql/slowindex.log
    skip-innodb
    max_connections = 200
    key_buffer_size = 32M
    myisam_sort_buffer_size = 64M
    join_buffer_size = 6M
    read_buffer_size = 1M
    sort_buffer_size = 3M
    table_cache = 1152
    thread_cache_size = 144
    wait_timeout = 120
    interactive_timeout = 10
    connect_timeout = 10
    tmp_table_size = 256M
    max_heap_table_size = 256M
    max_connect_errors = 10
    read_rnd_buffer_size = 1M
    bulk_insert_buffer_size = 8M
    query_cache_limit = 2M
    query_cache_size = 128M
    query_cache_type = 1
    
    [mysqld_safe]
    log-error=/var/log/mysqld.log
    open_files_limit = 4096
    
    [mysqldump]
    max_allowed_packet = 16M
    
    [myisamchk]
    key_buffer_size = 32M
    sort_buffer_size = 16M
    read_buffer_size = 16M
    write_buffer_size = 16M
    
     
  2. Kenpachi

    Kenpachi Member

    Joined:
    Nov 28, 2010
    Messages:
    22
    Likes Received:
    0
    Trophy Points:
    1
    Server Stats from mysqlmonlite.sh are attached below

    Im running vbulletin 3.8.4 with vbseo 3.6 on this vps with 900sec as cookie timeout with 10-15 members browsing and 800-900 guests.

    Code:
    
    -------------------------------------------------------------
    System MySQL monitoring stats
    mysqlmymonlite.sh - v0.4.0 WHM mysqlmymon.com
    compiled by George Liu (eva2000) vbtechsupport.com
    -------------------------------------------------------------
    
    Report Generated:
    Thu Jun 14 15:18:36 GMT-8 2012
    
    ----------------------------
    MySQL Uptime:
    ----------------------------
    MySQL server was started 
    Uptime: 1 day 8 min 13 sec  
    Uptime 86893
    
    Max Used Connections:      201/200 (100.50%)
    Key Buffer Used:           28.32M/32.00M (88.49%)
    Current Key Buffer Usage:  32.00M (100.00%)
    Query Cache:               38.83M/128.00M (30.33%)
    Table Locks Waited:        21.95k Rate: 0.3/s (0.57%)
    --------------------
    Query Cache Limit (bytes): 2097152
    Query Cache Min Unit (bytes): 4096
    Query Cache Size (bytes): 134217728
    Query Cache Free Mem (bytes): 93506096
    Query Cache Used Mem (bytes): 40711632
    Queries in Query Cache: 1
    Query Cache Avg Size (bytes): 40711632
    
    ----------------------------
    Hardware Info:
    ----------------------------
    Processors physical = 2, cores = 8, virtual = 16, hyperthreading = yes
         16  2033.630
         16  Intel(R) Xeon(R) CPU           E5520  @ 2.27GHz
         16  8192 KB
    
    
    ----------------------------
    TOP stats
    ----------------------------
    
    Linux 2.6.18-028stab070.4 ((yourserverhostname)) 	06/14/2012
    
    03:18:36 PM  CPU   %user   %nice    %sys %iowait    %irq   %soft  %steal   %idle    intr/s
    03:18:38 PM  all   14.98    0.00    1.09    0.10    0.00    0.00    0.00   83.84      0.00
    03:18:38 PM    0    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00      0.00
    03:18:38 PM    1   48.24    0.00    1.51    0.00    0.00    0.00    0.00   50.25      0.00
    03:18:38 PM    2    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00      0.00
    03:18:38 PM    3    0.00    0.00    0.51    0.00    0.00    0.00    0.00   99.49      0.00
    03:18:38 PM    4    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00      0.00
    03:18:38 PM    5    1.51    0.00    0.50    0.00    0.00    0.00    0.00   97.99      0.00
    03:18:38 PM    6    1.50    0.00    0.00    1.00    0.00    0.00    0.00   97.50      0.00
    03:18:38 PM    7   48.24    0.00    0.50    0.00    0.00    0.00    0.00   51.26      0.00
    03:18:38 PM    8    4.50    0.00    0.00    0.00    0.00    0.00    0.00   95.50      0.00
    03:18:38 PM    9    0.00    0.00    0.50    0.50    0.00    0.00    0.00   99.00      0.00
    03:18:38 PM   10    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00      0.00
    03:18:38 PM   11   69.85    0.00    1.51    0.00    0.00    0.00    0.00   28.64      0.00
    03:18:38 PM   12    3.73    0.00    0.00    0.00    0.00    0.00    0.00   96.27      0.00
    03:18:38 PM   13    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00      0.00
    03:18:38 PM   14   20.50    0.00   12.00    0.00    0.00    0.00    0.00   67.50      0.00
    03:18:38 PM   15   36.68    0.00    0.50    0.00    0.00    0.00    0.00   62.81      0.00
    
    03:18:38 PM  CPU   %user   %nice    %sys %iowait    %irq   %soft  %steal   %idle    intr/s
    03:18:40 PM  all   14.98    0.00    0.41    0.03    0.00    0.00    0.00   84.58      0.00
    03:18:40 PM    0   45.00    0.00    1.00    0.00    0.00    0.00    0.00   54.00      0.00
    03:18:40 PM    1    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00      0.00
    03:18:40 PM    2   44.50    0.00    1.00    0.00    0.00    0.00    0.00   54.50      0.00
    03:18:40 PM    3    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00      0.00
    03:18:40 PM    4    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00      0.00
    03:18:40 PM    5    1.00    0.00    0.50    0.00    0.00    0.00    0.00   98.51      0.00
    03:18:40 PM    6    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00      0.00
    03:18:40 PM    7   29.50    0.00    1.00    0.00    0.00    0.00    0.00   69.50      0.00
    03:18:40 PM    8   34.17    0.00    1.01    0.00    0.00    0.00    0.00   64.82      0.00
    03:18:40 PM    9    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00      0.00
    03:18:40 PM   10   46.00    0.00    1.00    0.00    0.00    0.00    0.00   53.00      0.00
    03:18:40 PM   11    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00      0.00
    03:18:40 PM   12    1.00    0.00    0.50    0.00    0.00    0.00    0.00   98.51      0.00
    03:18:40 PM   13   29.65    0.00    0.50    0.00    0.00    0.00    0.00   69.85      0.00
    03:18:40 PM   14    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00      0.00
    03:18:40 PM   15    9.50    0.00    0.00    0.00    0.00    0.00    0.00   90.50      0.00
    
    Average:     CPU   %user   %nice    %sys %iowait    %irq   %soft  %steal   %idle    intr/s
    Average:     all   14.98    0.00    0.74    0.06    0.00    0.00    0.00   84.22      0.00
    Average:       0   22.61    0.00    0.50    0.00    0.00    0.00    0.00   76.88      0.00
    Average:       1   24.06    0.00    0.75    0.00    0.00    0.00    0.00   75.19      0.00
    Average:       2   22.25    0.00    0.50    0.00    0.00    0.00    0.00   77.25      0.00
    Average:       3    0.00    0.00    0.25    0.00    0.00    0.00    0.00   99.75      0.00
    Average:       4    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00      0.00
    Average:       5    1.25    0.00    0.50    0.00    0.00    0.00    0.00   98.25      0.00
    Average:       6    0.75    0.00    0.00    0.50    0.00    0.00    0.00   98.75      0.00
    Average:       7   38.85    0.00    0.75    0.00    0.00    0.00    0.00   60.40      0.00
    Average:       8   19.30    0.00    0.50    0.00    0.00    0.00    0.00   80.20      0.00
    Average:       9    0.00    0.00    0.25    0.25    0.00    0.00    0.00   99.50      0.00
    Average:      10   23.00    0.00    0.50    0.00    0.00    0.00    0.00   76.50      0.00
    Average:      11   34.84    0.00    0.75    0.00    0.00    0.00    0.00   64.41      0.00
    Average:      12    2.09    0.00    0.30    0.00    0.00    0.00    0.00   97.61      0.00
    Average:      13   14.79    0.00    0.25    0.00    0.00    0.00    0.00   84.96      0.00
    Average:      14   10.25    0.00    6.00    0.00    0.00    0.00    0.00   83.75      0.00
    Average:      15   23.06    0.00    0.25    0.00    0.00    0.00    0.00   76.69      0.00
    
    top - 15:18:40 up 1 day, 17 min,  1 user,  load average: 3.64, 3.69, 3.81
    Tasks:  65 total,   2 running,  63 sleeping,   0 stopped,   0 zombie
    Cpu(s): 17.4%us,  0.5%sy,  0.0%ni, 80.9%id,  1.1%wa,  0.0%hi,  0.0%si,  0.0%st
    Mem:   2097152k total,   621480k used,  1475672k free,        0k buffers
    Swap:        0k total,        0k used,        0k free,        0k cached
    
      PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND            
    21980 nobody    15   0  119m  33m  12m S 79.5  1.6   2:31.52 httpd              
     9260 nobody    16   0  121m  34m  11m R 63.6  1.7   0:32.70 httpd              
     7575 nobody    15   0 22396 8864  840 S  4.0  0.4   0:13.18 nginx              
        1 root      18   0  2072  656  560 S  0.0  0.0   0:00.13 init               
     1736 root      18   0  1664  424  352 S  0.0  0.0   0:00.03 courierlogger      
     1737 root      15   0  1772  536  460 S  0.0  0.0   0:00.05 couriertcpd        
     1743 root      25   0  1664  332  276 S  0.0  0.0   0:00.00 courierlogger      
     1744 root      18   0  1772  520  440 S  0.0  0.0   0:00.00 couriertcpd        
     1750 root      18   0  1664  424  352 S  0.0  0.0   0:00.03 courierlogger      
     1751 root      18   0  1772  540  460 S  0.0  0.0   0:00.05 couriertcpd        
     1760 root      18   0  1664  332  276 S  0.0  0.0   0:00.00 courierlogger      
     1768 root      20   0  1772  516  440 S  0.0  0.0   0:00.00 couriertcpd        
     5315 named     18   0  189m 4508 2048 S  0.0  0.2   0:00.13 named              
     5720 mailnull  15   0 10240 1164  668 S  0.0  0.1   0:00.13 exim               
     6073 root      15   0  5716 2924 1596 S  0.0  0.1   0:00.22 authProg           
     6112 root      14  -4  2156  552  344 S  0.0  0.0   0:00.00 udevd              
     7287 nobody    15   0  119m  32m  11m S  0.0  1.6   0:37.24 httpd              
     7366 nobody    15   0  116m  29m  11m S  0.0  1.4   0:37.82 httpd              
     7573 root      22   0  6124  992  284 S  0.0  0.0   0:00.00 nginx              
     7574 nobody    18   0 12052 4208  840 S  0.0  0.2   0:14.33 nginx              
     7576 nobody    15   0  7380 2700  840 S  0.0  0.1   0:11.24 nginx              
     7578 nobody    18   0 11540 5396  840 S  0.0  0.3   0:15.49 nginx              
     7580 root      15   0  7908 5264 1832 S  0.0  0.3   0:00.06 leechprotect       
     7587 root      18   0 24296 9924 1296 S  0.0  0.5   0:00.00 httpd              
     9518 nobody    15   0  118m  32m  11m S  0.0  1.6   0:30.00 httpd              
     9532 nobody    15   0  118m  32m  11m S  0.0  1.6   0:29.56 httpd              
     9711 nobody    15   0  119m  33m  11m S  0.0  1.6   0:29.03 httpd              
     9832 root      18   0  7940 5284 1748 S  0.0  0.3   0:01.60 tailwatchd         
    10221 nobody    15   0  118m  31m  11m S  0.0  1.5   0:11.83 httpd              
    11318 nobody    16   0  119m  32m  10m S  0.0  1.6   0:08.82 httpd              
    11481 nobody    16   0  118m  31m  11m S  0.0  1.5   0:08.32 httpd              
    11580 nobody    16   0  118m  30m  10m S  0.0  1.5   0:07.14 httpd              
    11962 nobody    15   0  119m  31m  10m S  0.0  1.5   0:01.59 httpd              
    12003 root      18   0  3836 1476 1048 S  0.0  0.1   0:00.02 mysqlmymonlite.    
    12280 root      18   0  2196  924  712 R  0.0  0.0   0:00.00 top                
    15844 root      15   0 33960  30m 2292 S  0.0  1.5   0:03.51 spamd              
    17785 root      15   0 81788  11m 4960 S  0.0  0.6   0:00.01 vzavpsagent        
    17786 root      18   0 81772  12m 5304 S  0.0  0.6   0:00.22 vzavpsagent        
    18369 root      18   0  5716 2920 1596 S  0.0  0.1   0:00.19 authProg           
    21636 root      15   0  106m  12m 4504 S  0.0  0.6   0:11.72 httpd              
    21730 root      15   0  6376 1488 1128 S  0.0  0.1   0:00.18 pure-ftpd          
    21732 root      16   0  6108 1228  980 S  0.0  0.1   0:00.05 pure-authd         
    22021 root      15   0  1728  568  476 S  0.0  0.0   0:00.35 syslogd            
    22103 root      15   0  4404 1124  564 S  0.0  0.1   0:00.43 crond              
    22379 root      18   0  1664  416  352 S  0.0  0.0   0:00.00 courierlogger      
    23569 root      18   0  2004  628  512 S  0.0  0.0   0:00.00 authdaemond        
    25645 nobody    15   0  118m  33m  12m S  0.0  1.6   2:06.49 httpd              
    25883 root      18   0  2004  368  248 S  0.0  0.0   0:00.01 authdaemond        
    25884 root      15   0  2004  368  248 S  0.0  0.0   0:00.01 authdaemond        
    26467 root      15   0 10064 2772 2220 S  0.0  0.1   0:00.08 sshd               
    26510 root      15   0  3752 1504 1228 S  0.0  0.1   0:00.06 bash               
    28097 nobody    16   0  118m  32m  12m S  0.0  1.6   1:41.56 httpd              
    28361 root      15   0  4092 2248 1084 S  0.0  0.1   0:00.43 cphulkd            
    28425 root      18   0  7076 1068  664 S  0.0  0.1   0:00.01 sshd               
    29719 root      18   0  2728  872  700 S  0.0  0.0   0:00.00 xinetd             
    30153 root      18   0 15336 9304 1792 S  0.0  0.4   0:00.37 cpdavd             
    30266 nobody    15   0  118m  32m  12m S  0.0  1.6   1:35.54 httpd              
    30273 root      15   0  5988 4304 1316 S  0.0  0.2   0:00.07 queueprocd         
    30374 root      15   0 14152 7296 1224 S  0.0  0.3   0:01.06 cpsrvd-ssl         
    32055 root      33  18  4096 1876  668 S  0.0  0.1   0:00.05 cpanellogd         
    32166 nobody    16   0  119m  32m  11m S  0.0  1.6   1:17.44 httpd              
    32514 root      15   0 34332  30m 2356 S  0.0  1.5   0:15.52 spamd              
    32653 root      18   0  1688  428  344 S  0.0  0.0   0:00.00 portsentry         
    32690 root      18   0  3620 1288 1112 S  0.0  0.1   0:00.01 mysqld_safe        
    32720 mysql     18   0  277m 219m 3604 S  0.0 10.7  88:07.17 mysqld             
    
    
                 total       used       free     shared    buffers     cached
    Mem:          2048        606       1441          0          0          0
    Low:          2048        606       1441
    High:            0          0          0
    -/+ buffers/cache:        606       1441
    Swap:            0          0          0
    
    MemTotal:      2097152 kB
    MemFree:       1476296 kB
    Buffers:             0 kB
    Cached:              0 kB
    SwapCached:          0 kB
    Active:              0 kB
    Inactive:            0 kB
    HighTotal:           0 kB
    HighFree:            0 kB
    LowTotal:      2097152 kB
    LowFree:       1476296 kB
    SwapTotal:           0 kB
    SwapFree:            0 kB
    Dirty:               0 kB
    Writeback:           0 kB
    AnonPages:           0 kB
    Mapped:         620856 kB
    Slab:                0 kB
    PageTables:          0 kB
    NFS_Unstable:        0 kB
    Bounce:              0 kB
    CommitLimit:         0 kB
    Committed_AS:   937112 kB
    VmallocTotal:        0 kB
    VmallocUsed:         0 kB
    VmallocChunk:        0 kB
    HugePages_Total:     0
    HugePages_Free:      0
    HugePages_Rsvd:      0
    Hugepagesize:     2048 kB
    
    --------------------------
    ps_mem.py output:
    http://www.pixelbeat.org/scripts/ps_mem.py
    --------------------------
     Private  +   Shared  =  RAM used	Program 
    
    108.0 KiB +  13.0 KiB = 121.0 KiB	portsentry
    124.0 KiB +  17.5 KiB = 141.5 KiB	syslogd
    132.0 KiB +  36.5 KiB = 168.5 KiB	init
    232.0 KiB +  20.0 KiB = 252.0 KiB	udevd
    296.0 KiB +  35.5 KiB = 331.5 KiB	xinetd
    220.0 KiB + 150.0 KiB = 370.0 KiB	authdaemond (3)
    192.0 KiB + 184.5 KiB = 376.5 KiB	mysqld_safe
    320.0 KiB +  71.0 KiB = 391.0 KiB	courierlogger (5)
    268.0 KiB + 147.5 KiB = 415.5 KiB	pure-authd
    312.0 KiB + 120.0 KiB = 432.0 KiB	couriertcpd (4)
    384.0 KiB + 191.5 KiB = 575.5 KiB	bash
    432.0 KiB + 180.0 KiB = 612.0 KiB	mysqlmymonlite.
    608.0 KiB +  36.5 KiB = 644.5 KiB	crond
    440.0 KiB + 226.0 KiB = 666.0 KiB	pure-ftpd
    688.0 KiB +  51.0 KiB = 739.0 KiB	exim
      1.2 MiB +  72.5 KiB =   1.3 MiB	cpanellogd
      1.1 MiB + 127.0 KiB =   1.3 MiB	cphulkd
      1.5 MiB + 475.5 KiB =   2.0 MiB	sshd (2)
      3.0 MiB + 147.5 KiB =   3.1 MiB	queueprocd
      2.6 MiB + 965.0 KiB =   3.5 MiB	authProg (2)
      3.4 MiB + 354.5 KiB =   3.8 MiB	leechprotect
      3.5 MiB + 345.5 KiB =   3.8 MiB	tailwatchd
      3.8 MiB +  91.0 KiB =   3.8 MiB	named
      6.4 MiB + 188.0 KiB =   6.6 MiB	cpsrvd-ssl
      7.4 MiB + 286.0 KiB =   7.7 MiB	cpdavd
     15.7 MiB + 985.5 KiB =  16.7 MiB	nginx (5)
     24.5 MiB +  17.0 MiB =  41.5 MiB	spamd (2)
    219.0 MiB + 297.0 KiB = 219.3 MiB	mysqld
    220.7 MiB +  20.9 MiB = 241.6 MiB	httpd (18)
    ---------------------------------
                            562.1 MiB
    =================================
    
     Private  +   Shared  =  RAM used	Program 
    
    
    ----------------------------
    Server Disk Usage
    ----------------------------
    Filesystem            Size  Used Avail Use% Mounted on
    /dev/vzfs              50G   20G   31G  40% /
    none                  1.0G  4.0K  1.0G   1% /dev
    
    ----------------------------
    MySQL datadir disk usage
    ----------------------------
    /var/lib/mysql/ uses 1527144 kilobytes of disk space
    
    ----------------------------
    ulimit -aH
    ----------------------------
    core file size          (blocks, -c) 1000000
    data seg size           (kbytes, -d) unlimited
    scheduling priority             (-e) 0
    file size               (blocks, -f) unlimited
    pending signals                 (-i) 137216
    max locked memory       (kbytes, -l) 32
    max memory size         (kbytes, -m) unlimited
    open files                      (-n) 4096
    pipe size            (512 bytes, -p) 8
    POSIX message queues     (bytes, -q) 819200
    real-time priority              (-r) 0
    stack size              (kbytes, -s) 8192
    cpu time               (seconds, -t) unlimited
    max user processes              (-u) 14335
    virtual memory          (kbytes, -v) unlimited
    file locks                      (-x) unlimited
    
    ----------------------------------
    CPANEL WEB SERVER & PHP Info:
    ----------------------------------
    WHM / Cpanel version: 11.30.5.2
    
    WHM's PHP Handler config:
    /usr/local/cpanel/bin/rebuild_phpconf --current
    Available handlers: dso cgi none
    DEFAULT PHP: 5
    PHP4 SAPI: none
    PHP5 SAPI: dso
    SUEXEC: enabled
    
    PHP 5.3.2 (cli) (built: Apr 10 2010 08:44:48) 
    Copyright (c) 1997-2010 The PHP Group
    Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies
        with XCache v1.3.0, Copyright (c) 2005-2009, by mOo
    
    System => Linux yourserverhostname 2.6.18-028stab070.4 #1 SMP Tue Aug 17 18:32:47 MSD 2010 i686
    Build Date => Apr 10 2010 08:42:58
    
    Configure Command =>  './configure'  '--disable-fileinfo' '--disable-pdo' '--enable-bcmath' '--enable-calendar' '--enable-ftp' '--enable-libxml' '--enable-magic-quotes' '--enable-mbstring' '--enable-sockets' '--enable-zip' '--prefix=/usr/local' '--with-apxs2=/usr/local/apache/bin/apxs' '--with-bz2' '--with-curl=/opt/curlssl/' '--with-gd' '--with-gettext' '--with-imap=/opt/php_with_imap_client/' '--with-imap-ssl=/usr' '--with-jpeg-dir=/usr' '--with-kerberos' '--with-libxml-dir=/opt/xml2/' '--with-mcrypt=/opt/libmcrypt/' '--with-mysql=/usr' '--with-mysql-sock=/var/lib/mysql/mysql.sock' '--with-openssl=/usr' '--with-openssl-dir=/usr' '--with-png-dir=/usr' '--with-xpm-dir=/usr' '--with-zlib' '--with-zlib-dir=/usr'
    
    Configuration File (php.ini) Path | /usr/local/lib
    Loaded Configuration File | /usr/local/lib/php.ini
    
    Server API | Command Line Interface
    PHP API | 20090626
    Zend Extension Build | API220090626,NTS
    PHP Extension Build | API20090626,NTS
    DOM/XML API Version | 20031129
    Client API version | 5.0.92
    Phar API version | 1.1.1
    
    display_errors | STDOUT | STDOUT
    error_log | error_log | error_log
    extension_dir | /usr/local/lib/php/extensions/no-debug-non-zts-20090626 | /usr/local/lib/php/extensions/no-debug-non-zts-20090626
    file_uploads | On | On
    log_errors | On | On
    log_errors_max_len | 1024 | 1024
    magic_quotes_gpc | On | On
    magic_quotes_sybase | Off | Off
    max_execution_time | 0 | 0
    max_file_uploads | 20 | 20
    memory_limit | 96M | 96M
    open_basedir | no value | no value
    post_max_size | 8M | 8M
    realpath_cache_size | 16K | 16K
    realpath_cache_ttl | 120 | 120
    safe_mode | Off | Off
    safe_mode_exec_dir | no value | no value
    safe_mode_gid | Off | Off
    safe_mode_include_dir | no value | no value
    sendmail_path | /usr/sbin/sendmail -t -i | /usr/sbin/sendmail -t -i
    sql.safe_mode | Off | Off
    upload_max_filesize | 16M | 16M
    upload_tmp_dir | no value | no value
    sqlite3.extension_dir | no value | no value
    safe_mode_allowed_env_vars | PHP_ | PHP_
    safe_mode_protected_env_vars | LD_LIBRARY_PATH | LD_LIBRARY_PATH
    
    cURL support | enabled
    cURL Information | 7.20.0
    ZLib Version | 1.2.3
    GD Support | enabled
    GD Version | bundled (2.0.34 compatible)
    GIF Read Support | enabled
    GIF Create Support | enabled
    JPEG Support | enabled
    libJPEG Version | 6b
    PNG Support | enabled
    libPNG Version | 1.2.10
    WBMP Support | enabled
    libXML support | active
    libXML Compiled Version | 2.7.6
    libXML Loaded Version | 20706
    libXML streams | enabled
    PCRE (Perl Compatible Regular Expressions) Support | enabled
    PCRE Library Version | 8.00 2009-10-19
    ZLib Support | enabled
    
    
    xcache.admin.enable_auth | On | On
    xcache.cacher | On | On
    xcache.coredump_directory | no value | no value
    xcache.count | 2 | 2
    xcache.gc_interval | 300 | 300
    xcache.mmap_path | /dev/zero | /dev/zero
    xcache.readonly_protection | no value | no value
    xcache.shm_scheme | mmap | mmap
    xcache.size | 80M | 80M
    xcache.slots | 8K | 8K
    xcache.stat | On | On
    xcache.test | no value | no value
    xcache.ttl | 7200 | 7200
    xcache.var_count | 1 | 1
    xcache.var_gc_interval | 300 | 300
    xcache.var_maxttl | 14400 | 14400
    xcache.var_size | 3M | 3M
    xcache.var_slots | 8K | 8K
    xcache.var_ttl | 7200 | 7200
    
    
    
    
    
    
    
    Server version: Apache/2.0.63
    Server built:   Apr 10 2010 08:21:15
    Cpanel::Easy::Apache v3.2.0 rev5054
    Server's Module Magic Number: 20020903:13
    Server loaded:  APR 0.9.17, APR-UTIL 0.9.15
    Compiled using: APR 0.9.17, APR-UTIL 0.9.15
    Architecture:   32-bit
    Server compiled with....
     -D APACHE_MPM_DIR="server/mpm/prefork"
     -D APR_HAS_SENDFILE
     -D APR_HAS_MMAP
     -D APR_HAVE_IPV6 (IPv4-mapped addresses enabled)
     -D APR_USE_SYSVSEM_SERIALIZE
     -D APR_USE_PTHREAD_SERIALIZE
     -D SINGLE_LISTEN_UNSERIALIZED_ACCEPT
     -D APR_HAS_OTHER_CHILD
     -D AP_HAVE_RELIABLE_PIPED_LOGS
     -D HTTPD_ROOT="/usr/local/apache"
     -D SUEXEC_BIN="/usr/local/apache/bin/suexec"
     -D DEFAULT_PIDLOG="logs/httpd.pid"
     -D DEFAULT_SCOREBOARD="logs/apache_runtime_status"
     -D DEFAULT_LOCKFILE="logs/accept.lock"
     -D DEFAULT_ERRORLOG="logs/error_log"
     -D AP_TYPES_CONFIG_FILE="conf/mime.types"
     -D SERVER_CONFIG_FILE="conf/httpd.conf"
    
    Compiled in modules:
      core.c
      mod_access.c
      mod_auth.c
      mod_include.c
      mod_log_config.c
      mod_logio.c
      mod_env.c
      mod_expires.c
      mod_headers.c
      mod_setenvif.c
      mod_proxy.c
      proxy_connect.c
      proxy_ftp.c
      proxy_http.c
      mod_ssl.c
      prefork.c
      http_core.c
      mod_mime.c
      mod_status.c
      mod_autoindex.c
      mod_asis.c
      mod_info.c
      mod_suexec.c
      mod_cgi.c
      mod_negotiation.c
      mod_dir.c
      mod_imap.c
      mod_actions.c
      mod_userdir.c
      mod_alias.c
      mod_rewrite.c
      mod_so.c
    
    
    -------------------------------
    From /usr/local/apache/conf/httpd.conf
    -------------------------------
    Timeout 60
    KeepAlive On
    MaxKeepAliveRequests 100
    KeepAliveTimeout 2
    
    </IfModule>
    StartServers 10
    <IfModule prefork.c>
    MinSpareServers 10
    MaxSpareServers 15
    </IfModule>
    ServerLimit 256
    MaxClients 150
    MaxRequestsPerChild 1000
    
    
    -------------------------------
    From /usr/local/apache/
    -------------------------------
    
    
    
    ---------------
    You are running Nginx
    ---------------
    
    
    user  nobody;
    # no need for more workers in the proxy mode
    worker_processes  4;
    worker_rlimit_nofile 20480;
     worker_connections 5120; # increase for busier servers
     use epoll; # you should use epoll here for Linux kernels 2.6.x
     sendfile on;
     keepalive_timeout  5;
     gzip on;
     gzip_vary on;
     gzip_disable "MSIE [1-6]\.";
     gzip_proxied any;
     gzip_http_version 1.1;
     gzip_min_length  1000;
     gzip_comp_level  1;
     gzip_buffers  16 8k;
     gzip_types    text/plain text/xml text/css application/x-javascript application/xml image/png image/x-icon image/gif image/jpeg application/xml+rss text/javascript application/atom+xml;
     client_header_timeout  3m;
     client_body_timeout 3m;
     client_header_buffer_size 256k;
     large_client_header_buffers 4 256k;
     client_max_body_size 200M; 
     client_body_buffer_size 128k;
     proxy_temp_path  /tmp/nginx_proxy/;
     client_body_in_file_only on;
    
    ----------------------------
    mysqlreport output
    ----------------------------
    
    MySQL 5.0.92-community-  uptime 1 0:8:19        Thu Jun 14 15:18:41 2012
    
    __ Key _________________________________________________________________
    Buffer used    28.32M of  32.00M  %Used:  88.49
      Current      32.00M            %Usage: 100.00
    Write hit      39.32%
    Read hit       99.81%
    
    __ Questions ___________________________________________________________
    Total           5.34M    61.4/s
      QC Hits       2.06M    23.7/s  %Total:  38.56
      DMS           2.05M    23.6/s           38.33
      Com_        959.95k    11.0/s           17.98
      COM_QUIT    301.83k     3.5/s            5.65
      -Unknown     27.55k     0.3/s            0.52
    Slow 10 s          85     0.0/s            0.00  %DMS:   0.00  Log:  ON
    DMS             2.05M    23.6/s           38.33
      SELECT        1.03M    11.8/s           19.21         50.12
      INSERT      517.02k     5.9/s            9.68         25.26
      REPLACE     291.23k     3.4/s            5.45         14.23
      UPDATE      204.50k     2.4/s            3.83          9.99
      DELETE        8.06k     0.1/s            0.15          0.39
    Com_          959.95k    11.0/s           17.98
      set_option  594.07k     6.8/s           11.13
      change_db   337.40k     3.9/s            6.32
      stmt_prepar   8.48k     0.1/s            0.16
    
    __ SELECT and Sort _____________________________________________________
    Scan          217.38k     2.5/s %SELECT:  21.19
    Range         327.44k     3.8/s           31.92
    Full join       1.63k     0.0/s            0.16
    Range check         0       0/s            0.00
    Full rng join       0       0/s            0.00
    Sort scan      23.94k     0.3/s
    Sort range    402.75k     4.6/s
    Sort mrg pass      20     0.0/s
    
    __ Query Cache _________________________________________________________
    Memory usage   39.18M of 128.00M  %Used:  30.61
    Block Fragmnt  24.33%
    Hits            2.06M    23.7/s
    Inserts         1.01M    11.6/s
    Insrt:Prune  448.22:1    11.6/s
    Hit:Insert     2.04:1
    
    __ Table Locks _________________________________________________________
    Waited         21.95k     0.3/s  %Total:   0.57
    Immediate       3.86M    44.4/s
    
    __ Tables ______________________________________________________________
    Open             1150 of 1152    %Cache:  99.83
    Opened          2.31k     0.0/s
    
    __ Connections _________________________________________________________
    Max used          201 of  200      %Max: 100.50
    Total         302.31k     3.5/s
    
    __ Created Temp ________________________________________________________
    Disk table      3.01k     0.0/s
    Table          17.80k     0.2/s    Size: 256.0M
    File               40     0.0/s
    
    __ Threads _____________________________________________________________
    Running             1 of    3
    Cached            141 of  144      %Hit:  99.91
    Created           261     0.0/s
    Slow                0       0/s
    
    __ Aborted _____________________________________________________________
    Clients           960     0.0/s
    Connects          143     0.0/s
    
    __ Bytes _______________________________________________________________
    Sent            1.88G   21.7k/s
    Received        1.43G   16.4k/s
    
    __ InnoDB Buffer Pool __________________________________________________
    Usage               0 of       0  %Used:   0.00
    Read hit        0.00%
    Pages
      Free              0            %Total:   0.00
      Data              0                      0.00 %Drty:   0.00
      Misc              0                      0.00
      Latched                                  0.00
    Reads               0       0/s
      From file         0       0/s            0.00
      Ahead Rnd         0       0/s
      Ahead Sql         0       0/s
    Writes              0       0/s
    Flushes             0       0/s
    Wait Free           0       0/s
    
    __ InnoDB Lock _________________________________________________________
    Waits               0       0/s
    Current             0
    Time acquiring
      Total             0 ms
      Average           0 ms
      Max               0 ms
    
    __ InnoDB Data, Pages, Rows ____________________________________________
    Data
      Reads             0       0/s
      Writes            0       0/s
      fsync             0       0/s
      Pending
        Reads           0
        Writes          0
        fsync           0
    
    Pages
      Created           0       0/s
      Read              0       0/s
      Written           0       0/s
    
    Rows
      Deleted           0       0/s
      Inserted          0       0/s
      Read              0       0/s
      Updated           0       0/s
    
    ----------------------------
    Total Server MyISAM and InnoDB Size
    ----------------------------
    *************************** 1. row ***************************
    innodb_tablespace_utilization_perc: NULL
                         total_size_gb: 1.43016034550965
                         index_size_gb: 0.458871677517891
                          data_size_gb: 0.971288667991757
                  innodb_total_size_gb: 0
                   innodb_data_size_gb: 0
                  innodb_index_size_gb: 0
                  myisam_total_size_gb: 1.42489108256996
                   myisam_data_size_gb: 0.967387763783336
                  myisam_index_size_gb: 0.457503318786621
                            perc_index: 32.0853
                             perc_data: 67.9147
                     innodb_perc_index: NULL
                      innodb_perc_data: NULL
                     myisam_perc_index: 32.1080
                      myisam_perc_data: 67.8920
               innodb_perc_total_index: 0.0000
                innodb_perc_total_data: 0.0000
               myisam_perc_total_index: 99.7018
                myisam_perc_total_data: 99.5984
    
    ----------------------------
    MySQL settings
    ----------------------------
    [mysqld]
    local-infile=0
    datadir = /var/lib/mysql
    log-slow-queries=/var/lib/mysql/slow.log
    log-queries-not-using-indexes=var/lib/mysql/slowindex.log
    skip-innodb
    max_connections = 200 
    key_buffer_size = 32M
    myisam_sort_buffer_size = 64M
    join_buffer_size = 6M
    read_buffer_size = 1M
    sort_buffer_size = 3M
    table_cache = 1152
    thread_cache_size = 144
    wait_timeout = 120
    interactive_timeout = 10
    connect_timeout = 10
    tmp_table_size = 256M
    max_heap_table_size = 256M
    max_connect_errors = 10
    read_rnd_buffer_size = 1M
    bulk_insert_buffer_size = 8M
    query_cache_limit = 2M
    query_cache_size = 128M
    query_cache_type = 1
    
    [mysqld_safe]
    log-error=/var/log/mysqld.log
    open_files_limit = 4096
    
    [mysqldump]
    max_allowed_packet = 16M
    
    [myisamchk]
    key_buffer_size = 32M
    sort_buffer_size = 16M
    read_buffer_size = 16M
    write_buffer_size = 16M
    ---
    +-----------------------------------------+--------------------------------------------------+
    | Variable_name | Value |
    +-----------------------------------------+--------------------------------------------------+
    | auto_increment_increment | 1 |
    | auto_increment_offset | 1 |
    | automatic_sp_privileges | ON |
    | back_log | 50 |
    | basedir | / |
    | binlog_cache_size | 32768 |
    | bulk_insert_buffer_size | 8388608 |
    | character_set_client | latin1 |
    | character_set_connection | latin1 |
    | character_set_database | latin1 |
    | character_set_filesystem | binary |
    | character_set_results | latin1 |
    | character_set_server | latin1 |
    | character_set_system | utf8 |
    | character_sets_dir | /usr/share/mysql/charsets/ |
    | collation_connection | latin1_swedish_ci |
    | collation_database | latin1_swedish_ci |
    | collation_server | latin1_swedish_ci |
    | completion_type | 0 |
    | concurrent_insert | 1 |
    | connect_timeout | 10 |
    | datadir | /var/lib/mysql/ |
    | date_format | %Y-%m-%d |
    | datetime_format | %Y-%m-%d %H:%i:%s |
    | default_week_format | 0 |
    | delay_key_write | ON |
    | delayed_insert_limit | 100 |
    | delayed_insert_timeout | 300 |
    | delayed_queue_size | 1000 |
    | div_precision_increment | 4 |
    | keep_files_on_create | OFF |
    | engine_condition_pushdown | OFF |
    | expire_logs_days | 0 |
    | flush | OFF |
    | flush_time | 0 |
    | ft_boolean_syntax | + -><()~*:""&| |
    | ft_max_word_len | 84 |
    | ft_min_word_len | 4 |
    | ft_query_expansion_limit | 20 |
    | ft_stopword_file | (built-in) |
    | group_concat_max_len | 1024 |
    | have_archive | YES |
    | have_bdb | NO |
    | have_blackhole_engine | YES |
    | have_compress | YES |
    | have_community_features | NO |
    | have_profiling | NO |
    | have_crypt | YES |
    | have_csv | YES |
    | have_dynamic_loading | YES |
    | have_example_engine | YES |
    | have_federated_engine | YES |
    | have_geometry | YES |
    | have_innodb | DISABLED |
    | have_isam | NO |
    | have_merge_engine | YES |
    | have_ndbcluster | NO |
    | have_openssl | NO |
    | have_ssl | NO |
    | have_query_cache | YES |
    | have_raid | NO |
    | have_rtree_keys | YES |
    | have_symlink | YES |
    | hostname | yourserverhostname |
    | init_connect | |
    | init_file | |
    | init_slave | |
    | innodb_additional_mem_pool_size | 1048576 |
    | innodb_autoextend_increment | 8 |
    | innodb_buffer_pool_awe_mem_mb | 0 |
    | innodb_buffer_pool_size | 8388608 |
    | innodb_checksums | ON |
    | innodb_commit_concurrency | 0 |
    | innodb_concurrency_tickets | 500 |
    | innodb_data_file_path | |
    | innodb_data_home_dir | |
    | innodb_adaptive_hash_index | ON |
    | innodb_doublewrite | ON |
    | innodb_fast_shutdown | 1 |
    | innodb_file_io_threads | 4 |
    | innodb_file_per_table | OFF |
    | innodb_flush_log_at_trx_commit | 1 |
    | innodb_flush_method | |
    | innodb_force_recovery | 0 |
    | innodb_lock_wait_timeout | 50 |
    | innodb_locks_unsafe_for_binlog | OFF |
    | innodb_log_arch_dir | |
    | innodb_log_archive | OFF |
    | innodb_log_buffer_size | 1048576 |
    | innodb_log_file_size | 5242880 |
    | innodb_log_files_in_group | 2 |
    | innodb_log_group_home_dir | |
    | innodb_max_dirty_pages_pct | 90 |
    | innodb_max_purge_lag | 0 |
    | innodb_mirrored_log_groups | 1 |
    | innodb_open_files | 300 |
    | innodb_rollback_on_timeout | OFF |
    | innodb_support_xa | ON |
    | innodb_sync_spin_loops | 20 |
    | innodb_table_locks | ON |
    | innodb_thread_concurrency | 8 |
    | innodb_thread_sleep_delay | 10000 |
    | innodb_use_legacy_cardinality_algorithm | ON |
    | interactive_timeout | 10 |
    | join_buffer_size | 6291456 |
    | key_buffer_size | 33554432 |
    | key_cache_age_threshold | 300 |
    | key_cache_block_size | 1024 |
    | key_cache_division_limit | 100 |
    | language | /usr/share/mysql/english/ |
    | large_files_support | ON |
    | large_page_size | 0 |
    | large_pages | OFF |
    | lc_time_names | en_US |
    | license | GPL |
    | local_infile | OFF |
    | locked_in_memory | OFF |
    | log | OFF |
    | log_bin | OFF |
    | log_bin_trust_function_creators | OFF |
    | log_error | |
    | log_queries_not_using_indexes | OFF |
    | log_slave_updates | OFF |
    | log_slow_queries | ON |
    | log_warnings | 1 |
    | long_query_time | 10 |
    | low_priority_updates | OFF |
    | lower_case_file_system | OFF |
    | lower_case_table_names | 0 |
    | max_allowed_packet | 1048576 |
    | max_binlog_cache_size | 4294963200 |
    | max_binlog_size | 1073741824 |
    | max_connect_errors | 10 |
    | max_connections | 200 |
    | max_delayed_threads | 20 |
    | max_error_count | 64 |
    | max_heap_table_size | 268435456 |
    | max_insert_delayed_threads | 20 |
    | max_join_size | 18446744073709551615 |
    | max_length_for_sort_data | 1024 |
    | max_prepared_stmt_count | 16382 |
    | max_relay_log_size | 0 |
    | max_seeks_for_key | 4294967295 |
    | max_sort_length | 1024 |
    | max_sp_recursion_depth | 0 |
    | max_tmp_tables | 32 |
    | max_user_connections | 0 |
    | max_write_lock_count | 4294967295 |
    | multi_range_count | 256 |
    | myisam_data_pointer_size | 6 |
    | myisam_max_sort_file_size | 2146435072 |
    | myisam_mmap_size | 4294967295 |
    | myisam_recover_options | OFF |
    | myisam_repair_threads | 1 |
    | myisam_sort_buffer_size | 67108864 |
    | myisam_stats_method | nulls_unequal |
    | net_buffer_length | 16384 |
    | net_read_timeout | 30 |
    | net_retry_count | 10 |
    | net_write_timeout | 60 |
    | new | OFF |
    | old_passwords | OFF |
    | open_files_limit | 4096 |
    | optimizer_prune_level | 1 |
    | optimizer_search_depth | 62 |
    | pid_file | /var/lib/mysql/yourserverhostname.pid |
    | plugin_dir | |
    | port | 3306 |
    | preload_buffer_size | 32768 |
    | protocol_version | 10 |
    | query_alloc_block_size | 8192 |
    | query_cache_limit | 2097152 |
    | query_cache_min_res_unit | 4096 |
    | query_cache_size | 134217728 |
    | query_cache_type | ON |
    | query_cache_wlock_invalidate | OFF |
    | query_prealloc_size | 8192 |
    | range_alloc_block_size | 4096 |
    | read_buffer_size | 1048576 |
    | read_only | OFF |
    | read_rnd_buffer_size | 1048576 |
    | relay_log | |
    | relay_log_index | |
    | relay_log_info_file | relay-log.info |
    | relay_log_purge | ON |
    | relay_log_space_limit | 0 |
    | rpl_recovery_rank | 0 |
    | secure_auth | OFF |
    | secure_file_priv | |
    | server_id | 0 |
    | skip_external_locking | ON |
    | skip_networking | OFF |
    | skip_show_database | OFF |
    | slave_compressed_protocol | OFF |
    | slave_load_tmpdir | /tmp/ |
    | slave_net_timeout | 3600 |
    | slave_skip_errors | OFF |
    | slave_transaction_retries | 10 |
    | slow_launch_time | 2 |
    | socket | /var/lib/mysql/mysql.sock |
    | sort_buffer_size | 3145728 |
    | sql_big_selects | ON |
    | sql_mode | |
    | sql_notes | ON |
    | sql_warnings | OFF |
    | ssl_ca | |
    | ssl_capath | |
    | ssl_cert | |
    | ssl_cipher | |
    | ssl_key | |
    | storage_engine | MyISAM |
    | sync_binlog | 0 |
    | sync_frm | ON |
    | system_time_zone | GMT-8 |
    | table_cache | 1152 |
    | table_lock_wait_timeout | 50 |
    | table_type | MyISAM |
    | thread_cache_size | 144 |
    | thread_stack | 196608 |
    | time_format | %H:%i:%s |
    | time_zone | SYSTEM |
    | timed_mutexes | OFF |
    | tmp_table_size | 268435456 |
    | tmpdir | /tmp/ |
    | transaction_alloc_block_size | 8192 |
    | transaction_prealloc_size | 4096 |
    | tx_isolation | REPEATABLE-READ |
    | updatable_views_with_limit | YES |
    | version | 5.0.92-community-log |
    | version_comment | MySQL Community Edition (GPL) |
    | version_compile_machine | i686 |
    | version_compile_os | pc-linux-gnu |
    | wait_timeout | 120 |
    +-----------------------------------------+--------------------------------------------------+
    +-----------------------------------+------------+
    | Variable_name | Value |
    +-----------------------------------+------------+
    | Aborted_clients | 960 |
    | Aborted_connects | 143 |
    | Binlog_cache_disk_use | 0 |
    | Binlog_cache_use | 0 |
    | Bytes_received | 1428412807 |
    | Bytes_sent | 1883596473 |
    | Com_admin_commands | 961 |
    | Com_alter_db | 0 |
    | Com_alter_table | 0 |
    | Com_analyze | 0 |
    | Com_backup_table | 0 |
    | Com_begin | 0 |
    | Com_call_procedure | 0 |
    | Com_change_db | 337405 |
    | Com_change_master | 0 |
    | Com_check | 0 |
    | Com_checksum | 0 |
    | Com_commit | 0 |
    | Com_create_db | 0 |
    | Com_create_function | 0 |
    | Com_create_index | 0 |
    | Com_create_table | 50 |
    | Com_create_user | 0 |
    | Com_dealloc_sql | 0 |
    | Com_delete | 8063 |
    | Com_delete_multi | 0 |
    | Com_do | 0 |
    | Com_drop_db | 0 |
    | Com_drop_function | 0 |
    | Com_drop_index | 0 |
    | Com_drop_table | 50 |
    | Com_drop_user | 0 |
    | Com_execute_sql | 0 |
    | Com_flush | 1 |
    | Com_grant | 0 |
    | Com_ha_close | 0 |
    | Com_ha_open | 0 |
    | Com_ha_read | 0 |
    | Com_help | 0 |
    | Com_insert | 516966 |
    | Com_insert_select | 50 |
    | Com_kill | 0 |
    | Com_load | 0 |
    | Com_load_master_data | 0 |
    | Com_load_master_table | 0 |
    | Com_lock_tables | 2 |
    | Com_optimize | 1 |
    | Com_preload_keys | 0 |
    | Com_prepare_sql | 0 |
    | Com_purge | 0 |
    | Com_purge_before_date | 0 |
    | Com_rename_table | 0 |
    | Com_repair | 0 |
    | Com_replace | 291226 |
    | Com_replace_select | 0 |
    | Com_reset | 0 |
    | Com_restore_table | 0 |
    | Com_revoke | 0 |
    | Com_revoke_all | 0 |
    | Com_rollback | 0 |
    | Com_savepoint | 0 |
    | Com_select | 1025680 |
    | Com_set_option | 594074 |
    | Com_show_binlog_events | 0 |
    | Com_show_binlogs | 0 |
    | Com_show_charsets | 1 |
    | Com_show_collations | 0 |
    | Com_show_column_types | 0 |
    | Com_show_create_db | 0 |
    | Com_show_create_table | 0 |
    | Com_show_databases | 11 |
    | Com_show_errors | 0 |
    | Com_show_fields | 334 |
    | Com_show_grants | 3 |
    | Com_show_innodb_status | 0 |
    | Com_show_keys | 0 |
    | Com_show_logs | 0 |
    | Com_show_master_status | 0 |
    | Com_show_ndb_status | 0 |
    | Com_show_new_master | 0 |
    | Com_show_open_tables | 0 |
    | Com_show_privileges | 0 |
    | Com_show_processlist | 296 |
    | Com_show_slave_hosts | 0 |
    | Com_show_slave_status | 0 |
    | Com_show_status | 21 |
    | Com_show_storage_engines | 3 |
    | Com_show_tables | 1053 |
    | Com_show_triggers | 0 |
    | Com_show_variables | 208 |
    | Com_show_warnings | 0 |
    | Com_slave_start | 0 |
    | Com_slave_stop | 0 |
    | Com_stmt_close | 8476 |
    | Com_stmt_execute | 8476 |
    | Com_stmt_fetch | 0 |
    | Com_stmt_prepare | 8476 |
    | Com_stmt_reset | 0 |
    | Com_stmt_send_long_data | 0 |
    | Com_truncate | 50 |
    | Com_unlock_tables | 2 |
    | Com_update | 204451 |
    | Com_update_multi | 52 |
    | Com_xa_commit | 0 |
    | Com_xa_end | 0 |
    | Com_xa_prepare | 0 |
    | Com_xa_recover | 0 |
    | Com_xa_rollback | 0 |
    | Com_xa_start | 0 |
    | Compression | OFF |
    | Connections | 302313 |
    | Created_tmp_disk_tables | 3014 |
    | Created_tmp_files | 40 |
    | Created_tmp_tables | 17823 |
    | Delayed_errors | 0 |
    | Delayed_insert_threads | 0 |
    | Delayed_writes | 0 |
    | Flush_commands | 1 |
    | Handler_commit | 0 |
    | Handler_delete | 314461 |
    | Handler_discover | 0 |
    | Handler_prepare | 0 |
    | Handler_read_first | 28636 |
    | Handler_read_key | 176692309 |
    | Handler_read_next | 164423089 |
    | Handler_read_prev | 4025950 |
    | Handler_read_rnd | 3115014 |
    | Handler_read_rnd_next | 1630474591 |
    | Handler_rollback | 0 |
    | Handler_savepoint | 0 |
    | Handler_savepoint_rollback | 0 |
    | Handler_update | 64023890 |
    | Handler_write | 4233681 |
    | Innodb_buffer_pool_pages_data | 0 |
    | Innodb_buffer_pool_pages_dirty | 0 |
    | Innodb_buffer_pool_pages_flushed | 0 |
    | Innodb_buffer_pool_pages_free | 0 |
    | Innodb_buffer_pool_pages_misc | 0 |
    | Innodb_buffer_pool_pages_total | 0 |
    | Innodb_buffer_pool_read_ahead_rnd | 0 |
    | Innodb_buffer_pool_read_ahead_seq | 0 |
    | Innodb_buffer_pool_read_requests | 0 |
    | Innodb_buffer_pool_reads | 0 |
    | Innodb_buffer_pool_wait_free | 0 |
    | Innodb_buffer_pool_write_requests | 0 |
    | Innodb_data_fsyncs | 0 |
    | Innodb_data_pending_fsyncs | 0 |
    | Innodb_data_pending_reads | 0 |
    | Innodb_data_pending_writes | 0 |
    | Innodb_data_read | 0 |
    | Innodb_data_reads | 0 |
    | Innodb_data_writes | 0 |
    | Innodb_data_written | 0 |
    | Innodb_dblwr_pages_written | 0 |
    | Innodb_dblwr_writes | 0 |
    | Innodb_log_waits | 0 |
    | Innodb_log_write_requests | 0 |
    | Innodb_log_writes | 0 |
    | Innodb_os_log_fsyncs | 0 |
    | Innodb_os_log_pending_fsyncs | 0 |
    | Innodb_os_log_pending_writes | 0 |
    | Innodb_os_log_written | 0 |
    | Innodb_page_size | 0 |
    | Innodb_pages_created | 0 |
    | Innodb_pages_read | 0 |
    | Innodb_pages_written | 0 |
    | Innodb_row_lock_current_waits | 0 |
    | Innodb_row_lock_time | 0 |
    | Innodb_row_lock_time_avg | 0 |
    | Innodb_row_lock_time_max | 0 |
    | Innodb_row_lock_waits | 0 |
    | Innodb_rows_deleted | 0 |
    | Innodb_rows_inserted | 0 |
    | Innodb_rows_read | 0 |
    | Innodb_rows_updated | 0 |
    | Key_blocks_not_flushed | 0 |
    | Key_blocks_unused | 0 |
    | Key_blocks_used | 28995 |
    | Key_read_requests | 282251056 |
    | Key_reads | 549657 |
    | Key_write_requests | 2576352 |
    | Key_writes | 1563410 |
    | Last_query_cost | 0.000000 |
    | Max_used_connections | 201 |
    | Not_flushed_delayed_rows | 0 |
    | Open_files | 1420 |
    | Open_streams | 0 |
    | Open_tables | 1150 |
    | Opened_tables | 2313 |
    | Prepared_stmt_count | 0 |
    | Qcache_free_blocks | 7988 |
    | Qcache_free_memory | 93136912 |
    | Qcache_hits | 2058777 |
    | Qcache_inserts | 1007154 |
    | Qcache_lowmem_prunes | 2247 |
    | Qcache_not_cached | 20146 |
    | Qcache_queries_in_cache | 11987 |
    | Qcache_total_blocks | 32835 |
    | Queries | 5356456 |
    | Questions | 5339504 |
    | Rpl_status | NULL |
    | Select_full_join | 1634 |
    | Select_full_range_join | 0 |
    | Select_range | 327442 |
    | Select_range_check | 0 |
    | Select_scan | 217387 |
    | Slave_open_temp_tables | 0 |
    | Slave_retried_transactions | 0 |
    | Slave_running | OFF |
    | Slow_launch_threads | 0 |
    | Slow_queries | 85 |
    | Sort_merge_passes | 20 |
    | Sort_range | 402745 |
    | Sort_rows | 7162458 |
    | Sort_scan | 23940 |
    | Table_locks_immediate | 3859425 |
    | Table_locks_waited | 21953 |
    | Tc_log_max_pages_used | 0 |
    | Tc_log_page_size | 0 |
    | Tc_log_page_waits | 0 |
    | Threads_cached | 141 |
    | Threads_connected | 3 |
    | Threads_created | 261 |
    | Threads_running | 1 |
    | Uptime | 86900 |
    +-----------------------------------+------------+
    +--------+---------------+-----------+----------------+---------+------+-------+------------------+
    | Id | User | Host | db | Command | Time | State | Info |
    +--------+---------------+-----------+----------------+---------+------+-------+------------------+
    | 302308 | db_user | localhost | db_name | Sleep | 1 | | |
    | 302309 | db_user | localhost | db_name | Sleep | 1 | | |
    | 302312 | root | localhost | | Query | 0 | | show processlist |
    +--------+---------------+-----------+----------------+---------+------+-------+------------------+
    
    ----------------------------
    MySQL Error Log
    ----------------------------
    
    MySQL error log not set
    
    Report Complete:
    Thu Jun 14 15:18:42 GMT-8 2012
    ----------------------------
    
    
     
    #2 Kenpachi, Jun 14, 2012
    Last edited: Jun 14, 2012
  3. srpurdy

    srpurdy Well-Known Member

    Joined:
    Jun 1, 2011
    Messages:
    101
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    Well looks like the problem is apache is using a lot of cpu.

    Most VPS's are somewhat cpu limited they're might not actually be a lot you can do, but it can just as easily be a problem in the code of the software your using. You may have to upgrade the vps with 800-900 users online all the time. You definitely need to increase the mysql connections, but I wouldn't do that until the problem is sorted since it will only make things worse.

    However you may have some success tweaking apache.

    I would change the following

    Timeout 20
    KeepAlive On
    MaxKeepAliveRequests 100
    KeepAliveTimeout 2

    </IfModule>
    StartServers 20
    <IfModule prefork.c>
    MinSpareServers 20
    MaxSpareServers 25
    </IfModule>
    ServerLimit 256
    MaxClients 150
    MaxRequestsPerChild 2000

    The reason to increase MaxRequestPerChild is with your traffic apache will be forking new processes too much I think. Should probably be higher.

    You can change those settings in WHM of course. :)

    Also based on your apache process size I'm guessing your running no security at all. Your probably being pounded hard by bots and attackers. I would make sure to harden the server before going any further. It's a pretty clear indication your being pounded if you have a forum with 800-900 users and only 15 of them are logged in. That should be a red flag right away.

    I have a small board I run for a client that has from 50-100 users online during the course of the day. Usually they're is always 15-20 people logged in also. If I ran no security I'd be seeing numbers n the 500 + range also.
     
    #3 srpurdy, Jun 17, 2012
    Last edited: Jun 17, 2012
  4. Kenpachi

    Kenpachi Member

    Joined:
    Nov 28, 2010
    Messages:
    22
    Likes Received:
    0
    Trophy Points:
    1
    Hi Spurdy thanks for your valuable input, I've changed the apache settings past week according to your input.
    Earlier csf was installed on my vps but i'd to remove it cause it was causing the kernal to crash.
    Now again today im seeing the server inaccessible for long time and im seeing a lot of httpd processes in top list.
    After restarting the server, the result is same .. the load average is hovering around 50+
     
  5. Kenpachi

    Kenpachi Member

    Joined:
    Nov 28, 2010
    Messages:
    22
    Likes Received:
    0
    Trophy Points:
    1
    Im also noticing random high load spike from httpd processes, the load average remains at 3.0 4.0 3.5 for some time and randomly it shoots to 15.0 16.0 18.0 with lot of httpd processes in top list.
     
  6. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
  7. Kenpachi

    Kenpachi Member

    Joined:
    Nov 28, 2010
    Messages:
    22
    Likes Received:
    0
    Trophy Points:
    1
    I too have a similar thought so i opened the support ticket with my host and they said

    "Dear Customer,

    Your httpd has been attack.
    Please refer to the log.
    There is a single IP 24.187.67.162 having massive connection to your port 80.
    We have blocked the IP 24.187.67.162 from our router.
    Your VPS load should be reduce in 15 minutes."

    But after again im seeing random spike in http load and at specific intervals of time like 1:00 am / 1:20 am / 1:30 am / 1:40 am / 2:00am and so on..

    Also i've a query, does raising the maxclient in apache will result in some change ?
     
  8. Kenpachi

    Kenpachi Member

    Joined:
    Nov 28, 2010
    Messages:
    22
    Likes Received:
    0
    Trophy Points:
    1
    Httpd high load issue is consistent for last couple of days, i tried disabling the whole plugin system of vbulletin and after that the load had come down to normal but again shoots up randomly.

    Can this be also the possible case that my site has outgrown the vps and in need of dedicated server ?

    Im also attaching the high load status sent my csf, pls check it also :) View attachment ps.txt
     
    #8 Kenpachi, Jul 4, 2012
    Last edited: Jul 4, 2012
  9. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    If you've followed my post on the prior thread that I linked, these questions are answered there. I don't see where MaxClients was checked in the Apache error log to see if that was an issue nor whether you saw any IPs hitting the server for a large number of connections yourself. Rather than having your provider investigate, you have SSH access, so you would want to log into the machine and run the commands indicated in that prior thread post. It's the only way to investigate and troubleshoot the issue properly.
     
  10. Kenpachi

    Kenpachi Member

    Joined:
    Nov 28, 2010
    Messages:
    22
    Likes Received:
    0
    Trophy Points:
    1
    Im attaching the results of those commands in the post. View attachment command results.txt

    The load remains stable for sometime and it spikes every 10th mint of an hour.
     
    #10 Kenpachi, Jul 5, 2012
    Last edited: Jul 5, 2012
  11. voshka

    voshka Active Member

    Joined:
    Apr 4, 2010
    Messages:
    30
    Likes Received:
    0
    Trophy Points:
    6
    If you have enough memory attleast 2gig on that vps alter the pache handler to fcgi
    it lowers the cpu usage by both apache and mysql and also is so much more stable under dos attack
    because what ever the bot net attack or high requests from one ip address is it serves plain html and compile php once
    test it on fcgi and see if the problem resolves

    also if you have more than one cpu use mpm_worker
    also ad mem_cache
    Thanks
     
Loading...

Share This Page