BruceWest
Mon 21st Aug '06, 7:30am
This is an invaluable service. Thanks for taking the time to go over all this! Let me know what I can contribute in return!
1. Dedicated I run the server with CPanel, and there are at least 10-20 accounts on the system, but all except one are relatively low-traffic.
2. CPU Information: Dual Xeon 2.4 GHz w/HyperThreading
Installed Memory: 2 GB RAM
Hard Drive Type/Configuration: 2 x 73 GB, 10000 rpm, Ultra320 SCSI+ Drives | 200 GB Backup EIDE Drive
Linux Information: Redhat Enterprise 3 i686
Apache Version: Apache/1.3.36 (Unix)
PHP Version: 4.4.2
MySQL Version: 4.1.19-standard
3. No InnoDB-type tables or database in use.
4. Via WHM/CPanel (with Apache)
5. root@server [/]#
root@server [/]# top -b
20:41:04 up 86 days, 12:08, 2 users, load average: 8.53, 7.40, 5.39
326 processes: 320 sleeping, 5 running, 1 zombie, 0 stopped
CPU states: cpu user nice system irq softirq iowait idle
total 16.2% 1.3% 2.3% 0.0% 1.8% 26.4% 51.7%
cpu00 33.6% 0.9% 4.6% 0.0% 4.6% 15.8% 40.1%
cpu01 6.4% 1.8% 0.9% 0.0% 0.0% 32.4% 58.3%
cpu02 12.9% 0.0% 2.7% 0.0% 0.9% 28.7% 54.6%
cpu03 12.0% 2.7% 0.9% 0.0% 1.8% 28.7% 53.7%
Mem: 2055436k av, 1931832k used, 123604k free, 0k shrd, 65140k buff
1520120k actv, 234676k in_d, 9388k in_c
Swap: 2048276k av, 257312k used, 1790964k free 617408k cached
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
4372 nobody 15 0 16012 15M 3936 S 3.9 0.7 0:12 3 httpd
4374 nobody 15 0 15912 15M 3940 S 2.3 0.7 0:10 2 httpd
5577 nobody 16 0 10888 10M 3916 R 2.3 0.5 0:00 1 httpd
4423 nobody 16 0 17196 16M 3940 R 1.3 0.8 0:07 3 httpd
5259 nobody 16 0 11004 10M 3936 R 1.3 0.5 0:01 0 httpd
4352 nobody 15 0 16212 15M 3964 S 0.9 0.7 0:10 2 httpd
4420 nobody 15 0 12608 12M 3940 S 0.6 0.6 0:06 2 httpd
5702 nobody 15 0 11124 10M 3920 S 0.6 0.5 0:00 2 httpd
5725 root 20 0 1252 1252 800 R 0.6 0.0 0:00 2 top
25755 mysql 34 19 152M 109M 1916 S N 0.4 5.4 0:39 1 mysqld
2723 mysql 35 19 152M 109M 1916 R N 0.4 5.4 0:08 1 mysqld
4338 nobody 16 0 14256 13M 3944 S 0.4 0.6 0:07 3 httpd
4424 nobody 15 0 16024 15M 3940 S 0.4 0.7 0:08 2 httpd
2462 root 15 0 660 600 380 S 0.2 0.0 17:48 0 antirelayd
2596 mysql 34 19 152M 109M 1916 S N 0.2 5.4 0:07 1 mysqld
2796 mysql 34 19 152M 109M 1916 S N 0.2 5.4 0:06 1 mysqld
4361 nobody 15 0 17012 16M 3992 S 0.2 0.8 0:07 2 httpd
4367 nobody 15 0 14780 14M 3940 S 0.2 0.7 0:09 2 httpd
4389 nobody 15 0 15184 14M 3944 S 0.2 0.7 0:09 1 httpd
4425 nobody 15 0 11316 11M 3940 S 0.2 0.5 0:07 3 httpd
4434 nobody 15 0 11396 11M 3940 S 0.2 0.5 0:07 2 httpd
5690 nobody 15 0 10080 9.8M 3900 S 0.2 0.4 0:00 2 httpd
5697 nobody 15 0 11232 10M 3924 S 0.2 0.5 0:01 2 httpd
1 root 15 0 116 88 56 S 0.0 0.0 2:28 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 RT 0 0 0 0 SW 0.0 0.0 0:00 2 migration/2
5 root RT 0 0 0 0 SW 0.0 0.0 0:00 3 migration/3
6 root 15 0 0 0 0 SW 0.0 0.0 0:01 2 keventd
7 root 34 19 0 0 0 SWN 0.0 0.0 0:00 0 ksoftirqd/0
8 root 34 19 0 0 0 SWN 0.0 0.0 0:00 1 ksoftirqd/1
9 root 34 19 0 0 0 SWN 0.0 0.0 0:00 2 ksoftirqd/2
10 root 34 19 0 0 0 SWN 0.0 0.0 0:00 3 ksoftirqd/3
13 root 15 0 0 0 0 SW 0.0 0.0 1:12 2 bdflush
11 root 15 0 0 0 0 SW 0.0 0.0 99:16 1 kswapd
12 root 15 0 0 0 0 SW 0.0 0.0 300:44 1 kscand
14 root 15 0 0 0 0 SW 0.0 0.0 23:48 0 kupdated
15 root 25 0 0 0 0 SW 0.0 0.0 0:00 0 mdrecoveryd
25 root 15 0 0 0 0 SW 0.0 0.0 97:05 3 kjournald
88 root 25 0 0 0 0 SW 0.0 0.0 0:00 2 khubd
1537 root 15 0 0 0 0 SW 0.0 0.0 0:00 1 kjournald
1538 root 15 0 0 0 0 SW 0.0 0.0 5:30 0 kjournald
1539 root 15 0 0 0 0 SW 0.0 0.0 17:23 3 kjournald
2010 root 15 0 272 252 188 S 0.0 0.0 16:23 2 syslogd
2014 root 15 0 180 168 116 S 0.0 0.0 10:31 3 klogd
2024 root 15 0 244 236 180 S 0.0 0.0 8:17 0 irqbalance
2032 rpc 39 19 80 4 0 S N 0.0 0.0 0:00 1 portmap
2051 rpcuser 39 19 76 4 0 S N 0.0 0.0 0:00 1 rpc.statd
2062 root 15 0 176 156 116 S 0.0 0.0 0:27 0 mdadm
2174 root 15 0 1960 932 284 S 0.0 0.0 0:51 3 sshdfilter
2175 root 15 0 1864 584 208 S 0.0 0.0 0:46 2 sshdfilter
2182 root 15 0 364 216 120 S 0.0 0.0 0:52 2 sshd
2197 root 16 0 128 4 0 S 0.0 0.0 0:01 2 xinetd
2446 mailnull 35 19 344 24 20 S N 0.0 0.0 0:00 3 exim
2452 mailnull 34 19 568 312 232 S N 0.0 0.0 1:48 2 exim
2457 mailnull 35 19 352 24 20 S N 0.0 0.0 0:00 2 exim
2469 root 15 0 20828 3168 608 S 0.0 0.1 24:33 2 spamd
2488 root 15 0 508 184 124 S 0.0 0.0 0:44 2 crond
2526 xfs 34 19 2096 60 32 S N 0.0 0.0 0:01 2 xfs
2736 cpanel 35 19 2384 1540 696 S N 0.0 0.0 0:18 0 stunnel-4.15loc
2824 root 15 0 124 48 32 S 0.0 0.0 464:39 2 portsentry
2828 root 15 0 88 36 20 S 0.0 0.0 5:50 1 portsentry
2846 root 15 0 0 0 0 SW 0.0 0.0 16:28 0 loop0
2847 root 15 0 0 0 0 SW 0.0 0.0 15:41 0 kjournald
2879 root 15 0 56 4 0 S 0.0 0.0 0:00 0 mingetty
2880 root 15 0 56 4 0 S 0.0 0.0 0:00 1 mingetty
2881 root 15 0 56 4 0 S 0.0 0.0 0:00 1 mingetty
2882 root 21 0 56 4 0 S 0.0 0.0 0:00 0 mingetty
2883 root 21 0 56 4 0 S 0.0 0.0 0:00 1 mingetty
2884 root 17 0 56 4 0 S 0.0 0.0 0:00 0 mingetty
2885 root 20 0 56 4 0 S 0.0 0.0 0:00 1 agetty
3363 named 25 0 2572 1524 576 S 0.0 0.0 0:00 2 named
3365 named 15 0 2572 1524 576 S 0.0 0.0 4:25 0 named
3366 named 15 0 2572 1524 576 S 0.0 0.0 4:24 1 named
3367 named 15 0 2572 1524 576 S 0.0 0.0 4:25 2 named
3368 named 15 0 2572 1524 576 S 0.0 0.0 4:26 0 named
3369 named 15 0 2572 1524 576 S 0.0 0.0 0:22 3 named
3370 named 15 0 2572 1524 576 S 0.0 0.0 7:00 0 named
3396 root 15 0 396 164 88 S 0.0 0.0 0:21 1 pure-ftpd
3400 root 15 0 184 4 0 S 0.0 0.0 0:01 2 pure-authd
19626 storm 34 19 1688 1296 712 S N 0.0 0.0 1:04 3 server_linux
19627 storm 34 19 1688 1296 712 S N 0.0 0.0 1:52 3 server_linux
19628 storm 34 19 1688 1296 712 S N 0.0 0.0 126:48 1 server_linux
19629 storm 34 19 1688 1296 712 S N 0.0 0.0 137:12 1 server_linux
19630 storm 34 19 1688 1296 712 S N 0.0 0.0 28:07 3 server_linux
19631 storm 34 19 1688 1296 712 S N 0.0 0.0 3:13 3 server_linux
19632 storm 34 19 1688 1296 712 S N 0.0 0.0 99:07 3 server_linux
19633 storm 34 19 1688 1296 712 S N 0.0 0.0 99:16 1 server_linux
19634 storm 34 19 1688 1296 712 S N 0.0 0.0 9:51 1 server_linux
14509 radiobe 34 19 1136 164 88 S N 0.0 0.0 19:25 3 icecast
14510 radiobe 15 0 1136 164 88 S 0.0 0.0 3:08 1 icecast
14511 radiobe 15 0 1136 164 88 S 0.0 0.0 4:43 1 icecast
14512 radiobe 15 0 1136 164 88 S 0.0 0.0 5:21 1 icecast
14513 radiobe 15 0 1136 164 88 S 0.0 0.0 0:53 3 icecast
14516 radiobe 15 0 1136 164 88 S 0.0 0.0 5:39 1 icecast
14517 radiobe 15 0 1136 164 88 S 0.0 0.0 16:22 1 icecast
28304 root 15 0 160 104 24 S 0.0 0.0 2:32 1 ventrilo_srv
3231 root 15 0 60 52 0 S 0.0 0.0 0:00 0 rhnsd
3798 root 25 0 5936 2984 724 S 0.0 0.1 10:15 1 mrtg
26224 root 34 19 26728 936 296 S N 0.0 0.0 6:47 0 cpanellogd
26286 root 15 0 5004 2132 488 S 0.0 0.1 0:18 1 cppop
26290 mailman 34 19 3348 20 16 S N 0.0 0.0 0:00 2 mailmanctl
26298 mailman 34 19 3604 660 308 S N 0.0 0.0 1:27 1 python2.4
26299 mailman 34 19 3636 716 324 S N 0.0 0.0 1:27 1 python2.4
26300 mailman 34 19 3620 652 308 S N 0.0 0.0 1:32 1 python2.4
26301 mailman 34 19 3608 688 308 S N 0.0 0.0 1:34 2 python2.4
26302 mailman 34 19 3644 688 308 S N 0.0 0.0 1:28 2 python2.4
26303 mailman 34 19 3692 700 324 S N 0.0 0.0 1:34 1 python2.4
26304 mailman 34 19 3608 688 308 S N 0.0 0.0 1:27 0 python2.4
26305 mailman 34 19 3472 568 176 S N 0.0 0.0 0:00 0 python2.4
26367 cpanel 34 19 26852 708 272 S N 0.0 0.0 0:37 0 interchange
26721 root 25 0 148 4 0 S 0.0 0.0 0:00 2 mysqld_safe
26751 mysql 34 19 152M 109M 1916 S N 0.0 5.4 3:27 2 mysqld
26756 mysql 25 0 152M 109M 1916 S 0.0 5.4 0:00 3 mysqld
26757 mysql 15 0 152M 109M 1916 S 0.0 5.4 0:00 2 mysqld
26758 mysql 25 0 152M 109M 1916 S 0.0 5.4 0:00 3 mysqld
26759 mysql 15 0 152M 109M 1916 S 0.0 5.4 0:00 3 mysqld
26760 mysql 15 0 152M 109M 1916 S 0.0 5.4 2:02 1 mysqld
26761 mysql 15 0 152M 109M 1916 S 0.0 5.4 1:26 3 mysqld
26762 mysql 15 0 152M 109M 1916 S 0.0 5.4 0:00 3 mysqld
26763 mysql 15 0 152M 109M 1916 S 0.0 5.4 2:50 2 mysqld
7628 root 15 0 836 548 392 S 0.0 0.0 0:06 1 sshd
7633 root 15 0 900 700 456 S 0.0 0.0 0:00 3 bash
31744 root 16 0 5896 1652 428 S 0.0 0.0 0:01 2 cpsrvd
1523 root 15 0 24352 17M 1272 S 0.0 0.8 1:30 1 spamd
23355 root 15 0 756 352 260 S 0.0 0.0 0:03 3 cupsd
18397 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:56 3 mysqld
25672 mysql 35 19 152M 109M 1916 S N 0.0 5.4 0:36 1 mysqld
25699 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:33 1 mysqld
25731 mysql 35 19 152M 109M 1916 S N 0.0 5.4 0:41 1 mysqld
25759 mysql 35 19 152M 109M 1916 S N 0.0 5.4 0:37 3 mysqld
25762 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:38 2 mysqld
31392 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:20 3 mysqld
31429 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:20 3 mysqld
31431 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:16 1 mysqld
31434 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:21 3 mysqld
31485 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:23 1 mysqld
31496 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:18 2 mysqld
2518 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:06 2 mysqld
2524 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:08 2 mysqld
2535 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:08 2 mysqld
2552 mysql 35 19 152M 109M 1916 S N 0.0 5.4 0:05 0 mysqld
2553 mysql 35 19 152M 109M 1916 S N 0.0 5.4 0:09 3 mysqld
2555 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:08 1 mysqld
2556 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:08 2 mysqld
2557 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:06 2 mysqld
2562 mysql 35 19 152M 109M 1916 S N 0.0 5.4 0:08 3 mysqld
2571 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:06 0 mysqld
2583 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:07 1 mysqld
2595 mysql 35 19 152M 109M 1916 S N 0.0 5.4 0:07 2 mysqld
2625 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:08 1 mysqld
2630 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:06 0 mysqld
2646 mysql 35 19 152M 109M 1916 S N 0.0 5.4 0:08 0 mysqld
2673 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:07 3 mysqld
2700 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:09 2 mysqld
2701 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:08 0 mysqld
2709 mysql 35 19 152M 109M 1916 S N 0.0 5.4 0:06 2 mysqld
2729 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:08 1 mysqld
2731 mysql 35 19 152M 109M 1916 S N 0.0 5.4 0:07 1 mysqld
2734 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:07 0 mysqld
2740 mysql 35 19 152M 109M 1916 S N 0.0 5.4 0:08 3 mysqld
2741 mysql 35 19 152M 109M 1916 S N 0.0 5.4 0:04 0 mysqld
2742 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:08 3 mysqld
2743 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:07 1 mysqld
2745 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:07 1 mysqld
2752 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:09 3 mysqld
2753 mysql 35 19 152M 109M 1916 S N 0.0 5.4 0:05 1 mysqld
2754 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:08 2 mysqld
2756 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:07 2 mysqld
2757 mysql 35 19 152M 109M 1916 S N 0.0 5.4 0:07 0 mysqld
2763 mysql 35 19 152M 109M 1916 S N 0.0 5.4 0:07 1 mysqld
2765 mysql 35 19 152M 109M 1916 S N 0.0 5.4 0:07 2 mysqld
2767 mysql 35 19 152M 109M 1916 S N 0.0 5.4 0:04 2 mysqld
2769 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:05 3 mysqld
2794 mysql 35 19 152M 109M 1916 S N 0.0 5.4 0:07 2 mysqld
2803 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:03 2 mysqld
2804 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:10 3 mysqld
2805 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:06 1 mysqld
2806 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:08 3 mysqld
2807 mysql 35 19 152M 109M 1916 S N 0.0 5.4 0:07 2 mysqld
2808 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:07 0 mysqld
2810 mysql 35 19 152M 109M 1916 S N 0.0 5.4 0:08 1 mysqld
2813 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:10 0 mysqld
2814 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:09 2 mysqld
2816 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:09 2 mysqld
2820 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:07 2 mysqld
3607 root 15 0 1280 1220 884 S 0.0 0.0 0:00 2 sshd
3609 root 15 0 860 860 616 S 0.0 0.0 0:00 1 bash
4331 root 15 0 7276 7276 3480 S 0.0 0.3 0:00 1 httpd
4337 nobody 15 0 15260 14M 3984 S 0.0 0.7 0:06 0 httpd
4339 nobody 15 0 15824 15M 3948 S 0.0 0.7 0:08 1 httpd
4340 nobody 15 0 15484 15M 3980 S 0.0 0.7 0:07 3 httpd
4341 nobody 15 0 15176 14M 3940 S 0.0 0.7 0:10 0 httpd
4342 nobody 15 0 15192 14M 3944 S 0.0 0.7 0:07 1 httpd
4343 nobody 15 0 14792 14M 3984 S 0.0 0.7 0:13 0 httpd
4344 nobody 15 0 16144 15M 3984 S 0.0 0.7 0:09 2 httpd
4345 nobody 15 0 11536 11M 3940 S 0.0 0.5 0:08 1 httpd
4346 nobody 15 0 14408 14M 3952 S 0.0 0.7 0:11 3 httpd
4347 nobody 15 0 14892 14M 3940 S 0.0 0.7 0:11 3 httpd
4348 nobody 15 0 15012 14M 3936 S 0.0 0.7 0:10 2 httpd
4349 nobody 15 0 8740 8740 3860 S 0.0 0.4 0:11 2 httpd
4350 nobody 15 0 11884 11M 3940 S 0.0 0.5 0:11 2 httpd
4351 nobody 15 0 11716 11M 3944 S 0.0 0.5 0:13 3 httpd
4353 nobody 15 0 15084 14M 3984 S 0.0 0.7 0:10 0 httpd
4354 nobody 15 0 11724 11M 4340 S 0.0 0.5 0:06 3 httpd
4355 nobody 16 0 11640 11M 3944 S 0.0 0.5 0:08 3 httpd
4356 nobody 15 0 15180 14M 3940 S 0.0 0.7 0:10 1 httpd
4357 nobody 15 0 15168 14M 3940 S 0.0 0.7 0:08 1 httpd
4358 nobody 15 0 15668 15M 3984 S 0.0 0.7 0:10 1 httpd
4359 nobody 15 0 11948 11M 3944 S 0.0 0.5 0:07 3 httpd
4360 nobody 15 0 15164 14M 3984 S 0.0 0.7 0:08 0 httpd
4362 nobody 15 0 15416 15M 3984 S 0.0 0.7 0:12 3 httpd
4363 nobody 15 0 12004 11M 3968 S 0.0 0.5 0:10 2 httpd
4364 nobody 15 0 17344 16M 3984 S 0.0 0.8 0:12 0 httpd
4365 nobody 15 0 14764 14M 3940 S 0.0 0.7 0:07 1 httpd
4366 nobody 15 0 15472 15M 3984 S 0.0 0.7 0:07 2 httpd
4368 nobody 15 0 15072 14M 3940 S 0.0 0.7 0:10 3 httpd
4369 nobody 15 0 14212 13M 3988 S 0.0 0.6 0:08 2 httpd
4370 nobody 15 0 15220 14M 3944 S 0.0 0.7 0:09 0 httpd
4371 nobody 16 0 11484 11M 3944 S 0.0 0.5 0:10 1 httpd
4373 nobody 15 0 12772 12M 3940 S 0.0 0.6 0:08 2 httpd
4375 nobody 15 0 11328 11M 3984 S 0.0 0.5 0:06 2 httpd
4376 nobody 15 0 15056 14M 3984 S 0.0 0.7 0:03 0 httpd
4377 nobody 15 0 11848 11M 3940 S 0.0 0.5 0:10 3 httpd
4378 nobody 15 0 14784 14M 3940 S 0.0 0.7 0:09 0 httpd
4379 nobody 15 0 14472 14M 3988 S 0.0 0.7 0:12 3 httpd
4380 nobody 15 0 15016 14M 3940 S 0.0 0.7 0:08 2 httpd
4381 nobody 15 0 14636 14M 3940 S 0.0 0.7 0:09 2 httpd
4382 nobody 15 0 15104 14M 3940 S 0.0 0.7 0:09 1 httpd
4383 nobody 15 0 14240 13M 3984 S 0.0 0.6 0:07 1 httpd
4384 nobody 15 0 16380 15M 3984 S 0.0 0.7 0:10 3 httpd
4385 nobody 15 0 14360 14M 3940 S 0.0 0.6 0:07 0 httpd
4386 nobody 15 0 15240 14M 3940 S 0.0 0.7 0:06 2 httpd
4387 nobody 15 0 14704 14M 3940 S 0.0 0.7 0:08 3 httpd
4388 nobody 15 0 11572 11M 3936 S 0.0 0.5 0:08 1 httpd
4390 nobody 15 0 17028 16M 3940 S 0.0 0.8 0:10 0 httpd
4391 nobody 15 0 19272 18M 3988 S 0.0 0.9 0:10 1 httpd
4392 nobody 15 0 15148 14M 3984 S 0.0 0.7 0:09 3 httpd
4393 nobody 15 0 11364 11M 3940 S 0.0 0.5 0:08 0 httpd
4394 nobody 15 0 11952 11M 3948 S 0.0 0.5 0:07 0 httpd
4395 nobody 15 0 14808 14M 3940 S 0.0 0.7 0:08 1 httpd
4396 nobody 15 0 17408 17M 3984 S 0.0 0.8 0:10 1 httpd
4397 nobody 16 0 14644 14M 3940 S 0.0 0.7 0:08 1 httpd
4398 nobody 15 0 16980 16M 3988 S 0.0 0.8 0:15 0 httpd
4399 nobody 15 0 14980 14M 3940 S 0.0 0.7 0:08 2 httpd
4400 nobody 16 0 11972 11M 3940 S 0.0 0.5 0:03 0 httpd
4401 nobody 15 0 18764 18M 3984 S 0.0 0.9 0:09 0 httpd
4402 nobody 15 0 11436 11M 3984 S 0.0 0.5 0:07 2 httpd
4403 nobody 15 0 15192 14M 3940 S 0.0 0.7 0:09 2 httpd
4404 nobody 15 0 15172 14M 3960 S 0.0 0.7 0:07 2 httpd
4405 nobody 15 0 17472 17M 3940 S 0.0 0.8 0:10 2 httpd
4406 nobody 15 0 11352 11M 3940 S 0.0 0.5 0:08 3 httpd
4407 nobody 15 0 14264 13M 3940 S 0.0 0.6 0:14 2 httpd
4408 nobody 15 0 17576 17M 3984 S 0.0 0.8 0:07 2 httpd
4409 nobody 15 0 14980 14M 3940 S 0.0 0.7 0:09 2 httpd
4412 nobody 15 0 11488 11M 3940 S 0.0 0.5 0:06 3 httpd
4413 nobody 15 0 15040 14M 3940 S 0.0 0.7 0:10 2 httpd
4414 nobody 15 0 14292 13M 3944 S 0.0 0.6 0:07 3 httpd
4415 nobody 15 0 14476 14M 3984 S 0.0 0.7 0:08 3 httpd
4416 nobody 15 0 15016 14M 3956 S 0.0 0.7 0:09 1 httpd
4417 nobody 15 0 15056 14M 3936 S 0.0 0.7 0:07 3 httpd
4418 nobody 15 0 11380 11M 3940 S 0.0 0.5 0:08 2 httpd
4419 nobody 15 0 15900 15M 4036 S 0.0 0.7 0:11 2 httpd
4421 nobody 15 0 10900 10M 3920 S 0.0 0.5 0:00 1 httpd
4422 nobody 15 0 14976 14M 3984 S 0.0 0.7 0:07 2 httpd
4426 nobody 15 0 15380 15M 3940 S 0.0 0.7 0:09 1 httpd
4427 nobody 15 0 17104 16M 3984 S 0.0 0.8 0:10 1 httpd
4428 nobody 15 0 15016 14M 3940 S 0.0 0.7 0:07 3 httpd
4429 nobody 15 0 14672 14M 3940 S 0.0 0.7 0:08 1 httpd
4430 nobody 15 0 15116 14M 3944 S 0.0 0.7 0:08 1 httpd
4431 nobody 15 0 15140 14M 3940 S 0.0 0.7 0:09 3 httpd
4432 nobody 15 0 14988 14M 3940 S 0.0 0.7 0:07 3 httpd
4435 nobody 16 0 11412 11M 3940 S 0.0 0.5 0:06 1 httpd
4436 nobody 15 0 11316 11M 3944 S 0.0 0.5 0:08 2 httpd
4437 nobody 15 0 15180 14M 3940 S 0.0 0.7 0:09 2 httpd
4438 nobody 15 0 11464 11M 3940 S 0.0 0.5 0:07 2 httpd
4439 nobody 15 0 15760 15M 3984 S 0.0 0.7 0:09 2 httpd
4441 nobody 15 0 15000 14M 3984 S 0.0 0.7 0:10 3 httpd
4444 nobody 15 0 14932 14M 3940 S 0.0 0.7 0:09 3 httpd
4638 nobody 16 0 11380 11M 3940 S 0.0 0.5 0:06 1 httpd
4862 nobody 15 0 16668 16M 3984 S 0.0 0.8 0:07 0 httpd
4901 nobody 16 0 10980 10M 3920 S 0.0 0.5 0:00 0 httpd
5204 nobody 15 0 14892 14M 3940 S 0.0 0.7 0:04 3 httpd
5205 nobody 15 0 14932 14M 3964 S 0.0 0.7 0:03 1 httpd
5211 nobody 15 0 14480 14M 3940 S 0.0 0.7 0:04 2 httpd
5245 root 15 0 20752 3556 532 S 0.0 0.1 0:00 1 spamd
5250 nobody 15 0 14796 14M 3936 S 0.0 0.7 0:04 1 httpd
5253 nobody 15 0 11756 11M 3940 S 0.0 0.5 0:03 2 httpd
5254 nobody 15 0 14672 14M 3940 S 0.0 0.7 0:03 2 httpd
5257 nobody 15 0 11312 11M 3936 S 0.0 0.5 0:03 3 httpd
5297 mailnull 34 19 3068 2932 2016 S N 0.0 0.1 0:00 2 exim
5316 nobody 15 0 14700 14M 3940 S 0.0 0.7 0:03 2 httpd
5326 nobody 15 0 11332 11M 3936 S 0.0 0.5 0:04 2 httpd
5327 nobody 15 0 14580 14M 3940 S 0.0 0.7 0:03 1 httpd
5328 nobody 16 0 11536 11M 3940 S 0.0 0.5 0:03 2 httpd
5343 nobody 15 0 11400 11M 3940 S 0.0 0.5 0:02 3 httpd
5344 nobody 15 0 14700 14M 3936 S 0.0 0.7 0:03 2 httpd
5345 nobody 15 0 11408 11M 4276 S 0.0 0.5 0:00 2 httpd
5352 nobody 15 0 11224 10M 3940 S 0.0 0.5 0:02 3 httpd
5578 nobody 15 0 17016 16M 3912 S 0.0 0.8 0:00 3 httpd
5579 nobody 15 0 11288 11M 3936 S 0.0 0.5 0:00 3 httpd
5580 nobody 15 0 11104 10M 3936 S 0.0 0.5 0:01 3 httpd
5581 nobody 15 0 11188 10M 3936 S 0.0 0.5 0:00 2 httpd
5582 nobody 15 0 12080 11M 3928 S 0.0 0.5 0:00 1 httpd
5583 nobody 15 0 11176 10M 3956 S 0.0 0.5 0:00 2 httpd
5587 nobody 15 0 11332 11M 3972 S 0.0 0.5 0:01 3 httpd
5677 nobody 15 0 11120 10M 3916 S 0.0 0.5 0:00 0 httpd
5687 nobody 15 0 11340 11M 3940 S 0.0 0.5 0:00 2 httpd
5688 nobody 15 0 11228 10M 3936 S 0.0 0.5 0:01 3 httpd
5689 nobody 15 0 7392 7392 3580 S 0.0 0.3 0:00 0 httpd
5691 nobody 15 0 10604 10M 3936 S 0.0 0.5 0:00 2 httpd
5692 nobody 15 0 9868 9868 3900 S 0.0 0.4 0:00 3 httpd
5694 nobody 15 0 9792 9792 3900 S 0.0 0.4 0:00 3 httpd
5695 nobody 15 0 11120 10M 3920 S 0.0 0.5 0:00 2 httpd
5696 nobody 15 0 10968 10M 3940 S 0.0 0.5 0:00 3 httpd
5698 nobody 15 0 14092 13M 3932 S 0.0 0.6 0:00 1 httpd
5701 nobody 15 0 11116 10M 3920 S 0.0 0.5 0:00 2 httpd
5708 nobody 15 0 7528 7528 3716 S 0.0 0.3 0:00 0 httpd
5713 nobody 15 0 7392 7392 3580 S 0.0 0.3 0:00 1 httpd
5718 nobody 15 0 9840 9840 3900 S 0.0 0.4 0:00 2 httpd
5719 nobody 15 0 7396 7396 3580 S 0.0 0.3 0:00 0 httpd
5720 nobody 15 0 0 0 0 Z 0.0 0.0 0:00 3 httpd <defunct>
5721 nobody 16 0 11144 10M 3936 S 0.0 0.5 0:00 2 httpd
5722 nobody 15 0 9888 9888 3900 S 0.0 0.4 0:00 3 httpd
5723 nobody 15 0 9356 9356 3852 S 0.0 0.4 0:00 1 httpd
5724 bruce 19 0 5756 3692 1148 S 0.0 0.1 0:00 3 cppop
6. [mysqld]
datadir=/var/lib/mysql
interactive_timeout=100
max_connections = 1000
key_buffer = 16M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
read_rnd_buffer_size = 768K
table_cache = 1024
thread_cache_size = 64
thread_concurrency = 2
wait_timeout = 1800
connect_timeout = 10
max_allowed_packet = 16M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1
#skip-innodb
old-passwords = 1
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[client]
[mysqld_safe]
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
6. root@server [/]# mysqladmin -u root -p var ext stat ver
Enter password:
+---------------------------------+------------------------------------------+
| Variable_name | Value |
+---------------------------------+------------------------------------------+
| back_log | 50 |
| basedir | / |
| binlog_cache_size | 32768 |
| bulk_insert_buffer_size | 8388608 |
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
| collation_connection | latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
| concurrent_insert | ON |
| connect_timeout | 10 |
| datadir | /var/lib/mysql/ |
| date_format | %Y-%m-%d |
| datetime_format | %Y-%m-%d %H:%i:%s |
| default_week_format | 0 |
| delay_key_write | ON |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| expire_logs_days | 0 |
| flush | OFF |
| flush_time | 0 |
| ft_boolean_syntax | + -><()~*:""&| |
| ft_max_word_len | 84 |
| ft_min_word_len | 4 |
| ft_query_expansion_limit | 20 |
| ft_stopword_file | (built-in) |
| group_concat_max_len | 1024 |
| have_archive | NO |
| have_bdb | NO |
| have_blackhole_engine | NO |
| have_compress | YES |
| have_crypt | YES |
| have_csv | NO |
| have_example_engine | NO |
| have_geometry | YES |
| have_innodb | YES |
| have_isam | NO |
| have_ndbcluster | NO |
| have_openssl | NO |
| have_query_cache | YES |
| have_raid | NO |
| have_rtree_keys | YES |
| have_symlink | YES |
| init_connect | |
| init_file | |
| init_slave | |
| innodb_additional_mem_pool_size | 1048576 |
| innodb_autoextend_increment | 8 |
| innodb_buffer_pool_awe_mem_mb | 0 |
| innodb_buffer_pool_size | 8388608 |
| innodb_data_file_path | ibdata1:10M:autoextend |
| innodb_data_home_dir | |
| innodb_fast_shutdown | ON |
| innodb_file_io_threads | 4 |
| innodb_file_per_table | OFF |
| innodb_flush_log_at_trx_commit | 1 |
| innodb_flush_method | |
| innodb_force_recovery | 0 |
| innodb_lock_wait_timeout | 50 |
| innodb_locks_unsafe_for_binlog | OFF |
| innodb_log_arch_dir | |
| innodb_log_archive | OFF |
| innodb_log_buffer_size | 1048576 |
| innodb_log_file_size | 5242880 |
| innodb_log_files_in_group | 2 |
| innodb_log_group_home_dir | ./ |
| innodb_max_dirty_pages_pct | 90 |
| innodb_max_purge_lag | 0 |
| innodb_mirrored_log_groups | 1 |
| innodb_open_files | 300 |
| innodb_table_locks | ON |
| innodb_thread_concurrency | 8 |
| interactive_timeout | 100 |
| join_buffer_size | 1044480 |
| key_buffer_size | 16777216 |
| key_cache_age_threshold | 300 |
| key_cache_block_size | 1024 |
| key_cache_division_limit | 100 |
| language | /usr/share/mysql/english/ |
| large_files_support | ON |
| license | GPL |
| local_infile | ON |
| locked_in_memory | OFF |
| log | OFF |
| log_bin | OFF |
| log_error | |
| log_slave_updates | OFF |
| log_slow_queries | OFF |
| log_update | OFF |
| log_warnings | 1 |
| long_query_time | 10 |
| low_priority_updates | OFF |
| lower_case_file_system | OFF |
| lower_case_table_names | 0 |
| max_allowed_packet | 16776192 |
| max_binlog_cache_size | 4294967295 |
| max_binlog_size | 1073741824 |
| max_connect_errors | 10 |
| max_connections | 1000 |
| max_delayed_threads | 20 |
| max_error_count | 64 |
| max_heap_table_size | 16777216 |
| max_insert_delayed_threads | 20 |
| max_join_size | 4294967295 |
| max_length_for_sort_data | 1024 |
| max_prepared_stmt_count | 16382 |
| max_relay_log_size | 0 |
| max_seeks_for_key | 4294967295 |
| max_sort_length | 1024 |
| max_tmp_tables | 32 |
| max_user_connections | 0 |
| max_write_lock_count | 4294967295 |
| myisam_data_pointer_size | 4 |
| myisam_max_extra_sort_file_size | 2147483648 |
| myisam_max_sort_file_size | 2147483647 |
| myisam_recover_options | OFF |
| myisam_repair_threads | 1 |
| myisam_sort_buffer_size | 67108864 |
| myisam_stats_method | nulls_unequal |
| net_buffer_length | 16384 |
| net_read_timeout | 30 |
| net_retry_count | 10 |
| net_write_timeout | 60 |
| new | OFF |
| old_passwords | ON |
| open_files_limit | 5010 |
| pid_file | /var/lib/mysql/server.hidden.net.pid |
| port | 3306 |
| preload_buffer_size | 32768 |
| prepared_stmt_count | 0 |
| protocol_version | 10 |
| query_alloc_block_size | 8192 |
| query_cache_limit | 1048576 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 33554432 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 8192 |
| range_alloc_block_size | 2048 |
| read_buffer_size | 1044480 |
| read_only | OFF |
| read_rnd_buffer_size | 782336 |
| relay_log_purge | ON |
| relay_log_space_limit | 0 |
| rpl_recovery_rank | 0 |
| secure_auth | OFF |
| server_id | 0 |
| skip_external_locking | ON |
| skip_networking | OFF |
| skip_show_database | OFF |
| slave_net_timeout | 3600 |
| slave_transaction_retries | 0 |
| slow_launch_time | 2 |
| socket | /var/lib/mysql/mysql.sock |
| sort_buffer_size | 2097144 |
| sql_mode | |
| sql_notes | ON |
| sql_warnings | ON |
| storage_engine | MyISAM |
| sync_binlog | 0 |
| sync_frm | ON |
| sync_replication | 0 |
| sync_replication_slave_id | 0 |
| sync_replication_timeout | 0 |
| system_time_zone | CDT |
| table_cache | 1024 |
| table_type | MyISAM |
| thread_cache_size | 64 |
| thread_stack | 196608 |
| time_format | %H:%i:%s |
| time_zone | SYSTEM |
| tmp_table_size | 33554432 |
| tmpdir | |
| transaction_alloc_block_size | 8192 |
| transaction_prealloc_size | 4096 |
| tx_isolation | REPEATABLE-READ |
| version | 4.1.19-standard |
| version_comment | MySQL Community Edition - Standard (GPL) |
| version_compile_machine | i686 |
| version_compile_os | pc-linux-gnu |
| wait_timeout | 1800 |
+---------------------------------+------------------------------------------+
+----------------------------+------------+
| Variable_name | Value |
+----------------------------+------------+
| Aborted_clients | 493 |
| Aborted_connects | 3 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 3644478339 |
| Bytes_sent | 4111174155 |
| Com_admin_commands | 0 |
| Com_alter_db | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 24 |
| Com_change_db | 1964774 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_checksum | 0 |
| Com_commit | 24 |
| Com_create_db | 2 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 40 |
| Com_dealloc_sql | 0 |
| Com_delete | 2734298 |
| Com_delete_multi | 0 |
| Com_do | 0 |
| Com_drop_db | 1 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 40 |
| Com_drop_user | 0 |
| Com_execute_sql | 0 |
| Com_flush | 173 |
| Com_grant | 19 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_help | 0 |
| Com_insert | 366765 |
| Com_insert_select | 955 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 607 |
| Com_optimize | 15 |
| Com_preload_keys | 0 |
| Com_prepare_sql | 0 |
| Com_purge | 0 |
| Com_purge_before_date | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 192240 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_revoke_all | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 10895860 |
| Com_set_option | 4604 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 3 |
| Com_show_charsets | 5 |
| Com_show_collations | 5 |
| Com_show_column_types | 0 |
| Com_show_create_db | 0 |
| Com_show_create_table | 3347 |
| Com_show_databases | 100 |
| Com_show_errors | 0 |
| Com_show_fields | 3400 |
| Com_show_grants | 160 |
| Com_show_innodb_status | 0 |
| Com_show_keys | 28 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_ndb_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_privileges | 0 |
| Com_show_processlist | 1152 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 1133 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 3700 |
| Com_show_variables | 146 |
| Com_show_warnings | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_stmt_close | 0 |
| Com_stmt_execute | 0 |
| Com_stmt_prepare | 0 |
| Com_stmt_reset | 0 |
| Com_stmt_send_long_data | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 644 |
| Com_update | 2505394 |
| Com_update_multi | 334 |
| Connections | 1508399 |
| Created_tmp_disk_tables | 69920 |
| Created_tmp_files | 324806 |
| Created_tmp_tables | 558291 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 309966 |
| Handler_discover | 0 |
| Handler_read_first | 1867811 |
| Handler_read_key | 2169207846 |
| Handler_read_next | 446724290 |
| Handler_read_prev | 18098725 |
| Handler_read_rnd | 75976423 |
| Handler_read_rnd_next | 849050523 |
| Handler_rollback | 1 |
| Handler_update | 3424828 |
| Handler_write | 162682970 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 0 |
| Key_blocks_used | 14497 |
| Key_read_requests | 3136786670 |
| Key_reads | 838173 |
| Key_write_requests | 4012811 |
| Key_writes | 2315420 |
| Max_used_connections | 711 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 1436 |
| Open_streams | 0 |
| Open_tables | 1024 |
| Opened_tables | 8188 |
| Qcache_free_blocks | 3417 |
| Qcache_free_memory | 11000744 |
| Qcache_hits | 16214470 |
| Qcache_inserts | 10592822 |
| Qcache_lowmem_prunes | 387107 |
| Qcache_not_cached | 299598 |
| Qcache_queries_in_cache | 5306 |
| Qcache_total_blocks | 15166 |
| Questions | 36397303 |
| Rpl_status | NULL |
| Select_full_join | 20871 |
| Select_full_range_join | 334 |
| Select_range | 1207958 |
| Select_range_check | 0 |
| Select_scan | 1683531 |
| Slave_open_temp_tables | 0 |
| Slave_retried_transactions | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 15 |
| Slow_queries | 1994 |
| Sort_merge_passes | 162401 |
| Sort_range | 2254872 |
| Sort_rows | 1438044191 |
| Sort_scan | 759960 |
| Table_locks_immediate | 23109373 |
| Table_locks_waited | 206834 |
| Threads_cached | 39 |
| Threads_connected | 25 |
| Threads_created | 5098 |
| Threads_running | 3 |
| Uptime | 345475 |
+----------------------------+------------+
Uptime: 345475 Threads: 24 Questions: 36397320 Slow queries: 1994 Opens: 8188 Flush tables: 1 Open tables: 1024 Queries per second avg: 105.354
mysqladmin Ver 8.41 Distrib 4.1.19, for pc-linux-gnu on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version4.1.19-standard
Protocol version10
ConnectionLocalhost via UNIX socket
UNIX socket/var/lib/mysql/mysql.sock
Uptime:3 days 23 hours 57 min 55 sec
Threads: 24 Questions: 36397320 Slow queries: 1994 Opens: 8188 Flush tables: 1 Open tables: 1024 Queries per second avg: 105.354
Additional mysqlreport information:
root@server [/]# less stats
MySQL 4.1.19-standard uptime 4 0:3:56 Sun Aug 20 20:53:51 2006
__ Key __________________________________________________ _______________
Buffer usage 14.16M of 16.00M %Used: 88.48
Write ratio 0.58
Read ratio 0.00
__ Questions __________________________________________________ _________
Total 36.43M 105.35/s
DMS 16.71M 48.32/s %Total: 45.86
QC Hits 16.23M 46.94/s 44.55
Com_ 1.99M 5.75/s 5.45
COM_QUIT 1.51M 4.37/s 4.15
-Unknown 6.28k 0.02/s 0.02
Slow 2.34k 0.01/s 0.01 %DMS: 0.01
DMS 16.71M 48.32/s 45.86
SELECT 10.90M 31.53/s 29.93 65.26
DELETE 2.74M 7.91/s 7.51 16.38
UPDATE 2.51M 7.25/s 6.88 15.01
INSERT 368.09k 1.06/s 1.01 2.20
REPLACE 192.44k 0.56/s 0.53 1.15
Com_ 1.99M 5.75/s 5.45
change_db 1.97M 5.69/s 5.40
set_option 4.61k 0.01/s 0.01
show_tables 3.70k 0.01/s 0.01
__ SELECT and Sort __________________________________________________ ___
Scan 1.69M 4.87/s %SELECT: 15.45
Range 1.21M 3.50/s 11.09
Full join 20.89k 0.06/s 0.19
Range check 0 0.00/s 0.00
Full rng join 335 0.00/s 0.00
Sort scan 760.52k 2.20/s
Sort range 2.26M 6.52/s
Sort mrg pass 162.51k 0.47/s
__ Query Cache __________________________________________________ _______
Memory usage 22.34M of 32.00M %Used: 69.82
Block Fragmnt 22.46%
Hits 16.23M 46.94/s
Inserts 10.60M 30.65/s
Prunes 387.66k 1.12/s
Insrt:Prune 27.34:1 29.53/s
Hit:Insert 1.53:1
__ Table Locks __________________________________________________ _______
Waited 209.33k 0.61/s %Total: 0.90
Immediate 23.13M 66.87/s
__ Tables __________________________________________________ ____________
Open 1.02k of 1024 %Cache: 100.00
Opened 8.71k 0.03/s
__ Connections __________________________________________________ _______
Max used 718 of 1000 %Max: 71.80
Total 1.51M 4.37/s
__ Created Temp __________________________________________________ ______
Disk table 70.00k 0.20/s
8. There are many scripts that utilize PHP and MySQL. vBulletin is chief among them, but not the sole user.
9. Most users ever online was 221. Average number of concurrent users ranges from 50 - 150. Cookie Session Timeout is 900.
10. PHP Info (http://www.zefron.com/phpinfo.php)
11. KeepAlive On
MaxKeepAliveRequests 0 (unlimited)
KeepAliveTimeout 4
MinSpareServers 15
MaxSpareServers 20
StartServers 10
MaxClients 512
AND Maxrequestsperchild value = 0 (unlimited)
12. 3.6.0 Across all 4 installations... one is still at 3.5.4 but has extremely low traffic (about 5-6 users per day).
13. Nothing jumps out at me.
14. root@server [/]# uname -a
Linux server.bl5.net 2.4.21-40.ELsmp #1 SMP Thu Feb 2 22:22:39 EST 2006 i686 i686 i386 GNU/Linux root@server [/]# uname -a
Linux server.bl5.net 2.4.21-40.ELsmp #1 SMP Thu Feb 2 22:22:39 EST 2006 i686 i686 i386 GNU/Linux
root@server [/]# ulimit -aH
core file size (blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
max locked memory (kbytes, -l) 4
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
stack size (kbytes, -s) unlimited
cpu time (seconds, -t) unlimited
max user processes (-u) 7168
virtual memory (kbytes, -v) unlimited root@server [/]# cat /proc/cpuinfo
processor : 0
vendor_id : GenuineIntel
cpu family : 15
model : 2
model name : Intel(R) Xeon(TM) CPU 2.40GHz
stepping : 9
cpu MHz : 2392.134
cache size : 512 KB
physical id : 0
siblings : 2
runqueue : 0
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 2
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm
bogomips : 4771.02
processor : 1
vendor_id : GenuineIntel
cpu family : 15
model : 2
model name : Intel(R) Xeon(TM) CPU 2.40GHz
stepping : 9
cpu MHz : 2392.134
cache size : 512 KB
physical id : 0
siblings : 2
runqueue : 0
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 2
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm
bogomips : 4771.02
processor : 2
vendor_id : GenuineIntel
cpu family : 15
model : 2
model name : Intel(R) Xeon(TM) CPU 2.40GHz
stepping : 9
cpu MHz : 2392.134
cache size : 512 KB
physical id : 3
siblings : 2
runqueue : 2
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 2
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm
bogomips : 4771.02
processor : 3
vendor_id : GenuineIntel
cpu family : 15
model : 2
model name : Intel(R) Xeon(TM) CPU 2.40GHz
stepping : 9
cpu MHz : 2392.134
cache size : 512 KB
physical id : 3
siblings : 2
runqueue : 2
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 2
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm
bogomips : 4771.02
Thanks!
1. Dedicated I run the server with CPanel, and there are at least 10-20 accounts on the system, but all except one are relatively low-traffic.
2. CPU Information: Dual Xeon 2.4 GHz w/HyperThreading
Installed Memory: 2 GB RAM
Hard Drive Type/Configuration: 2 x 73 GB, 10000 rpm, Ultra320 SCSI+ Drives | 200 GB Backup EIDE Drive
Linux Information: Redhat Enterprise 3 i686
Apache Version: Apache/1.3.36 (Unix)
PHP Version: 4.4.2
MySQL Version: 4.1.19-standard
3. No InnoDB-type tables or database in use.
4. Via WHM/CPanel (with Apache)
5. root@server [/]#
root@server [/]# top -b
20:41:04 up 86 days, 12:08, 2 users, load average: 8.53, 7.40, 5.39
326 processes: 320 sleeping, 5 running, 1 zombie, 0 stopped
CPU states: cpu user nice system irq softirq iowait idle
total 16.2% 1.3% 2.3% 0.0% 1.8% 26.4% 51.7%
cpu00 33.6% 0.9% 4.6% 0.0% 4.6% 15.8% 40.1%
cpu01 6.4% 1.8% 0.9% 0.0% 0.0% 32.4% 58.3%
cpu02 12.9% 0.0% 2.7% 0.0% 0.9% 28.7% 54.6%
cpu03 12.0% 2.7% 0.9% 0.0% 1.8% 28.7% 53.7%
Mem: 2055436k av, 1931832k used, 123604k free, 0k shrd, 65140k buff
1520120k actv, 234676k in_d, 9388k in_c
Swap: 2048276k av, 257312k used, 1790964k free 617408k cached
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
4372 nobody 15 0 16012 15M 3936 S 3.9 0.7 0:12 3 httpd
4374 nobody 15 0 15912 15M 3940 S 2.3 0.7 0:10 2 httpd
5577 nobody 16 0 10888 10M 3916 R 2.3 0.5 0:00 1 httpd
4423 nobody 16 0 17196 16M 3940 R 1.3 0.8 0:07 3 httpd
5259 nobody 16 0 11004 10M 3936 R 1.3 0.5 0:01 0 httpd
4352 nobody 15 0 16212 15M 3964 S 0.9 0.7 0:10 2 httpd
4420 nobody 15 0 12608 12M 3940 S 0.6 0.6 0:06 2 httpd
5702 nobody 15 0 11124 10M 3920 S 0.6 0.5 0:00 2 httpd
5725 root 20 0 1252 1252 800 R 0.6 0.0 0:00 2 top
25755 mysql 34 19 152M 109M 1916 S N 0.4 5.4 0:39 1 mysqld
2723 mysql 35 19 152M 109M 1916 R N 0.4 5.4 0:08 1 mysqld
4338 nobody 16 0 14256 13M 3944 S 0.4 0.6 0:07 3 httpd
4424 nobody 15 0 16024 15M 3940 S 0.4 0.7 0:08 2 httpd
2462 root 15 0 660 600 380 S 0.2 0.0 17:48 0 antirelayd
2596 mysql 34 19 152M 109M 1916 S N 0.2 5.4 0:07 1 mysqld
2796 mysql 34 19 152M 109M 1916 S N 0.2 5.4 0:06 1 mysqld
4361 nobody 15 0 17012 16M 3992 S 0.2 0.8 0:07 2 httpd
4367 nobody 15 0 14780 14M 3940 S 0.2 0.7 0:09 2 httpd
4389 nobody 15 0 15184 14M 3944 S 0.2 0.7 0:09 1 httpd
4425 nobody 15 0 11316 11M 3940 S 0.2 0.5 0:07 3 httpd
4434 nobody 15 0 11396 11M 3940 S 0.2 0.5 0:07 2 httpd
5690 nobody 15 0 10080 9.8M 3900 S 0.2 0.4 0:00 2 httpd
5697 nobody 15 0 11232 10M 3924 S 0.2 0.5 0:01 2 httpd
1 root 15 0 116 88 56 S 0.0 0.0 2:28 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 RT 0 0 0 0 SW 0.0 0.0 0:00 2 migration/2
5 root RT 0 0 0 0 SW 0.0 0.0 0:00 3 migration/3
6 root 15 0 0 0 0 SW 0.0 0.0 0:01 2 keventd
7 root 34 19 0 0 0 SWN 0.0 0.0 0:00 0 ksoftirqd/0
8 root 34 19 0 0 0 SWN 0.0 0.0 0:00 1 ksoftirqd/1
9 root 34 19 0 0 0 SWN 0.0 0.0 0:00 2 ksoftirqd/2
10 root 34 19 0 0 0 SWN 0.0 0.0 0:00 3 ksoftirqd/3
13 root 15 0 0 0 0 SW 0.0 0.0 1:12 2 bdflush
11 root 15 0 0 0 0 SW 0.0 0.0 99:16 1 kswapd
12 root 15 0 0 0 0 SW 0.0 0.0 300:44 1 kscand
14 root 15 0 0 0 0 SW 0.0 0.0 23:48 0 kupdated
15 root 25 0 0 0 0 SW 0.0 0.0 0:00 0 mdrecoveryd
25 root 15 0 0 0 0 SW 0.0 0.0 97:05 3 kjournald
88 root 25 0 0 0 0 SW 0.0 0.0 0:00 2 khubd
1537 root 15 0 0 0 0 SW 0.0 0.0 0:00 1 kjournald
1538 root 15 0 0 0 0 SW 0.0 0.0 5:30 0 kjournald
1539 root 15 0 0 0 0 SW 0.0 0.0 17:23 3 kjournald
2010 root 15 0 272 252 188 S 0.0 0.0 16:23 2 syslogd
2014 root 15 0 180 168 116 S 0.0 0.0 10:31 3 klogd
2024 root 15 0 244 236 180 S 0.0 0.0 8:17 0 irqbalance
2032 rpc 39 19 80 4 0 S N 0.0 0.0 0:00 1 portmap
2051 rpcuser 39 19 76 4 0 S N 0.0 0.0 0:00 1 rpc.statd
2062 root 15 0 176 156 116 S 0.0 0.0 0:27 0 mdadm
2174 root 15 0 1960 932 284 S 0.0 0.0 0:51 3 sshdfilter
2175 root 15 0 1864 584 208 S 0.0 0.0 0:46 2 sshdfilter
2182 root 15 0 364 216 120 S 0.0 0.0 0:52 2 sshd
2197 root 16 0 128 4 0 S 0.0 0.0 0:01 2 xinetd
2446 mailnull 35 19 344 24 20 S N 0.0 0.0 0:00 3 exim
2452 mailnull 34 19 568 312 232 S N 0.0 0.0 1:48 2 exim
2457 mailnull 35 19 352 24 20 S N 0.0 0.0 0:00 2 exim
2469 root 15 0 20828 3168 608 S 0.0 0.1 24:33 2 spamd
2488 root 15 0 508 184 124 S 0.0 0.0 0:44 2 crond
2526 xfs 34 19 2096 60 32 S N 0.0 0.0 0:01 2 xfs
2736 cpanel 35 19 2384 1540 696 S N 0.0 0.0 0:18 0 stunnel-4.15loc
2824 root 15 0 124 48 32 S 0.0 0.0 464:39 2 portsentry
2828 root 15 0 88 36 20 S 0.0 0.0 5:50 1 portsentry
2846 root 15 0 0 0 0 SW 0.0 0.0 16:28 0 loop0
2847 root 15 0 0 0 0 SW 0.0 0.0 15:41 0 kjournald
2879 root 15 0 56 4 0 S 0.0 0.0 0:00 0 mingetty
2880 root 15 0 56 4 0 S 0.0 0.0 0:00 1 mingetty
2881 root 15 0 56 4 0 S 0.0 0.0 0:00 1 mingetty
2882 root 21 0 56 4 0 S 0.0 0.0 0:00 0 mingetty
2883 root 21 0 56 4 0 S 0.0 0.0 0:00 1 mingetty
2884 root 17 0 56 4 0 S 0.0 0.0 0:00 0 mingetty
2885 root 20 0 56 4 0 S 0.0 0.0 0:00 1 agetty
3363 named 25 0 2572 1524 576 S 0.0 0.0 0:00 2 named
3365 named 15 0 2572 1524 576 S 0.0 0.0 4:25 0 named
3366 named 15 0 2572 1524 576 S 0.0 0.0 4:24 1 named
3367 named 15 0 2572 1524 576 S 0.0 0.0 4:25 2 named
3368 named 15 0 2572 1524 576 S 0.0 0.0 4:26 0 named
3369 named 15 0 2572 1524 576 S 0.0 0.0 0:22 3 named
3370 named 15 0 2572 1524 576 S 0.0 0.0 7:00 0 named
3396 root 15 0 396 164 88 S 0.0 0.0 0:21 1 pure-ftpd
3400 root 15 0 184 4 0 S 0.0 0.0 0:01 2 pure-authd
19626 storm 34 19 1688 1296 712 S N 0.0 0.0 1:04 3 server_linux
19627 storm 34 19 1688 1296 712 S N 0.0 0.0 1:52 3 server_linux
19628 storm 34 19 1688 1296 712 S N 0.0 0.0 126:48 1 server_linux
19629 storm 34 19 1688 1296 712 S N 0.0 0.0 137:12 1 server_linux
19630 storm 34 19 1688 1296 712 S N 0.0 0.0 28:07 3 server_linux
19631 storm 34 19 1688 1296 712 S N 0.0 0.0 3:13 3 server_linux
19632 storm 34 19 1688 1296 712 S N 0.0 0.0 99:07 3 server_linux
19633 storm 34 19 1688 1296 712 S N 0.0 0.0 99:16 1 server_linux
19634 storm 34 19 1688 1296 712 S N 0.0 0.0 9:51 1 server_linux
14509 radiobe 34 19 1136 164 88 S N 0.0 0.0 19:25 3 icecast
14510 radiobe 15 0 1136 164 88 S 0.0 0.0 3:08 1 icecast
14511 radiobe 15 0 1136 164 88 S 0.0 0.0 4:43 1 icecast
14512 radiobe 15 0 1136 164 88 S 0.0 0.0 5:21 1 icecast
14513 radiobe 15 0 1136 164 88 S 0.0 0.0 0:53 3 icecast
14516 radiobe 15 0 1136 164 88 S 0.0 0.0 5:39 1 icecast
14517 radiobe 15 0 1136 164 88 S 0.0 0.0 16:22 1 icecast
28304 root 15 0 160 104 24 S 0.0 0.0 2:32 1 ventrilo_srv
3231 root 15 0 60 52 0 S 0.0 0.0 0:00 0 rhnsd
3798 root 25 0 5936 2984 724 S 0.0 0.1 10:15 1 mrtg
26224 root 34 19 26728 936 296 S N 0.0 0.0 6:47 0 cpanellogd
26286 root 15 0 5004 2132 488 S 0.0 0.1 0:18 1 cppop
26290 mailman 34 19 3348 20 16 S N 0.0 0.0 0:00 2 mailmanctl
26298 mailman 34 19 3604 660 308 S N 0.0 0.0 1:27 1 python2.4
26299 mailman 34 19 3636 716 324 S N 0.0 0.0 1:27 1 python2.4
26300 mailman 34 19 3620 652 308 S N 0.0 0.0 1:32 1 python2.4
26301 mailman 34 19 3608 688 308 S N 0.0 0.0 1:34 2 python2.4
26302 mailman 34 19 3644 688 308 S N 0.0 0.0 1:28 2 python2.4
26303 mailman 34 19 3692 700 324 S N 0.0 0.0 1:34 1 python2.4
26304 mailman 34 19 3608 688 308 S N 0.0 0.0 1:27 0 python2.4
26305 mailman 34 19 3472 568 176 S N 0.0 0.0 0:00 0 python2.4
26367 cpanel 34 19 26852 708 272 S N 0.0 0.0 0:37 0 interchange
26721 root 25 0 148 4 0 S 0.0 0.0 0:00 2 mysqld_safe
26751 mysql 34 19 152M 109M 1916 S N 0.0 5.4 3:27 2 mysqld
26756 mysql 25 0 152M 109M 1916 S 0.0 5.4 0:00 3 mysqld
26757 mysql 15 0 152M 109M 1916 S 0.0 5.4 0:00 2 mysqld
26758 mysql 25 0 152M 109M 1916 S 0.0 5.4 0:00 3 mysqld
26759 mysql 15 0 152M 109M 1916 S 0.0 5.4 0:00 3 mysqld
26760 mysql 15 0 152M 109M 1916 S 0.0 5.4 2:02 1 mysqld
26761 mysql 15 0 152M 109M 1916 S 0.0 5.4 1:26 3 mysqld
26762 mysql 15 0 152M 109M 1916 S 0.0 5.4 0:00 3 mysqld
26763 mysql 15 0 152M 109M 1916 S 0.0 5.4 2:50 2 mysqld
7628 root 15 0 836 548 392 S 0.0 0.0 0:06 1 sshd
7633 root 15 0 900 700 456 S 0.0 0.0 0:00 3 bash
31744 root 16 0 5896 1652 428 S 0.0 0.0 0:01 2 cpsrvd
1523 root 15 0 24352 17M 1272 S 0.0 0.8 1:30 1 spamd
23355 root 15 0 756 352 260 S 0.0 0.0 0:03 3 cupsd
18397 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:56 3 mysqld
25672 mysql 35 19 152M 109M 1916 S N 0.0 5.4 0:36 1 mysqld
25699 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:33 1 mysqld
25731 mysql 35 19 152M 109M 1916 S N 0.0 5.4 0:41 1 mysqld
25759 mysql 35 19 152M 109M 1916 S N 0.0 5.4 0:37 3 mysqld
25762 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:38 2 mysqld
31392 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:20 3 mysqld
31429 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:20 3 mysqld
31431 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:16 1 mysqld
31434 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:21 3 mysqld
31485 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:23 1 mysqld
31496 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:18 2 mysqld
2518 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:06 2 mysqld
2524 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:08 2 mysqld
2535 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:08 2 mysqld
2552 mysql 35 19 152M 109M 1916 S N 0.0 5.4 0:05 0 mysqld
2553 mysql 35 19 152M 109M 1916 S N 0.0 5.4 0:09 3 mysqld
2555 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:08 1 mysqld
2556 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:08 2 mysqld
2557 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:06 2 mysqld
2562 mysql 35 19 152M 109M 1916 S N 0.0 5.4 0:08 3 mysqld
2571 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:06 0 mysqld
2583 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:07 1 mysqld
2595 mysql 35 19 152M 109M 1916 S N 0.0 5.4 0:07 2 mysqld
2625 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:08 1 mysqld
2630 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:06 0 mysqld
2646 mysql 35 19 152M 109M 1916 S N 0.0 5.4 0:08 0 mysqld
2673 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:07 3 mysqld
2700 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:09 2 mysqld
2701 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:08 0 mysqld
2709 mysql 35 19 152M 109M 1916 S N 0.0 5.4 0:06 2 mysqld
2729 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:08 1 mysqld
2731 mysql 35 19 152M 109M 1916 S N 0.0 5.4 0:07 1 mysqld
2734 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:07 0 mysqld
2740 mysql 35 19 152M 109M 1916 S N 0.0 5.4 0:08 3 mysqld
2741 mysql 35 19 152M 109M 1916 S N 0.0 5.4 0:04 0 mysqld
2742 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:08 3 mysqld
2743 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:07 1 mysqld
2745 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:07 1 mysqld
2752 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:09 3 mysqld
2753 mysql 35 19 152M 109M 1916 S N 0.0 5.4 0:05 1 mysqld
2754 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:08 2 mysqld
2756 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:07 2 mysqld
2757 mysql 35 19 152M 109M 1916 S N 0.0 5.4 0:07 0 mysqld
2763 mysql 35 19 152M 109M 1916 S N 0.0 5.4 0:07 1 mysqld
2765 mysql 35 19 152M 109M 1916 S N 0.0 5.4 0:07 2 mysqld
2767 mysql 35 19 152M 109M 1916 S N 0.0 5.4 0:04 2 mysqld
2769 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:05 3 mysqld
2794 mysql 35 19 152M 109M 1916 S N 0.0 5.4 0:07 2 mysqld
2803 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:03 2 mysqld
2804 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:10 3 mysqld
2805 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:06 1 mysqld
2806 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:08 3 mysqld
2807 mysql 35 19 152M 109M 1916 S N 0.0 5.4 0:07 2 mysqld
2808 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:07 0 mysqld
2810 mysql 35 19 152M 109M 1916 S N 0.0 5.4 0:08 1 mysqld
2813 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:10 0 mysqld
2814 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:09 2 mysqld
2816 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:09 2 mysqld
2820 mysql 34 19 152M 109M 1916 S N 0.0 5.4 0:07 2 mysqld
3607 root 15 0 1280 1220 884 S 0.0 0.0 0:00 2 sshd
3609 root 15 0 860 860 616 S 0.0 0.0 0:00 1 bash
4331 root 15 0 7276 7276 3480 S 0.0 0.3 0:00 1 httpd
4337 nobody 15 0 15260 14M 3984 S 0.0 0.7 0:06 0 httpd
4339 nobody 15 0 15824 15M 3948 S 0.0 0.7 0:08 1 httpd
4340 nobody 15 0 15484 15M 3980 S 0.0 0.7 0:07 3 httpd
4341 nobody 15 0 15176 14M 3940 S 0.0 0.7 0:10 0 httpd
4342 nobody 15 0 15192 14M 3944 S 0.0 0.7 0:07 1 httpd
4343 nobody 15 0 14792 14M 3984 S 0.0 0.7 0:13 0 httpd
4344 nobody 15 0 16144 15M 3984 S 0.0 0.7 0:09 2 httpd
4345 nobody 15 0 11536 11M 3940 S 0.0 0.5 0:08 1 httpd
4346 nobody 15 0 14408 14M 3952 S 0.0 0.7 0:11 3 httpd
4347 nobody 15 0 14892 14M 3940 S 0.0 0.7 0:11 3 httpd
4348 nobody 15 0 15012 14M 3936 S 0.0 0.7 0:10 2 httpd
4349 nobody 15 0 8740 8740 3860 S 0.0 0.4 0:11 2 httpd
4350 nobody 15 0 11884 11M 3940 S 0.0 0.5 0:11 2 httpd
4351 nobody 15 0 11716 11M 3944 S 0.0 0.5 0:13 3 httpd
4353 nobody 15 0 15084 14M 3984 S 0.0 0.7 0:10 0 httpd
4354 nobody 15 0 11724 11M 4340 S 0.0 0.5 0:06 3 httpd
4355 nobody 16 0 11640 11M 3944 S 0.0 0.5 0:08 3 httpd
4356 nobody 15 0 15180 14M 3940 S 0.0 0.7 0:10 1 httpd
4357 nobody 15 0 15168 14M 3940 S 0.0 0.7 0:08 1 httpd
4358 nobody 15 0 15668 15M 3984 S 0.0 0.7 0:10 1 httpd
4359 nobody 15 0 11948 11M 3944 S 0.0 0.5 0:07 3 httpd
4360 nobody 15 0 15164 14M 3984 S 0.0 0.7 0:08 0 httpd
4362 nobody 15 0 15416 15M 3984 S 0.0 0.7 0:12 3 httpd
4363 nobody 15 0 12004 11M 3968 S 0.0 0.5 0:10 2 httpd
4364 nobody 15 0 17344 16M 3984 S 0.0 0.8 0:12 0 httpd
4365 nobody 15 0 14764 14M 3940 S 0.0 0.7 0:07 1 httpd
4366 nobody 15 0 15472 15M 3984 S 0.0 0.7 0:07 2 httpd
4368 nobody 15 0 15072 14M 3940 S 0.0 0.7 0:10 3 httpd
4369 nobody 15 0 14212 13M 3988 S 0.0 0.6 0:08 2 httpd
4370 nobody 15 0 15220 14M 3944 S 0.0 0.7 0:09 0 httpd
4371 nobody 16 0 11484 11M 3944 S 0.0 0.5 0:10 1 httpd
4373 nobody 15 0 12772 12M 3940 S 0.0 0.6 0:08 2 httpd
4375 nobody 15 0 11328 11M 3984 S 0.0 0.5 0:06 2 httpd
4376 nobody 15 0 15056 14M 3984 S 0.0 0.7 0:03 0 httpd
4377 nobody 15 0 11848 11M 3940 S 0.0 0.5 0:10 3 httpd
4378 nobody 15 0 14784 14M 3940 S 0.0 0.7 0:09 0 httpd
4379 nobody 15 0 14472 14M 3988 S 0.0 0.7 0:12 3 httpd
4380 nobody 15 0 15016 14M 3940 S 0.0 0.7 0:08 2 httpd
4381 nobody 15 0 14636 14M 3940 S 0.0 0.7 0:09 2 httpd
4382 nobody 15 0 15104 14M 3940 S 0.0 0.7 0:09 1 httpd
4383 nobody 15 0 14240 13M 3984 S 0.0 0.6 0:07 1 httpd
4384 nobody 15 0 16380 15M 3984 S 0.0 0.7 0:10 3 httpd
4385 nobody 15 0 14360 14M 3940 S 0.0 0.6 0:07 0 httpd
4386 nobody 15 0 15240 14M 3940 S 0.0 0.7 0:06 2 httpd
4387 nobody 15 0 14704 14M 3940 S 0.0 0.7 0:08 3 httpd
4388 nobody 15 0 11572 11M 3936 S 0.0 0.5 0:08 1 httpd
4390 nobody 15 0 17028 16M 3940 S 0.0 0.8 0:10 0 httpd
4391 nobody 15 0 19272 18M 3988 S 0.0 0.9 0:10 1 httpd
4392 nobody 15 0 15148 14M 3984 S 0.0 0.7 0:09 3 httpd
4393 nobody 15 0 11364 11M 3940 S 0.0 0.5 0:08 0 httpd
4394 nobody 15 0 11952 11M 3948 S 0.0 0.5 0:07 0 httpd
4395 nobody 15 0 14808 14M 3940 S 0.0 0.7 0:08 1 httpd
4396 nobody 15 0 17408 17M 3984 S 0.0 0.8 0:10 1 httpd
4397 nobody 16 0 14644 14M 3940 S 0.0 0.7 0:08 1 httpd
4398 nobody 15 0 16980 16M 3988 S 0.0 0.8 0:15 0 httpd
4399 nobody 15 0 14980 14M 3940 S 0.0 0.7 0:08 2 httpd
4400 nobody 16 0 11972 11M 3940 S 0.0 0.5 0:03 0 httpd
4401 nobody 15 0 18764 18M 3984 S 0.0 0.9 0:09 0 httpd
4402 nobody 15 0 11436 11M 3984 S 0.0 0.5 0:07 2 httpd
4403 nobody 15 0 15192 14M 3940 S 0.0 0.7 0:09 2 httpd
4404 nobody 15 0 15172 14M 3960 S 0.0 0.7 0:07 2 httpd
4405 nobody 15 0 17472 17M 3940 S 0.0 0.8 0:10 2 httpd
4406 nobody 15 0 11352 11M 3940 S 0.0 0.5 0:08 3 httpd
4407 nobody 15 0 14264 13M 3940 S 0.0 0.6 0:14 2 httpd
4408 nobody 15 0 17576 17M 3984 S 0.0 0.8 0:07 2 httpd
4409 nobody 15 0 14980 14M 3940 S 0.0 0.7 0:09 2 httpd
4412 nobody 15 0 11488 11M 3940 S 0.0 0.5 0:06 3 httpd
4413 nobody 15 0 15040 14M 3940 S 0.0 0.7 0:10 2 httpd
4414 nobody 15 0 14292 13M 3944 S 0.0 0.6 0:07 3 httpd
4415 nobody 15 0 14476 14M 3984 S 0.0 0.7 0:08 3 httpd
4416 nobody 15 0 15016 14M 3956 S 0.0 0.7 0:09 1 httpd
4417 nobody 15 0 15056 14M 3936 S 0.0 0.7 0:07 3 httpd
4418 nobody 15 0 11380 11M 3940 S 0.0 0.5 0:08 2 httpd
4419 nobody 15 0 15900 15M 4036 S 0.0 0.7 0:11 2 httpd
4421 nobody 15 0 10900 10M 3920 S 0.0 0.5 0:00 1 httpd
4422 nobody 15 0 14976 14M 3984 S 0.0 0.7 0:07 2 httpd
4426 nobody 15 0 15380 15M 3940 S 0.0 0.7 0:09 1 httpd
4427 nobody 15 0 17104 16M 3984 S 0.0 0.8 0:10 1 httpd
4428 nobody 15 0 15016 14M 3940 S 0.0 0.7 0:07 3 httpd
4429 nobody 15 0 14672 14M 3940 S 0.0 0.7 0:08 1 httpd
4430 nobody 15 0 15116 14M 3944 S 0.0 0.7 0:08 1 httpd
4431 nobody 15 0 15140 14M 3940 S 0.0 0.7 0:09 3 httpd
4432 nobody 15 0 14988 14M 3940 S 0.0 0.7 0:07 3 httpd
4435 nobody 16 0 11412 11M 3940 S 0.0 0.5 0:06 1 httpd
4436 nobody 15 0 11316 11M 3944 S 0.0 0.5 0:08 2 httpd
4437 nobody 15 0 15180 14M 3940 S 0.0 0.7 0:09 2 httpd
4438 nobody 15 0 11464 11M 3940 S 0.0 0.5 0:07 2 httpd
4439 nobody 15 0 15760 15M 3984 S 0.0 0.7 0:09 2 httpd
4441 nobody 15 0 15000 14M 3984 S 0.0 0.7 0:10 3 httpd
4444 nobody 15 0 14932 14M 3940 S 0.0 0.7 0:09 3 httpd
4638 nobody 16 0 11380 11M 3940 S 0.0 0.5 0:06 1 httpd
4862 nobody 15 0 16668 16M 3984 S 0.0 0.8 0:07 0 httpd
4901 nobody 16 0 10980 10M 3920 S 0.0 0.5 0:00 0 httpd
5204 nobody 15 0 14892 14M 3940 S 0.0 0.7 0:04 3 httpd
5205 nobody 15 0 14932 14M 3964 S 0.0 0.7 0:03 1 httpd
5211 nobody 15 0 14480 14M 3940 S 0.0 0.7 0:04 2 httpd
5245 root 15 0 20752 3556 532 S 0.0 0.1 0:00 1 spamd
5250 nobody 15 0 14796 14M 3936 S 0.0 0.7 0:04 1 httpd
5253 nobody 15 0 11756 11M 3940 S 0.0 0.5 0:03 2 httpd
5254 nobody 15 0 14672 14M 3940 S 0.0 0.7 0:03 2 httpd
5257 nobody 15 0 11312 11M 3936 S 0.0 0.5 0:03 3 httpd
5297 mailnull 34 19 3068 2932 2016 S N 0.0 0.1 0:00 2 exim
5316 nobody 15 0 14700 14M 3940 S 0.0 0.7 0:03 2 httpd
5326 nobody 15 0 11332 11M 3936 S 0.0 0.5 0:04 2 httpd
5327 nobody 15 0 14580 14M 3940 S 0.0 0.7 0:03 1 httpd
5328 nobody 16 0 11536 11M 3940 S 0.0 0.5 0:03 2 httpd
5343 nobody 15 0 11400 11M 3940 S 0.0 0.5 0:02 3 httpd
5344 nobody 15 0 14700 14M 3936 S 0.0 0.7 0:03 2 httpd
5345 nobody 15 0 11408 11M 4276 S 0.0 0.5 0:00 2 httpd
5352 nobody 15 0 11224 10M 3940 S 0.0 0.5 0:02 3 httpd
5578 nobody 15 0 17016 16M 3912 S 0.0 0.8 0:00 3 httpd
5579 nobody 15 0 11288 11M 3936 S 0.0 0.5 0:00 3 httpd
5580 nobody 15 0 11104 10M 3936 S 0.0 0.5 0:01 3 httpd
5581 nobody 15 0 11188 10M 3936 S 0.0 0.5 0:00 2 httpd
5582 nobody 15 0 12080 11M 3928 S 0.0 0.5 0:00 1 httpd
5583 nobody 15 0 11176 10M 3956 S 0.0 0.5 0:00 2 httpd
5587 nobody 15 0 11332 11M 3972 S 0.0 0.5 0:01 3 httpd
5677 nobody 15 0 11120 10M 3916 S 0.0 0.5 0:00 0 httpd
5687 nobody 15 0 11340 11M 3940 S 0.0 0.5 0:00 2 httpd
5688 nobody 15 0 11228 10M 3936 S 0.0 0.5 0:01 3 httpd
5689 nobody 15 0 7392 7392 3580 S 0.0 0.3 0:00 0 httpd
5691 nobody 15 0 10604 10M 3936 S 0.0 0.5 0:00 2 httpd
5692 nobody 15 0 9868 9868 3900 S 0.0 0.4 0:00 3 httpd
5694 nobody 15 0 9792 9792 3900 S 0.0 0.4 0:00 3 httpd
5695 nobody 15 0 11120 10M 3920 S 0.0 0.5 0:00 2 httpd
5696 nobody 15 0 10968 10M 3940 S 0.0 0.5 0:00 3 httpd
5698 nobody 15 0 14092 13M 3932 S 0.0 0.6 0:00 1 httpd
5701 nobody 15 0 11116 10M 3920 S 0.0 0.5 0:00 2 httpd
5708 nobody 15 0 7528 7528 3716 S 0.0 0.3 0:00 0 httpd
5713 nobody 15 0 7392 7392 3580 S 0.0 0.3 0:00 1 httpd
5718 nobody 15 0 9840 9840 3900 S 0.0 0.4 0:00 2 httpd
5719 nobody 15 0 7396 7396 3580 S 0.0 0.3 0:00 0 httpd
5720 nobody 15 0 0 0 0 Z 0.0 0.0 0:00 3 httpd <defunct>
5721 nobody 16 0 11144 10M 3936 S 0.0 0.5 0:00 2 httpd
5722 nobody 15 0 9888 9888 3900 S 0.0 0.4 0:00 3 httpd
5723 nobody 15 0 9356 9356 3852 S 0.0 0.4 0:00 1 httpd
5724 bruce 19 0 5756 3692 1148 S 0.0 0.1 0:00 3 cppop
6. [mysqld]
datadir=/var/lib/mysql
interactive_timeout=100
max_connections = 1000
key_buffer = 16M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
read_rnd_buffer_size = 768K
table_cache = 1024
thread_cache_size = 64
thread_concurrency = 2
wait_timeout = 1800
connect_timeout = 10
max_allowed_packet = 16M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1
#skip-innodb
old-passwords = 1
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[client]
[mysqld_safe]
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
6. root@server [/]# mysqladmin -u root -p var ext stat ver
Enter password:
+---------------------------------+------------------------------------------+
| Variable_name | Value |
+---------------------------------+------------------------------------------+
| back_log | 50 |
| basedir | / |
| binlog_cache_size | 32768 |
| bulk_insert_buffer_size | 8388608 |
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
| collation_connection | latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
| concurrent_insert | ON |
| connect_timeout | 10 |
| datadir | /var/lib/mysql/ |
| date_format | %Y-%m-%d |
| datetime_format | %Y-%m-%d %H:%i:%s |
| default_week_format | 0 |
| delay_key_write | ON |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| expire_logs_days | 0 |
| flush | OFF |
| flush_time | 0 |
| ft_boolean_syntax | + -><()~*:""&| |
| ft_max_word_len | 84 |
| ft_min_word_len | 4 |
| ft_query_expansion_limit | 20 |
| ft_stopword_file | (built-in) |
| group_concat_max_len | 1024 |
| have_archive | NO |
| have_bdb | NO |
| have_blackhole_engine | NO |
| have_compress | YES |
| have_crypt | YES |
| have_csv | NO |
| have_example_engine | NO |
| have_geometry | YES |
| have_innodb | YES |
| have_isam | NO |
| have_ndbcluster | NO |
| have_openssl | NO |
| have_query_cache | YES |
| have_raid | NO |
| have_rtree_keys | YES |
| have_symlink | YES |
| init_connect | |
| init_file | |
| init_slave | |
| innodb_additional_mem_pool_size | 1048576 |
| innodb_autoextend_increment | 8 |
| innodb_buffer_pool_awe_mem_mb | 0 |
| innodb_buffer_pool_size | 8388608 |
| innodb_data_file_path | ibdata1:10M:autoextend |
| innodb_data_home_dir | |
| innodb_fast_shutdown | ON |
| innodb_file_io_threads | 4 |
| innodb_file_per_table | OFF |
| innodb_flush_log_at_trx_commit | 1 |
| innodb_flush_method | |
| innodb_force_recovery | 0 |
| innodb_lock_wait_timeout | 50 |
| innodb_locks_unsafe_for_binlog | OFF |
| innodb_log_arch_dir | |
| innodb_log_archive | OFF |
| innodb_log_buffer_size | 1048576 |
| innodb_log_file_size | 5242880 |
| innodb_log_files_in_group | 2 |
| innodb_log_group_home_dir | ./ |
| innodb_max_dirty_pages_pct | 90 |
| innodb_max_purge_lag | 0 |
| innodb_mirrored_log_groups | 1 |
| innodb_open_files | 300 |
| innodb_table_locks | ON |
| innodb_thread_concurrency | 8 |
| interactive_timeout | 100 |
| join_buffer_size | 1044480 |
| key_buffer_size | 16777216 |
| key_cache_age_threshold | 300 |
| key_cache_block_size | 1024 |
| key_cache_division_limit | 100 |
| language | /usr/share/mysql/english/ |
| large_files_support | ON |
| license | GPL |
| local_infile | ON |
| locked_in_memory | OFF |
| log | OFF |
| log_bin | OFF |
| log_error | |
| log_slave_updates | OFF |
| log_slow_queries | OFF |
| log_update | OFF |
| log_warnings | 1 |
| long_query_time | 10 |
| low_priority_updates | OFF |
| lower_case_file_system | OFF |
| lower_case_table_names | 0 |
| max_allowed_packet | 16776192 |
| max_binlog_cache_size | 4294967295 |
| max_binlog_size | 1073741824 |
| max_connect_errors | 10 |
| max_connections | 1000 |
| max_delayed_threads | 20 |
| max_error_count | 64 |
| max_heap_table_size | 16777216 |
| max_insert_delayed_threads | 20 |
| max_join_size | 4294967295 |
| max_length_for_sort_data | 1024 |
| max_prepared_stmt_count | 16382 |
| max_relay_log_size | 0 |
| max_seeks_for_key | 4294967295 |
| max_sort_length | 1024 |
| max_tmp_tables | 32 |
| max_user_connections | 0 |
| max_write_lock_count | 4294967295 |
| myisam_data_pointer_size | 4 |
| myisam_max_extra_sort_file_size | 2147483648 |
| myisam_max_sort_file_size | 2147483647 |
| myisam_recover_options | OFF |
| myisam_repair_threads | 1 |
| myisam_sort_buffer_size | 67108864 |
| myisam_stats_method | nulls_unequal |
| net_buffer_length | 16384 |
| net_read_timeout | 30 |
| net_retry_count | 10 |
| net_write_timeout | 60 |
| new | OFF |
| old_passwords | ON |
| open_files_limit | 5010 |
| pid_file | /var/lib/mysql/server.hidden.net.pid |
| port | 3306 |
| preload_buffer_size | 32768 |
| prepared_stmt_count | 0 |
| protocol_version | 10 |
| query_alloc_block_size | 8192 |
| query_cache_limit | 1048576 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 33554432 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 8192 |
| range_alloc_block_size | 2048 |
| read_buffer_size | 1044480 |
| read_only | OFF |
| read_rnd_buffer_size | 782336 |
| relay_log_purge | ON |
| relay_log_space_limit | 0 |
| rpl_recovery_rank | 0 |
| secure_auth | OFF |
| server_id | 0 |
| skip_external_locking | ON |
| skip_networking | OFF |
| skip_show_database | OFF |
| slave_net_timeout | 3600 |
| slave_transaction_retries | 0 |
| slow_launch_time | 2 |
| socket | /var/lib/mysql/mysql.sock |
| sort_buffer_size | 2097144 |
| sql_mode | |
| sql_notes | ON |
| sql_warnings | ON |
| storage_engine | MyISAM |
| sync_binlog | 0 |
| sync_frm | ON |
| sync_replication | 0 |
| sync_replication_slave_id | 0 |
| sync_replication_timeout | 0 |
| system_time_zone | CDT |
| table_cache | 1024 |
| table_type | MyISAM |
| thread_cache_size | 64 |
| thread_stack | 196608 |
| time_format | %H:%i:%s |
| time_zone | SYSTEM |
| tmp_table_size | 33554432 |
| tmpdir | |
| transaction_alloc_block_size | 8192 |
| transaction_prealloc_size | 4096 |
| tx_isolation | REPEATABLE-READ |
| version | 4.1.19-standard |
| version_comment | MySQL Community Edition - Standard (GPL) |
| version_compile_machine | i686 |
| version_compile_os | pc-linux-gnu |
| wait_timeout | 1800 |
+---------------------------------+------------------------------------------+
+----------------------------+------------+
| Variable_name | Value |
+----------------------------+------------+
| Aborted_clients | 493 |
| Aborted_connects | 3 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 3644478339 |
| Bytes_sent | 4111174155 |
| Com_admin_commands | 0 |
| Com_alter_db | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 24 |
| Com_change_db | 1964774 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_checksum | 0 |
| Com_commit | 24 |
| Com_create_db | 2 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 40 |
| Com_dealloc_sql | 0 |
| Com_delete | 2734298 |
| Com_delete_multi | 0 |
| Com_do | 0 |
| Com_drop_db | 1 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 40 |
| Com_drop_user | 0 |
| Com_execute_sql | 0 |
| Com_flush | 173 |
| Com_grant | 19 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_help | 0 |
| Com_insert | 366765 |
| Com_insert_select | 955 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 607 |
| Com_optimize | 15 |
| Com_preload_keys | 0 |
| Com_prepare_sql | 0 |
| Com_purge | 0 |
| Com_purge_before_date | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 192240 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_revoke_all | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 10895860 |
| Com_set_option | 4604 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 3 |
| Com_show_charsets | 5 |
| Com_show_collations | 5 |
| Com_show_column_types | 0 |
| Com_show_create_db | 0 |
| Com_show_create_table | 3347 |
| Com_show_databases | 100 |
| Com_show_errors | 0 |
| Com_show_fields | 3400 |
| Com_show_grants | 160 |
| Com_show_innodb_status | 0 |
| Com_show_keys | 28 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_ndb_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_privileges | 0 |
| Com_show_processlist | 1152 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 1133 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 3700 |
| Com_show_variables | 146 |
| Com_show_warnings | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_stmt_close | 0 |
| Com_stmt_execute | 0 |
| Com_stmt_prepare | 0 |
| Com_stmt_reset | 0 |
| Com_stmt_send_long_data | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 644 |
| Com_update | 2505394 |
| Com_update_multi | 334 |
| Connections | 1508399 |
| Created_tmp_disk_tables | 69920 |
| Created_tmp_files | 324806 |
| Created_tmp_tables | 558291 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 309966 |
| Handler_discover | 0 |
| Handler_read_first | 1867811 |
| Handler_read_key | 2169207846 |
| Handler_read_next | 446724290 |
| Handler_read_prev | 18098725 |
| Handler_read_rnd | 75976423 |
| Handler_read_rnd_next | 849050523 |
| Handler_rollback | 1 |
| Handler_update | 3424828 |
| Handler_write | 162682970 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 0 |
| Key_blocks_used | 14497 |
| Key_read_requests | 3136786670 |
| Key_reads | 838173 |
| Key_write_requests | 4012811 |
| Key_writes | 2315420 |
| Max_used_connections | 711 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 1436 |
| Open_streams | 0 |
| Open_tables | 1024 |
| Opened_tables | 8188 |
| Qcache_free_blocks | 3417 |
| Qcache_free_memory | 11000744 |
| Qcache_hits | 16214470 |
| Qcache_inserts | 10592822 |
| Qcache_lowmem_prunes | 387107 |
| Qcache_not_cached | 299598 |
| Qcache_queries_in_cache | 5306 |
| Qcache_total_blocks | 15166 |
| Questions | 36397303 |
| Rpl_status | NULL |
| Select_full_join | 20871 |
| Select_full_range_join | 334 |
| Select_range | 1207958 |
| Select_range_check | 0 |
| Select_scan | 1683531 |
| Slave_open_temp_tables | 0 |
| Slave_retried_transactions | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 15 |
| Slow_queries | 1994 |
| Sort_merge_passes | 162401 |
| Sort_range | 2254872 |
| Sort_rows | 1438044191 |
| Sort_scan | 759960 |
| Table_locks_immediate | 23109373 |
| Table_locks_waited | 206834 |
| Threads_cached | 39 |
| Threads_connected | 25 |
| Threads_created | 5098 |
| Threads_running | 3 |
| Uptime | 345475 |
+----------------------------+------------+
Uptime: 345475 Threads: 24 Questions: 36397320 Slow queries: 1994 Opens: 8188 Flush tables: 1 Open tables: 1024 Queries per second avg: 105.354
mysqladmin Ver 8.41 Distrib 4.1.19, for pc-linux-gnu on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version4.1.19-standard
Protocol version10
ConnectionLocalhost via UNIX socket
UNIX socket/var/lib/mysql/mysql.sock
Uptime:3 days 23 hours 57 min 55 sec
Threads: 24 Questions: 36397320 Slow queries: 1994 Opens: 8188 Flush tables: 1 Open tables: 1024 Queries per second avg: 105.354
Additional mysqlreport information:
root@server [/]# less stats
MySQL 4.1.19-standard uptime 4 0:3:56 Sun Aug 20 20:53:51 2006
__ Key __________________________________________________ _______________
Buffer usage 14.16M of 16.00M %Used: 88.48
Write ratio 0.58
Read ratio 0.00
__ Questions __________________________________________________ _________
Total 36.43M 105.35/s
DMS 16.71M 48.32/s %Total: 45.86
QC Hits 16.23M 46.94/s 44.55
Com_ 1.99M 5.75/s 5.45
COM_QUIT 1.51M 4.37/s 4.15
-Unknown 6.28k 0.02/s 0.02
Slow 2.34k 0.01/s 0.01 %DMS: 0.01
DMS 16.71M 48.32/s 45.86
SELECT 10.90M 31.53/s 29.93 65.26
DELETE 2.74M 7.91/s 7.51 16.38
UPDATE 2.51M 7.25/s 6.88 15.01
INSERT 368.09k 1.06/s 1.01 2.20
REPLACE 192.44k 0.56/s 0.53 1.15
Com_ 1.99M 5.75/s 5.45
change_db 1.97M 5.69/s 5.40
set_option 4.61k 0.01/s 0.01
show_tables 3.70k 0.01/s 0.01
__ SELECT and Sort __________________________________________________ ___
Scan 1.69M 4.87/s %SELECT: 15.45
Range 1.21M 3.50/s 11.09
Full join 20.89k 0.06/s 0.19
Range check 0 0.00/s 0.00
Full rng join 335 0.00/s 0.00
Sort scan 760.52k 2.20/s
Sort range 2.26M 6.52/s
Sort mrg pass 162.51k 0.47/s
__ Query Cache __________________________________________________ _______
Memory usage 22.34M of 32.00M %Used: 69.82
Block Fragmnt 22.46%
Hits 16.23M 46.94/s
Inserts 10.60M 30.65/s
Prunes 387.66k 1.12/s
Insrt:Prune 27.34:1 29.53/s
Hit:Insert 1.53:1
__ Table Locks __________________________________________________ _______
Waited 209.33k 0.61/s %Total: 0.90
Immediate 23.13M 66.87/s
__ Tables __________________________________________________ ____________
Open 1.02k of 1024 %Cache: 100.00
Opened 8.71k 0.03/s
__ Connections __________________________________________________ _______
Max used 718 of 1000 %Max: 71.80
Total 1.51M 4.37/s
__ Created Temp __________________________________________________ ______
Disk table 70.00k 0.20/s
8. There are many scripts that utilize PHP and MySQL. vBulletin is chief among them, but not the sole user.
9. Most users ever online was 221. Average number of concurrent users ranges from 50 - 150. Cookie Session Timeout is 900.
10. PHP Info (http://www.zefron.com/phpinfo.php)
11. KeepAlive On
MaxKeepAliveRequests 0 (unlimited)
KeepAliveTimeout 4
MinSpareServers 15
MaxSpareServers 20
StartServers 10
MaxClients 512
AND Maxrequestsperchild value = 0 (unlimited)
12. 3.6.0 Across all 4 installations... one is still at 3.5.4 but has extremely low traffic (about 5-6 users per day).
13. Nothing jumps out at me.
14. root@server [/]# uname -a
Linux server.bl5.net 2.4.21-40.ELsmp #1 SMP Thu Feb 2 22:22:39 EST 2006 i686 i686 i386 GNU/Linux root@server [/]# uname -a
Linux server.bl5.net 2.4.21-40.ELsmp #1 SMP Thu Feb 2 22:22:39 EST 2006 i686 i686 i386 GNU/Linux
root@server [/]# ulimit -aH
core file size (blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
max locked memory (kbytes, -l) 4
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
stack size (kbytes, -s) unlimited
cpu time (seconds, -t) unlimited
max user processes (-u) 7168
virtual memory (kbytes, -v) unlimited root@server [/]# cat /proc/cpuinfo
processor : 0
vendor_id : GenuineIntel
cpu family : 15
model : 2
model name : Intel(R) Xeon(TM) CPU 2.40GHz
stepping : 9
cpu MHz : 2392.134
cache size : 512 KB
physical id : 0
siblings : 2
runqueue : 0
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 2
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm
bogomips : 4771.02
processor : 1
vendor_id : GenuineIntel
cpu family : 15
model : 2
model name : Intel(R) Xeon(TM) CPU 2.40GHz
stepping : 9
cpu MHz : 2392.134
cache size : 512 KB
physical id : 0
siblings : 2
runqueue : 0
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 2
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm
bogomips : 4771.02
processor : 2
vendor_id : GenuineIntel
cpu family : 15
model : 2
model name : Intel(R) Xeon(TM) CPU 2.40GHz
stepping : 9
cpu MHz : 2392.134
cache size : 512 KB
physical id : 3
siblings : 2
runqueue : 2
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 2
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm
bogomips : 4771.02
processor : 3
vendor_id : GenuineIntel
cpu family : 15
model : 2
model name : Intel(R) Xeon(TM) CPU 2.40GHz
stepping : 9
cpu MHz : 2392.134
cache size : 512 KB
physical id : 3
siblings : 2
runqueue : 2
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 2
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm
bogomips : 4771.02
Thanks!