derbyi
Sat 19th Nov '05, 2:50pm
1)dedicated only this site on server
2)my server is
p4 2.8 HTT with 2GB ram Processor #1 Vendor: GenuineIntel
Processor #1 Name: Intel(R) Pentium(R) 4 CPU 2.80GHz
Processor #1 speed: 2793.203 MHz
Processor #1 cache size: 512 KB
Processor #2 Vendor: GenuineIntel
Processor #2 Name: Intel(R) Pentium(R) 4 CPU 2.80GHz
Processor #2 speed: 2793.203 MHz
Processor #2 cache size: 512 KB
3)mysql is version 4.0.25 with no innodb
4) i use cpanel it install mysql itself
5) top results
20:38:45 up 11 days, 3:10, 1 user, load average: 7.47, 5.85, 6.04
263 processes: 250 sleeping, 13 running, 0 zombie, 0 stopped
CPU0 states: 85.2% user 14.2% system 0.0% nice 0.0% iowait 0.1% idle
CPU1 states: 88.2% user 11.1% system 0.0% nice 0.0% iowait 0.1% idle
Mem: 2047480k av, 2035488k used, 11992k free, 0k shrd, 37604k buff
1265472k actv, 143672k in_d, 46368k in_c
Swap: 2040244k av, 418708k used, 1621536k free 1007456k cached
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
16421 root 15 0 2164 124 76 S 99.9 0.0 152:14 1 httpd
32226 mysql 15 0 146M 142M 1284 S 32.6 7.1 5:45 0 mysqld
30277 squid 25 0 71632 67M 744 R 7.8 3.3 1561m 0 squid
5521 root 16 0 1232 1232 852 R 0.7 0.0 0:00 0 top
1 root 15 0 100 76 56 S 0.0 0.0 0:14 1 init
2 root RT 0 0 0 0 SW 0.0 0.0 0:00 0 migration/0
3 root RT 0 0 0 0 SW 0.0 0.0 0:00 1 migration/1
4 root 15 0 0 0 0 SW 0.0 0.0 0:08 0 keventd
5 root 34 19 0 0 0 SWN 0.0 0.0 0:02 0 ksoftirqd_CPU0
6 root 34 19 0 0 0 SWN 0.0 0.0 0:00 1 ksoftirqd_CPU1
11 root 25 0 0 0 0 SW 0.0 0.0 0:00 0 bdflush
7 root 15 0 0 0 0 SW 0.0 0.0 6:11 1 kswapd
8 root 15 0 0 0 0 SW 0.0 0.0 0:05 0 kscand/DMA
9 root 16 0 0 0 0 SW 0.0 0.0 27:14 1 kscand/Normal
10 root 16 0 0 0 0 SW 0.0 0.0 79:47 1 kscand/HighMem
12 root 15 0 0 0 0 SW 0.0 0.0 0:23 1 kupdated
13 root 23 0 0 0 0 SW 0.0 0.0 0:00 0 mdrecoveryd
17 root 15 0 0 0 0 SW 0.0 0.0 6:50 1 kjournald
642 root 15 0 0 0 0 SW 0.0 0.0 0:00 1 kjournald
1033 root 15 0 248 216 152 S 0.0 0.0 1:38 1 syslogd
1037 root 15 0 184 172 120 S 0.0 0.0 0:13 1 klogd
2200 named 25 0 964 516 260 S 0.0 0.0 0:03 0 named
2228 root 25 0 148 4 0 S 0.0 0.0 0:00 1 xinetd
2246 root 18 0 7080 1272 652 S 0.0 0.0 0:12 0 chkservd
2328 root 15 0 176 152 88 S 0.0 0.0 0:03 0 crond
2684 root 34 19 7960 880 340 S N 0.0 0.0 0:11 1 cpanellogd
2756 root 24 0 136 4 0 S 0.0 0.0 0:00 0 S99radyo
2765 root 15 0 1792 436 192 S 0.0 0.0 63:08 0 sc_serv
2965 root 15 0 4240 4 0 S 0.0 0.0 0:00 1 cppop
5492 nobody 15 0 724 248 144 S 0.0 0.0 0:05 1 proftpd
30275 root 15 0 320 4 0 S 0.0 0.0 0:00 1 squid
30279 squid 15 0 80 72 48 S 0.0 0.0 0:08 1 unlinkd
18903 root 21 0 52 4 0 S 0.0 0.0 0:00 1 mingetty
18904 root 21 0 52 4 0 S 0.0 0.0 0:00 0 mingetty
18905 root 21 0 52 4 0 S 0.0 0.0 0:00 1 mingetty
18906 root 21 0 52 4 0 S 0.0 0.0 0:00 1 mingetty
18907 root 21 0 52 4 0 S 0.0 0.0 0:00 0 mingetty
18908 root 21 0 52 4 0 S 0.0 0.0 0:00 1 mingetty
32205 root 15 0 3412 752 312 S 0.0 0.0 0:07 0 miniserv.pl
ps axu results
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
root 1 0.0 0.0 1296 76 ? S Nov08 0:14 init [3] --init
root 2 0.0 0.0 0 0 ? SW Nov08 0:00 [migration/0]
root 3 0.0 0.0 0 0 ? SW Nov08 0:00 [migration/1]
root 4 0.0 0.0 0 0 ? SW Nov08 0:08 [keventd]
root 5 0.0 0.0 0 0 ? SWN Nov08 0:02 [ksoftirqd_CPU0]
root 6 0.0 0.0 0 0 ? SWN Nov08 0:00 [ksoftirqd_CPU1]
root 11 0.0 0.0 0 0 ? SW Nov08 0:00 [bdflush]
root 7 0.0 0.0 0 0 ? SW Nov08 6:11 [kswapd]
root 8 0.0 0.0 0 0 ? SW Nov08 0:05 [kscand/DMA]
root 9 0.1 0.0 0 0 ? SW Nov08 27:14 [kscand/Normal]
root 10 0.4 0.0 0 0 ? SW Nov08 79:47 [kscand/HighMem]
root 12 0.0 0.0 0 0 ? SW Nov08 0:23 [kupdated]
root 13 0.0 0.0 0 0 ? SW Nov08 0:00 [mdrecoveryd]
root 17 0.0 0.0 0 0 ? SW Nov08 6:50 [kjournald]
root 642 0.0 0.0 0 0 ? SW Nov08 0:00 [kjournald]
root 1033 0.0 0.0 1468 216 ? S Nov08 1:38 syslogd -m 0
root 1037 0.0 0.0 1384 172 ? S Nov08 0:13 klogd -x
named 2200 0.0 0.0 39040 516 ? S Nov08 0:03 /usr/sbin/named -u named
root 2228 0.0 0.0 2068 4 ? S Nov08 0:00 xinetd -stayalive -pidfile /var/run/xinetd.pid
root 2246 0.0 0.0 11272 1272 ? S Nov08 0:12 chkservd
root 2328 0.0 0.0 1452 152 ? S Nov08 0:03 crond
root 2684 0.0 0.0 11068 880 ? SN Nov08 0:11 cpanellogd - sleeping for logs
root 2756 0.0 0.0 4176 4 ? S Nov08 0:00 /bin/sh /etc/rc3.d/S99radyo start
root 2765 0.3 0.0 29684 436 ? S Nov08 63:08 ./sc_serv
root 2965 0.0 0.0 9948 4 ? S Nov08 0:00 cppop - accepting on port 110
nobody 5492 0.0 0.0 4324 248 ? S Nov11 0:05 proftpd: (accepting connections)
root 30275 0.0 0.0 5888 4 ? S Nov12 0:00 squid -D
squid 30277 13.8 3.3 75660 68640 ? R Nov12 1561:09 (squid) -D
squid 30279 0.0 0.0 1344 72 ? S Nov12 0:08 (unlinkd)
root 18903 0.0 0.0 1360 4 tty1 S Nov12 0:00 /sbin/mingetty tty1
root 18904 0.0 0.0 1360 4 tty2 S Nov12 0:00 /sbin/mingetty tty2
root 18905 0.0 0.0 1360 4 tty3 S Nov12 0:00 /sbin/mingetty tty3
root 18906 0.0 0.0 1360 4 tty4 S Nov12 0:00 /sbin/mingetty tty4
root 18907 0.0 0.0 1360 4 tty5 S Nov12 0:00 /sbin/mingetty tty5
root 18908 0.0 0.0 1360 4 tty6 S Nov12 0:00 /sbin/mingetty tty6
root 32205 0.0 0.0 7820 752 ? S Nov13 0:07 /usr/bin/perl /usr/libexec/webmin/miniserv.pl /etc/webmin/miniserv.co
root 21397 0.0 0.0 3448 4 ? S Nov15 0:00 /usr/sbin/sshd
cpanel 21650 0.0 0.0 3772 4 ? S Nov15 0:00 /usr/bin/stunnel-4.04local /usr/local/cpanel/etc/stunnel/default/stun
root 21672 0.0 0.0 11460 1448 ? S Nov15 0:01 cpsrvd - waiting for connections
root 31818 0.0 0.0 6824 324 ? S 16:49 0:01 /usr/sbin/sshd
root 31996 0.0 0.0 5160 668 pts/0 S 16:50 0:00 -bash
root 32194 0.0 0.0 4996 4 pts/0 S 16:53 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var
mysql 32226 21.5 7.1 242664 145376 pts/0 S 16:53 5:26 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --
root 16421 0.0 0.0 45360 124 ? S 18:30 0:01 /usr/local/apache/bin/httpd
nobody 16427 1.0 0.4 48200 8520 ? S 18:30 1:18 /usr/local/apache/bin/httpd
nobody 16428 1.0 0.4 48400 9412 ? S 18:30 1:17 /usr/local/apache/bin/httpd
nobody 16429 0.9 0.3 47996 7260 ? S 18:30 1:13 /usr/local/apache/bin/httpd
nobody 16430 1.4 0.4 48176 8480 ? S 18:30 1:50 /usr/local/apache/bin/httpd
nobody 16431 1.0 0.4 48524 8856 ? S 18:30 1:21 /usr/local/apache/bin/httpd
nobody 16432 1.0 0.4 48456 8720 ? S 18:30 1:17 /usr/local/apache/bin/httpd
nobody 16433 0.9 0.4 48780 9616 ? R 18:30 1:16 /usr/local/apache/bin/httpd
nobody 16434 1.0 0.4 48268 8572 ? S 18:30 1:18 /usr/local/apache/bin/httpd
nobody 16435 1.0 0.3 48088 8164 ? S 18:30 1:20 /usr/local/apache/bin/httpd
nobody 16436 0.9 0.4 47992 8236 ? S 18:30 1:16 /usr/local/apache/bin/httpd
nobody 16437 0.9 0.4 48060 8468 ? S 18:30 1:12 /usr/local/apache/bin/httpd
nobody 16438 0.9 0.3 48340 7768 ? S 18:30 1:16 /usr/local/apache/bin/httpd
nobody 16439 0.9 0.4 48156 8836 ? S 18:30 1:15 /usr/local/apache/bin/httpd
nobody 16440 0.9 0.4 48492 9412 ? R 18:30 1:16 /usr/local/apache/bin/httpd
nobody 16441 1.0 0.4 48080 8604 ? S 18:30 1:17 /usr/local/apache/bin/httpd
nobody 16442 1.0 0.4 48536 9016 ? S 18:30 1:19 /usr/local/apache/bin/httpd
nobody 16443 1.0 0.4 47900 8432 ? S 18:30 1:17 /usr/local/apache/bin/httpd
nobody 16444 0.9 0.4 48144 8276 ? S 18:30 1:12 /usr/local/apache/bin/httpd
nobody 16445 0.9 0.4 48152 8828 ? S 18:30 1:15 /usr/local/apache/bin/httpd
nobody 16446 1.0 0.3 48040 7984 ? S 18:30 1:17 /usr/local/apache/bin/httpd
nobody 16447 1.0 0.4 48432 8576 ? S 18:30 1:17 /usr/local/apache/bin/httpd
nobody 16448 1.6 0.4 48204 8540 ? S 18:30 2:03 /usr/local/apache/bin/httpd
nobody 16449 0.9 0.4 48240 8668 ? S 18:30 1:12 /usr/local/apache/bin/httpd
nobody 16450 0.9 0.4 48160 8780 ? S 18:30 1:16 /usr/local/apache/bin/httpd
nobody 16451 1.0 0.4 48372 8644 ? S 18:30 1:19 /usr/local/apache/bin/httpd
nobody 16452 0.9 0.4 48460 8664 ? S 18:30 1:13 /usr/local/apache/bin/httpd
nobody 16453 1.0 0.4 48116 8524 ? S 18:30 1:19 /usr/local/apache/bin/httpd
nobody 16454 1.0 0.4 48156 8832 ? S 18:30 1:17 /usr/local/apache/bin/httpd
nobody 16455 1.0 0.4 48372 8832 ? S 18:30 1:18 /usr/local/apache/bin/httpd
nobody 16456 1.0 0.4 48200 8636 ? S 18:30 1:19 /usr/local/apache/bin/httpd
nobody 16457 0.9 0.4 48244 8628 ? S 18:30 1:14 /usr/local/apache/bin/httpd
nobody 16458 0.9 0.4 48420 9132 ? S 18:30 1:15 /usr/local/apache/bin/httpd
nobody 16459 1.0 0.4 48360 9124 ? S 18:30 1:23 /usr/local/apache/bin/httpd
nobody 16460 1.4 0.4 47960 8776 ? S 18:30 1:48 /usr/local/apache/bin/httpd
nobody 16462 0.9 0.4 48156 8852 ? S 18:30 1:15 /usr/local/apache/bin/httpd
nobody 16463 0.9 0.4 48160 8900 ? S 18:30 1:14 /usr/local/apache/bin/httpd
nobody 16464 0.9 0.3 47832 8020 ? S 18:30 1:15 /usr/local/apache/bin/httpd
nobody 16466 0.9 0.4 48504 8988 ? S 18:30 1:14 /usr/local/apache/bin/httpd
nobody 16468 0.9 0.4 48260 9280 ? S 18:30 1:13 /usr/local/apache/bin/httpd
nobody 16469 0.9 0.4 48068 8816 ? S 18:30 1:11 /usr/local/apache/bin/httpd
nobody 16472 0.9 0.4 48004 8692 ? S 18:30 1:16 /usr/local/apache/bin/httpd
nobody 16473 1.0 0.4 48368 8576 ? S 18:30 1:18 /usr/local/apache/bin/httpd
nobody 16474 1.0 0.4 47976 8196 ? S 18:30 1:18 /usr/local/apache/bin/httpd
nobody 16475 1.0 0.4 48136 9132 ? S 18:30 1:19 /usr/local/apache/bin/httpd
nobody 16478 0.9 0.4 48124 8624 ? S 18:30 1:16 /usr/local/apache/bin/httpd
nobody 16480 0.9 0.3 47956 8048 ? S 18:30 1:12 /usr/local/apache/bin/httpd
nobody 16487 0.9 0.3 48236 8036 ? S 18:30 1:15 /usr/local/apache/bin/httpd
nobody 16488 1.0 0.4 48160 9028 ? S 18:30 1:19 /usr/local/apache/bin/httpd
nobody 16489 0.9 0.3 48100 8016 ? S 18:30 1:14 /usr/local/apache/bin/httpd
nobody 16491 0.9 0.4 48312 8536 ? S 18:30 1:12 /usr/local/apache/bin/httpd
nobody 16493 0.9 0.4 48260 8584 ? S 18:30 1:14 /usr/local/apache/bin/httpd
nobody 16494 0.9 0.4 48828 8900 ? S 18:30 1:12 /usr/local/apache/bin/httpd
nobody 16496 1.0 0.4 48240 9172 ? S 18:30 1:18 /usr/local/apache/bin/httpd
nobody 16497 1.0 0.4 48476 8848 ? S 18:30 1:17 /usr/local/apache/bin/httpd
nobody 16499 1.2 0.4 48288 8388 ? S 18:30 1:39 /usr/local/apache/bin/httpd
nobody 16500 1.0 0.4 47956 8800 ? S 18:30 1:17 /usr/local/apache/bin/httpd
nobody 16502 1.0 0.4 48548 9144 ? S 18:30 1:17 /usr/local/apache/bin/httpd
nobody 16503 0.9 0.3 48008 7256 ? S 18:30 1:15 /usr/local/apache/bin/httpd
nobody 16504 0.9 0.4 48264 8788 ? S 18:30 1:13 /usr/local/apache/bin/httpd
nobody 16505 0.9 0.3 47916 7676 ? S 18:30 1:16 /usr/local/apache/bin/httpd
nobody 16509 0.9 0.4 48324 8696 ? S 18:30 1:15 /usr/local/apache/bin/httpd
nobody 16511 0.9 0.4 48284 9556 ? S 18:30 1:12 /usr/local/apache/bin/httpd
nobody 16513 0.9 0.4 48196 8384 ? S 18:30 1:12 /usr/local/apache/bin/httpd
nobody 16514 0.9 0.4 47928 8308 ? S 18:30 1:15 /usr/local/apache/bin/httpd
nobody 16518 0.9 0.4 48172 9068 ? S 18:30 1:16 /usr/local/apache/bin/httpd
nobody 16520 1.0 0.4 48008 8288 ? S 18:30 1:19 /usr/local/apache/bin/httpd
nobody 16521 1.0 0.4 48200 8868 ? S 18:30 1:17 /usr/local/apache/bin/httpd
nobody 16523 1.4 0.4 48028 8648 ? S 18:30 1:52 /usr/local/apache/bin/httpd
nobody 16524 1.0 0.4 48228 8436 ? S 18:30 1:19 /usr/local/apache/bin/httpd
nobody 16525 0.9 0.4 48296 8352 ? S 18:30 1:16 /usr/local/apache/bin/httpd
nobody 16526 0.9 0.4 48352 8740 ? S 18:30 1:16 /usr/local/apache/bin/httpd
nobody 16530 1.0 0.4 48444 8624 ? S 18:30 1:20 /usr/local/apache/bin/httpd
nobody 16531 0.9 0.4 48268 8340 ? S 18:30 1:12 /usr/local/apache/bin/httpd
nobody 16532 0.9 0.3 47972 7420 ? S 18:30 1:16 /usr/local/apache/bin/httpd
nobody 16533 0.9 0.4 48264 8760 ? S 18:30 1:16 /usr/local/apache/bin/httpd
nobody 16539 0.9 0.4 48068 9004 ? S 18:30 1:09 /usr/local/apache/bin/httpd
nobody 16540 1.5 0.5 49328 10748 ? S 18:30 1:55 /usr/local/apache/bin/httpd
nobody 16541 0.9 0.4 48524 9528 ? S 18:30 1:13 /usr/local/apache/bin/httpd
nobody 16544 1.0 0.4 48220 9452 ? S 18:30 1:18 /usr/local/apache/bin/httpd
nobody 16545 1.3 0.4 48116 8196 ? S 18:30 1:40 /usr/local/apache/bin/httpd
nobody 16546 1.0 0.4 49260 9976 ? S 18:30 1:17 /usr/local/apache/bin/httpd
nobody 16547 0.9 0.4 48132 8776 ? S 18:30 1:14 /usr/local/apache/bin/httpd
nobody 16548 1.0 0.4 47976 8604 ? S 18:30 1:21 /usr/local/apache/bin/httpd
nobody 16549 0.9 0.3 48004 8116 ? S 18:30 1:14 /usr/local/apache/bin/httpd
nobody 16550 1.0 0.4 47992 8212 ? S 18:30 1:20 /usr/local/apache/bin/httpd
nobody 16551 1.0 0.3 47904 8064 ? S 18:30 1:17 /usr/local/apache/bin/httpd
nobody 16552 1.3 0.5 51504 11816 ? R 18:30 1:47 /usr/local/apache/bin/httpd
nobody 16553 1.1 0.4 48132 8600 ? S 18:30 1:31 /usr/local/apache/bin/httpd
nobody 16554 0.9 0.3 48084 8060 ? S 18:30 1:15 /usr/local/apache/bin/httpd
nobody 16555 0.9 0.4 48168 8892 ? S 18:30 1:15 /usr/local/apache/bin/httpd
nobody 16556 0.9 0.4 48232 8288 ? S 18:30 1:14 /usr/local/apache/bin/httpd
nobody 16557 0.9 0.7 55040 15524 ? S 18:30 1:12 /usr/local/apache/bin/httpd
nobody 16558 1.0 0.4 48332 9284 ? S 18:30 1:19 /usr/local/apache/bin/httpd
nobody 16559 0.9 0.4 48272 8556 ? S 18:30 1:15 /usr/local/apache/bin/httpd
nobody 16560 1.2 0.4 48312 9156 ? S 18:30 1:39 /usr/local/apache/bin/httpd
nobody 16561 0.9 0.5 50192 10808 ? S 18:30 1:14 /usr/local/apache/bin/httpd
nobody 16562 1.0 0.4 48108 8620 ? S 18:30 1:18 /usr/local/apache/bin/httpd
nobody 16563 0.9 0.4 48320 8536 ? S 18:30 1:16 /usr/local/apache/bin/httpd
nobody 16564 0.9 0.4 48092 8376 ? S 18:30 1:16 /usr/local/apache/bin/httpd
nobody 16565 1.0 0.3 48092 7728 ? S 18:30 1:22 /usr/local/apache/bin/httpd
nobody 16566 1.4 0.4 48348 8768 ? S 18:30 1:50 /usr/local/apache/bin/httpd
nobody 16567 0.9 0.3 48012 8176 ? S 18:30 1:15 /usr/local/apache/bin/httpd
nobody 16568 1.1 0.3 48168 8156 ? S 18:30 1:28 /usr/local/apache/bin/httpd
nobody 16569 0.9 0.4 48380 9048 ? S 18:30 1:13 /usr/local/apache/bin/httpd
nobody 16570 0.9 0.4 48500 8548 ? S 18:30 1:15 /usr/local/apache/bin/httpd
nobody 16571 1.0 0.4 48180 8892 ? S 18:30 1:17 /usr/local/apache/bin/httpd
nobody 16572 0.9 0.4 48076 8720 ? S 18:30 1:11 /usr/local/apache/bin/httpd
nobody 16573 1.0 0.5 49940 10616 ? S 18:30 1:17 /usr/local/apache/bin/httpd
nobody 16574 0.9 0.4 48076 8656 ? S 18:30 1:13 /usr/local/apache/bin/httpd
nobody 16576 0.9 0.4 48164 8292 ? S 18:30 1:15 /usr/local/apache/bin/httpd
nobody 16577 0.9 0.4 48092 8628 ? S 18:30 1:12 /usr/local/apache/bin/httpd
nobody 16580 1.0 0.4 48328 9144 ? S 18:31 1:17 /usr/local/apache/bin/httpd
nobody 27147 1.0 0.4 48252 8652 ? S 19:37 0:39 /usr/local/apache/bin/httpd
nobody 27148 1.2 0.3 47916 7852 ? S 19:37 0:46 /usr/local/apache/bin/httpd
nobody 27149 0.9 0.3 47992 8188 ? S 19:37 0:36 /usr/local/apache/bin/httpd
nobody 27154 0.9 0.4 48248 8664 ? S 19:38 0:36 /usr/local/apache/bin/httpd
nobody 27159 0.9 0.3 47932 7868 ? S 19:38 0:36 /usr/local/apache/bin/httpd
nobody 27160 0.9 0.4 47800 8244 ? S 19:38 0:34 /usr/local/apache/bin/httpd
nobody 3975 0.8 0.3 47752 8012 ? S 20:29 0:05 /usr/local/apache/bin/httpd
nobody 3976 1.2 0.4 48468 8756 ? S 20:29 0:07 /usr/local/apache/bin/httpd
nobody 3977 0.9 0.3 47856 7548 ? S 20:29 0:05 /usr/local/apache/bin/httpd
nobody 3978 1.0 0.3 47936 7684 ? S 20:29 0:05 /usr/local/apache/bin/httpd
nobody 3982 1.2 0.3 47712 7888 ? S 20:29 0:07 /usr/local/apache/bin/httpd
nobody 3983 1.0 0.3 47796 7752 ? S 20:29 0:05 /usr/local/apache/bin/httpd
nobody 5485 1.0 0.3 47652 6576 ? S 20:37 0:01 /usr/local/apache/bin/httpd
nobody 5494 0.9 0.3 47520 7088 ? R 20:37 0:01 /usr/local/apache/bin/httpd
nobody 5495 0.8 0.3 47660 7392 ? S 20:37 0:00 /usr/local/apache/bin/httpd
nobody 5496 0.5 0.3 47620 6848 ? S 20:37 0:00 /usr/local/apache/bin/httpd
nobody 5497 0.7 0.3 47688 7444 ? S 20:37 0:00 /usr/local/apache/bin/httpd
nobody 5498 0.9 0.3 47588 6516 ? S 20:37 0:00 /usr/local/apache/bin/httpd
nobody 5499 1.0 0.3 47528 6700 ? S 20:37 0:01 /usr/local/apache/bin/httpd
nobody 5507 0.7 0.2 47532 5956 ? S 20:38 0:00 /usr/local/apache/bin/httpd
nobody 5508 0.8 0.3 47724 6800 ? S 20:38 0:00 /usr/local/apache/bin/httpd
root 5530 0.0 0.0 2768 892 pts/0 R 20:39 0:00 ps axu
6)my.cnf is
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
skip-innodb
max_connections = 250
key_buffer = 128M
myisam_sort_buffer_size = 64M
#join_buffer_size = 1M
#read_buffer_size = 1M
#sort_buffer_size = 2M
table_cache = 512
thread_cache_size = 32
wait_timeout = 10
connect_timeout = 10
tmp_table_size = 32M
max_allowed_packet = 16M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1
thread_concurrency=4
bind-address=127.0.0.1
skip-networking
[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
7)+--------------------------+------------+
| Variable_name | Value |
+--------------------------+------------+
| Aborted_clients | 137439 |
| Aborted_connects | 1 |
| Bytes_received | 501342433 |
| Bytes_sent | 3544825725 |
| Com_admin_commands | 82987 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 89846 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_commit | 0 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 1 |
| Com_delete | 7745 |
| Com_delete_multi | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_flush | 0 |
| Com_grant | 0 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_insert | 52383 |
| Com_insert_select | 427 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 0 |
| Com_optimize | 0 |
| Com_purge | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 3692 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 488311 |
| Com_set_option | 27 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_create | 0 |
| Com_show_databases | 0 |
| Com_show_fields | 0 |
| Com_show_grants | 0 |
| Com_show_keys | 0 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_processlist | 46 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 2 |
| Com_show_innodb_status | 0 |
| Com_show_tables | 12 |
| Com_show_variables | 13 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 0 |
| Com_update | 165269 |
| Com_update_multi | 0 |
| Connections | 71722 |
| Created_tmp_disk_tables | 526 |
| Created_tmp_tables | 26239 |
| Created_tmp_files | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 17679 |
| Handler_read_first | 38717 |
| Handler_read_key | 60981736 |
| Handler_read_next | 49344995 |
| Handler_read_prev | 3123009 |
| Handler_read_rnd | 8687207 |
| Handler_read_rnd_next | 295183729 |
| Handler_rollback | 0 |
| Handler_update | 228641 |
| Handler_write | 5666663 |
| Key_blocks_used | 78641 |
| Key_read_requests | 193552810 |
| Key_reads | 77321 |
| Key_write_requests | 109524 |
| Key_writes | 91730 |
| Max_used_connections | 174 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 512 |
| Open_files | 576 |
| Open_streams | 0 |
| Opened_tables | 896 |
| Questions | 2827845 |
| Qcache_queries_in_cache | 7580 |
| Qcache_inserts | 482418 |
| Qcache_hits | 2017136 |
| Qcache_lowmem_prunes | 1169 |
| Qcache_not_cached | 5893 |
| Qcache_free_memory | 19120600 |
| Qcache_free_blocks | 5462 |
| Qcache_total_blocks | 20881 |
| Rpl_status | NULL |
| Select_full_join | 10 |
| Select_full_range_join | 0 |
| Select_range | 99782 |
| Select_range_check | 0 |
| Select_scan | 73427 |
| Slave_open_temp_tables | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 17 |
| Sort_merge_passes | 0 |
| Sort_range | 116203 |
| Sort_rows | 12447863 |
| Sort_scan | 28689 |
| Table_locks_immediate | 1474775 |
| Table_locks_waited | 24951 |
| Threads_cached | 10 |
| Threads_created | 1106 |
| Threads_connected | 65 |
| Threads_running | 2 |
| Uptime | 13668 |
+--------------------------+------------+
8)no other scripts vb is only thing running i use eaccelerator already
9)900 is my cookie time 700 800 users
10)
11)
Timeout 150
KeepAlive On
MaxKeepAliveRequests 150
KeepAliveTimeout 15
MinSpareServers 30
MaxSpareServers 60
StartServers 15
MaxClients 200
MaxClients 200
12) vb 3.0.7
13)there is no file above 2Gb
2)my server is
p4 2.8 HTT with 2GB ram Processor #1 Vendor: GenuineIntel
Processor #1 Name: Intel(R) Pentium(R) 4 CPU 2.80GHz
Processor #1 speed: 2793.203 MHz
Processor #1 cache size: 512 KB
Processor #2 Vendor: GenuineIntel
Processor #2 Name: Intel(R) Pentium(R) 4 CPU 2.80GHz
Processor #2 speed: 2793.203 MHz
Processor #2 cache size: 512 KB
3)mysql is version 4.0.25 with no innodb
4) i use cpanel it install mysql itself
5) top results
20:38:45 up 11 days, 3:10, 1 user, load average: 7.47, 5.85, 6.04
263 processes: 250 sleeping, 13 running, 0 zombie, 0 stopped
CPU0 states: 85.2% user 14.2% system 0.0% nice 0.0% iowait 0.1% idle
CPU1 states: 88.2% user 11.1% system 0.0% nice 0.0% iowait 0.1% idle
Mem: 2047480k av, 2035488k used, 11992k free, 0k shrd, 37604k buff
1265472k actv, 143672k in_d, 46368k in_c
Swap: 2040244k av, 418708k used, 1621536k free 1007456k cached
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
16421 root 15 0 2164 124 76 S 99.9 0.0 152:14 1 httpd
32226 mysql 15 0 146M 142M 1284 S 32.6 7.1 5:45 0 mysqld
30277 squid 25 0 71632 67M 744 R 7.8 3.3 1561m 0 squid
5521 root 16 0 1232 1232 852 R 0.7 0.0 0:00 0 top
1 root 15 0 100 76 56 S 0.0 0.0 0:14 1 init
2 root RT 0 0 0 0 SW 0.0 0.0 0:00 0 migration/0
3 root RT 0 0 0 0 SW 0.0 0.0 0:00 1 migration/1
4 root 15 0 0 0 0 SW 0.0 0.0 0:08 0 keventd
5 root 34 19 0 0 0 SWN 0.0 0.0 0:02 0 ksoftirqd_CPU0
6 root 34 19 0 0 0 SWN 0.0 0.0 0:00 1 ksoftirqd_CPU1
11 root 25 0 0 0 0 SW 0.0 0.0 0:00 0 bdflush
7 root 15 0 0 0 0 SW 0.0 0.0 6:11 1 kswapd
8 root 15 0 0 0 0 SW 0.0 0.0 0:05 0 kscand/DMA
9 root 16 0 0 0 0 SW 0.0 0.0 27:14 1 kscand/Normal
10 root 16 0 0 0 0 SW 0.0 0.0 79:47 1 kscand/HighMem
12 root 15 0 0 0 0 SW 0.0 0.0 0:23 1 kupdated
13 root 23 0 0 0 0 SW 0.0 0.0 0:00 0 mdrecoveryd
17 root 15 0 0 0 0 SW 0.0 0.0 6:50 1 kjournald
642 root 15 0 0 0 0 SW 0.0 0.0 0:00 1 kjournald
1033 root 15 0 248 216 152 S 0.0 0.0 1:38 1 syslogd
1037 root 15 0 184 172 120 S 0.0 0.0 0:13 1 klogd
2200 named 25 0 964 516 260 S 0.0 0.0 0:03 0 named
2228 root 25 0 148 4 0 S 0.0 0.0 0:00 1 xinetd
2246 root 18 0 7080 1272 652 S 0.0 0.0 0:12 0 chkservd
2328 root 15 0 176 152 88 S 0.0 0.0 0:03 0 crond
2684 root 34 19 7960 880 340 S N 0.0 0.0 0:11 1 cpanellogd
2756 root 24 0 136 4 0 S 0.0 0.0 0:00 0 S99radyo
2765 root 15 0 1792 436 192 S 0.0 0.0 63:08 0 sc_serv
2965 root 15 0 4240 4 0 S 0.0 0.0 0:00 1 cppop
5492 nobody 15 0 724 248 144 S 0.0 0.0 0:05 1 proftpd
30275 root 15 0 320 4 0 S 0.0 0.0 0:00 1 squid
30279 squid 15 0 80 72 48 S 0.0 0.0 0:08 1 unlinkd
18903 root 21 0 52 4 0 S 0.0 0.0 0:00 1 mingetty
18904 root 21 0 52 4 0 S 0.0 0.0 0:00 0 mingetty
18905 root 21 0 52 4 0 S 0.0 0.0 0:00 1 mingetty
18906 root 21 0 52 4 0 S 0.0 0.0 0:00 1 mingetty
18907 root 21 0 52 4 0 S 0.0 0.0 0:00 0 mingetty
18908 root 21 0 52 4 0 S 0.0 0.0 0:00 1 mingetty
32205 root 15 0 3412 752 312 S 0.0 0.0 0:07 0 miniserv.pl
ps axu results
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
root 1 0.0 0.0 1296 76 ? S Nov08 0:14 init [3] --init
root 2 0.0 0.0 0 0 ? SW Nov08 0:00 [migration/0]
root 3 0.0 0.0 0 0 ? SW Nov08 0:00 [migration/1]
root 4 0.0 0.0 0 0 ? SW Nov08 0:08 [keventd]
root 5 0.0 0.0 0 0 ? SWN Nov08 0:02 [ksoftirqd_CPU0]
root 6 0.0 0.0 0 0 ? SWN Nov08 0:00 [ksoftirqd_CPU1]
root 11 0.0 0.0 0 0 ? SW Nov08 0:00 [bdflush]
root 7 0.0 0.0 0 0 ? SW Nov08 6:11 [kswapd]
root 8 0.0 0.0 0 0 ? SW Nov08 0:05 [kscand/DMA]
root 9 0.1 0.0 0 0 ? SW Nov08 27:14 [kscand/Normal]
root 10 0.4 0.0 0 0 ? SW Nov08 79:47 [kscand/HighMem]
root 12 0.0 0.0 0 0 ? SW Nov08 0:23 [kupdated]
root 13 0.0 0.0 0 0 ? SW Nov08 0:00 [mdrecoveryd]
root 17 0.0 0.0 0 0 ? SW Nov08 6:50 [kjournald]
root 642 0.0 0.0 0 0 ? SW Nov08 0:00 [kjournald]
root 1033 0.0 0.0 1468 216 ? S Nov08 1:38 syslogd -m 0
root 1037 0.0 0.0 1384 172 ? S Nov08 0:13 klogd -x
named 2200 0.0 0.0 39040 516 ? S Nov08 0:03 /usr/sbin/named -u named
root 2228 0.0 0.0 2068 4 ? S Nov08 0:00 xinetd -stayalive -pidfile /var/run/xinetd.pid
root 2246 0.0 0.0 11272 1272 ? S Nov08 0:12 chkservd
root 2328 0.0 0.0 1452 152 ? S Nov08 0:03 crond
root 2684 0.0 0.0 11068 880 ? SN Nov08 0:11 cpanellogd - sleeping for logs
root 2756 0.0 0.0 4176 4 ? S Nov08 0:00 /bin/sh /etc/rc3.d/S99radyo start
root 2765 0.3 0.0 29684 436 ? S Nov08 63:08 ./sc_serv
root 2965 0.0 0.0 9948 4 ? S Nov08 0:00 cppop - accepting on port 110
nobody 5492 0.0 0.0 4324 248 ? S Nov11 0:05 proftpd: (accepting connections)
root 30275 0.0 0.0 5888 4 ? S Nov12 0:00 squid -D
squid 30277 13.8 3.3 75660 68640 ? R Nov12 1561:09 (squid) -D
squid 30279 0.0 0.0 1344 72 ? S Nov12 0:08 (unlinkd)
root 18903 0.0 0.0 1360 4 tty1 S Nov12 0:00 /sbin/mingetty tty1
root 18904 0.0 0.0 1360 4 tty2 S Nov12 0:00 /sbin/mingetty tty2
root 18905 0.0 0.0 1360 4 tty3 S Nov12 0:00 /sbin/mingetty tty3
root 18906 0.0 0.0 1360 4 tty4 S Nov12 0:00 /sbin/mingetty tty4
root 18907 0.0 0.0 1360 4 tty5 S Nov12 0:00 /sbin/mingetty tty5
root 18908 0.0 0.0 1360 4 tty6 S Nov12 0:00 /sbin/mingetty tty6
root 32205 0.0 0.0 7820 752 ? S Nov13 0:07 /usr/bin/perl /usr/libexec/webmin/miniserv.pl /etc/webmin/miniserv.co
root 21397 0.0 0.0 3448 4 ? S Nov15 0:00 /usr/sbin/sshd
cpanel 21650 0.0 0.0 3772 4 ? S Nov15 0:00 /usr/bin/stunnel-4.04local /usr/local/cpanel/etc/stunnel/default/stun
root 21672 0.0 0.0 11460 1448 ? S Nov15 0:01 cpsrvd - waiting for connections
root 31818 0.0 0.0 6824 324 ? S 16:49 0:01 /usr/sbin/sshd
root 31996 0.0 0.0 5160 668 pts/0 S 16:50 0:00 -bash
root 32194 0.0 0.0 4996 4 pts/0 S 16:53 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var
mysql 32226 21.5 7.1 242664 145376 pts/0 S 16:53 5:26 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --
root 16421 0.0 0.0 45360 124 ? S 18:30 0:01 /usr/local/apache/bin/httpd
nobody 16427 1.0 0.4 48200 8520 ? S 18:30 1:18 /usr/local/apache/bin/httpd
nobody 16428 1.0 0.4 48400 9412 ? S 18:30 1:17 /usr/local/apache/bin/httpd
nobody 16429 0.9 0.3 47996 7260 ? S 18:30 1:13 /usr/local/apache/bin/httpd
nobody 16430 1.4 0.4 48176 8480 ? S 18:30 1:50 /usr/local/apache/bin/httpd
nobody 16431 1.0 0.4 48524 8856 ? S 18:30 1:21 /usr/local/apache/bin/httpd
nobody 16432 1.0 0.4 48456 8720 ? S 18:30 1:17 /usr/local/apache/bin/httpd
nobody 16433 0.9 0.4 48780 9616 ? R 18:30 1:16 /usr/local/apache/bin/httpd
nobody 16434 1.0 0.4 48268 8572 ? S 18:30 1:18 /usr/local/apache/bin/httpd
nobody 16435 1.0 0.3 48088 8164 ? S 18:30 1:20 /usr/local/apache/bin/httpd
nobody 16436 0.9 0.4 47992 8236 ? S 18:30 1:16 /usr/local/apache/bin/httpd
nobody 16437 0.9 0.4 48060 8468 ? S 18:30 1:12 /usr/local/apache/bin/httpd
nobody 16438 0.9 0.3 48340 7768 ? S 18:30 1:16 /usr/local/apache/bin/httpd
nobody 16439 0.9 0.4 48156 8836 ? S 18:30 1:15 /usr/local/apache/bin/httpd
nobody 16440 0.9 0.4 48492 9412 ? R 18:30 1:16 /usr/local/apache/bin/httpd
nobody 16441 1.0 0.4 48080 8604 ? S 18:30 1:17 /usr/local/apache/bin/httpd
nobody 16442 1.0 0.4 48536 9016 ? S 18:30 1:19 /usr/local/apache/bin/httpd
nobody 16443 1.0 0.4 47900 8432 ? S 18:30 1:17 /usr/local/apache/bin/httpd
nobody 16444 0.9 0.4 48144 8276 ? S 18:30 1:12 /usr/local/apache/bin/httpd
nobody 16445 0.9 0.4 48152 8828 ? S 18:30 1:15 /usr/local/apache/bin/httpd
nobody 16446 1.0 0.3 48040 7984 ? S 18:30 1:17 /usr/local/apache/bin/httpd
nobody 16447 1.0 0.4 48432 8576 ? S 18:30 1:17 /usr/local/apache/bin/httpd
nobody 16448 1.6 0.4 48204 8540 ? S 18:30 2:03 /usr/local/apache/bin/httpd
nobody 16449 0.9 0.4 48240 8668 ? S 18:30 1:12 /usr/local/apache/bin/httpd
nobody 16450 0.9 0.4 48160 8780 ? S 18:30 1:16 /usr/local/apache/bin/httpd
nobody 16451 1.0 0.4 48372 8644 ? S 18:30 1:19 /usr/local/apache/bin/httpd
nobody 16452 0.9 0.4 48460 8664 ? S 18:30 1:13 /usr/local/apache/bin/httpd
nobody 16453 1.0 0.4 48116 8524 ? S 18:30 1:19 /usr/local/apache/bin/httpd
nobody 16454 1.0 0.4 48156 8832 ? S 18:30 1:17 /usr/local/apache/bin/httpd
nobody 16455 1.0 0.4 48372 8832 ? S 18:30 1:18 /usr/local/apache/bin/httpd
nobody 16456 1.0 0.4 48200 8636 ? S 18:30 1:19 /usr/local/apache/bin/httpd
nobody 16457 0.9 0.4 48244 8628 ? S 18:30 1:14 /usr/local/apache/bin/httpd
nobody 16458 0.9 0.4 48420 9132 ? S 18:30 1:15 /usr/local/apache/bin/httpd
nobody 16459 1.0 0.4 48360 9124 ? S 18:30 1:23 /usr/local/apache/bin/httpd
nobody 16460 1.4 0.4 47960 8776 ? S 18:30 1:48 /usr/local/apache/bin/httpd
nobody 16462 0.9 0.4 48156 8852 ? S 18:30 1:15 /usr/local/apache/bin/httpd
nobody 16463 0.9 0.4 48160 8900 ? S 18:30 1:14 /usr/local/apache/bin/httpd
nobody 16464 0.9 0.3 47832 8020 ? S 18:30 1:15 /usr/local/apache/bin/httpd
nobody 16466 0.9 0.4 48504 8988 ? S 18:30 1:14 /usr/local/apache/bin/httpd
nobody 16468 0.9 0.4 48260 9280 ? S 18:30 1:13 /usr/local/apache/bin/httpd
nobody 16469 0.9 0.4 48068 8816 ? S 18:30 1:11 /usr/local/apache/bin/httpd
nobody 16472 0.9 0.4 48004 8692 ? S 18:30 1:16 /usr/local/apache/bin/httpd
nobody 16473 1.0 0.4 48368 8576 ? S 18:30 1:18 /usr/local/apache/bin/httpd
nobody 16474 1.0 0.4 47976 8196 ? S 18:30 1:18 /usr/local/apache/bin/httpd
nobody 16475 1.0 0.4 48136 9132 ? S 18:30 1:19 /usr/local/apache/bin/httpd
nobody 16478 0.9 0.4 48124 8624 ? S 18:30 1:16 /usr/local/apache/bin/httpd
nobody 16480 0.9 0.3 47956 8048 ? S 18:30 1:12 /usr/local/apache/bin/httpd
nobody 16487 0.9 0.3 48236 8036 ? S 18:30 1:15 /usr/local/apache/bin/httpd
nobody 16488 1.0 0.4 48160 9028 ? S 18:30 1:19 /usr/local/apache/bin/httpd
nobody 16489 0.9 0.3 48100 8016 ? S 18:30 1:14 /usr/local/apache/bin/httpd
nobody 16491 0.9 0.4 48312 8536 ? S 18:30 1:12 /usr/local/apache/bin/httpd
nobody 16493 0.9 0.4 48260 8584 ? S 18:30 1:14 /usr/local/apache/bin/httpd
nobody 16494 0.9 0.4 48828 8900 ? S 18:30 1:12 /usr/local/apache/bin/httpd
nobody 16496 1.0 0.4 48240 9172 ? S 18:30 1:18 /usr/local/apache/bin/httpd
nobody 16497 1.0 0.4 48476 8848 ? S 18:30 1:17 /usr/local/apache/bin/httpd
nobody 16499 1.2 0.4 48288 8388 ? S 18:30 1:39 /usr/local/apache/bin/httpd
nobody 16500 1.0 0.4 47956 8800 ? S 18:30 1:17 /usr/local/apache/bin/httpd
nobody 16502 1.0 0.4 48548 9144 ? S 18:30 1:17 /usr/local/apache/bin/httpd
nobody 16503 0.9 0.3 48008 7256 ? S 18:30 1:15 /usr/local/apache/bin/httpd
nobody 16504 0.9 0.4 48264 8788 ? S 18:30 1:13 /usr/local/apache/bin/httpd
nobody 16505 0.9 0.3 47916 7676 ? S 18:30 1:16 /usr/local/apache/bin/httpd
nobody 16509 0.9 0.4 48324 8696 ? S 18:30 1:15 /usr/local/apache/bin/httpd
nobody 16511 0.9 0.4 48284 9556 ? S 18:30 1:12 /usr/local/apache/bin/httpd
nobody 16513 0.9 0.4 48196 8384 ? S 18:30 1:12 /usr/local/apache/bin/httpd
nobody 16514 0.9 0.4 47928 8308 ? S 18:30 1:15 /usr/local/apache/bin/httpd
nobody 16518 0.9 0.4 48172 9068 ? S 18:30 1:16 /usr/local/apache/bin/httpd
nobody 16520 1.0 0.4 48008 8288 ? S 18:30 1:19 /usr/local/apache/bin/httpd
nobody 16521 1.0 0.4 48200 8868 ? S 18:30 1:17 /usr/local/apache/bin/httpd
nobody 16523 1.4 0.4 48028 8648 ? S 18:30 1:52 /usr/local/apache/bin/httpd
nobody 16524 1.0 0.4 48228 8436 ? S 18:30 1:19 /usr/local/apache/bin/httpd
nobody 16525 0.9 0.4 48296 8352 ? S 18:30 1:16 /usr/local/apache/bin/httpd
nobody 16526 0.9 0.4 48352 8740 ? S 18:30 1:16 /usr/local/apache/bin/httpd
nobody 16530 1.0 0.4 48444 8624 ? S 18:30 1:20 /usr/local/apache/bin/httpd
nobody 16531 0.9 0.4 48268 8340 ? S 18:30 1:12 /usr/local/apache/bin/httpd
nobody 16532 0.9 0.3 47972 7420 ? S 18:30 1:16 /usr/local/apache/bin/httpd
nobody 16533 0.9 0.4 48264 8760 ? S 18:30 1:16 /usr/local/apache/bin/httpd
nobody 16539 0.9 0.4 48068 9004 ? S 18:30 1:09 /usr/local/apache/bin/httpd
nobody 16540 1.5 0.5 49328 10748 ? S 18:30 1:55 /usr/local/apache/bin/httpd
nobody 16541 0.9 0.4 48524 9528 ? S 18:30 1:13 /usr/local/apache/bin/httpd
nobody 16544 1.0 0.4 48220 9452 ? S 18:30 1:18 /usr/local/apache/bin/httpd
nobody 16545 1.3 0.4 48116 8196 ? S 18:30 1:40 /usr/local/apache/bin/httpd
nobody 16546 1.0 0.4 49260 9976 ? S 18:30 1:17 /usr/local/apache/bin/httpd
nobody 16547 0.9 0.4 48132 8776 ? S 18:30 1:14 /usr/local/apache/bin/httpd
nobody 16548 1.0 0.4 47976 8604 ? S 18:30 1:21 /usr/local/apache/bin/httpd
nobody 16549 0.9 0.3 48004 8116 ? S 18:30 1:14 /usr/local/apache/bin/httpd
nobody 16550 1.0 0.4 47992 8212 ? S 18:30 1:20 /usr/local/apache/bin/httpd
nobody 16551 1.0 0.3 47904 8064 ? S 18:30 1:17 /usr/local/apache/bin/httpd
nobody 16552 1.3 0.5 51504 11816 ? R 18:30 1:47 /usr/local/apache/bin/httpd
nobody 16553 1.1 0.4 48132 8600 ? S 18:30 1:31 /usr/local/apache/bin/httpd
nobody 16554 0.9 0.3 48084 8060 ? S 18:30 1:15 /usr/local/apache/bin/httpd
nobody 16555 0.9 0.4 48168 8892 ? S 18:30 1:15 /usr/local/apache/bin/httpd
nobody 16556 0.9 0.4 48232 8288 ? S 18:30 1:14 /usr/local/apache/bin/httpd
nobody 16557 0.9 0.7 55040 15524 ? S 18:30 1:12 /usr/local/apache/bin/httpd
nobody 16558 1.0 0.4 48332 9284 ? S 18:30 1:19 /usr/local/apache/bin/httpd
nobody 16559 0.9 0.4 48272 8556 ? S 18:30 1:15 /usr/local/apache/bin/httpd
nobody 16560 1.2 0.4 48312 9156 ? S 18:30 1:39 /usr/local/apache/bin/httpd
nobody 16561 0.9 0.5 50192 10808 ? S 18:30 1:14 /usr/local/apache/bin/httpd
nobody 16562 1.0 0.4 48108 8620 ? S 18:30 1:18 /usr/local/apache/bin/httpd
nobody 16563 0.9 0.4 48320 8536 ? S 18:30 1:16 /usr/local/apache/bin/httpd
nobody 16564 0.9 0.4 48092 8376 ? S 18:30 1:16 /usr/local/apache/bin/httpd
nobody 16565 1.0 0.3 48092 7728 ? S 18:30 1:22 /usr/local/apache/bin/httpd
nobody 16566 1.4 0.4 48348 8768 ? S 18:30 1:50 /usr/local/apache/bin/httpd
nobody 16567 0.9 0.3 48012 8176 ? S 18:30 1:15 /usr/local/apache/bin/httpd
nobody 16568 1.1 0.3 48168 8156 ? S 18:30 1:28 /usr/local/apache/bin/httpd
nobody 16569 0.9 0.4 48380 9048 ? S 18:30 1:13 /usr/local/apache/bin/httpd
nobody 16570 0.9 0.4 48500 8548 ? S 18:30 1:15 /usr/local/apache/bin/httpd
nobody 16571 1.0 0.4 48180 8892 ? S 18:30 1:17 /usr/local/apache/bin/httpd
nobody 16572 0.9 0.4 48076 8720 ? S 18:30 1:11 /usr/local/apache/bin/httpd
nobody 16573 1.0 0.5 49940 10616 ? S 18:30 1:17 /usr/local/apache/bin/httpd
nobody 16574 0.9 0.4 48076 8656 ? S 18:30 1:13 /usr/local/apache/bin/httpd
nobody 16576 0.9 0.4 48164 8292 ? S 18:30 1:15 /usr/local/apache/bin/httpd
nobody 16577 0.9 0.4 48092 8628 ? S 18:30 1:12 /usr/local/apache/bin/httpd
nobody 16580 1.0 0.4 48328 9144 ? S 18:31 1:17 /usr/local/apache/bin/httpd
nobody 27147 1.0 0.4 48252 8652 ? S 19:37 0:39 /usr/local/apache/bin/httpd
nobody 27148 1.2 0.3 47916 7852 ? S 19:37 0:46 /usr/local/apache/bin/httpd
nobody 27149 0.9 0.3 47992 8188 ? S 19:37 0:36 /usr/local/apache/bin/httpd
nobody 27154 0.9 0.4 48248 8664 ? S 19:38 0:36 /usr/local/apache/bin/httpd
nobody 27159 0.9 0.3 47932 7868 ? S 19:38 0:36 /usr/local/apache/bin/httpd
nobody 27160 0.9 0.4 47800 8244 ? S 19:38 0:34 /usr/local/apache/bin/httpd
nobody 3975 0.8 0.3 47752 8012 ? S 20:29 0:05 /usr/local/apache/bin/httpd
nobody 3976 1.2 0.4 48468 8756 ? S 20:29 0:07 /usr/local/apache/bin/httpd
nobody 3977 0.9 0.3 47856 7548 ? S 20:29 0:05 /usr/local/apache/bin/httpd
nobody 3978 1.0 0.3 47936 7684 ? S 20:29 0:05 /usr/local/apache/bin/httpd
nobody 3982 1.2 0.3 47712 7888 ? S 20:29 0:07 /usr/local/apache/bin/httpd
nobody 3983 1.0 0.3 47796 7752 ? S 20:29 0:05 /usr/local/apache/bin/httpd
nobody 5485 1.0 0.3 47652 6576 ? S 20:37 0:01 /usr/local/apache/bin/httpd
nobody 5494 0.9 0.3 47520 7088 ? R 20:37 0:01 /usr/local/apache/bin/httpd
nobody 5495 0.8 0.3 47660 7392 ? S 20:37 0:00 /usr/local/apache/bin/httpd
nobody 5496 0.5 0.3 47620 6848 ? S 20:37 0:00 /usr/local/apache/bin/httpd
nobody 5497 0.7 0.3 47688 7444 ? S 20:37 0:00 /usr/local/apache/bin/httpd
nobody 5498 0.9 0.3 47588 6516 ? S 20:37 0:00 /usr/local/apache/bin/httpd
nobody 5499 1.0 0.3 47528 6700 ? S 20:37 0:01 /usr/local/apache/bin/httpd
nobody 5507 0.7 0.2 47532 5956 ? S 20:38 0:00 /usr/local/apache/bin/httpd
nobody 5508 0.8 0.3 47724 6800 ? S 20:38 0:00 /usr/local/apache/bin/httpd
root 5530 0.0 0.0 2768 892 pts/0 R 20:39 0:00 ps axu
6)my.cnf is
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
skip-innodb
max_connections = 250
key_buffer = 128M
myisam_sort_buffer_size = 64M
#join_buffer_size = 1M
#read_buffer_size = 1M
#sort_buffer_size = 2M
table_cache = 512
thread_cache_size = 32
wait_timeout = 10
connect_timeout = 10
tmp_table_size = 32M
max_allowed_packet = 16M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1
thread_concurrency=4
bind-address=127.0.0.1
skip-networking
[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
7)+--------------------------+------------+
| Variable_name | Value |
+--------------------------+------------+
| Aborted_clients | 137439 |
| Aborted_connects | 1 |
| Bytes_received | 501342433 |
| Bytes_sent | 3544825725 |
| Com_admin_commands | 82987 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 89846 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_commit | 0 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 1 |
| Com_delete | 7745 |
| Com_delete_multi | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_flush | 0 |
| Com_grant | 0 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_insert | 52383 |
| Com_insert_select | 427 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 0 |
| Com_optimize | 0 |
| Com_purge | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 3692 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 488311 |
| Com_set_option | 27 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_create | 0 |
| Com_show_databases | 0 |
| Com_show_fields | 0 |
| Com_show_grants | 0 |
| Com_show_keys | 0 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_processlist | 46 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 2 |
| Com_show_innodb_status | 0 |
| Com_show_tables | 12 |
| Com_show_variables | 13 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 0 |
| Com_update | 165269 |
| Com_update_multi | 0 |
| Connections | 71722 |
| Created_tmp_disk_tables | 526 |
| Created_tmp_tables | 26239 |
| Created_tmp_files | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 17679 |
| Handler_read_first | 38717 |
| Handler_read_key | 60981736 |
| Handler_read_next | 49344995 |
| Handler_read_prev | 3123009 |
| Handler_read_rnd | 8687207 |
| Handler_read_rnd_next | 295183729 |
| Handler_rollback | 0 |
| Handler_update | 228641 |
| Handler_write | 5666663 |
| Key_blocks_used | 78641 |
| Key_read_requests | 193552810 |
| Key_reads | 77321 |
| Key_write_requests | 109524 |
| Key_writes | 91730 |
| Max_used_connections | 174 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 512 |
| Open_files | 576 |
| Open_streams | 0 |
| Opened_tables | 896 |
| Questions | 2827845 |
| Qcache_queries_in_cache | 7580 |
| Qcache_inserts | 482418 |
| Qcache_hits | 2017136 |
| Qcache_lowmem_prunes | 1169 |
| Qcache_not_cached | 5893 |
| Qcache_free_memory | 19120600 |
| Qcache_free_blocks | 5462 |
| Qcache_total_blocks | 20881 |
| Rpl_status | NULL |
| Select_full_join | 10 |
| Select_full_range_join | 0 |
| Select_range | 99782 |
| Select_range_check | 0 |
| Select_scan | 73427 |
| Slave_open_temp_tables | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 17 |
| Sort_merge_passes | 0 |
| Sort_range | 116203 |
| Sort_rows | 12447863 |
| Sort_scan | 28689 |
| Table_locks_immediate | 1474775 |
| Table_locks_waited | 24951 |
| Threads_cached | 10 |
| Threads_created | 1106 |
| Threads_connected | 65 |
| Threads_running | 2 |
| Uptime | 13668 |
+--------------------------+------------+
8)no other scripts vb is only thing running i use eaccelerator already
9)900 is my cookie time 700 800 users
10)
11)
Timeout 150
KeepAlive On
MaxKeepAliveRequests 150
KeepAliveTimeout 15
MinSpareServers 30
MaxSpareServers 60
StartServers 15
MaxClients 200
MaxClients 200
12) vb 3.0.7
13)there is no file above 2Gb