zfrank
Thu 24th Aug '06, 7:54am
Maybe we can optimize something. Sometimes serverload is high (20-30)
1. Dedicated I run the server with CPanel , we´ve vb and phpadsnew running on this server
2. cpu speed/type single or dual cpus): dual xeon 3,2mhz
how much memory installed: 4GB ram
hard drive type/configuration: 4x SATA 250GB with raid 10
linux distributor or windows version: redhat enterprise 3
apache/IIS version: apache 1.3.37
PHP version: php 4.4.4
MySQL version: mysql 4.1.21
3. No InnoDB-type tables or database in use.
4. Via WHM/CPanel (with Apache)
5. 12:35:56 up 15 days, 23:44, 1 user, load average: 6.81, 8.81, 9.32
315 processes: 313 sleeping, 2 running, 0 zombie, 0 stopped
CPU states: cpu user nice system irq softirq iowait idle
total 49.0% 0.0% 4.2% 0.0% 1.6% 0.8% 44.2%
cpu00 51.4% 0.0% 5.2% 0.1% 5.2% 0.6% 37.1%
cpu01 47.0% 0.0% 5.0% 0.0% 0.4% 1.3% 46.1%
cpu02 48.7% 0.0% 2.9% 0.0% 0.4% 0.5% 47.3%
cpu03 48.8% 0.0% 3.5% 0.0% 0.5% 0.8% 46.2%
Mem: 4027640k av, 3560312k used, 467328k free, 0k shrd, 58776k buff
2623600k actv, 575492k in_d, 67852k in_c
Swap: 2048276k av, 53036k used, 1995240k free 2081088k cached
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
29727 nobody 15 0 18580 18M 7796 S 3.7 0.4 0:01 2 httpd
23555 mysql 17 0 237M 237M 2872 S 3.6 6.0 0:08 1 mysqld
27486 nobody 16 0 20956 20M 11600 S 1.9 0.5 0:09 0 httpd
29730 nobody 16 0 15836 15M 6448 S 1.9 0.3 0:00 3 httpd
27978 nobody 16 0 21124 20M 11540 S 1.8 0.5 0:06 1 httpd
29119 nobody 15 0 19872 19M 9980 S 1.8 0.4 0:06 1 httpd
29518 nobody 15 0 18628 18M 8632 S 1.7 0.4 0:01 2 httpd
21203 nobody 16 0 22300 21M 12524 S 1.6 0.5 0:14 1 httpd
29722 nobody 15 0 17272 16M 8608 S 1.5 0.4 0:00 2 httpd
29598 nobody 15 0 17736 17M 8756 S 1.4 0.4 0:01 3 httpd
29726 nobody 15 0 15244 14M 6976 S 1.4 0.3 0:00 1 httpd
29263 nobody 16 0 17864 17M 8196 S 1.2 0.4 0:02 3 httpd
29541 nobody 16 0 18656 18M 9076 S 1.2 0.4 0:01 2 httpd
29732 nobody 15 0 16392 16M 7732 S 1.2 0.4 0:00 2 httpd
22728 nobody 16 0 21320 20M 11028 S 1.1 0.5 0:01 2 httpd
29538 nobody 16 0 18452 18M 8968 S 1.1 0.4 0:02 0 httpd
26692 nobody 16 0 20872 20M 11968 S 1.0 0.5 0:08 0 httpd
27260 nobody 15 0 20360 19M 11220 S 1.0 0.5 0:14 2 httpd
29543 nobody 16 0 17860 17M 8268 S 1.0 0.4 0:01 1 httpd
29718 nobody 15 0 16952 16M 8204 S 1.0 0.4 0:00 2 httpd
29723 nobody 15 0 11908 11M 5672 S 1.0 0.2 0:00 3 httpd
24290 nobody 16 0 20408 19M 11016 S 0.9 0.5 0:16 0 httpd
24039 nobody 15 0 21620 21M 12344 S 0.8 0.5 0:10 3 httpd
26659 nobody 15 0 22040 21M 11952 S 0.8 0.5 0:07 3 httpd
27267 nobody 15 0 22476 21M 12340 S 0.8 0.5 0:13 1 httpd
29728 nobody 15 0 14368 14M 6956 S 0.8 0.3 0:00 1 httpd
28832 nobody 15 0 21716 21M 11792 S 0.7 0.5 0:07 1 httpd
19804 mysql 15 0 237M 237M 2872 S 0.6 6.0 0:13 1 mysqld
29298 nobody 15 0 18736 18M 9380 S 0.6 0.4 0:03 2 httpd
19805 mysql 15 0 237M 237M 2872 S 0.5 6.0 0:17 1 mysqld
23559 mysql 15 0 237M 237M 2872 S 0.5 6.0 0:06 1 mysqld
29266 nobody 16 0 19772 19M 10012 S 0.5 0.4 0:04 1 httpd
29711 nobody 15 0 18480 18M 9192 S 0.5 0.4 0:01 0 httpd
23491 mysql 16 0 237M 237M 2872 R 0.4 6.0 0:03 1 mysqld
27485 nobody 16 0 18988 18M 9848 S 0.4 0.4 0:14 0 httpd
28835 nobody 15 0 18856 18M 9748 S 0.4 0.4 0:04 3 httpd
29097 nobody 15 0 28488 27M 15360 S 0.4 0.7 0:04 0 httpd
29101 nobody 15 0 20664 20M 11008 S 0.4 0.5 0:05 1 httpd
29734 nobody 17 0 12684 12M 5656 S 0.4 0.3 0:00 1 httpd
20092 mysql 15 0 237M 237M 2872 S 0.3 6.0 0:08 0 mysqld
20698 mysql 15 0 237M 237M 2872 S 0.3 6.0 0:08 3 mysqld
21430 mysql 15 0 237M 237M 2872 S 0.3 6.0 0:08 2 mysqld
27259 nobody 15 0 19332 18M 10900 S 0.3 0.4 0:09 1 httpd
29273 nobody 15 0 19156 18M 10152 S 0.3 0.4 0:04 0 httpd
23629 mysql 15 0 237M 237M 2872 S 0.2 6.0 0:05 1 mysqld
26319 nobody 15 0 29268 28M 16896 S 0.2 0.7 0:09 2 httpd
26685 nobody 15 0 27368 26M 14856 S 0.2 0.6 0:04 3 httpd
27043 nobody 15 0 19672 19M 10176 S 0.2 0.4 0:14 2 httpd
27269 nobody 15 0 20116 19M 11256 S 0.2 0.4 0:14 3 httpd
28852 nobody 15 0 18528 18M 9656 S 0.2 0.4 0:05 3 httpd
28956 nobody 15 0 27308 26M 15088 S 0.2 0.6 0:05 1 httpd
29716 nobody 15 0 14384 14M 6996 S 0.2 0.3 0:00 3 httpd
29717 nobody 15 0 9336 9336 5348 S 0.2 0.2 0:00 3 httpd
19787 mysql 15 0 237M 237M 2872 S 0.1 6.0 0:16 1 mysqld
19821 mysql 15 0 237M 237M 2872 S 0.1 6.0 0:07 2 mysqld
19963 mysql 15 0 237M 237M 2872 S 0.1 6.0 0:08 2 mysqld
19973 mysql 15 0 237M 237M 2872 S 0.1 6.0 0:13 2 mysqld
20089 mysql 15 0 237M 237M 2872 S 0.1 6.0 0:15 1 mysqld
20094 mysql 15 0 237M 237M 2872 S 0.1 6.0 0:20 1 mysqld
21185 nobody 15 0 19208 18M 10500 S 0.1 0.4 0:10 1 httpd
21196 nobody 15 0 18444 18M 9528 S 0.1 0.4 0:19 3 httpd
21423 mysql 15 0 237M 237M 2872 S 0.1 6.0 0:14 3 mysqld
21434 mysql 15 0 237M 237M 2872 S 0.1 6.0 0:08 3 mysqld
23479 mysql 15 0 237M 237M 2872 S 0.1 6.0 0:04 3 mysqld
27039 nobody 15 0 19228 18M 9836 S 0.1 0.4 0:12 3 httpd
27059 nobody 15 0 20712 20M 11180 S 0.1 0.5 0:10 3 httpd
29539 nobody 15 0 16752 16M 7996 S 0.1 0.4 0:01 2 httpd
29544 nobody 15 0 15656 15M 7348 S 0.1 0.3 0:00 2 httpd
29715 nobody 15 0 15932 15M 6928 S 0.1 0.3 0:01 3 httpd
29725 nobody 15 0 8548 8548 5344 S 0.1 0.2 0:00 1 httpd
29733 root 15 0 1252 1252 808 R 0.1 0.0 0:00 0 top
1 root 15 0 488 460 432 S 0.0 0.0 0:30 0 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 2:02 0 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 0:06 2 bdflush
11 root 15 0 0 0 0 SW 0.0 0.0 3:25 2 kswapd
12 root 15 0 0 0 0 SW 0.0 0.0 6:06 1 kscand
14 root 15 0 0 0 0 SW 0.0 0.0 2:11 1 kupdated
15 root 25 0 0 0 0 SW 0.0 0.0 0:00 1 mdrecoveryd
21 root 25 0 0 0 0 SW 0.0 0.0 0:00 3 scsi_eh_0
25 root 24 0 0 0 0 SW 0.0 0.0 0:00 0 scsi_eh_1
26 root 24 0 0 0 0 SW 0.0 0.0 0:00 0 scsi_eh_2
29 root 15 0 0 0 0 SW 0.0 0.0 7:48 1 kjournald
80 root 25 0 0 0 0 SW 0.0 0.0 0:00 1 khubd
506 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kjournald
507 root 25 0 0 0 0 SW 0.0 0.0 0:00 1 kjournald
843 root 15 0 0 0 0 SW 0.0 0.0 0:26 3 loop0
2732 root 15 0 576 552 496 S 0.0 0.0 0:13 2 syslogd
2736 root 15 0 456 444 392 S 0.0 0.0 0:01 2 klogd
2746 root 15 0 448 440 388 S 0.0 0.0 1:03 3 irqbalance
2775 root 15 0 400 380 340 S 0.0 0.0 0:02 2 mdadm
7655 named 25 0 3104 2116 1316 S 0.0 0.0 0:00 0 named
7656 named 15 0 3104 2116 1316 S 0.0 0.0 0:00 2 named
7657 named 15 0 3104 2116 1316 S 0.0 0.0 0:00 0 named
7658 named 15 0 3104 2116 1316 S 0.0 0.0 0:00 2 named
7659 named 15 0 3104 2116 1316 S 0.0 0.0 0:00 2 named
7660 named 15 0 3104 2116 1316 S 0.0 0.0 0:02 3 named
7661 named 15 0 3104 2116 1316 S 0.0 0.0 0:00 0 named
7686 root 20 0 736 664 608 S 0.0 0.0 0:00 2 xinetd
7927 root 15 0 952 932 580 S 0.0 0.0 0:08 2 crond
7950 xfs 15 0 2672 680 604 S 0.0 0.0 0:00 1 xfs
8185 root 15 0 1444 1228 1152 S 0.0 0.0 0:01 1 pure-ftpd
8192 root 15 0 904 728 724 S 0.0 0.0 0:00 3 pure-authd
8250 root 39 19 16600 14M 2004 S N 0.0 0.3 29:09 2 cpanellogd
8295 cpanel 15 0 2104 1792 1404 S 0.0 0.0 0:00 0 stunnel-4.15loc
8297 root 15 0 5936 3768 1416 S 0.0 0.0 0:09 3 cppop
8318 root 15 0 508 500 456 S 0.0 0.0 0:00 3 rhnsd
8381 root 23 0 464 396 392 S 0.0 0.0 0:00 2 portsentry
8423 root 23 0 420 368 364 S 0.0 0.0 0:00 0 mingetty
8424 root 23 0 420 368 364 S 0.0 0.0 0:00 1 mingetty
8425 root 23 0 420 368 364 S 0.0 0.0 0:00 1 mingetty
8426 root 23 0 420 368 364 S 0.0 0.0 0:00 0 mingetty
8427 root 23 0 416 368 364 S 0.0 0.0 0:00 1 mingetty
8428 root 23 0 416 368 364 S 0.0 0.0 0:00 0 mingetty
8429 root 22 0 468 408 404 S 0.0 0.0 0:00 1 agetty
29536 root 18 0 9488 3192 1784 S 0.0 0.0 0:35 2 chkservd
29698 root 15 0 27808 15M 760 S 0.0 0.3 0:21 1 clamd
29704 mailnull 15 0 1888 1732 1552 S 0.0 0.0 0:16 0 exim
29710 mailnull 15 0 1852 1528 1524 S 0.0 0.0 0:00 1 exim
29729 root 15 0 25856 8264 2232 S 0.0 0.2 3:16 1 spamd
29750 root 15 0 1780 1648 1408 S 0.0 0.0 1:43 1 antirelayd
32021 root 15 0 26156 16M 2256 S 0.0 0.4 0:02 1 spamd
14151 root 15 0 1700 1300 1208 S 0.0 0.0 0:11 2 cupsd
26368 root 15 0 5248 5248 2920 S 0.0 0.1 0:16 1 httpd
12528 root 15 0 26156 17M 2256 S 0.0 0.4 0:06 1 spamd
21485 root 15 0 7184 7044 1720 S 0.0 0.1 0:00 2 cpsrvd
30432 root 15 0 1496 1496 1256 S 0.0 0.0 0:00 0 sshd
15859 root 15 0 2032 2032 1656 S 0.0 0.0 0:00 0 sshd
15892 admin 15 0 2524 2524 2092 S 0.0 0.0 0:00 2 sshd
15894 admin 24 0 1316 1316 1104 S 0.0 0.0 0:00 0 bash
15937 root 20 0 952 952 780 S 0.0 0.0 0:00 1 su
16055 root 15 0 1360 1360 1108 S 0.0 0.0 0:00 3 bash
19632 root 25 0 1148 1148 1000 S 0.0 0.0 0:00 3 mysqld_safe
19690 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:05 0 mysqld
19767 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:00 0 mysqld
19774 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:15 3 mysqld
19775 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:07 1 mysqld
19776 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:14 2 mysqld
19777 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:15 1 mysqld
19778 mysql 16 0 237M 237M 2872 S 0.0 6.0 0:12 2 mysqld
19779 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:12 3 mysqld
19785 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:18 1 mysqld
19786 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:13 1 mysqld
19788 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:20 1 mysqld
19806 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:13 2 mysqld
19807 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:07 1 mysqld
19808 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:19 0 mysqld
19810 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:15 0 mysqld
19811 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:13 2 mysqld
19820 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:10 3 mysqld
19822 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:13 1 mysqld
19823 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:14 2 mysqld
19824 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:07 0 mysqld
19964 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:03 2 mysqld
19965 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:11 0 mysqld
19966 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:04 0 mysqld
19967 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:21 0 mysqld
19968 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:09 2 mysqld
19969 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:02 1 mysqld
19970 mysql 16 0 237M 237M 2872 S 0.0 6.0 0:17 2 mysqld
19971 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:13 3 mysqld
19972 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:08 1 mysqld
19974 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:21 2 mysqld
19975 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:06 2 mysqld
19976 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:07 1 mysqld
19977 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:15 2 mysqld
19978 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:08 3 mysqld
19979 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:12 2 mysqld
20027 mailnull 15 0 6336 6336 2100 S 0.0 0.1 0:00 1 eximstats
20090 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:07 3 mysqld
20091 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:20 1 mysqld
20095 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:14 1 mysqld
20223 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:06 2 mysqld
20224 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:15 3 mysqld
20685 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:17 2 mysqld
20686 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:13 1 mysqld
20687 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:17 3 mysqld
20688 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:18 2 mysqld
20689 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:08 3 mysqld
20690 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:05 3 mysqld
20691 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:14 2 mysqld
20692 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:12 0 mysqld
20693 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:07 0 mysqld
20694 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:13 0 mysqld
20695 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:14 3 mysqld
20696 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:13 2 mysqld
20697 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:06 2 mysqld
21104 root 21 0 4272 4272 1980 S 0.0 0.1 0:00 3 leechprotect
21105 nobody 15 0 24004 23M 10200 S 0.0 0.5 0:18 3 httpd
21111 nobody 15 0 18944 18M 10360 S 0.0 0.4 0:07 1 httpd
21135 nobody 15 0 18672 18M 9508 S 0.0 0.4 0:09 2 httpd
21154 nobody 15 0 18828 18M 10120 S 0.0 0.4 0:08 1 httpd
21206 nobody 15 0 18676 18M 9940 S 0.0 0.4 0:06 0 httpd
21214 nobody 15 0 19852 19M 9620 S 0.0 0.4 0:02 0 httpd
21415 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:13 2 mysqld
21416 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:10 1 mysqld
21417 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:19 2 mysqld
21418 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:12 2 mysqld
21419 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:07 3 mysqld
21421 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:05 3 mysqld
21422 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:10 3 mysqld
21424 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:05 0 mysqld
21425 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:17 3 mysqld
21426 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:06 3 mysqld
21427 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:04 3 mysqld
21431 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:03 1 mysqld
21432 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:16 1 mysqld
21433 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:19 1 mysqld
21435 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:07 2 mysqld
22862 nobody 15 0 27780 27M 14664 S 0.0 0.6 0:05 2 httpd
23239 nobody 15 0 19884 19M 9892 S 0.0 0.4 0:04 2 httpd
23422 nobody 16 0 20168 19M 10020 S 0.0 0.5 0:04 3 httpd
23435 nobody 15 0 19804 19M 11452 S 0.0 0.4 0:10 2 httpd
23476 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:06 1 mysqld
23477 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:07 1 mysqld
23478 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:02 2 mysqld
23480 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:04 3 mysqld
23481 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:04 0 mysqld
23482 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:02 0 mysqld
23488 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:02 2 mysqld
23490 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:09 2 mysqld
23492 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:05 1 mysqld
23495 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:08 3 mysqld
23499 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:11 2 mysqld
23508 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:06 0 mysqld
23509 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:09 3 mysqld
23510 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:03 2 mysqld
23511 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:06 2 mysqld
23512 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:08 2 mysqld
23513 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:02 0 mysqld
23521 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:05 2 mysqld
23524 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:11 3 mysqld
23541 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:05 0 mysqld
23545 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:02 3 mysqld
23552 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:12 1 mysqld
23553 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:05 3 mysqld
23554 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:04 3 mysqld
23556 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:04 0 mysqld
23557 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:06 3 mysqld
23558 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:19 3 mysqld
23565 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:04 1 mysqld
23628 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:05 0 mysqld
23630 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:13 0 mysqld
23631 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:06 3 mysqld
23632 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:13 1 mysqld
23633 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:04 3 mysqld
23836 nobody 15 0 16992 16M 7808 S 0.0 0.4 0:00 1 httpd
23849 nobody 15 0 13712 13M 6076 S 0.0 0.3 0:00 1 httpd
23880 nobody 16 0 23196 22M 13044 S 0.0 0.5 0:12 3 httpd
24037 nobody 15 0 21092 20M 11476 S 0.0 0.5 0:11 1 httpd
24274 nobody 15 0 16772 16M 8072 S 0.0 0.4 0:02 0 httpd
24277 nobody 16 0 19668 19M 10460 S 0.0 0.4 0:13 2 httpd
24469 nobody 16 0 20900 20M 11440 S 0.0 0.5 0:12 2 httpd
24473 nobody 15 0 19256 18M 10556 S 0.0 0.4 0:06 2 httpd
24492 nobody 15 0 19220 18M 9684 S 0.0 0.4 0:04 3 httpd
24514 nobody 16 0 20840 20M 10956 S 0.0 0.5 0:10 3 httpd
25574 nobody 15 0 19504 19M 10736 S 0.0 0.4 0:08 1 httpd
25575 nobody 15 0 20528 20M 10436 S 0.0 0.5 0:04 1 httpd
25576 nobody 15 0 16904 16M 8348 S 0.0 0.4 0:03 3 httpd
26484 nobody 15 0 20568 20M 11404 S 0.0 0.5 0:04 0 httpd
26528 nobody 15 0 18872 18M 10060 S 0.0 0.4 0:05 1 httpd
26664 nobody 15 0 20812 20M 11404 S 0.0 0.5 0:10 0 httpd
26687 nobody 15 0 17512 17M 9004 S 0.0 0.4 0:02 0 httpd
26691 nobody 15 0 19988 19M 10164 S 0.0 0.4 0:09 1 httpd
26733 nobody 15 0 21324 20M 12500 S 0.0 0.5 0:12 2 httpd
26734 nobody 15 0 20548 20M 11004 S 0.0 0.5 0:10 0 httpd
27041 nobody 15 0 20192 19M 10964 S 0.0 0.5 0:07 2 httpd
27042 nobody 15 0 20200 19M 11332 S 0.0 0.5 0:13 2 httpd
27053 nobody 15 0 18856 18M 9388 S 0.0 0.4 0:02 0 httpd
27058 nobody 15 0 19196 18M 10116 S 0.0 0.4 0:12 2 httpd
27060 nobody 15 0 19904 19M 9828 S 0.0 0.4 0:13 2 httpd
27065 nobody 15 0 27228 26M 14872 S 0.0 0.6 0:06 0 httpd
27067 nobody 15 0 21540 21M 12196 S 0.0 0.5 0:13 2 httpd
27073 nobody 15 0 18808 18M 9232 S 0.0 0.4 0:04 3 httpd
27107 nobody 15 0 22240 21M 12756 S 0.0 0.5 0:11 3 httpd
27108 nobody 15 0 19076 18M 10552 S 0.0 0.4 0:13 2 httpd
27252 nobody 15 0 17760 17M 9032 S 0.0 0.4 0:04 3 httpd
27254 nobody 16 0 18648 18M 10140 S 0.0 0.4 0:07 2 httpd
27255 nobody 15 0 19604 19M 11084 S 0.0 0.4 0:11 3 httpd
27256 nobody 16 0 18996 18M 9120 S 0.0 0.4 0:03 2 httpd
27257 nobody 15 0 18752 18M 10120 S 0.0 0.4 0:09 2 httpd
27258 nobody 15 0 18832 18M 9728 S 0.0 0.4 0:05 3 httpd
27261 nobody 15 0 19792 19M 10016 S 0.0 0.4 0:09 3 httpd
27262 nobody 15 0 21132 20M 11820 S 0.0 0.5 0:08 1 httpd
27268 nobody 15 0 20232 19M 10456 S 0.0 0.5 0:08 0 httpd
27306 nobody 15 0 19620 19M 10420 S 0.0 0.4 0:06 1 httpd
27308 nobody 15 0 20416 19M 10944 S 0.0 0.5 0:03 1 httpd
27482 nobody 15 0 19136 18M 10360 S 0.0 0.4 0:09 3 httpd
27483 nobody 15 0 19716 19M 9956 S 0.0 0.4 0:10 1 httpd
27484 nobody 15 0 20000 19M 11156 S 0.0 0.4 0:09 2 httpd
27499 nobody 15 0 17300 16M 8676 S 0.0 0.4 0:00 0 httpd
27782 nobody 15 0 18456 18M 9392 S 0.0 0.4 0:08 0 httpd
28670 nobody 15 0 14560 14M 7148 S 0.0 0.3 0:00 2 httpd
28673 nobody 15 0 15364 15M 6320 S 0.0 0.3 0:00 2 httpd
28674 nobody 15 0 15788 15M 6840 S 0.0 0.3 0:00 0 httpd
28677 nobody 15 0 15144 14M 7200 S 0.0 0.3 0:00 1 httpd
28837 nobody 15 0 20304 19M 11392 S 0.0 0.5 0:06 2 httpd
28839 nobody 20 0 6212 6208 3384 S 0.0 0.1 0:00 3 httpd
28872 nobody 15 0 19356 18M 10004 S 0.0 0.4 0:05 3 httpd
28977 nobody 15 0 9376 9376 5392 S 0.0 0.2 0:00 2 httpd
29095 nobody 15 0 27592 26M 15224 S 0.0 0.6 0:04 1 httpd
29098 nobody 15 0 16460 16M 7168 S 0.0 0.4 0:01 2 httpd
29283 nobody 15 0 17840 17M 8968 S 0.0 0.4 0:02 2 httpd
29356 nobody 15 0 19204 18M 9196 S 0.0 0.4 0:01 3 httpd
29391 nobody 15 0 16012 15M 7476 S 0.0 0.3 0:01 1 httpd
29517 nobody 15 0 17320 16M 8496 S 0.0 0.4 0:01 0 httpd
29724 nobody 15 0 11376 11M 5076 S 0.0 0.2 0:00 2 httpd
29735 nobody 19 0 6600 6600 3732 S 0.0 0.1 0:00 3 httpd6. [mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
max_connections = 500
back_log = 75
key_buffer = 64M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1800
thread_cache_size = 384
wait_timeout = 15
tmp_table_size = 128M
max_heap_table_size = 64M
connect_timeout = 10
max_allowed_packet = 64M
max_connect_errors = 10
read_rnd_buffer_size = 524288
bulk_insert_buffer_size = 8M
thread_concurrency = 2
query_cache_limit = 3M
query_cache_size = 128M
query_cache_type = 1
query_prealloc_size = 163840
query_alloc_block_size = 32768
default-storage-engine = MyISAM
ft_min_word_len = 3
skip-innodb
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[mysqlhotcopy]
interactive-timeout7. +---------------------------------+------------------------------------------+
| Variable_name | Value |
+---------------------------------+------------------------------------------+
| back_log | 75 |
| 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 | 3 |
| 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 | DISABLED |
| have_isam | NO |
| have_ndbcluster | NO |
| have_merge_engine | YES |
| 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 | |
| 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 | 28800 |
| join_buffer_size | 1044480 |
| key_buffer_size | 67108864 |
| key_cache_age_threshold | 300 |
| key_cache_block_size | 1024 |
| key_cache_division_limit | 100 |
| language | /usr/share/mysql/english/ |
| large_files_support | ON |
| lc_time_names | en_US |
| 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 | 67107840 |
| max_binlog_cache_size | 4294967295 |
| max_binlog_size | 1073741824 |
| max_connect_errors | 10 |
| max_connections | 500 |
| max_delayed_threads | 20 |
| max_error_count | 64 |
| max_heap_table_size | 67107840 |
| 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 | OFF |
| open_files_limit | 4110 |
| pid_file | /var/lib/mysql/dual32.gsmhosting.com.pid |
| port | 3306 |
| preload_buffer_size | 32768 |
| prepared_stmt_count | 0 |
| protocol_version | 10 |
| query_alloc_block_size | 32768 |
| query_cache_limit | 3145728 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 134217728 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 163840 |
| range_alloc_block_size | 2048 |
| read_buffer_size | 1044480 |
| read_only | OFF |
| read_rnd_buffer_size | 520192 |
| 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 | CEST |
| table_cache | 1800 |
| table_type | MyISAM |
| thread_cache_size | 384 |
| thread_stack | 196608 |
| time_format | %H:%i:%s |
| time_zone | SYSTEM |
| tmp_table_size | 134217728 |
| tmpdir | |
| transaction_alloc_block_size | 8192 |
| transaction_prealloc_size | 4096 |
| tx_isolation | REPEATABLE-READ |
| version | 4.1.21-standard |
| version_comment | MySQL Community Edition - Standard (GPL) |
| version_compile_machine | i686 |
| version_compile_os | pc-linux-gnu |
| wait_timeout | 15 |
+---------------------------------+------------------------------------------+
+----------------------------+------------+
| Variable_name | Value |
+----------------------------+------------+
| Aborted_clients | 92 |
| Aborted_connects | 4 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 182338674 |
| Bytes_sent | 3114054342 |
| Com_admin_commands | 0 |
| Com_alter_db | 0 |
| Com_alter_table | 33 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 3 |
| Com_change_db | 77825 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_checksum | 0 |
| Com_commit | 3 |
| Com_create_db | 2 |
| Com_create_function | 0 |
| Com_create_index | 43 |
| Com_create_table | 24 |
| Com_dealloc_sql | 0 |
| Com_delete | 1394 |
| Com_delete_multi | 0 |
| Com_do | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_drop_user | 0 |
| Com_execute_sql | 0 |
| Com_flush | 4 |
| Com_grant | 23 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_help | 0 |
| Com_insert | 10845 |
| Com_insert_select | 0 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 897 |
| Com_optimize | 0 |
| 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 | 2328 |
| 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 | 189886 |
| Com_set_option | 16 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_charsets | 0 |
| Com_show_collations | 0 |
| Com_show_column_types | 0 |
| Com_show_create_db | 0 |
| Com_show_create_table | 0 |
| Com_show_databases | 0 |
| Com_show_errors | 0 |
| Com_show_fields | 0 |
| Com_show_grants | 0 |
| Com_show_innodb_status | 0 |
| Com_show_keys | 0 |
| 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 | 7 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 1 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 0 |
| Com_show_variables | 1 |
| 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 | 897 |
| Com_update | 46223 |
| Com_update_multi | 0 |
| Connections | 77845 |
| Created_tmp_disk_tables | 24 |
| Created_tmp_files | 80 |
| Created_tmp_tables | 97063 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 3834 |
| Handler_discover | 0 |
| Handler_read_first | 118516 |
| Handler_read_key | 12220832 |
| Handler_read_next | 13296476 |
| Handler_read_prev | 286147 |
| Handler_read_rnd | 2230038 |
| Handler_read_rnd_next | 68761000 |
| Handler_rollback | 0 |
| Handler_update | 50672 |
| Handler_write | 1901849 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 0 |
| Key_blocks_used | 57990 |
| Key_read_requests | 175671784 |
| Key_reads | 278028 |
| Key_write_requests | 27141 |
| Key_writes | 18137 |
| Max_used_connections | 117 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 877 |
| Open_streams | 0 |
| Open_tables | 797 |
| Opened_tables | 836 |
| Qcache_free_blocks | 1427 |
| Qcache_free_memory | 6340872 |
| Qcache_hits | 244062 |
| Qcache_inserts | 188076 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 1383 |
| Qcache_queries_in_cache | 99709 |
| Qcache_total_blocks | 201087 |
| Questions | 652267 |
| Rpl_status | NULL |
| Select_full_join | 0 |
| Select_full_range_join | 0 |
| Select_range | 116832 |
| Select_range_check | 0 |
| Select_scan | 15548 |
| Slave_open_temp_tables | 0 |
| Slave_retried_transactions | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 5 |
| Sort_merge_passes | 40 |
| Sort_range | 113088 |
| Sort_rows | 5128759 |
| Sort_scan | 8384 |
| Table_locks_immediate | 476779 |
| Table_locks_waited | 9438 |
| Threads_cached | 86 |
| Threads_connected | 31 |
| Threads_created | 117 |
| Threads_running | 2 |
| Uptime | 2160 |
+----------------------------+------------+
Uptime: 2160 Threads: 29 Questions: 652361 Slow queries: 5 Opens: 836 Flush tables: 1 Open tables: 797 Queries per second avg: 302.019
mysqladmin Ver 8.41 Distrib 4.1.21, 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 version 4.1.21-standard
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 36 min 0 sec
Threads: 29 Questions: 652361 Slow queries: 5 Opens: 836 Flush tables: 1 Open tables: 797 Queries per second avg: 302.019root@dual32 [~]# ./mysqlreport --all -tab
MySQL 4.1.21-standard uptime 0 1:35:56 Thu Aug 24 13:38:41 2006
__ Key __________________________________________________ _______________
Buffer usage 56.63M of 64.00M %Used: 88.49
Write ratio 0.70
Read ratio 0.00
__ Questions __________________________________________________ _________
Total 1.74M 301.79/s
DMS 683.60k 118.76/s %Total: 39.35
QC Hits 636.32k 110.55/s 36.63
Com_ 210.74k 36.61/s 12.13
COM_QUIT 206.48k 35.87/s 11.89
-Unknown 19 0.00/s 0.00
Slow 34 0.01/s 0.00 %DMS: 0.00
DMS 683.60k 118.76/s 39.35
SELECT 520.82k 90.48/s 29.98 76.19
UPDATE 124.98k 21.71/s 7.19 18.28
INSERT 28.19k 4.90/s 1.62 4.12
REPLACE 6.42k 1.12/s 0.37 0.94
DELETE 3.18k 0.55/s 0.18 0.47
Com_ 210.74k 36.61/s 12.13
change_db 206.47k 35.87/s 11.89
lock_tables 2.03k 0.35/s 0.12
unlock_tabl 2.03k 0.35/s 0.12
__ SELECT and Sort __________________________________________________ ___
Scan 42.52k 7.39/s %SELECT: 8.16
Range 322.77k 56.08/s 61.97
Full join 3 0.00/s 0.00
Range check 0 0.00/s 0.00
Full rng join 0 0.00/s 0.00
Sort scan 22.64k 3.93/s
Sort range 314.37k 54.62/s
Sort mrg pass 119 0.02/s
__ Query Cache __________________________________________________ _______
Memory usage 85.10M of 128.00M %Used: 66.49
Block Fragmnt 3.08%
Hits 636.32k 110.5/s
Inserts 516.12k 89.67/s
Prunes 204.87k 35.59/s
Insrt:Prune 2.52:1 54.07/s
Hit:Insert 1.23:1
__ Table Locks __________________________________________________ _______
Waited 23.06k 4.01/s %Total: 1.73
Immediate 1.31M 227.32/s
__ Tables __________________________________________________ ____________
Open 876 of 1800 %Cache: 48.67
Opened 915 0.16/s
__ Connections __________________________________________________ _______
Max used 117 of 500 %Max: 23.40
Total 206.53k 35.88/s
__ Created Temp __________________________________________________ ______
Disk table 91 0.02/s
Table 270.33k 46.96/s
File 238 0.04/s
__ Threads __________________________________________________ ___________
Running 2 of 33
Cache 84 %Hit: 99.94
Created 117 0.02/s
Slow 0 0.00/s
__ Aborted __________________________________________________ ___________
Clients 94 0.02/s
Connects 4 0.00/s
__ Bytes __________________________________________________ _____________
Sent 1.84G 320.52/s
Received 486.24M 84.47k/s8. phpadsnew is running with 2 banners
9. Most users ever online was 2805. Average number of concurrent users ranges from 1900-2500. Cookie Session Timeout is 1800.
10. http://forum.gsmhosting.com/phpinfogsm.php
11.
KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 5
MinSpareServers 10
MaxSpareServers 15
StartServers 10
MaxClients 150
Maxrequestsperchild 500
12. vb3.6.0
13. no logfiles over 2GB
14. Linux dual32.gsmhosting.com 2.4.21-47.ELsmp #1 SMP Wed Jul 5 20:38:41 EDT 2006 i686 i686 i386 GNU/Linuxcore file size (blocks, -c) 1000000
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) 4096
pipe size (512 bytes, -p) 8
stack size (kbytes, -s) 8192
cpu time (seconds, -t) unlimited
max user processes (-u) 14335
virtual memory (kbytes, -v) unlimitedprocessor : 0
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 3.20GHz
stepping : 3
cpu MHz : 3192.121
cache size : 2048 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 : 3
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 nx lm
bogomips : 6370.09
processor : 1
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 3.20GHz
stepping : 3
cpu MHz : 3192.121
cache size : 2048 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 : 3
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 nx lm
bogomips : 6383.20
processor : 2
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 3.20GHz
stepping : 3
cpu MHz : 3192.121
cache size : 2048 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 : 3
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 nx lm
bogomips : 6383.20
processor : 3
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 3.20GHz
stepping : 3
cpu MHz : 3192.121
cache size : 2048 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 : 3
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 nx lm
bogomips : 6383.20
1. Dedicated I run the server with CPanel , we´ve vb and phpadsnew running on this server
2. cpu speed/type single or dual cpus): dual xeon 3,2mhz
how much memory installed: 4GB ram
hard drive type/configuration: 4x SATA 250GB with raid 10
linux distributor or windows version: redhat enterprise 3
apache/IIS version: apache 1.3.37
PHP version: php 4.4.4
MySQL version: mysql 4.1.21
3. No InnoDB-type tables or database in use.
4. Via WHM/CPanel (with Apache)
5. 12:35:56 up 15 days, 23:44, 1 user, load average: 6.81, 8.81, 9.32
315 processes: 313 sleeping, 2 running, 0 zombie, 0 stopped
CPU states: cpu user nice system irq softirq iowait idle
total 49.0% 0.0% 4.2% 0.0% 1.6% 0.8% 44.2%
cpu00 51.4% 0.0% 5.2% 0.1% 5.2% 0.6% 37.1%
cpu01 47.0% 0.0% 5.0% 0.0% 0.4% 1.3% 46.1%
cpu02 48.7% 0.0% 2.9% 0.0% 0.4% 0.5% 47.3%
cpu03 48.8% 0.0% 3.5% 0.0% 0.5% 0.8% 46.2%
Mem: 4027640k av, 3560312k used, 467328k free, 0k shrd, 58776k buff
2623600k actv, 575492k in_d, 67852k in_c
Swap: 2048276k av, 53036k used, 1995240k free 2081088k cached
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
29727 nobody 15 0 18580 18M 7796 S 3.7 0.4 0:01 2 httpd
23555 mysql 17 0 237M 237M 2872 S 3.6 6.0 0:08 1 mysqld
27486 nobody 16 0 20956 20M 11600 S 1.9 0.5 0:09 0 httpd
29730 nobody 16 0 15836 15M 6448 S 1.9 0.3 0:00 3 httpd
27978 nobody 16 0 21124 20M 11540 S 1.8 0.5 0:06 1 httpd
29119 nobody 15 0 19872 19M 9980 S 1.8 0.4 0:06 1 httpd
29518 nobody 15 0 18628 18M 8632 S 1.7 0.4 0:01 2 httpd
21203 nobody 16 0 22300 21M 12524 S 1.6 0.5 0:14 1 httpd
29722 nobody 15 0 17272 16M 8608 S 1.5 0.4 0:00 2 httpd
29598 nobody 15 0 17736 17M 8756 S 1.4 0.4 0:01 3 httpd
29726 nobody 15 0 15244 14M 6976 S 1.4 0.3 0:00 1 httpd
29263 nobody 16 0 17864 17M 8196 S 1.2 0.4 0:02 3 httpd
29541 nobody 16 0 18656 18M 9076 S 1.2 0.4 0:01 2 httpd
29732 nobody 15 0 16392 16M 7732 S 1.2 0.4 0:00 2 httpd
22728 nobody 16 0 21320 20M 11028 S 1.1 0.5 0:01 2 httpd
29538 nobody 16 0 18452 18M 8968 S 1.1 0.4 0:02 0 httpd
26692 nobody 16 0 20872 20M 11968 S 1.0 0.5 0:08 0 httpd
27260 nobody 15 0 20360 19M 11220 S 1.0 0.5 0:14 2 httpd
29543 nobody 16 0 17860 17M 8268 S 1.0 0.4 0:01 1 httpd
29718 nobody 15 0 16952 16M 8204 S 1.0 0.4 0:00 2 httpd
29723 nobody 15 0 11908 11M 5672 S 1.0 0.2 0:00 3 httpd
24290 nobody 16 0 20408 19M 11016 S 0.9 0.5 0:16 0 httpd
24039 nobody 15 0 21620 21M 12344 S 0.8 0.5 0:10 3 httpd
26659 nobody 15 0 22040 21M 11952 S 0.8 0.5 0:07 3 httpd
27267 nobody 15 0 22476 21M 12340 S 0.8 0.5 0:13 1 httpd
29728 nobody 15 0 14368 14M 6956 S 0.8 0.3 0:00 1 httpd
28832 nobody 15 0 21716 21M 11792 S 0.7 0.5 0:07 1 httpd
19804 mysql 15 0 237M 237M 2872 S 0.6 6.0 0:13 1 mysqld
29298 nobody 15 0 18736 18M 9380 S 0.6 0.4 0:03 2 httpd
19805 mysql 15 0 237M 237M 2872 S 0.5 6.0 0:17 1 mysqld
23559 mysql 15 0 237M 237M 2872 S 0.5 6.0 0:06 1 mysqld
29266 nobody 16 0 19772 19M 10012 S 0.5 0.4 0:04 1 httpd
29711 nobody 15 0 18480 18M 9192 S 0.5 0.4 0:01 0 httpd
23491 mysql 16 0 237M 237M 2872 R 0.4 6.0 0:03 1 mysqld
27485 nobody 16 0 18988 18M 9848 S 0.4 0.4 0:14 0 httpd
28835 nobody 15 0 18856 18M 9748 S 0.4 0.4 0:04 3 httpd
29097 nobody 15 0 28488 27M 15360 S 0.4 0.7 0:04 0 httpd
29101 nobody 15 0 20664 20M 11008 S 0.4 0.5 0:05 1 httpd
29734 nobody 17 0 12684 12M 5656 S 0.4 0.3 0:00 1 httpd
20092 mysql 15 0 237M 237M 2872 S 0.3 6.0 0:08 0 mysqld
20698 mysql 15 0 237M 237M 2872 S 0.3 6.0 0:08 3 mysqld
21430 mysql 15 0 237M 237M 2872 S 0.3 6.0 0:08 2 mysqld
27259 nobody 15 0 19332 18M 10900 S 0.3 0.4 0:09 1 httpd
29273 nobody 15 0 19156 18M 10152 S 0.3 0.4 0:04 0 httpd
23629 mysql 15 0 237M 237M 2872 S 0.2 6.0 0:05 1 mysqld
26319 nobody 15 0 29268 28M 16896 S 0.2 0.7 0:09 2 httpd
26685 nobody 15 0 27368 26M 14856 S 0.2 0.6 0:04 3 httpd
27043 nobody 15 0 19672 19M 10176 S 0.2 0.4 0:14 2 httpd
27269 nobody 15 0 20116 19M 11256 S 0.2 0.4 0:14 3 httpd
28852 nobody 15 0 18528 18M 9656 S 0.2 0.4 0:05 3 httpd
28956 nobody 15 0 27308 26M 15088 S 0.2 0.6 0:05 1 httpd
29716 nobody 15 0 14384 14M 6996 S 0.2 0.3 0:00 3 httpd
29717 nobody 15 0 9336 9336 5348 S 0.2 0.2 0:00 3 httpd
19787 mysql 15 0 237M 237M 2872 S 0.1 6.0 0:16 1 mysqld
19821 mysql 15 0 237M 237M 2872 S 0.1 6.0 0:07 2 mysqld
19963 mysql 15 0 237M 237M 2872 S 0.1 6.0 0:08 2 mysqld
19973 mysql 15 0 237M 237M 2872 S 0.1 6.0 0:13 2 mysqld
20089 mysql 15 0 237M 237M 2872 S 0.1 6.0 0:15 1 mysqld
20094 mysql 15 0 237M 237M 2872 S 0.1 6.0 0:20 1 mysqld
21185 nobody 15 0 19208 18M 10500 S 0.1 0.4 0:10 1 httpd
21196 nobody 15 0 18444 18M 9528 S 0.1 0.4 0:19 3 httpd
21423 mysql 15 0 237M 237M 2872 S 0.1 6.0 0:14 3 mysqld
21434 mysql 15 0 237M 237M 2872 S 0.1 6.0 0:08 3 mysqld
23479 mysql 15 0 237M 237M 2872 S 0.1 6.0 0:04 3 mysqld
27039 nobody 15 0 19228 18M 9836 S 0.1 0.4 0:12 3 httpd
27059 nobody 15 0 20712 20M 11180 S 0.1 0.5 0:10 3 httpd
29539 nobody 15 0 16752 16M 7996 S 0.1 0.4 0:01 2 httpd
29544 nobody 15 0 15656 15M 7348 S 0.1 0.3 0:00 2 httpd
29715 nobody 15 0 15932 15M 6928 S 0.1 0.3 0:01 3 httpd
29725 nobody 15 0 8548 8548 5344 S 0.1 0.2 0:00 1 httpd
29733 root 15 0 1252 1252 808 R 0.1 0.0 0:00 0 top
1 root 15 0 488 460 432 S 0.0 0.0 0:30 0 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 2:02 0 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 0:06 2 bdflush
11 root 15 0 0 0 0 SW 0.0 0.0 3:25 2 kswapd
12 root 15 0 0 0 0 SW 0.0 0.0 6:06 1 kscand
14 root 15 0 0 0 0 SW 0.0 0.0 2:11 1 kupdated
15 root 25 0 0 0 0 SW 0.0 0.0 0:00 1 mdrecoveryd
21 root 25 0 0 0 0 SW 0.0 0.0 0:00 3 scsi_eh_0
25 root 24 0 0 0 0 SW 0.0 0.0 0:00 0 scsi_eh_1
26 root 24 0 0 0 0 SW 0.0 0.0 0:00 0 scsi_eh_2
29 root 15 0 0 0 0 SW 0.0 0.0 7:48 1 kjournald
80 root 25 0 0 0 0 SW 0.0 0.0 0:00 1 khubd
506 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kjournald
507 root 25 0 0 0 0 SW 0.0 0.0 0:00 1 kjournald
843 root 15 0 0 0 0 SW 0.0 0.0 0:26 3 loop0
2732 root 15 0 576 552 496 S 0.0 0.0 0:13 2 syslogd
2736 root 15 0 456 444 392 S 0.0 0.0 0:01 2 klogd
2746 root 15 0 448 440 388 S 0.0 0.0 1:03 3 irqbalance
2775 root 15 0 400 380 340 S 0.0 0.0 0:02 2 mdadm
7655 named 25 0 3104 2116 1316 S 0.0 0.0 0:00 0 named
7656 named 15 0 3104 2116 1316 S 0.0 0.0 0:00 2 named
7657 named 15 0 3104 2116 1316 S 0.0 0.0 0:00 0 named
7658 named 15 0 3104 2116 1316 S 0.0 0.0 0:00 2 named
7659 named 15 0 3104 2116 1316 S 0.0 0.0 0:00 2 named
7660 named 15 0 3104 2116 1316 S 0.0 0.0 0:02 3 named
7661 named 15 0 3104 2116 1316 S 0.0 0.0 0:00 0 named
7686 root 20 0 736 664 608 S 0.0 0.0 0:00 2 xinetd
7927 root 15 0 952 932 580 S 0.0 0.0 0:08 2 crond
7950 xfs 15 0 2672 680 604 S 0.0 0.0 0:00 1 xfs
8185 root 15 0 1444 1228 1152 S 0.0 0.0 0:01 1 pure-ftpd
8192 root 15 0 904 728 724 S 0.0 0.0 0:00 3 pure-authd
8250 root 39 19 16600 14M 2004 S N 0.0 0.3 29:09 2 cpanellogd
8295 cpanel 15 0 2104 1792 1404 S 0.0 0.0 0:00 0 stunnel-4.15loc
8297 root 15 0 5936 3768 1416 S 0.0 0.0 0:09 3 cppop
8318 root 15 0 508 500 456 S 0.0 0.0 0:00 3 rhnsd
8381 root 23 0 464 396 392 S 0.0 0.0 0:00 2 portsentry
8423 root 23 0 420 368 364 S 0.0 0.0 0:00 0 mingetty
8424 root 23 0 420 368 364 S 0.0 0.0 0:00 1 mingetty
8425 root 23 0 420 368 364 S 0.0 0.0 0:00 1 mingetty
8426 root 23 0 420 368 364 S 0.0 0.0 0:00 0 mingetty
8427 root 23 0 416 368 364 S 0.0 0.0 0:00 1 mingetty
8428 root 23 0 416 368 364 S 0.0 0.0 0:00 0 mingetty
8429 root 22 0 468 408 404 S 0.0 0.0 0:00 1 agetty
29536 root 18 0 9488 3192 1784 S 0.0 0.0 0:35 2 chkservd
29698 root 15 0 27808 15M 760 S 0.0 0.3 0:21 1 clamd
29704 mailnull 15 0 1888 1732 1552 S 0.0 0.0 0:16 0 exim
29710 mailnull 15 0 1852 1528 1524 S 0.0 0.0 0:00 1 exim
29729 root 15 0 25856 8264 2232 S 0.0 0.2 3:16 1 spamd
29750 root 15 0 1780 1648 1408 S 0.0 0.0 1:43 1 antirelayd
32021 root 15 0 26156 16M 2256 S 0.0 0.4 0:02 1 spamd
14151 root 15 0 1700 1300 1208 S 0.0 0.0 0:11 2 cupsd
26368 root 15 0 5248 5248 2920 S 0.0 0.1 0:16 1 httpd
12528 root 15 0 26156 17M 2256 S 0.0 0.4 0:06 1 spamd
21485 root 15 0 7184 7044 1720 S 0.0 0.1 0:00 2 cpsrvd
30432 root 15 0 1496 1496 1256 S 0.0 0.0 0:00 0 sshd
15859 root 15 0 2032 2032 1656 S 0.0 0.0 0:00 0 sshd
15892 admin 15 0 2524 2524 2092 S 0.0 0.0 0:00 2 sshd
15894 admin 24 0 1316 1316 1104 S 0.0 0.0 0:00 0 bash
15937 root 20 0 952 952 780 S 0.0 0.0 0:00 1 su
16055 root 15 0 1360 1360 1108 S 0.0 0.0 0:00 3 bash
19632 root 25 0 1148 1148 1000 S 0.0 0.0 0:00 3 mysqld_safe
19690 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:05 0 mysqld
19767 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:00 0 mysqld
19774 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:15 3 mysqld
19775 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:07 1 mysqld
19776 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:14 2 mysqld
19777 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:15 1 mysqld
19778 mysql 16 0 237M 237M 2872 S 0.0 6.0 0:12 2 mysqld
19779 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:12 3 mysqld
19785 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:18 1 mysqld
19786 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:13 1 mysqld
19788 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:20 1 mysqld
19806 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:13 2 mysqld
19807 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:07 1 mysqld
19808 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:19 0 mysqld
19810 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:15 0 mysqld
19811 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:13 2 mysqld
19820 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:10 3 mysqld
19822 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:13 1 mysqld
19823 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:14 2 mysqld
19824 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:07 0 mysqld
19964 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:03 2 mysqld
19965 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:11 0 mysqld
19966 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:04 0 mysqld
19967 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:21 0 mysqld
19968 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:09 2 mysqld
19969 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:02 1 mysqld
19970 mysql 16 0 237M 237M 2872 S 0.0 6.0 0:17 2 mysqld
19971 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:13 3 mysqld
19972 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:08 1 mysqld
19974 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:21 2 mysqld
19975 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:06 2 mysqld
19976 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:07 1 mysqld
19977 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:15 2 mysqld
19978 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:08 3 mysqld
19979 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:12 2 mysqld
20027 mailnull 15 0 6336 6336 2100 S 0.0 0.1 0:00 1 eximstats
20090 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:07 3 mysqld
20091 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:20 1 mysqld
20095 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:14 1 mysqld
20223 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:06 2 mysqld
20224 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:15 3 mysqld
20685 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:17 2 mysqld
20686 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:13 1 mysqld
20687 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:17 3 mysqld
20688 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:18 2 mysqld
20689 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:08 3 mysqld
20690 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:05 3 mysqld
20691 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:14 2 mysqld
20692 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:12 0 mysqld
20693 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:07 0 mysqld
20694 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:13 0 mysqld
20695 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:14 3 mysqld
20696 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:13 2 mysqld
20697 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:06 2 mysqld
21104 root 21 0 4272 4272 1980 S 0.0 0.1 0:00 3 leechprotect
21105 nobody 15 0 24004 23M 10200 S 0.0 0.5 0:18 3 httpd
21111 nobody 15 0 18944 18M 10360 S 0.0 0.4 0:07 1 httpd
21135 nobody 15 0 18672 18M 9508 S 0.0 0.4 0:09 2 httpd
21154 nobody 15 0 18828 18M 10120 S 0.0 0.4 0:08 1 httpd
21206 nobody 15 0 18676 18M 9940 S 0.0 0.4 0:06 0 httpd
21214 nobody 15 0 19852 19M 9620 S 0.0 0.4 0:02 0 httpd
21415 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:13 2 mysqld
21416 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:10 1 mysqld
21417 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:19 2 mysqld
21418 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:12 2 mysqld
21419 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:07 3 mysqld
21421 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:05 3 mysqld
21422 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:10 3 mysqld
21424 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:05 0 mysqld
21425 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:17 3 mysqld
21426 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:06 3 mysqld
21427 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:04 3 mysqld
21431 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:03 1 mysqld
21432 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:16 1 mysqld
21433 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:19 1 mysqld
21435 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:07 2 mysqld
22862 nobody 15 0 27780 27M 14664 S 0.0 0.6 0:05 2 httpd
23239 nobody 15 0 19884 19M 9892 S 0.0 0.4 0:04 2 httpd
23422 nobody 16 0 20168 19M 10020 S 0.0 0.5 0:04 3 httpd
23435 nobody 15 0 19804 19M 11452 S 0.0 0.4 0:10 2 httpd
23476 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:06 1 mysqld
23477 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:07 1 mysqld
23478 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:02 2 mysqld
23480 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:04 3 mysqld
23481 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:04 0 mysqld
23482 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:02 0 mysqld
23488 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:02 2 mysqld
23490 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:09 2 mysqld
23492 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:05 1 mysqld
23495 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:08 3 mysqld
23499 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:11 2 mysqld
23508 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:06 0 mysqld
23509 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:09 3 mysqld
23510 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:03 2 mysqld
23511 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:06 2 mysqld
23512 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:08 2 mysqld
23513 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:02 0 mysqld
23521 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:05 2 mysqld
23524 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:11 3 mysqld
23541 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:05 0 mysqld
23545 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:02 3 mysqld
23552 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:12 1 mysqld
23553 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:05 3 mysqld
23554 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:04 3 mysqld
23556 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:04 0 mysqld
23557 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:06 3 mysqld
23558 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:19 3 mysqld
23565 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:04 1 mysqld
23628 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:05 0 mysqld
23630 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:13 0 mysqld
23631 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:06 3 mysqld
23632 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:13 1 mysqld
23633 mysql 15 0 237M 237M 2872 S 0.0 6.0 0:04 3 mysqld
23836 nobody 15 0 16992 16M 7808 S 0.0 0.4 0:00 1 httpd
23849 nobody 15 0 13712 13M 6076 S 0.0 0.3 0:00 1 httpd
23880 nobody 16 0 23196 22M 13044 S 0.0 0.5 0:12 3 httpd
24037 nobody 15 0 21092 20M 11476 S 0.0 0.5 0:11 1 httpd
24274 nobody 15 0 16772 16M 8072 S 0.0 0.4 0:02 0 httpd
24277 nobody 16 0 19668 19M 10460 S 0.0 0.4 0:13 2 httpd
24469 nobody 16 0 20900 20M 11440 S 0.0 0.5 0:12 2 httpd
24473 nobody 15 0 19256 18M 10556 S 0.0 0.4 0:06 2 httpd
24492 nobody 15 0 19220 18M 9684 S 0.0 0.4 0:04 3 httpd
24514 nobody 16 0 20840 20M 10956 S 0.0 0.5 0:10 3 httpd
25574 nobody 15 0 19504 19M 10736 S 0.0 0.4 0:08 1 httpd
25575 nobody 15 0 20528 20M 10436 S 0.0 0.5 0:04 1 httpd
25576 nobody 15 0 16904 16M 8348 S 0.0 0.4 0:03 3 httpd
26484 nobody 15 0 20568 20M 11404 S 0.0 0.5 0:04 0 httpd
26528 nobody 15 0 18872 18M 10060 S 0.0 0.4 0:05 1 httpd
26664 nobody 15 0 20812 20M 11404 S 0.0 0.5 0:10 0 httpd
26687 nobody 15 0 17512 17M 9004 S 0.0 0.4 0:02 0 httpd
26691 nobody 15 0 19988 19M 10164 S 0.0 0.4 0:09 1 httpd
26733 nobody 15 0 21324 20M 12500 S 0.0 0.5 0:12 2 httpd
26734 nobody 15 0 20548 20M 11004 S 0.0 0.5 0:10 0 httpd
27041 nobody 15 0 20192 19M 10964 S 0.0 0.5 0:07 2 httpd
27042 nobody 15 0 20200 19M 11332 S 0.0 0.5 0:13 2 httpd
27053 nobody 15 0 18856 18M 9388 S 0.0 0.4 0:02 0 httpd
27058 nobody 15 0 19196 18M 10116 S 0.0 0.4 0:12 2 httpd
27060 nobody 15 0 19904 19M 9828 S 0.0 0.4 0:13 2 httpd
27065 nobody 15 0 27228 26M 14872 S 0.0 0.6 0:06 0 httpd
27067 nobody 15 0 21540 21M 12196 S 0.0 0.5 0:13 2 httpd
27073 nobody 15 0 18808 18M 9232 S 0.0 0.4 0:04 3 httpd
27107 nobody 15 0 22240 21M 12756 S 0.0 0.5 0:11 3 httpd
27108 nobody 15 0 19076 18M 10552 S 0.0 0.4 0:13 2 httpd
27252 nobody 15 0 17760 17M 9032 S 0.0 0.4 0:04 3 httpd
27254 nobody 16 0 18648 18M 10140 S 0.0 0.4 0:07 2 httpd
27255 nobody 15 0 19604 19M 11084 S 0.0 0.4 0:11 3 httpd
27256 nobody 16 0 18996 18M 9120 S 0.0 0.4 0:03 2 httpd
27257 nobody 15 0 18752 18M 10120 S 0.0 0.4 0:09 2 httpd
27258 nobody 15 0 18832 18M 9728 S 0.0 0.4 0:05 3 httpd
27261 nobody 15 0 19792 19M 10016 S 0.0 0.4 0:09 3 httpd
27262 nobody 15 0 21132 20M 11820 S 0.0 0.5 0:08 1 httpd
27268 nobody 15 0 20232 19M 10456 S 0.0 0.5 0:08 0 httpd
27306 nobody 15 0 19620 19M 10420 S 0.0 0.4 0:06 1 httpd
27308 nobody 15 0 20416 19M 10944 S 0.0 0.5 0:03 1 httpd
27482 nobody 15 0 19136 18M 10360 S 0.0 0.4 0:09 3 httpd
27483 nobody 15 0 19716 19M 9956 S 0.0 0.4 0:10 1 httpd
27484 nobody 15 0 20000 19M 11156 S 0.0 0.4 0:09 2 httpd
27499 nobody 15 0 17300 16M 8676 S 0.0 0.4 0:00 0 httpd
27782 nobody 15 0 18456 18M 9392 S 0.0 0.4 0:08 0 httpd
28670 nobody 15 0 14560 14M 7148 S 0.0 0.3 0:00 2 httpd
28673 nobody 15 0 15364 15M 6320 S 0.0 0.3 0:00 2 httpd
28674 nobody 15 0 15788 15M 6840 S 0.0 0.3 0:00 0 httpd
28677 nobody 15 0 15144 14M 7200 S 0.0 0.3 0:00 1 httpd
28837 nobody 15 0 20304 19M 11392 S 0.0 0.5 0:06 2 httpd
28839 nobody 20 0 6212 6208 3384 S 0.0 0.1 0:00 3 httpd
28872 nobody 15 0 19356 18M 10004 S 0.0 0.4 0:05 3 httpd
28977 nobody 15 0 9376 9376 5392 S 0.0 0.2 0:00 2 httpd
29095 nobody 15 0 27592 26M 15224 S 0.0 0.6 0:04 1 httpd
29098 nobody 15 0 16460 16M 7168 S 0.0 0.4 0:01 2 httpd
29283 nobody 15 0 17840 17M 8968 S 0.0 0.4 0:02 2 httpd
29356 nobody 15 0 19204 18M 9196 S 0.0 0.4 0:01 3 httpd
29391 nobody 15 0 16012 15M 7476 S 0.0 0.3 0:01 1 httpd
29517 nobody 15 0 17320 16M 8496 S 0.0 0.4 0:01 0 httpd
29724 nobody 15 0 11376 11M 5076 S 0.0 0.2 0:00 2 httpd
29735 nobody 19 0 6600 6600 3732 S 0.0 0.1 0:00 3 httpd6. [mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
max_connections = 500
back_log = 75
key_buffer = 64M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1800
thread_cache_size = 384
wait_timeout = 15
tmp_table_size = 128M
max_heap_table_size = 64M
connect_timeout = 10
max_allowed_packet = 64M
max_connect_errors = 10
read_rnd_buffer_size = 524288
bulk_insert_buffer_size = 8M
thread_concurrency = 2
query_cache_limit = 3M
query_cache_size = 128M
query_cache_type = 1
query_prealloc_size = 163840
query_alloc_block_size = 32768
default-storage-engine = MyISAM
ft_min_word_len = 3
skip-innodb
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[mysqlhotcopy]
interactive-timeout7. +---------------------------------+------------------------------------------+
| Variable_name | Value |
+---------------------------------+------------------------------------------+
| back_log | 75 |
| 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 | 3 |
| 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 | DISABLED |
| have_isam | NO |
| have_ndbcluster | NO |
| have_merge_engine | YES |
| 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 | |
| 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 | 28800 |
| join_buffer_size | 1044480 |
| key_buffer_size | 67108864 |
| key_cache_age_threshold | 300 |
| key_cache_block_size | 1024 |
| key_cache_division_limit | 100 |
| language | /usr/share/mysql/english/ |
| large_files_support | ON |
| lc_time_names | en_US |
| 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 | 67107840 |
| max_binlog_cache_size | 4294967295 |
| max_binlog_size | 1073741824 |
| max_connect_errors | 10 |
| max_connections | 500 |
| max_delayed_threads | 20 |
| max_error_count | 64 |
| max_heap_table_size | 67107840 |
| 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 | OFF |
| open_files_limit | 4110 |
| pid_file | /var/lib/mysql/dual32.gsmhosting.com.pid |
| port | 3306 |
| preload_buffer_size | 32768 |
| prepared_stmt_count | 0 |
| protocol_version | 10 |
| query_alloc_block_size | 32768 |
| query_cache_limit | 3145728 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 134217728 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 163840 |
| range_alloc_block_size | 2048 |
| read_buffer_size | 1044480 |
| read_only | OFF |
| read_rnd_buffer_size | 520192 |
| 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 | CEST |
| table_cache | 1800 |
| table_type | MyISAM |
| thread_cache_size | 384 |
| thread_stack | 196608 |
| time_format | %H:%i:%s |
| time_zone | SYSTEM |
| tmp_table_size | 134217728 |
| tmpdir | |
| transaction_alloc_block_size | 8192 |
| transaction_prealloc_size | 4096 |
| tx_isolation | REPEATABLE-READ |
| version | 4.1.21-standard |
| version_comment | MySQL Community Edition - Standard (GPL) |
| version_compile_machine | i686 |
| version_compile_os | pc-linux-gnu |
| wait_timeout | 15 |
+---------------------------------+------------------------------------------+
+----------------------------+------------+
| Variable_name | Value |
+----------------------------+------------+
| Aborted_clients | 92 |
| Aborted_connects | 4 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 182338674 |
| Bytes_sent | 3114054342 |
| Com_admin_commands | 0 |
| Com_alter_db | 0 |
| Com_alter_table | 33 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 3 |
| Com_change_db | 77825 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_checksum | 0 |
| Com_commit | 3 |
| Com_create_db | 2 |
| Com_create_function | 0 |
| Com_create_index | 43 |
| Com_create_table | 24 |
| Com_dealloc_sql | 0 |
| Com_delete | 1394 |
| Com_delete_multi | 0 |
| Com_do | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_drop_user | 0 |
| Com_execute_sql | 0 |
| Com_flush | 4 |
| Com_grant | 23 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_help | 0 |
| Com_insert | 10845 |
| Com_insert_select | 0 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 897 |
| Com_optimize | 0 |
| 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 | 2328 |
| 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 | 189886 |
| Com_set_option | 16 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_charsets | 0 |
| Com_show_collations | 0 |
| Com_show_column_types | 0 |
| Com_show_create_db | 0 |
| Com_show_create_table | 0 |
| Com_show_databases | 0 |
| Com_show_errors | 0 |
| Com_show_fields | 0 |
| Com_show_grants | 0 |
| Com_show_innodb_status | 0 |
| Com_show_keys | 0 |
| 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 | 7 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 1 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 0 |
| Com_show_variables | 1 |
| 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 | 897 |
| Com_update | 46223 |
| Com_update_multi | 0 |
| Connections | 77845 |
| Created_tmp_disk_tables | 24 |
| Created_tmp_files | 80 |
| Created_tmp_tables | 97063 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 3834 |
| Handler_discover | 0 |
| Handler_read_first | 118516 |
| Handler_read_key | 12220832 |
| Handler_read_next | 13296476 |
| Handler_read_prev | 286147 |
| Handler_read_rnd | 2230038 |
| Handler_read_rnd_next | 68761000 |
| Handler_rollback | 0 |
| Handler_update | 50672 |
| Handler_write | 1901849 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 0 |
| Key_blocks_used | 57990 |
| Key_read_requests | 175671784 |
| Key_reads | 278028 |
| Key_write_requests | 27141 |
| Key_writes | 18137 |
| Max_used_connections | 117 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 877 |
| Open_streams | 0 |
| Open_tables | 797 |
| Opened_tables | 836 |
| Qcache_free_blocks | 1427 |
| Qcache_free_memory | 6340872 |
| Qcache_hits | 244062 |
| Qcache_inserts | 188076 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 1383 |
| Qcache_queries_in_cache | 99709 |
| Qcache_total_blocks | 201087 |
| Questions | 652267 |
| Rpl_status | NULL |
| Select_full_join | 0 |
| Select_full_range_join | 0 |
| Select_range | 116832 |
| Select_range_check | 0 |
| Select_scan | 15548 |
| Slave_open_temp_tables | 0 |
| Slave_retried_transactions | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 5 |
| Sort_merge_passes | 40 |
| Sort_range | 113088 |
| Sort_rows | 5128759 |
| Sort_scan | 8384 |
| Table_locks_immediate | 476779 |
| Table_locks_waited | 9438 |
| Threads_cached | 86 |
| Threads_connected | 31 |
| Threads_created | 117 |
| Threads_running | 2 |
| Uptime | 2160 |
+----------------------------+------------+
Uptime: 2160 Threads: 29 Questions: 652361 Slow queries: 5 Opens: 836 Flush tables: 1 Open tables: 797 Queries per second avg: 302.019
mysqladmin Ver 8.41 Distrib 4.1.21, 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 version 4.1.21-standard
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 36 min 0 sec
Threads: 29 Questions: 652361 Slow queries: 5 Opens: 836 Flush tables: 1 Open tables: 797 Queries per second avg: 302.019root@dual32 [~]# ./mysqlreport --all -tab
MySQL 4.1.21-standard uptime 0 1:35:56 Thu Aug 24 13:38:41 2006
__ Key __________________________________________________ _______________
Buffer usage 56.63M of 64.00M %Used: 88.49
Write ratio 0.70
Read ratio 0.00
__ Questions __________________________________________________ _________
Total 1.74M 301.79/s
DMS 683.60k 118.76/s %Total: 39.35
QC Hits 636.32k 110.55/s 36.63
Com_ 210.74k 36.61/s 12.13
COM_QUIT 206.48k 35.87/s 11.89
-Unknown 19 0.00/s 0.00
Slow 34 0.01/s 0.00 %DMS: 0.00
DMS 683.60k 118.76/s 39.35
SELECT 520.82k 90.48/s 29.98 76.19
UPDATE 124.98k 21.71/s 7.19 18.28
INSERT 28.19k 4.90/s 1.62 4.12
REPLACE 6.42k 1.12/s 0.37 0.94
DELETE 3.18k 0.55/s 0.18 0.47
Com_ 210.74k 36.61/s 12.13
change_db 206.47k 35.87/s 11.89
lock_tables 2.03k 0.35/s 0.12
unlock_tabl 2.03k 0.35/s 0.12
__ SELECT and Sort __________________________________________________ ___
Scan 42.52k 7.39/s %SELECT: 8.16
Range 322.77k 56.08/s 61.97
Full join 3 0.00/s 0.00
Range check 0 0.00/s 0.00
Full rng join 0 0.00/s 0.00
Sort scan 22.64k 3.93/s
Sort range 314.37k 54.62/s
Sort mrg pass 119 0.02/s
__ Query Cache __________________________________________________ _______
Memory usage 85.10M of 128.00M %Used: 66.49
Block Fragmnt 3.08%
Hits 636.32k 110.5/s
Inserts 516.12k 89.67/s
Prunes 204.87k 35.59/s
Insrt:Prune 2.52:1 54.07/s
Hit:Insert 1.23:1
__ Table Locks __________________________________________________ _______
Waited 23.06k 4.01/s %Total: 1.73
Immediate 1.31M 227.32/s
__ Tables __________________________________________________ ____________
Open 876 of 1800 %Cache: 48.67
Opened 915 0.16/s
__ Connections __________________________________________________ _______
Max used 117 of 500 %Max: 23.40
Total 206.53k 35.88/s
__ Created Temp __________________________________________________ ______
Disk table 91 0.02/s
Table 270.33k 46.96/s
File 238 0.04/s
__ Threads __________________________________________________ ___________
Running 2 of 33
Cache 84 %Hit: 99.94
Created 117 0.02/s
Slow 0 0.00/s
__ Aborted __________________________________________________ ___________
Clients 94 0.02/s
Connects 4 0.00/s
__ Bytes __________________________________________________ _____________
Sent 1.84G 320.52/s
Received 486.24M 84.47k/s8. phpadsnew is running with 2 banners
9. Most users ever online was 2805. Average number of concurrent users ranges from 1900-2500. Cookie Session Timeout is 1800.
10. http://forum.gsmhosting.com/phpinfogsm.php
11.
KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 5
MinSpareServers 10
MaxSpareServers 15
StartServers 10
MaxClients 150
Maxrequestsperchild 500
12. vb3.6.0
13. no logfiles over 2GB
14. Linux dual32.gsmhosting.com 2.4.21-47.ELsmp #1 SMP Wed Jul 5 20:38:41 EDT 2006 i686 i686 i386 GNU/Linuxcore file size (blocks, -c) 1000000
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) 4096
pipe size (512 bytes, -p) 8
stack size (kbytes, -s) 8192
cpu time (seconds, -t) unlimited
max user processes (-u) 14335
virtual memory (kbytes, -v) unlimitedprocessor : 0
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 3.20GHz
stepping : 3
cpu MHz : 3192.121
cache size : 2048 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 : 3
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 nx lm
bogomips : 6370.09
processor : 1
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 3.20GHz
stepping : 3
cpu MHz : 3192.121
cache size : 2048 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 : 3
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 nx lm
bogomips : 6383.20
processor : 2
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 3.20GHz
stepping : 3
cpu MHz : 3192.121
cache size : 2048 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 : 3
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 nx lm
bogomips : 6383.20
processor : 3
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 3.20GHz
stepping : 3
cpu MHz : 3192.121
cache size : 2048 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 : 3
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 nx lm
bogomips : 6383.20