server load is high suddenly from 0 to 18

[claven177]

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​

 

[claven177]

.....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​

 

[claven177]

.....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​

 

[AndyReed]

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).
​

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."

 

[OCX]

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

 

[OCX]

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

 

[claven177]

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

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/

​

 

[claven177]

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."

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.

 

[claven177]

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.

 

[AndyReed]

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.

I am happy that you solved this "high server load" problem which was a bad/old/insecure Php script

 

[claven177]

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

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.

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

 

[OCX]

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.

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

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..

 

[RandyO]

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..

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)

 

[OCX]

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)

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

 

[RandyO]

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

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..

 

[OCX]

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..

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

 

[RandyO]

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

 

[OCX]

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

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

 

[RandyO]

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

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.

 

[OCX]

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.

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