Results 1 to 8 of 8
  1. #1
    Join Date
    Apr 2004
    Posts
    500

    Server Load very High

    top
    =================
    Code:
     12:53:16  up 42 days, 13:45,  2 users,  load average: 6.92, 10.77, 12.41 
    86 processes: 75 sleeping, 8 running, 1 zombie, 2 stopped 
    CPU states:  cpu    user    nice  system    irq  softirq  iowait    idle 
               total   30.1%    0.0%    2.9%   0.5%     0.3%    0.0%   65.8% 
    Mem:  1019396k av,  585896k used,  433500k free,       0k shrd,   88592k buff 
                        324908k actv,  152416k in_d,   21444k in_c 
    Swap: 2040244k av,   19588k used, 2020656k free                  335124k cached 
     
      PID USER     PRI  NI  SIZE  RSS SHARE STAT %CPU %MEM   TIME CPU COMMAND 
    22571 nobody    16   0 13896  13M  3588 S    10.7  1.3   0:02   0 httpd 
    21952 nobody    15   0 13276  12M  3588 S     1.1  1.3   0:05   0 httpd 
    21974 nobody    15   0 13264  12M  3580 S     0.9  1.3   0:02   0 httpd 
    22010 nobody    15   0 13988  13M  3596 S     0.9  1.3   0:03   0 httpd 
    22718 nobody    15   0 12900  12M  3584 S     0.7  1.2   0:01   0 httpd 
    22729 nobody    15   0 13192  12M  3564 S     0.7  1.2   0:01   0 httpd 
    22960 mysql     23   0 18332  16M  2168 R     0.5  1.7   0:00   0 mysqld 
    22961 mysql     23   0 18332  16M  2168 R     0.5  1.7   0:00   0 mysqld 
    22955 mysql     23   0 18332  16M  2168 R     0.3  1.7   0:00   0 mysqld 
    22962 mysql     23   0 18332  16M  2168 R     0.3  1.7   0:00   0 mysqld 
    16295 named     15   0  1996 1676  1072 S     0.1  0.1   3:06   0 named 
    22800 nobody    15   0 13136  12M  3584 S     0.1  1.2   0:01   0 httpd 
    22809 root      15   0  1240 1240   896 R     0.1  0.1   0:00   0 top 
    22956 mysql     23   0 18332  16M  2168 R     0.1  1.7   0:00   0 mysqld 
    22957 mysql     23   0 18332  16M  2168 R     0.1  1.7   0:00   0 mysqld 
        1 root      15   0   116   84    56 S     0.0  0.0   0:06   0 init
    ps auxww
    [code]
    root 1 0.0 0.0 1520 80 ? S Mar30 0:46 init [3]
    root 2 0.0 0.0 0 0 ? SW Mar30 0:00 [migration/0]
    root 3 0.0 0.0 0 0 ? SW Mar30 0:00 [migration/1]
    root 4 0.0 0.0 0 0 ? SW Mar30 0:00 [keventd]
    root 5 0.0 0.0 0 0 ? SWN Mar30 0:00 [ksoftirqd/0]
    root 6 0.0 0.0 0 0 ? SWN Mar30 0:00 [ksoftirqd/1]
    root 9 0.0 0.0 0 0 ? SW Mar30 0:00 [bdflush]
    root 7 0.0 0.0 0 0 ? SW Mar30 80:51 [kswapd]
    root 8 0.2 0.0 0 0 ? SW Mar30 185:40 [kscand]
    root 10 0.0 0.0 0 0 ? SW Mar30 2:16 [kupdated]
    root 11 0.0 0.0 0 0 ? SW Mar30 0:00 [mdrecoveryd]
    root 18 0.0 0.0 0 0 ? SW Mar30 0:00 [scsi_eh_0]
    root 19 0.0 0.0 0 0 ? SW Mar30 0:00 [scsi_eh_1]
    root 22 0.0 0.0 0 0 ? SW Mar30 0:50 [kjournald]
    root 77 0.0 0.0 0 0 ? SW Mar30 0:00 [khubd]
    root 3377 0.0 0.0 0 0 ? SW Mar30 0:00 [kjournald]
    root 3378 0.0 0.0 0 0 ? SW Mar30 3:43 [kjournald]
    root 3379 0.0 0.0 0 0 ? SW Mar30 0:03 [kjournald]
    root 3380 0.0 0.0 0 0 ? SW Mar30 0:54 [kjournald]
    root 3381 0.0 0.0 0 0 ? SW Mar30 2:00 [kjournald]
    root 3382 0.0 0.0 0 0 ? SW Mar30 1:41 [kjournald]
    root 3383 0.0 0.0 0 0 ? SW Mar30 4:16 [kjournald]
    root 3860 0.0 0.0 1516 240 ? S Mar30 2:09 irqbalance
    root 5372 0.0 0.0 2152 276 ? S Mar30 0:00 xinetd -stayalive -pidfile
    bin 5593 0.0 0.0 2004 48 ? S Mar30 0:04 /usr/sbin/cannaserver -sysl
    daemon 5640 0.0 0.0 1584 176 ? S Mar30 0:04 /usr/sbin/atd
    root 5886 0.0 0.0 4628 72 ? S Mar30 0:01 rhnsd --interval 240
    root 5915 0.0 0.0 1676 300 ? S Mar30 0:00 /usr/sbin/portsentry -tcp
    root 5940 0.0 0.0 6036 544 ? S Mar30 2:26 perl /usr/sbin/cleanlink.pl
    root 5952 0.0 0.0 1580 148 ? S Mar30 0:12 mdadm --monitor --scan -f
    root 5965 0.0 1.1 12164 12160 ? SL Mar30 0:16 mdmpd
    root 5973 0.0 0.0 1504 4 tty1 S Mar30 0:00 /sbin/mingetty tty1
    root 5974 0.0 0.0 1504 4 tty2 S Mar30 0:00 /sbin/mingetty tty2
    root 5975 0.0 0.0 1504 4 tty3 S Mar30 0:00 /sbin/mingetty tty3
    root 5976 0.0 0.0 1504 4 tty4 S Mar30 0:00 /sbin/mingetty tty4
    root 5977 0.0 0.0 1504 4 tty5 S Mar30 0:00 /sbin/mingetty tty5
    root 5978 0.0 0.0 1504 4 tty6 S Mar30 0:00 /sbin/mingetty tty6
    root 5979 0.0 0.0 1504 4 ttyS0 S Mar30 0:00 /sbin/mingetty ttyS0 CON960
    root 6748 0.0 0.0 9516 200 ? S Apr03 0:00 cpsrvd - waiting for connec
    root 21765 0.0 0.0 11284 220 ? S Apr17 0:00 cppop - accepting on port 1
    nobody 31913 0.0 0.0 4284 692 ? S May14 0:07 proftpd: (accepting connect
    root 15548 0.0 0.2 31500 2640 ? S May22 2:14 /usr/local/apache/bin/httpd
    named 12597 0.0 0.2 48736 2640 ? S May26 0:12 /usr/sbin/named -u named
    root 27303 0.0 0.0 3664 644 ? S May26 0:04 /usr/sbin/sshd
    root 14598 0.0 0.0 1584 224 ? S May26 0:02 syslogd -m 0
    root 14602 0.0 0.0 1524 12 ? S May26 0:00 klogd -x
    root 31520 0.0 0.0 1600 584 ? S May29 0:00 crond
    nobody 12379 0.0 0.2 31512 2832 ? S 10:01 0:00 /usr/local/apache/bin/httpd
    root 12829 0.0 0.1 6876 1492 ? S 10:16 0:00 sshd: root@pts/0
    root 12834 0.0 0.1 5320 1284 pts/0 S 10:17 0:00 -bash
    nobody 14157 0.0 0.2 31512 2776 ? S 10:51 0:00 /usr/local/apache/bin/httpd
    nobody 16276 0.0 0.2 31512 2856 ? S 11:58 0:00 /usr/local/apache/bin/httpd
    nobody 16631 0.0 0.2 31512 2912 ? S 12:06 0:00
    ***************************
    about 100 of these

    The server doesnt host any videos just database webpages

  2. #2
    Join Date
    Mar 2003
    Location
    California USA
    Posts
    13,681
    have you optimized apache/mysql?
    Steven Ciaburri | Industry's Best Server Management - Rack911.com
    Software Auditing - 400+ Vulnerabilities Found - Quote @ https://www.RACK911Labs.com
    Fully Managed Dedicated Servers (Las Vegas, New York City, & Amsterdam) (AS62710)
    FreeBSD & Linux Server Management, Security Auditing, Server Optimization, PCI Compliance

  3. #3
    Is this an "out of the box" server? As linuxguy mentioned you should take steps to optimise your apache and MySQL config, and furthermore your entire server configuration to cease reoccuring issues.

    If you feel incapable, I reccomend hiring someone to configure your server nicely
    BeeServe
    * Rock solid shared & reseller UK webhosting. No downtime™ *
    Now offering fully managed VPS servers

  4. #4
    Join Date
    Apr 2004
    Posts
    500
    the problem im having is that I cannot tune any mysql settings

    because for any syntax I put
    e.g
    max_connections = 500
    max_user_connections = 500
    It wont let me restart mysqld and it fails until I change it back to the default

    If I tail -f /var/log/mysqld.log
    It just read the default settings and tells me

    050530 15:35:53 mysqld started
    /usr/libexec/mysqld: unrecognized option `--max_connections=500'
    /usr/libexec/mysqld Ver 3.23.58 for redhat-linux-gnu on i386


    Code:
    [mysqld]
    skip-innodb
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
     
    [mysql.server]
    user=mysql
    basedir=/var/lib
     
    [safe_mysqld]
    err-log=/var/log/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid

  5. #5
    Join Date
    Jan 2003
    Posts
    1,715
    Either upgrade your mysql install (recommended) or use the 3.x config format:
    set-variable = max_join_size=6M
    Game Servers are the next hot market!
    Slim margins, heavy support, fickle customers, and moronic suppliers!
    Start your own today!

  6. #6
    Join Date
    Apr 2004
    Posts
    500
    yes thats it thanks, I need to use another config format.
    although ive run out of money and the last time i tried to update mysql I crashed the server and lost a few days and had to pay someone to fix it.

    So I want to make sure I have someone helping me, if I try it again, plus I heard that it can break many scripts.

  7. #7
    Join Date
    Apr 2004
    Posts
    500
    Well I've managed to get the average down from 12-15 down to less than 1. thelinuxguy was correct, it was totally untouched, im surprised at how much difference it has made, learnt quite alot along the way.
    Now webpages load fast, I just have to wait until tonight to see what happens during peak time and optimise more during this time.

    I started off by tuning the sysctl.conf, removing unneccesary processes, optimising apache settings and then optimising mysql.

    But now with the older version 3.23 is it possible to change these values or did they only come out after 4?

    query_cache_limit = 1M
    query_cache_size = 32M
    query_cache_type = 1
    Last edited by Blueheaven; 06-05-2005 at 01:53 AM.

  8. #8
    Join Date
    Jan 2003
    Posts
    1,715
    Query cache is a 4.x feature.
    Game Servers are the next hot market!
    Slim margins, heavy support, fickle customers, and moronic suppliers!
    Start your own today!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •