MySQL high load
Here is top output
Code:
CPU states: cpu user nice system irq softirq iowait idle
total 87.3% 0.0% 11.7% 0.4% 0.4% 0.0% 0.0%
Mem: 1027472k av, 1016268k used, 11204k free, 0k shrd, 149772k buff
774448k actv, 145120k in_d, 13936k in_c
Swap: 2048276k av, 85000k used, 1963276k free 529256k cached
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
13163 mysql 15 0 19764 19M 1508 S 60.0 1.9 0:55 0 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/alpha.ourserver.com.pid
15218 root 16 0 3148 3148 1416 D 22.4 0.3 0:01 0 /usr/bin/perl /usr/local/cpanel/bin/mkvhostspasswd
15231 sportdir 21 0 7216 7216 1332 D 4.3 0.7 0:00 0 /usr/bin/perl index.cgi
2611 root 15 0 31372 25M 5064 S 2.4 2.5 0:41 0 /usr/local/apache/bin/httpd -DSSL
2400 named 25 0 6412 5976 2116 S 0.9 0.5 3:10 0 /usr/sbin/named -u named
5 root 15 0 0 0 0 SW 0.4 0.0 1:19 0 kswapd
569 root 15 0 0 0 0 SW 0.4 0.0 1:06 0 kjournald
15200 root 15 0 1308 1308 908 R 0.4 0.1 0:00 0 top
1 root 15 0 484 460 424 S 0.0 0.0 0:06 0 init [3]
2 root 15 0 0 0 0 SW 0.0 0.0 0:02 0 keventd
3 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kapmd
4 root 34 19 0 0 0 SWN 0.0 0.0 0:00 0 ksoftirqd/0
7 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 bdflush
6 root 15 0 0 0 0 SW 0.0 0.0 3:58 0 kscand
8 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kupdated
9 root 25 0 0 0 0 SW 0.0 0.0 0:00 0 mdrecoveryd
13 root 15 0 0 0 0 DW 0.0 0.0 1:10 0 kjournald
98 root 25 0 0 0 0 SW 0.0 0.0 0:00 0 khubd
568 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kjournald
1042 root 15 0 580 556 496 D 0.0 0.0 0:14 0 syslogd -m 0
1046 root 15 0 472 460 412 S 0.0 0.0 0:00 0 klogd -x
2413 root 15 0 1168 1020 932 S 0.0 0.0 0:00 0 /usr/sbin/sshd
2427 root 15 0 776 728 652 S 0.0 0.0 0:00 0 xinetd -stayalive -pidfile /var/run/xinetd.pid
2498 root 15 0 2288 1400 996 S 0.0 0.1 0:02 0 chkservd
2558 mailnull 15 0 1560 1312 1232 S 0.0 0.1 0:00 0 /usr/sbin/exim -bd -oX 26
2564 mailnull 15 0 1596 1344 1264 S 0.0 0.1 0:05 0 /usr/sbin/exim -bd -q45m
2570 mailnull 15 0 1536 1216 1212 S 0.0 0.1 0:00 0 /usr/sbin/exim -tls-on-connect -bd -oX 465
2577 root 15 0 1024 980 724 S 0.0 0.0 0:12 0 antirelayd
2593 root 15 0 21284 2328 860 S 0.0 0.2 0:02 0 /usr/bin/spamd -d --allowed-ips=127.0.0.1 --pidfile=/var/run/spamd.pid --max-children=10 --max-conn-per-child=5
2634 root 15 0 644 628 540 S 0.0 0.0 0:01 0 crond
2680 daemon 15 0 572 552 508 S 0.0 0.0 0:00 0 /usr/sbin/atd
2941 root 34 19 13708 12M 1348 S N 0.0 1.2 4:48 0 cpanellogd - sleeping for logs
3105 root 15 0 1388 1388 1088 S 0.0 0.1 0:00 0 pure-ftpd (SERVER)
3109 root 15 0 988 968 800 S 0.0 0.0 0:00 0 /usr/sbin/pure-authd -s /var/run/ftpd.sock -r /usr/sbin/pureauth
3115 mailman 15 0 4564 4392 1708 S 0.0 0.4 0:00 0 /usr/bin/python2 /usr/local/cpanel/3rdparty/mailman/bin/mailmanctl -s start
3123 root 15 0 552 552 492 S 0.0 0.0 0:00 0 rhnsd --interval 240
3125 mailman 15 0 4400 4400 1600 R 0.0 0.4 0:00 0 /usr/bin/python2 /usr/local/cpanel/3rdparty/mailman/bin/qrunner --runner=ArchRunner:0:1 -s
3126 mailman 15 0 5572 5504 1644 D 0.0 0.5 0:01 0 /usr/bin/python2 /usr/local/cpanel/3rdparty/mailman/bin/qrunner --runner=BounceRunner:0:1 -s
3127 mailman 15 0 5648 5224 1704 D 0.0 0.5 0:01 0 /usr/bin/python2 /usr/local/cpanel/3rdparty/mailman/bin/qrunner --runner=CommandRunner:0:1 -s
3128 mailman 15 0 5844 5504 1736 D 0.0 0.5 0:01 0 /usr/bin/python2 /usr/local/cpanel/3rdparty/mailman/bin/qrunner --runner=IncomingRunner:0:1 -s
3129 mailman 15 0 4436 4436 1600 D 0.0 0.4 0:01 0 /usr/bin/python2 /usr/local/cpanel/3rdparty/mailman/bin/qrunner --runner=NewsRunner:0:1 -s
3130 mailman 15 0 6012 6000 1832 R 0.0 0.5 0:02 0 /usr/bin/python2 /usr/local/cpanel/3rdparty/mailman/bin/qrunner --runner=OutgoingRunner:0:1 -s
3131 mailman 15 0 5760 5728 1704 D 0.0 0.5 0:01 0 /usr/bin/python2 /usr/local/cpanel/3rdparty/mailman/bin/qrunner --runner=VirginRunner:0:1 -s
3132 mailman 15 0 4400 4400 1600 S 0.0 0.4 0:00 0 /usr/bin/python2 /usr/local/cpanel/3rdparty/mailman/bin/qrunner --runner=RetryRunner:0:1 -s
3161 root 15 0 0 0 0 DW 0.0 0.0 0:06 0 loop0
3163 root 15 0 0 0 0 DW 0.0 0.0 0:03 0 kjournald
3314 root 15 0 408 408 348 S 0.0 0.0 0:00 0 mdadm --monitor --scan -f
3355 root 21 0 416 416 360 S 0.0 0.0 0:00 0 /sbin/mingetty tty1
3356 root 21 0 416 416 360 S 0.0 0.0 0:00 0 /sbin/mingetty tty2
3357 root 21 0 416 416 360 S 0.0 0.0 0:00 0 /sbin/mingetty tty3
3358 root 21 0 416 416 360 S 0.0 0.0 0:00 0 /sbin/mingetty tty4
3359 root 21 0 416 416 360 S 0.0 0.0 0:00 0 /sbin/mingetty tty5
3360 root 21 0 412 412 360 S 0.0 0.0 0:00 0 /sbin/mingetty tty6
3361 root 20 0 444 444 384 S 0.0 0.0 0:00 0 /sbin/agetty -L 9600 ttyS0 vt100
3504 postgres 15 0 1700 1700 1344 S 0.0 0.1 0:01 0 /usr/bin/postmaster -p 5432 -D /var/lib/pgsql/data
3513 postgres 15 0 1548 1524 1156 S 0.0 0.1 0:00 0 postgres: stats buffer process
3514 postgres 15 0 1540 1536 1168 S 0.0 0.1 0:00 0 postgres: stats collector process
18362 root 15 0 5980 5776 2760 S 0.0 0.5 0:32 0 cppop - accepting on port 110
21176 cpanel 16 0 2272 2252 1464 S 0.0 0.2 0:06 0 /usr/bin/stunnel-4.04local /usr/local/cpanel/etc/stunnel/my/stunnel.conf
21191 root 15 0 7304 6832 3364 S 0.0 0.6 0:22 0 cpsrvd - waiting for connections
18876 root 15 0 644 628 536 S 0.0 0.0 0:00 0 CROND
18877 root 35 19 4052 4048 1088 S N 0.0 0.3 0:00 0 /usr/bin/perl /scripts/cpbackup
19834 mailnull 15 0 1352 1352 1016 S 0.0 0.1 0:00 0 /usr/sbin/sendmail -FCronDaemon -i -odi -oem root
3336 root 15 0 1960 1788 1520 R 0.0 0.1 0:01 0 sshd: root@pts/1
3464 root 15 0 1404 1352 1152 S 0.0 0.1 0:00 0 -bash
3055 coccsyn 15 0 1616 1576 1256 S 0.0 0.1 0:00 0 pure-ftpd (IDLE)
6162 root 16 0 24548 18M 2084 S 0.0 1.8 0:01 0 spamd child
6502 nyteda1 15 0 1600 1492 1248 S 0.0 0.1 0:00 0 pure-ftpd (IDLE)
8512 root 15 0 23276 15M 2044 S 0.0 1.5 0:00 0 spamd child
8927 root 16 0 23384 14M 1916 S 0.0 1.4 0:00 0 spamd child
9494 root 15 0 23400 13M 1944 S 0.0 1.3 0:00 0 spamd child
Code:
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND root 1 0.0 0.0 1524 460 ? S Jun18 0:06 init [3] root 2 0.0 0.0 0 0 ? SW Jun18 0:02 [keventd] root 3 0.0 0.0 0 0 ? SW Jun18 0:00 [kapmd] root 4 0.0 0.0 0 0 ? SWN Jun18 0:00 [ksoftirqd/0] root 7 0.0 0.0 0 0 ? SW Jun18 0:00 [bdflush] root 5 0.0 0.0 0 0 ? SW Jun18 1:19 [kswapd] root 6 0.2 0.0 0 0 ? SW Jun18 3:59 [kscand] root 8 0.0 0.0 0 0 ? SW Jun18 0:00 [kupdated] root 9 0.0 0.0 0 0 ? SW Jun18 0:00 [mdrecoveryd] root 13 0.0 0.0 0 0 ? DW Jun18 1:10 [kjournald] root 98 0.0 0.0 0 0 ? SW Jun18 0:00 [khubd] root 568 0.0 0.0 0 0 ? SW Jun18 0:00 [kjournald] root 569 0.0 0.0 0 0 ? SW Jun18 1:06 [kjournald] root 1042 0.0 0.0 1576 556 ? D Jun18 0:14 syslogd -m 0 root 1046 0.0 0.0 1520 460 ? S Jun18 0:00 klogd -x named 2400 0.1 0.5 39860 5976 ? S Jun18 3:10 /usr/sbin/named -u named root 2413 0.0 0.0 3656 1020 ? S Jun18 0:00 /usr/sbin/sshd root 3336 0.0 0.1 7044 1788 ? S 09:09 0:01 \_ sshd: root@pts/1 root 3464 0.0 0.1 4272 1352 pts/1 S 09:09 0:00 \_ -bash root 15543 0.0 0.0 2860 864 pts/1 R 16:42 0:00 \_ ps auxf root 2427 0.0 0.0 2140 728 ? S Jun18 0:00 xinetd -stayalive -pidfile /var/run/xinetd.pid root 2498 0.0 0.1 6068 1388 ? S Jun18 0:02 chkservd mailnull 2558 0.0 0.1 6596 1312 ? S Jun18 0:00 /usr/sbin/exim -bd -oX 26 mailnull 12597 0.0 0.0 0 0 ? Z 16:32 0:00 \_ [exim <defunct>] mailnull 2564 0.0 0.1 6624 1344 ? S Jun18 0:05 /usr/sbin/exim -bd -q45m mailnull 14264 0.0 0.1 6632 1628 ? S 16:38 0:00 \_ /usr/sbin/exim -bd -q45m mailnull 15429 0.0 0.1 6632 1628 ? S 16:41 0:00 \_ /usr/sbin/exim -bd -q45m mailnull 2570 0.0 0.1 6592 1216 ? S Jun18 0:00 /usr/sbin/exim -tls-on-connect -bd -oX 465 root 2577 0.0 0.0 2920 980 ? S Jun18 0:12 antirelayd root 2593 0.0 0.2 24388 2328 ? S Jun18 0:02 /usr/bin/spamd -d --allowed-ips=127.0.0.1 --pidfile=/var/run/spamd.pid --max-children=10 --max-conn-per-child=5 root 6162 0.1 1.8 26472 18708 ? S 16:15 0:01 \_ spamd child root 8512 0.0 1.4 25260 15000 ? S 16:22 0:00 \_ spamd child root 8927 0.0 1.7 25440 17728 ? S 16:23 0:00 \_ spamd child jortex 9494 0.0 1.6 25956 17092 ? D 16:25 0:00 \_ spamd child jortex 9588 0.0 1.6 25916 17136 ? D 16:25 0:00 \_ spamd child root 9996 0.0 1.3 25528 13976 ? S 16:26 0:00 \_ spamd child root 10471 0.1 1.1 25648 11652 ? S 16:27 0:01 \_ spamd child root 12421 0.0 1.3 25420 13544 ? S 16:32 0:00 \_ spamd child root 12649 0.0 1.6 25276 17404 ? S 16:32 0:00 \_ spamd child root 12928 0.0 1.6 25140 17428 ? S 16:33 0:00 \_ spamd child root 2611 0.0 2.4 59804 25676 ? S Jun18 0:39 /usr/local/apache/bin/httpd -DSSL nobody 14186 0.0 1.7 59832 18364 ? S 16:38 0:00 \_ /usr/local/apache/bin/httpd -DSSL root 15188 0.0 0.3 6948 3136 ? S 16:40 0:00 \_ /usr/bin/perl /usr/local/cpanel/bin/leechprotect nobody 15189 0.5 2.8 61476 29716 ? S 16:40 0:00 \_ /usr/local/apache/bin/httpd -DSSL nobody 15190 0.3 3.0 60840 31172 ? S 16:40 0:00 \_ /usr/local/apache/bin/httpd -DSSL nobody 15191 0.3 2.7 60536 27824 ? S 16:40 0:00 \_ /usr/local/apache/bin/httpd -DSSL nobody 15192 0.7 3.3 64000 34856 ? S 16:40 0:00 \_ /usr/local/apache/bin/httpd -DSSL nobody 15193 0.4 3.1 61100 32120 ? S 16:40 0:00 \_ /usr/local/apache/bin/httpd -DSSL nobody 15196 0.6 2.9 61696 30592 ? S 16:40 0:00 \_ /usr/local/apache/bin/httpd -DSSL nobody 15201 0.5 3.4 61644 35932 ? D 16:40 0:00 \_ /usr/local/apache/bin/httpd -DSSL nobody 15202 0.2 2.7 61344 28740 ? S 16:40 0:00 \_ /usr/local/apache/bin/httpd -DSSL nobody 15206 0.5 2.9 61364 30420 ? S 16:40 0:00 \_ /usr/local/apache/bin/httpd -DSSL nobody 15209 0.5 2.8 61668 29404 ? S 16:40 0:00 \_ /usr/local/apache/bin/httpd -DSSL nobody 15212 0.4 3.2 61356 33832 ? S 16:40 0:00 \_ /usr/local/apache/bin/httpd -DSSL nobody 15215 0.4 2.8 60608 29444 ? S 16:40 0:00 \_ /usr/local/apache/bin/httpd -DSSL nobody 15221 0.3 3.0 60760 31576 ? S 16:40 0:00 \_ /usr/local/apache/bin/httpd -DSSL nobody 15242 0.6 2.9 60804 30168 ? S 16:40 0:00 \_ /usr/local/apache/bin/httpd -DSSL nobody 15296 0.3 2.8 60716 28812 ? S 16:41 0:00 \_ /usr/local/apache/bin/httpd -DSSL nobody 15374 0.1 2.6 60140 27160 ? S 16:41 0:00 \_ /usr/local/apache/bin/httpd -DSSL root 2634 0.0 0.0 1596 628 ? S Jun18 0:01 crond root 18876 0.0 0.0 1600 628 ? S 01:00 0:00 \_ CROND root 18877 0.0 0.3 5764 4048 ? SN 01:00 0:00 \_ /usr/bin/perl /scripts/cpbackup root 14366 0.0 0.0 1488 388 ? SN 16:39 0:00 | \_ /usr/local/cpanel/bin/cpuwatch 11.0 /scripts/pkgacct rodneyf /backup/cpbackup/daily backup root 14367 0.0 0.2 3928 2580 ? TN 16:39 0:00 | \_ pkgacct - rodneyf root 14440 0.6 0.3 4976 3632 ? DN 16:39 0:01 | \_ pkgacct - rodneyf mailnull 19834 0.0 0.1 6644 1352 ? S 01:00 0:00 \_ /usr/sbin/sendmail -FCronDaemon -i -odi -oem root daemon 2680 0.0 0.0 1576 552 ? S Jun18 0:00 /usr/sbin/atd root 2941 0.3 1.2 16420 13144 ? SN Jun18 4:48 cpanellogd - sleeping for logs root 3105 0.0 0.1 6056 1388 ? S Jun18 0:00 pure-ftpd (SERVER) coccsyn 3055 0.0 0.1 7180 1576 ? S 16:07 0:00 \_ pure-ftpd (IDLE) nyteda1 6502 0.0 0.1 7180 1520 ? S 16:17 0:00 \_ pure-ftpd (IDLE) coccsyn 10876 0.0 0.1 7180 1456 ? S 16:29 0:00 \_ pure-ftpd (IDLE) coccsyn 10877 0.0 0.1 7180 1452 ? S 16:29 0:00 \_ pure-ftpd (IDLE) coccsyn 11990 0.0 0.1 7180 1524 ? S 16:30 0:00 \_ pure-ftpd (IDLE) coccsyn 11994 0.0 0.1 7180 1592 ? S 16:30 0:00 \_ pure-ftpd (IDLE) coccsyn 13487 0.0 0.1 7180 1628 ? S 16:35 0:00 \_ pure-ftpd (UPLOAD) coccsyn 14134 0.0 0.1 7180 1596 ? S 16:38 0:00 \_ pure-ftpd (UPLOAD) root 3109 0.0 0.0 5584 968 ? S Jun18 0:00 /usr/sbin/pure-authd -s /var/run/ftpd.sock -r /usr/sbin/pureauth mailman 3115 0.0 0.4 7212 4392 ? S Jun18 0:00 /usr/bin/python2 /usr/local/cpanel/3rdparty/mailman/bin/mailmanctl -s start mailman 3125 0.0 0.4 7176 4400 ? S Jun18 0:00 \_ /usr/bin/python2 /usr/local/cpanel/3rdparty/mailman/bin/qrunner --runner=ArchRunner:0:1 -s mailman 3126 0.0 0.5 8292 5504 ? S Jun18 0:01 \_ /usr/bin/python2 /usr/local/cpanel/3rdparty/mailman/bin/qrunner --runner=BounceRunner:0:1 -s mailman 3127 0.0 0.5 8304 5224 ? S Jun18 0:01 \_ /usr/bin/python2 /usr/local/cpanel/3rdparty/mailman/bin/qrunner --runner=CommandRunner:0:1 -s mailman 3128 0.0 0.5 8416 5380 ? S Jun18 0:01 \_ /usr/bin/python2 /usr/local/cpanel/3rdparty/mailman/bin/qrunner --runner=IncomingRunner:0:1 -s mailman 3129 0.0 0.4 7220 4436 ? S Jun18 0:01 \_ /usr/bin/python2 /usr/local/cpanel/3rdparty/mailman/bin/qrunner --runner=NewsRunner:0:1 -s mailman 3130 0.0 0.5 8596 5928 ? S Jun18 0:02 \_ /usr/bin/python2 /usr/local/cpanel/3rdparty/mailman/bin/qrunner --runner=OutgoingRunner:0:1 -s mailman 3131 0.0 0.5 8492 5728 ? S Jun18 0:01 \_ /usr/bin/python2 /usr/local/cpanel/3rdparty/mailman/bin/qrunner --runner=VirginRunner:0:1 -s mailman 3132 0.0 0.4 7176 4400 ? S Jun18 0:00 \_ /usr/bin/python2 /usr/local/cpanel/3rdparty/mailman/bin/qrunner --runner=RetryRunner:0:1 -s root 3123 0.0 0.0 3552 552 ? S Jun18 0:00 rhnsd --interval 240 root 3161 0.0 0.0 0 0 ? SW Jun18 0:06 [loop0] root 3163 0.0 0.0 0 0 ? SW Jun18 0:03 [kjournald] root 3314 0.0 0.0 1580 408 ? S Jun18 0:00 mdadm --monitor --scan -f root 3355 0.0 0.0 1504 416 tty1 S Jun18 0:00 /sbin/mingetty tty1 root 3356 0.0 0.0 1504 416 tty2 S Jun18 0:00 /sbin/mingetty tty2 root 3357 0.0 0.0 1504 416 tty3 S Jun18 0:00 /sbin/mingetty tty3 root 3358 0.0 0.0 1504 416 tty4 S Jun18 0:00 /sbin/mingetty tty4 root 3359 0.0 0.0 1504 416 tty5 S Jun18 0:00 /sbin/mingetty tty5 root 3360 0.0 0.0 1504 412 tty6 S Jun18 0:00 /sbin/mingetty tty6 root 3361 0.0 0.0 1516 444 ttyS0 S Jun18 0:00 /sbin/agetty -L 9600 ttyS0 vt100 postgres 3504 0.0 0.1 9592 1700 ? S Jun18 0:01 /usr/bin/postmaster -p 5432 -D /var/lib/pgsql/data postgres 3513 0.0 0.1 9152 1524 ? S Jun18 0:00 \_ postgres: stats buffer process postgres 3514 0.0 0.1 8160 1536 ? S Jun18 0:00 \_ postgres: stats collector process root 18362 0.0 0.5 10236 5792 ? S Jun18 0:32 cppop - accepting on port 110 discount 15507 0.6 0.6 10252 6316 ? S 16:42 0:00 \_ cppop - serving 68.215.16.96 - UPDATE - info@discountfloridabroker.com stephan 15515 0.8 0.6 10252 6300 ? S 16:42 0:00 \_ cppop - serving 64.164.37.176 - AUTHORIZATION root 15542 0.0 0.6 10248 6248 ? S 16:42 0:00 \_ cppop - serving 24.79.94.25 - AUTHORIZATION cpanel 21176 0.0 0.2 35708 2248 ? S Jun18 0:06 /usr/bin/stunnel-4.04local /usr/local/cpanel/etc/stunnel/my/stunnel.conf root 21191 0.0 0.6 9552 6844 ? S Jun18 0:22 cpsrvd - waiting for connections root 13129 0.0 0.1 4252 1188 pts/1 S 16:34 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/alpha.myservst.com.pid mysql 13163 0.0 1.9 178928 20420 pts/1 S 16:34 0:00 \_ /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/alpha.myservst.com.p mysql 13170 0.0 1.9 178928 20420 pts/1 S 16:34 0:00 \_ /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/alpha.myservst.c mysql 13171 0.0 1.9 178928 20420 pts/1 S 16:34 0:00 \_ /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/alpha.myserv mysql 13193 1.3 1.9 178928 20420 pts/1 S 16:34 0:06 \_ /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/alpha.myserv mysql 13194 1.2 1.9 178928 20420 pts/1 S 16:34 0:05 \_ /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/alpha.myserv mysql 13196 0.7 1.9 178928 20420 pts/1 S 16:34 0:03 \_ /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/alpha.myserv mysql 13198 0.3 1.9 178928 20420 pts/1 S 16:34 0:01 \_ /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/alpha.myserv mysql 13215 0.6 1.9 178928 20420 pts/1 S 16:34 0:03 \_ /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/alpha.myserv mysql 13218 0.5 1.9 178928 20420 pts/1 S 16:34 0:02 \_ /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/alpha.myserv mysql 13219 0.7 1.9 178928 20420 pts/1 S 16:34 0:03 \_ /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/alpha.myserv mysql 13226 0.8 1.9 178928 20420 pts/1 S 16:34 0:04 \_ /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/alpha.myserv mysql 13227 1.3 1.9 178928 20420 pts/1 S 16:34 0:05 \_ /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/alpha.myserv mysql 13228 1.3 1.9 178928 20420 pts/1 D 16:34 0:06 \_ /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/alpha.myserv mysql 13233 1.6 1.9 178928 20420 pts/1 S 16:34 0:07 \_ /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/alpha.myserv mysql 13238 0.7 1.9 178928 20420 pts/1 S 16:34 0:03 \_ /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/alpha.myserv mysql 13247 1.5 1.9 178928 20420 pts/1 S 16:34 0:07 \_ /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/alpha.myserv mysql 13248 1.1 1.9 178928 20420 pts/1 S 16:34 0:05 \_ /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/alpha.myserv mysql 13250 0.7 1.9 178928 20420 pts/1 S 16:34 0:03 \_ /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/alpha.myserv mysql 13252 0.6 1.9 178928 20420 pts/1 S 16:34 0:02 \_ /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/alpha.myserv mysql 13253 0.2 1.9 178928 20420 pts/1 S 16:34 0:01 \_ /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/alpha.myserv mysql 13254 0.7 1.9 178928 20420 pts/1 S 16:34 0:03 \_ /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/alpha.myserv mysql 13257 0.9 1.9 178928 20420 pts/1 S 16:34 0:04 \_ /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/alpha.myserv root 15376 0.1 0.3 7412 3836 ? S 16:41 0:00 /usr/sbin/exim -Mc 1Dk6ba-0003zr-9J jortex 15380 0.0 0.3 7412 3844 ? S 16:41 0:00 \_ /usr/sbin/exim -Mc 1Dk6ba-0003zr-9J mailnull 15381 0.0 0.1 6620 1896 ? S 16:41 0:00 \_ /usr/sbin/sendmail -bS jortex 15382 0.0 0.3 7412 3840 ? S 16:41 0:00 \_ /usr/sbin/exim -Mc 1Dk6ba-0003zr-9J jortex 15383 0.0 0.0 2104 560 ? S 16:41 0:00 \_ /usr/bin/spamc jortex 15384 0.0 0.0 0 0 ? Z 16:41 0:00 \_ [exim <defunct>] root 15412 0.2 0.3 7432 3820 ? S 16:41 0:00 /usr/sbin/exim -Mc 1Dk6br-00040V-GT jortex 15416 0.0 0.3 7432 3832 ? S 16:41 0:00 \_ /usr/sbin/exim -Mc 1Dk6br-00040V-GT mailnull 15417 0.0 0.1 6620 1896 ? S 16:41 0:00 \_ /usr/sbin/sendmail -bS jortex 15418 0.0 0.3 7432 3828 ? S 16:41 0:00 \_ /usr/sbin/exim -Mc 1Dk6br-00040V-GT jortex 15419 0.0 0.0 2104 564 ? S 16:41 0:00 \_ /usr/bin/spamc jortex 15420 0.0 0.0 0 0 ? Z 16:41 0:00 \_ [exim <defunct>]
Code:
total used free shared buffers cached Mem: 1003 940 62 0 101 528 -/+ buffers/cache: 310 692 Swap: 2000 87 1912
Code:
[mysqld] datadir=/var/lib/mysql # skip-locking skip-innodb query_cache_limit=1M query_cache_size=32M query_cache_type=1 max_connections=500 interactive_timeout=60 wait_timeout=5 connect_timeout=5 thread_cache_size=100 key_buffer=128M join_buffer=1M max_allowed_packet=16M table_cache=1024 record_buffer=1M sort_buffer_size=1M read_buffer_size=1M read_rnd_buffer_size=768K 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 #log-long-format #log_slow_queries=/var/log/slow-queries.log #long_query_time=2 [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 [myisamchk] key_buffer=64M sort_buffer=64M read_buffer=16M write_buffer=16M [mysqlhotcopy] interactive-timeout
