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 is high suddenly from 0 to 18

Discussion in 'General Discussion' started by claven177, Jun 1, 2006.

  1. claven177

    claven177 Well-Known Member

    Joined:
    Sep 3, 2003
    Messages:
    61
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Taipei
    Hello,

    My server load is extremely high suddenly, and I have not got a clue why.
    I have setup a cronjob every 3 minuties to collect imformations about
    Load and processes (ps h -A -o "pid user pcpu pmem cmd")
    Read this Load time (TIME -A), when 2006/06/01 14:54 LOAD from 2 to 13 suddenly
    and read below mysql /usr/sbin/mysqld occupied cpu and eat memory.

    Read this Load time (TIME -B), when 2006/06/01 22:48 LOAD from 0 to 18 suddenly
    and read below mysql /usr/sbin/mysqld occupied cpu.

    I think the most important addition for optimal performance is the addition of three new SQL variables.
    Somebody HIGHLY recommend that add them to my.cnf if running any type of busy server. Those SQL variables are;
    query_cache_limit and so on

    The day before yesterday, I have add them to my.cnf,
    but get the same load is extremely high suddenly.
    I think I have to tune the my.cnf again.


    Do you think why couse the load high suddenly?
    A quick response would be great.




    TIME -A


    2006/06/01 14:42 LOAD:0
    2006/06/01 14:45 LOAD:2
    2006/06/01 14:48 LOAD:0
    2006/06/01 14:51 LOAD:2
    2006/06/01 14:54 LOAD:13 ******
    2006/06/01 14:57 LOAD:2


    ps h -A -o "pid user pcpu pmem cmd"

    LOAD 2006/06/01 14:55 1 root 0.0 0.0 init [3]
    2 root 0.0 0.0 [ksoftirqd/0]
    3 root 0.0 0.0 [events/0]
    4 root 0.0 0.0 [khelper]
    5 root 0.0 0.0 [kacpid]
    20 root 0.0 0.0 [kblockd/0]
    33 root 0.0 0.0 [aio/0]
    21 root 0.0 0.0 [khubd]
    32 root 0.0 0.0 [kswapd0]
    107 root 0.0 0.0 [kseriod]
    184 root 0.0 0.0 [kjournald]
    1015 root 0.0 0.0 udevd
    1351 root 0.0 0.0 [kauditd]
    1380 root 0.0 0.0 [kmirrord]
    1381 root 0.0 0.0 [kmir_mon]
    1401 root 0.0 0.0 [kjournald]
    1402 root 0.0 0.0 [kjournald]
    2159 root 0.0 0.1 /usr/sbin/sshd
    2480 root 0.0 0.0 syslogd -m 0
    2484 root 0.0 0.0 klogd -x
    2532 root 0.0 0.0 rpc.idmapd
    2600 root 0.0 0.0 /usr/sbin/acpid
    4099 root 0.0 0.1 cupsd
    4150 root 0.0 0.0 xinetd -stayalive -pidfile /var/run/xinetd.pid
    4162 ntp 0.0 0.4 ntpd -u ntp:ntp -p /var/run/ntpd.pid -g
    4562 root 0.0 0.2 cpbandwd
    4563 root 0.0 1.1 cpanellogd - sleeping for logs
    4747 root 0.0 0.1 pure-ftpd (SERVER)
    4783 root 0.0 0.0 /usr/sbin/pure-authd -s /var/run/ftpd.sock -r /usr/sbin/pureauth
    4839 cpanel 0.0 0.1 /usr/bin/stunnel-4.15local /usr/local/cpanel/etc/stunnel/default/stunnel.conf.run
    4899 dbus 0.0 0.0 dbus-daemon-1 --system
    4936 root 0.0 0.0 rhnsd --interval 240
    4957 root 0.0 0.1 hald
    5071 root 0.0 0.0 /sbin/mingetty tty1
    5072 root 0.0 0.0 /sbin/mingetty tty2
    5073 root 0.0 0.0 /sbin/mingetty tty3
    5074 root 0.0 0.0 /sbin/mingetty tty4
    5075 root 0.0 0.0 /sbin/mingetty tty5
    5079 root 0.0 0.0 /sbin/mingetty tty6
    5080 root 0.0 0.0 /sbin/agetty -L 9600 ttyS0 vt100
    30531 root 0.0 0.0 crond
    12269 root 0.0 0.2 chkservd
    3768 root 0.0 0.0 [pdflush]
    8863 root 0.0 0.0 [pdflush]
    4906 root 0.0 0.0 [kjournald]
    25305 named 0.5 1.3 /usr/sbin/named -u named
    6267 root 0.0 0.3 cpsrvd - waiting for connections
    24958 root 0.0 0.1 sshd: viviki [priv]
    25086 viviki 0.1 0.2 sshd: viviki@pts/0
    25089 viviki 0.0 0.1 -bash
    25465 root 0.0 0.1 su -
    25487 root 0.0 0.1 -bash
    25549 root 0.3 0.1 top
    29235 root 0.0 0.2 sshd: viviki [priv]
    29283 viviki 0.0 0.2 sshd: viviki@pts/1
    29288 viviki 0.0 0.1 -bash
    29360 root 0.0 0.1 su -
    29380 root 0.0 0.1 -bash
    21683 mailnull 0.0 0.5 eximstats
    21835 root 0.0 0.0 /usr/sbin/courierlogger -pid=/var/run/imapd.pid -start -name=imapd /usr/lib/courier-imap/libexec/couriertcpd -address=0 -maxprocs=40 -maxperip=30 -nodnslookup -noidentlookup 143 /usr/lib/courier-imap/sbin/imaplogin /usr/lib/courier-imap/bin/imapd Maildir
    21836 root 0.0 0.0 /usr/lib/courier-imap/libexec/couriertcpd -address=0 -maxprocs=40 -maxperip=30 -nodnslookup -noidentlookup 143 /usr/lib/courier-imap/sbin/imaplogin /usr/lib/courier-imap/bin/imapd Maildir
    21842 root 0.0 0.0 /usr/sbin/courierlogger -pid=/var/run/imapd-ssl.pid -start -name=imapd-ssl /usr/lib/courier-imap/libexec/couriertcpd -address=0 -maxprocs=40 -maxperip=30 -nodnslookup -noidentlookup 993 /usr/lib/courier-imap/bin/couriertls -server -tcpd /usr/lib/courier-imap/sbin/imaplogin /usr/lib/courier-imap/bin/imapd Maildir
    21843 root 0.0 0.0 /usr/lib/courier-imap/libexec/couriertcpd -address=0 -maxprocs=40 -maxperip=30 -nodnslookup -noidentlookup 993 /usr/lib/courier-imap/bin/couriertls -server -tcpd /usr/lib/courier-imap/sbin/imaplogin /usr/lib/courier-imap/bin/imapd Maildir
    21848 root 0.0 0.0 /usr/sbin/courierlogger -pid=/var/run/pop3d.pid -start -name=pop3d /usr/lib/courier-imap/libexec/couriertcpd -address=0 -maxprocs=40 -maxperip=30 -nodnslookup -noidentlookup 110 /usr/lib/courier-imap/sbin/pop3login /usr/lib/courier-imap/bin/pop3d Maildir
    21849 root 0.0 0.0 /usr/lib/courier-imap/libexec/couriertcpd -address=0 -maxprocs=40 -maxperip=30 -nodnslookup -noidentlookup 110 /usr/lib/courier-imap/sbin/pop3login /usr/lib/courier-imap/bin/pop3d Maildir
    21854 root 0.0 0.0 /usr/sbin/courierlogger -pid=/var/run/pop3d-ssl.pid -start -name=pop3d-ssl /usr/lib/courier-imap/libexec/couriertcpd -address=0 -maxprocs=40 -maxperip=30 -nodnslookup -noidentlookup 995 /usr/lib/courier-imap/bin/couriertls -server -tcpd /usr/lib/courier-imap/sbin/pop3login /usr/lib/courier-imap/bin/pop3d Maildir
    21855 root 0.0 0.0 /usr/lib/courier-imap/libexec/couriertcpd -address=0 -maxprocs=40 -maxperip=30 -nodnslookup -noidentlookup 995 /usr/lib/courier-imap/bin/couriertls -server -tcpd /usr/lib/courier-imap/sbin/pop3login /usr/lib/courier-imap/bin/pop3d Maildir
    21861 root 0.0 0.0 /usr/sbin/courierlogger -pid=/var/spool/authdaemon/pid -facility=mail -start /usr/libexec/courier-authlib/authdaemond
    21862 root 0.0 0.0 /usr/libexec/courier-authlib/authdaemond
    21863 root 0.0 0.0 /usr/libexec/courier-authlib/authdaemond
    21864 root 0.0 0.0 /usr/libexec/courier-authlib/authdaemond
    21865 root 0.0 0.0 /usr/libexec/courier-authlib/authdaemond
    21866 root 0.0 0.0 /usr/libexec/courier-authlib/authdaemond
    21867 root 0.0 0.0 /usr/libexec/courier-authlib/authdaemond
    21869 root 0.0 0.7 /etc/authlib/authProg
    22571 root 0.0 0.7 /etc/authlib/authProg
    23006 root 0.0 0.6 /etc/authlib/authProg
    23739 root 0.0 0.6 /etc/authlib/authProg
    23989 root 0.0 0.6 /etc/authlib/authProg
    26547 root 0.0 0.4 /usr/local/apache/bin/httpd -DSSL
    29567 watch99 0.0 0.1 pure-ftpd (IDLE)
    1793 root 0.0 0.1 crond
    1800 kinwa 0.0 0.1 pure-ftpd (IDLE)
    1809 root 0.0 0.0 /bin/sh /usr/local/bin/loadmon2
    1844 mailnull 0.0 0.0 [exim] <defunct>
    2230 nobody 0.1 0.4 /usr/local/apache/bin/httpd -DSSL
    2231 nobody 0.0 0.4 /usr/local/apache/bin/httpd -DSSL
    2232 nobody 0.1 0.4 /usr/local/apache/bin/httpd -DSSL
    2233 nobody 0.1 0.4 /usr/local/apache/bin/httpd -DSSL
    2234 nobody 0.0 0.4 /usr/local/apache/bin/httpd -DSSL
    2238 nobody 0.2 0.4 /usr/local/apache/bin/httpd -DSSL
    2250 nobody 0.0 0.4 /usr/local/apache/bin/httpd -DSSL
    2251 nobody 0.1 0.4 /usr/local/apache/bin/httpd -DSSL
    2252 nobody 0.0 0.4 /usr/local/apache/bin/httpd -DSSL
    2261 nobody 0.1 0.4 /usr/local/apache/bin/httpd -DSSL
    2266 nobody 0.0 0.4 /usr/local/apache/bin/httpd -DSSL
    2267 nobody 0.1 0.4 /usr/local/apache/bin/httpd -DSSL
    2270 nobody 0.1 0.4 /usr/local/apache/bin/httpd -DSSL
    2330 root 0.0 0.0 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/p2006.viviki4.us.pid
    2363 mysql 1.5 2.1 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/p2006.viviki4.us.pid --skip-locking --socket=/var/lib/mysql/mysql.sock
    2560 nobody 0.0 0.4 /usr/local/apache/bin/httpd -DSSL
    2626 nobody 0.0 0.4 /usr/local/apache/bin/httpd -DSSL
    2629 nobody 0.2 0.4 /usr/local/apache/bin/httpd -DSSL
    2630 nobody 0.1 0.4 /usr/local/apache/bin/httpd -DSSL
    2631 nobody 0.0 0.4 /usr/local/apache/bin/httpd -DSSL
    2632 nobody 0.0 0.4 /usr/local/apache/bin/httpd -DSSL
    2633 root 0.0 1.2 /usr/sbin/clamd
    2639 mailnull 0.0 0.1 /usr/sbin/exim -bd -q60m
    2643 mailnull 0.0 0.1 /usr/sbin/exim -tls-on-connect -bd -oX 465
    2649 root 0.2 0.1 antirelayd
    2650 mailnull 0.0 0.1 /usr/sbin/exim -bd -q60m
    2655 mailnull 0.0 0.1 /usr/sbin/exim -bd -q60m
    2656 mailnull 0.0 0.1 /usr/sbin/exim -bd -q60m
    2659 mailnull 0.0 0.1 /usr/sbin/exim -bd -q60m
    2661 mailnull 1.6 0.3 /usr/sbin/exim -bd -q60m
    2662 mailnull 0.0 0.1 /usr/sbin/exim -bd -q60m
    2665 root 0.0 1.2 /usr/bin/spamd -d --allowed-ips=127.0.0.1 --pidfile=/var/run/spamd.pid --max-children=5
    2668 root 0.0 0.0 ps h -A -o pid user pcpu pmem cmd​
     
    #1 claven177, Jun 1, 2006
    Last edited: Jun 1, 2006
  2. claven177

    claven177 Well-Known Member

    Joined:
    Sep 3, 2003
    Messages:
    61
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Taipei
    .....CONTINUED


    TIME -B
    2006/06/01 22:36 LOAD:1
    2006/06/01 22:39 LOAD:3
    2006/06/01 22:42 LOAD:2
    2006/06/01 22:45 LOAD:0
    2006/06/01 22:48 LOAD:18 ******
    2006/06/01 22:51 LOAD:3
    2006/06/01 22:54 LOAD:0 ​


    ps h -A -o "pid user pcpu pmem cmd"

    LOAD 2006/06/01 22:49 1 root 0.0 0.0 init [3]
    2 root 0.0 0.0 [ksoftirqd/0]
    3 root 0.0 0.0 [events/0]
    4 root 0.0 0.0 [khelper]
    5 root 0.0 0.0 [kacpid]
    20 root 0.0 0.0 [kblockd/0]
    33 root 0.0 0.0 [aio/0]
    21 root 0.0 0.0 [khubd]
    32 root 0.0 0.0 [kswapd0]
    107 root 0.0 0.0 [kseriod]
    184 root 0.0 0.0 [kjournald]
    1015 root 0.0 0.0 udevd
    1351 root 0.0 0.0 [kauditd]
    1380 root 0.0 0.0 [kmirrord]
    1381 root 0.0 0.0 [kmir_mon]
    1401 root 0.0 0.0 [kjournald]
    1402 root 0.0 0.0 [kjournald]
    2159 root 0.0 0.1 /usr/sbin/sshd
    2480 root 0.0 0.0 syslogd -m 0
    2484 root 0.0 0.0 klogd -x
    2532 root 0.0 0.0 rpc.idmapd
    2600 root 0.0 0.0 /usr/sbin/acpid
    4099 root 0.0 0.1 cupsd
    4150 root 0.0 0.0 xinetd -stayalive -pidfile /var/run/xinetd.pid
    4162 ntp 0.0 0.4 ntpd -u ntp:ntp -p /var/run/ntpd.pid -g
    4562 root 0.0 0.2 cpbandwd
    4563 root 0.0 1.4 cpanellogd - sleeping for logs
    4747 root 0.0 0.1 pure-ftpd (SERVER)
    4783 root 0.0 0.0 /usr/sbin/pure-authd -s /var/run/ftpd.sock -r /usr/sbin/pureauth
    4839 cpanel 0.0 0.1 /usr/bin/stunnel-4.15local /usr/local/cpanel/etc/stunnel/default/stunnel.conf.run
    4899 dbus 0.0 0.0 dbus-daemon-1 --system
    4936 root 0.0 0.0 rhnsd --interval 240
    4957 root 0.0 0.1 hald
    5071 root 0.0 0.0 /sbin/mingetty tty1
    5072 root 0.0 0.0 /sbin/mingetty tty2
    5073 root 0.0 0.0 /sbin/mingetty tty3
    5074 root 0.0 0.0 /sbin/mingetty tty4
    5075 root 0.0 0.0 /sbin/mingetty tty5
    5079 root 0.0 0.0 /sbin/mingetty tty6
    5080 root 0.0 0.0 /sbin/agetty -L 9600 ttyS0 vt100
    30531 root 0.0 0.0 crond
    12269 root 0.0 0.2 chkservd
    3768 root 0.0 0.0 [pdflush]
    8863 root 0.0 0.0 [pdflush]
    4906 root 0.0 0.0 [kjournald]
    6267 root 0.0 0.3 cpsrvd - waiting for connections
    24219 named 0.6 1.0 /usr/sbin/named -u named
    13078 root 0.0 0.0 /usr/sbin/courierlogger -pid=/var/run/imapd.pid -start -name=imapd /usr/lib/courier-imap/libexec/couriertcpd -address=0 -maxprocs=40 -maxperip=30 -nodnslookup -noidentlookup 143 /usr/lib/courier-imap/sbin/imaplogin /usr/lib/courier-imap/bin/imapd Maildir
    13079 root 0.0 0.0 /usr/lib/courier-imap/libexec/couriertcpd -address=0 -maxprocs=40 -maxperip=30 -nodnslookup -noidentlookup 143 /usr/lib/courier-imap/sbin/imaplogin /usr/lib/courier-imap/bin/imapd Maildir
    13085 root 0.0 0.0 /usr/sbin/courierlogger -pid=/var/run/imapd-ssl.pid -start -name=imapd-ssl /usr/lib/courier-imap/libexec/couriertcpd -address=0 -maxprocs=40 -maxperip=30 -nodnslookup -noidentlookup 993 /usr/lib/courier-imap/bin/couriertls -server -tcpd /usr/lib/courier-imap/sbin/imaplogin /usr/lib/courier-imap/bin/imapd Maildir
    13086 root 0.0 0.0 /usr/lib/courier-imap/libexec/couriertcpd -address=0 -maxprocs=40 -maxperip=30 -nodnslookup -noidentlookup 993 /usr/lib/courier-imap/bin/couriertls -server -tcpd /usr/lib/courier-imap/sbin/imaplogin /usr/lib/courier-imap/bin/imapd Maildir
    13091 root 0.0 0.0 /usr/sbin/courierlogger -pid=/var/run/pop3d.pid -start -name=pop3d /usr/lib/courier-imap/libexec/couriertcpd -address=0 -maxprocs=40 -maxperip=30 -nodnslookup -noidentlookup 110 /usr/lib/courier-imap/sbin/pop3login /usr/lib/courier-imap/bin/pop3d Maildir
    13092 root 0.0 0.0 /usr/lib/courier-imap/libexec/couriertcpd -address=0 -maxprocs=40 -maxperip=30 -nodnslookup -noidentlookup 110 /usr/lib/courier-imap/sbin/pop3login /usr/lib/courier-imap/bin/pop3d Maildir
    13097 root 0.0 0.0 /usr/sbin/courierlogger -pid=/var/run/pop3d-ssl.pid -start -name=pop3d-ssl /usr/lib/courier-imap/libexec/couriertcpd -address=0 -maxprocs=40 -maxperip=30 -nodnslookup -noidentlookup 995 /usr/lib/courier-imap/bin/couriertls -server -tcpd /usr/lib/courier-imap/sbin/pop3login /usr/lib/courier-imap/bin/pop3d Maildir
    13098 root 0.0 0.0 /usr/lib/courier-imap/libexec/couriertcpd -address=0 -maxprocs=40 -maxperip=30 -nodnslookup -noidentlookup 995 /usr/lib/courier-imap/bin/couriertls -server -tcpd /usr/lib/courier-imap/sbin/pop3login /usr/lib/courier-imap/bin/pop3d Maildir
    13103 root 0.0 0.0 /usr/sbin/courierlogger -pid=/var/spool/authdaemon/pid -facility=mail -start /usr/libexec/courier-authlib/authdaemond
    13104 root 0.0 0.0 /usr/libexec/courier-authlib/authdaemond
    13106 root 0.0 0.0 /usr/libexec/courier-authlib/authdaemond
    13107 root 0.0 0.0 /usr/libexec/courier-authlib/authdaemond
    13108 root 0.0 0.0 /usr/libexec/courier-authlib/authdaemond
    13109 root 0.0 0.0 /usr/libexec/courier-authlib/authdaemond
    13110 root 0.0 0.0 /usr/libexec/courier-authlib/authdaemond
    15313 root 0.0 0.7 /etc/authlib/authProg
    19115 root 0.0 0.4 /usr/local/apache/bin/httpd -DSSL
    5816 root 0.0 0.2 sshd: viviki [priv]
    5845 viviki 0.1 0.2 sshd: viviki@pts/0
    5847 viviki 0.0 0.1 -bash
    5892 root 0.0 0.1 su -
    5920 root 0.0 0.1 -bash
    5988 root 0.3 0.1 top
    10454 root 0.0 0.6 /etc/authlib/authProg
    13700 root 0.0 0.6 /etc/authlib/authProg
    19344 root 0.0 0.6 /etc/authlib/authProg
    31154 root 0.0 0.6 /etc/authlib/authProg
    2620 root 0.0 0.0 /usr/lib/courier-imap/sbin/pop3login /usr/lib/courier-imap/bin/pop3d Maildir
    4336 diygame 0.0 0.1 pure-ftpd (IDLE)
    4619 root 0.0 0.1 crond
    4630 root 0.0 0.0 /bin/sh /usr/local/bin/loadmon2
    4658 mailnull 0.0 0.0 [exim] <defunct>
    5131 nobody 0.0 0.4 /usr/local/apache/bin/httpd -DSSL
    5132 nobody 0.0 0.4 /usr/local/apache/bin/httpd -DSSL
    5133 nobody 0.0 0.4 /usr/local/apache/bin/httpd -DSSL
    5134 nobody 0.0 0.4 /usr/local/apache/bin/httpd -DSSL
    5178 nobody 0.0 0.4 /usr/local/apache/bin/httpd -DSSL
    5180 nobody 0.0 0.4 /usr/local/apache/bin/httpd -DSSL
    5181 nobody 0.0 0.4 /usr/local/apache/bin/httpd -DSSL
    5182 nobody 0.0 0.4 /usr/local/apache/bin/httpd -DSSL
    5183 nobody 0.0 0.4 /usr/local/apache/bin/httpd -DSSL
    5184 nobody 0.0 0.4 /usr/local/apache/bin/httpd -DSSL
    5186 nobody 0.0 0.4 /usr/local/apache/bin/httpd -DSSL
    5187 nobody 0.0 0.4 /usr/local/apache/bin/httpd -DSSL
    5188 nobody 0.0 0.4 /usr/local/apache/bin/httpd -DSSL
    5189 nobody 0.0 0.4 /usr/local/apache/bin/httpd -DSSL
    5190 nobody 0.0 0.4 /usr/local/apache/bin/httpd -DSSL
    5191 nobody 0.1 0.4 /usr/local/apache/bin/httpd -DSSL
    5192 nobody 0.0 0.4 /usr/local/apache/bin/httpd -DSSL
    5193 nobody 0.0 0.4 /usr/local/apache/bin/httpd -DSSL
    5196 nobody 0.1 0.4 /usr/local/apache/bin/httpd -DSSL
    5197 nobody 0.0 0.4 /usr/local/apache/bin/httpd -DSSL
    5199 nobody 0.0 0.4 /usr/local/apache/bin/httpd -DSSL
    5200 nobody 0.0 0.4 /usr/local/apache/bin/httpd -DSSL
    5202 nobody 0.0 0.4 /usr/local/apache/bin/httpd -DSSL
    5203 nobody 0.0 0.4 /usr/local/apache/bin/httpd -DSSL
    5204 nobody 0.0 0.4 /usr/local/apache/bin/httpd -DSSL
    5217 nobody 0.0 0.4 /usr/local/apache/bin/httpd -DSSL
    5306 root 0.0 0.0 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/p2006.viviki4.us.pid
    5338 mysql 6.7 1.3 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/p2006.viviki4.us.pid --skip-locking --socket=/var/lib/mysql/mysql.sock
    5571 nobody 0.0 0.4 /usr/local/apache/bin/httpd -DSSL
    5575 root 0.0 1.2 /usr/sbin/clamd
    5581 mailnull 0.0 0.1 /usr/sbin/exim -bd -q60m
    5585 mailnull 0.0 0.1 /usr/sbin/exim -tls-on-connect -bd -oX 465
    5591 root 0.0 0.1 antirelayd
    5593 mailnull 0.2 0.3 /usr/sbin/exim -bd -q60m
    5598 mailnull 0.0 0.1 /usr/sbin/exim -bd -q60m
    5600 mailnull 0.0 0.1 /usr/sbin/exim -bd -q60m
    5603 mailnull 0.0 0.1 /usr/sbin/exim -bd -q60m
    5609 nobody 0.1 0.4 /usr/local/apache/bin/httpd -DSSL
    5613 mailnull 0.0 0.1 /usr/sbin/exim -bd -q60m
    5616 nobody 0.1 0.4 /usr/local/apache/bin/httpd -DSSL
    5621 mailnull 0.0 0.1 /usr/sbin/exim -bd -q60m
    5622 nobody 0.0 0.4 /usr/local/apache/bin/httpd -DSSL
    5623 nobody 0.0 0.4 /usr/local/apache/bin/httpd -DSSL
    5624 nobody 0.0 0.4 /usr/local/apache/bin/httpd -DSSL
    5625 mailnull 0.0 0.1 /usr/sbin/exim -bd -q60m
    5626 mailnull 0.0 0.1 /usr/sbin/exim -bd -q60m
    5630 mailnull 0.0 0.1 /usr/sbin/exim -bd -q60m
    5631 mailnull 0.0 0.1 /usr/sbin/exim -bd -q60m
    5632 mailnull 0.0 0.1 /usr/sbin/exim -bd -q60m
    5633 mailnull 0.0 0.1 /usr/sbin/exim -bd -q60m
    5635 ebbcbook 8.0 0.3 /usr/bin/php index.php
    5636 mailnull 0.0 0.1 /usr/sbin/exim -bd -q60m
    5637 root 0.0 1.2 /usr/bin/spamd -d --allowed-ips=127.0.0.1 --pidfile=/var/run/spamd.pid --max-children=5
    5638 ebbcbook 5.0 0.4 /usr/bin/php modules.php
    5641 root 0.0 0.0 ps h -A -o pid user pcpu pmem cmd​
     
    #2 claven177, Jun 1, 2006
    Last edited: Jun 1, 2006
  3. claven177

    claven177 Well-Known Member

    Joined:
    Sep 3, 2003
    Messages:
    61
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Taipei
    .....CONTINUED


    My server with a single-processor server P4 and 1 GB ram

    pico /etc/my.cnf


    [mysqld]
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    # Default to using old password format for compatibility with mysql 3.x
    # clients (those using the mysqlclient10 compatibility package).
    skip-locking
    skip-innodb
    query_cache_limit=1M
    query_cache_size=32M
    query_cache_type=1

    max_connections=500
    interactive_timeout=100
    wait_timeout=100
    connect_timeout=10
    thread_cache_size=60
    key_buffer=64M
    join_buffer=1M

    max_allowed_packet=16M
    table_cache=400
    record_buffer=1M
    sort_buffer_size=768K
    read_buffer_size=512K
    read_rnd_buffer_size=512K
    max_connect_errors=10
    # Try number of CPU's*2 for thread_concurrency
    thread_concurrency=2
    myisam_sort_buffer_size=32M
    log-bin
    server-id=1
    [mysql.server]
    user=mysql
    basedir=/var/lib
    old-passwords = 1

    [mysqld_safe]
    err-log=/var/log/mysqld.log
    # pid-file=/var/run/mysqld/mysqld.pid
    open_files_limit=8192

    [mysqldump]
    quick
    max_allowed_packet=16M

    [mysql]
    no-auto-rehash
    #safe-updates

    [isamchk]
    key_buffer=64M
    sort_buffer=64M
    read_buffer=16M
    write_buffer=16M

    [myisamchk]
    key_buffer=64M
    sort_buffer=64M
    read_buffer=16M
    write_buffer=16M

    [mysqlhotcopy]
    interactive-timeout​
     
    #3 claven177, Jun 1, 2006
    Last edited: Jun 1, 2006
  4. AndyReed

    AndyReed Well-Known Member
    PartnerNOC

    Joined:
    May 29, 2004
    Messages:
    2,222
    Likes Received:
    3
    Trophy Points:
    38
    Location:
    Minneapolis, MN
    The problem is not your MySQL, not Apache, and not Php. This subject has been discussed so many times in the past. Search these forums. Try "high server load."
     
  5. OCX

    OCX Well-Known Member

    Joined:
    Sep 20, 2003
    Messages:
    232
    Likes Received:
    0
    Trophy Points:
    16
    While AndyReed may be right its not your mysql.. have a look at my my.cnf config file tunage..

    My server specs are
    AMD Dual Opteron 242's with 2gigs of ram and 2 x 200gig 8MB cache Drives
    CentOS 4.3 i686 w/cpanel latest Edge Release ( non 64bit os)

    [mysqld]
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    skip-locking
    skip-innodb
    query_cache_limit=1M
    query_cache_size=32M
    query_cache_type=1
    max_connections=500
    interactive_timeout=100
    wait_timeout=100
    connect_timeout=10
    thread_cache_size=128
    key_buffer=16M
    join_buffer=1M
    max_allowed_packet=16M
    table_cache=1024
    record_buffer=1M
    sort_buffer_size=2M
    read_buffer_size=2M
    max_connect_errors=10
    # Try number of CPU's*2 for thread_concurrency
    thread_concurrency=2
    myisam_sort_buffer_size=64M
    #log-bin
    server-id=1

    [mysql.server]
    user=mysql
    basedir=/var/lib

    [safe_mysqld]
    err-log=/var/log/mysqld.log
    pid-file=/var/lib/mysql/mysql.pid
    open_files_limit=8192

    [mysqldump]
    quick
    max_allowed_packet=16M

    [mysql]
    no-auto-rehash
    #safe-updates

    [isamchk]
    key_buffer=64M
    sort_buffer=64M
    read_buffer=16M
    write_buffer=16M

    key_buffer=64M
    sort_buffer=64M
    read_buffer=16M
    write_buffer=16M









    i bet more then likly its an email issue, but without looking at your server first hand
    its hard to just sit n guess
     
  6. OCX

    OCX Well-Known Member

    Joined:
    Sep 20, 2003
    Messages:
    232
    Likes Received:
    0
    Trophy Points:
    16
    what does your /tmp directory look like? post the contents of your /tmp directory..
    good possiblity you got tmp files in there that shouldnt be there..


    OCX
     
  7. claven177

    claven177 Well-Known Member

    Joined:
    Sep 3, 2003
    Messages:
    61
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Taipei

    Thank you.


    # ls -l /tmp


    total 172
    drwxrwxrwt 5 root root 20480 Jun 2 12:27 ./
    drwxr-xr-x 29 root root 4096 Jun 2 03:07 ../
    -rw-r--r-- 1 root root 0 May 31 00:07 aquota.user
    drwx------ 2 root root 4096 Jun 1 14:27 clamav-f202ce66105bcc1f/
    drwxr-xr-x 2 root root 4096 Jun 2 00:04 cpbandwidth/
    -rw-r--r-- 1 mmtravel mmtravel 0 May 31 23:43 fileX0pnGi
    lrwxrwxrwx 1 root root 30 Jun 2 12:27 mysql.sock -> ../../var/lib/mysql/mysql.sock=
    -rw-r--r-- 1 root root 0 May 31 00:07 quota.user
    -rw------- 1 ubnesc ubnesc 0 Jun 2 00:53 sess_08f6f832569dd86ca81c9eee233977f0
    -rw------- 1 dyyi dyyi 0 May 31 21:38 sess_0a9e60c26c6a68f438f31c9939be01f5
    -rw------- 1 dyyi dyyi 0 Jun 1 06:26 sess_0d38bf65d43c24aafc592a9c314194be
    -rw------- 1 p12milex p12milex 0 Jun 2 11:31 sess_0ff6d700fc47ec6f4ace11e87ce37d5f
    -rw------- 1 p12milex p12milex 0 Jun 2 11:39 sess_117ebeb245d1434c7729254320618768
    -rw------- 1 cpanel cpanel 15518 May 30 22:45 sess_26b210397b2bc8bd287a32de977f76ef
    -rw------- 1 twkai twkai 977 Jun 1 21:24 sess_28e2e0f852f9d85ed664d12e4b8bd49e
    -rw------- 1 ubnesc ubnesc 89 Jun 1 18:03 sess_34e11f080c10ce1bb2be80f4f462e977
    -rw------- 1 dyyi dyyi 0 Jun 1 15:31 sess_398f7628c7fe68c5dc9264e9ae56f83d
    -rw------- 1 dyyi dyyi 0 May 31 05:53 sess_3b3a58ffc875a8559b81f1e07a6d7a29
    -rw------- 1 noount noount 0 May 31 18:46 sess_41911eea22aba22161d232941d934570
    -rw------- 1 twkai twkai 432 Jun 1 18:32 sess_5a05df0c64f96598a7b2cdba3a56193f
    -rw------- 1 twkai twkai 671 Jun 1 17:15 sess_623fb2b99225cb05d089ae2a980cdcf3
    -rw------- 1 twkai twkai 510 Jun 1 17:15 sess_6550665b21cd8b3831ad62fc581535a4
    -rw------- 1 p12milex p12milex 0 Jun 2 10:48 sess_663cca569e2ff79e6f84ce6bc11ffab8
    -rw------- 1 p12milex p12milex 0 Jun 2 11:34 sess_704ca5df86f4941678e089f5df74eda8
    -rw------- 1 twkai twkai 532 Jun 1 18:33 sess_875c2ce777caad4f0750c3bfaf3c8bf8
    -rw------- 1 dyyi dyyi 0 Jun 1 19:53 sess_8b9a98e4fd2986ca6ca6c3ab4e88937f
    -rw------- 1 twkai twkai 757 Jun 1 18:33 sess_95ce0f124f7903eee0fa4d2e58fdef03
    -rw------- 1 dyyi dyyi 0 Jun 2 12:10 sess_98dc6977c1569805ce3c91ce23cb2548
    -rw------- 1 noount noount 0 May 31 19:52 sess_9ef904b3ecff26396a2b034badd3d021
    -rw------- 1 dyyi dyyi 0 May 31 03:25 sess_9f218eecea8cf017994db7cfab1541c9
    -rw------- 1 ubnesc ubnesc 89 Jun 1 18:25 sess_9fc33d669a3e498562aca4291382e336
    -rw------- 1 noount noount 0 May 31 10:10 sess_a6635b8e3b2b0786af6616762f4b70f6
    -rw------- 1 dyyi dyyi 0 May 31 18:48 sess_a94b84fd86df5c0bdb7f111830e26a58
    -rw------- 1 root root 15560 May 30 21:40 sess_ac60c1f9acaef92564fc36b89a75f650
    -rw------- 1 maiktrey maiktrey 0 May 31 10:01 sess_b623d1b3aa9dc0f83f479361653997ce
    -rw------- 1 noount noount 24 May 31 19:52 sess_ccbaa720e97e03c4044e4cfddc45d7f6
    -rw------- 1 dyyi dyyi 0 Jun 1 14:42 sess_cd4bf5355625190d53def37db3768796
    -rw------- 1 support support 33520 May 31 23:27 sess_d5ea861635692737e7d9d163b228c708
    -rw------- 1 twkai twkai 1085 Jun 2 00:54 sess_d7113320f36e3ee9ea4326ccb7ca17dc
    -rw------- 1 twkai twkai 980 Jun 1 21:23 sess_d78af2934c85c54cfaa3e970d918bbfb
    -rw------- 1 twkai twkai 455 Jun 1 18:32 sess_eccbbc3d0dbc758746bc07ed14c8a880
    -rw------- 1 twkai twkai 429 Jun 1 17:16 sess_ef3466a198d287c4152faab3aaa820ff
    -rw------- 1 twkai twkai 1076 Jun 1 21:23 sess_f2f618e083ea6c2908994a2031c2c264
    -rw------- 1 dyyi dyyi 0 Jun 2 03:51 sess_f62d606d7cf347f41e91a3e645cf8cfe
    -rw------- 1 twkai twkai 481 Jun 1 20:23 sess_fe0243f32809e5d9aad1886125c8449e
    drwx------ 3 root root 4096 May 30 16:44 spamd-10027-init/

     
    #7 claven177, Jun 1, 2006
    Last edited: Jun 1, 2006
  8. claven177

    claven177 Well-Known Member

    Joined:
    Sep 3, 2003
    Messages:
    61
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Taipei
    I have read~~ this post

    Although this issue has been discussed hundreds of times in these forums, you need to find out who or what is causing the problem. Most likely a bad php and/or cgi/perl script. If that's true, you'll need to clean up your server, and install security patches and applications including ModeSecurity, APF, and BFD.​


    Thanks.
     
  9. claven177

    claven177 Well-Known Member

    Joined:
    Sep 3, 2003
    Messages:
    61
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Taipei
    Finally I have find out who or what is causing the problem.

    They have install XOOPS 2.0.2 (released 2003/4/25).
    likely a bad or expired php script.

    I have solved this problem and got the normal roading.
     
  10. AndyReed

    AndyReed Well-Known Member
    PartnerNOC

    Joined:
    May 29, 2004
    Messages:
    2,222
    Likes Received:
    3
    Trophy Points:
    38
    Location:
    Minneapolis, MN
    I am happy that you solved this "high server load" problem which was a bad/old/insecure Php script :)
     
  11. claven177

    claven177 Well-Known Member

    Joined:
    Sep 3, 2003
    Messages:
    61
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Taipei

    Thank you.

    I have forced to deliver all messages in queue using cronjob every 30 minutes
    */30 * * * * root exim -qff &
    maybe I have to change as
    * */2 * * * root exim -qff & for every 2 hours
    If I didnot put the cronjob, some mail will delay for 1 day or 2 day.

    I have use RH9 for 2 years, half a month I upgrade my box as
    WHM 10.8.0 cPanel 10.8.2-R115
    RedHat Enterprise 4 i686 - WHM

    But the spamd and clamd likely eat more CPU and RAM in my new box.

    Code:
    Top Process %CPU 19.5 /usr/bin/spamd -d --allowed-ips127.0.0.1 --pidfile/var/run/spamd.pid --max-children5 
     
  12. OCX

    OCX Well-Known Member

    Joined:
    Sep 20, 2003
    Messages:
    232
    Likes Received:
    0
    Trophy Points:
    16

    I myself use Mailscanner + Mailwatch + Clamav along with http://www.configserver.com/cp/msfe.html (so my clients can set there spam settings) and my mail que has no more then 10 in que at the most any time of the day or night..(with this config you dont use spamd. and i do have quit a bit of ram and cpu power to handle this too.

    also too make sure you have your data center setup Reverse DNS and Reverse MX records for your
    hostname and any domains your hosting that have its own IP#

    this will also help with email issues as some servers wont accept your emails
    if no reverse DNS is setup..
     
  13. RandyO

    RandyO Well-Known Member

    Joined:
    Jun 17, 2003
    Messages:
    173
    Likes Received:
    0
    Trophy Points:
    16
    And how would you propose that all domains have their own IP? this is not even possible by current rules. (well unless you have every client on an SSL)
     
  14. OCX

    OCX Well-Known Member

    Joined:
    Sep 20, 2003
    Messages:
    232
    Likes Received:
    0
    Trophy Points:
    16

    thats what im talkin about, if you have clients that have there own IP# for SSL purposes
    you setup reverse DNS for each domain on its own IP



    OCX
     
  15. RandyO

    RandyO Well-Known Member

    Joined:
    Jun 17, 2003
    Messages:
    173
    Likes Received:
    0
    Trophy Points:
    16
    You are dreaming.... How you are going to convert a 3-5% item to 100%, it would be just as easy to give everyone their own server..
     
  16. OCX

    OCX Well-Known Member

    Joined:
    Sep 20, 2003
    Messages:
    232
    Likes Received:
    0
    Trophy Points:
    16

    im not tryin to be rude or anything..but.i dont think you either understand what im talking about

    or

    you dont know what your talkin about..


    OCX
     
  17. RandyO

    RandyO Well-Known Member

    Joined:
    Jun 17, 2003
    Messages:
    173
    Likes Received:
    0
    Trophy Points:
    16
    300+ clients on a server and you propose to give each an IP? ARIN rules preclude this and they outright ban it. You can not just create IP based accounts for users.(IP's are a commodity and they are in short supply).
    You must justify a request for addtional IP's and that is going to be hard to do with the idea you are going to stop spam or service abuse.

    I just thought it was a well known fact and assumed to much I guess.

    Seems as likely a solution as just personally scanning each mail yourself
     
  18. OCX

    OCX Well-Known Member

    Joined:
    Sep 20, 2003
    Messages:
    232
    Likes Received:
    0
    Trophy Points:
    16

    no no no..all iment was..if you have clients that you have given private IP#s for the use of SSL or just because they asked for it and paid you for it..

    then dont forget to have reverse DNS setup for the IPS > domain reverse DNS setup for it

    thats all..i never said anything else..or ment anything else


    OCX
     
  19. RandyO

    RandyO Well-Known Member

    Joined:
    Jun 17, 2003
    Messages:
    173
    Likes Received:
    0
    Trophy Points:
    16
    Maybe someone else can explain this better than I, but you can not just assign IP's to clients because they request them or pay for them. There are in fact rules in place about IP assignments and I do not know a datacenter that will skirt or break these rules.
     
  20. OCX

    OCX Well-Known Member

    Joined:
    Sep 20, 2003
    Messages:
    232
    Likes Received:
    0
    Trophy Points:
    16
    yes you can..you can give an IP# to a customer as long as you justify the reason.
    such as a client wants an SSL cert for his or her online busienss and needs to take creditcards on there site..

    you have to give a customer his or her own IP# for the ssl cert..



    OCX
     
Loading...

Share This Page