hawamer
Tue 15th Nov '05, 11:12am
1. Is this on dedicated or shared virual server. If shared, how many sites share this server (ask web host if needed)
--- Dedicated Server
2. your server specs. For example:
cpu speed/type single or dual cpus): --- Dual Xeon 2.80GHz
how much memory installed: --- 4GB ram
hard drive type/configuration: --- Primary- 36GB SCSI / secondary- 40Gb EIDE non raid
linux distributor or windows version: --- CentOS 4.2
apache/IIS version: --- apache 1.3.34
PHP version: --- 4.4.1
MySQL version: --- 4.0.25-standard
3. if you use mysql 4.x instead of mysql 3.23.x, do you have any innodb type databases/tables on your server ? non
4. if possible how mysql was compiled/installed --- One
5. your top stats
--- 1
top - 16:50:15 up 1 day, 23 min, 2 users, load average: 5.26, 3.42, 2.89
Tasks: 203 total, 10 running, 191 sleeping, 0 stopped, 2 zombie
Cpu(s): 48.2% us, 6.0% sy, 0.0% ni, 45.7% id, 0.0% wa, 0.0% hi, 0.0% si
Mem: 3764412k total, 1697728k used, 2066684k free, 138328k buffers
Swap: 1052248k total, 0k used, 1052248k free, 902972k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
30588 nobody 15 0 22840 12m 3992 S 20.6 0.4 0:03.53 httpd
30953 nobody 16 0 20488 10m 3968 R 13.3 0.3 0:01.58 httpd
31372 nobody 15 0 19988 10m 3968 S 12.9 0.3 0:00.92 httpd
27747 nobody 16 0 20104 10m 3968 S 11.9 0.3 0:01.55 httpd
31143 nobody 16 0 21032 11m 3968 S 10.6 0.3 0:01.13 httpd
30727 nobody 15 0 20868 11m 3968 S 10.0 0.3 0:03.88 httpd
31385 nobody 16 0 19992 10m 3968 S 9.6 0.3 0:00.86 httpd
30863 nobody 15 0 20008 10m 3968 S 8.0 0.3 0:03.33 httpd
30920 nobody 15 0 19980 10m 3968 S 8.0 0.3 0:02.62 httpd
30933 nobody 16 0 20080 10m 3968 S 8.0 0.3 0:02.90 httpd
30683 nobody 15 0 19980 10m 3968 S 7.6 0.3 0:03.06 httpd
20423 nobody 17 0 21176 11m 3968 R 7.3 0.3 0:02.38 httpd
30745 nobody 15 0 20960 11m 3968 S 7.3 0.3 0:03.82 httpd
31153 nobody 16 0 19972 10m 3968 S 7.0 0.3 0:01.20 httpd
30754 nobody 15 0 19988 10m 3984 S 6.3 0.3 0:01.10 httpd
31063 nobody 16 0 19984 10m 3968 S 6.0 0.3 0:00.67 httpd
30742 nobody 16 0 20900 11m 3976 S 5.3 0.3 0:03.34 httpd
30635 nobody 16 0 23020 13m 3992 R 3.7 0.4 0:03.41 httpd
30728 nobody 16 0 22984 13m 3992 R 3.7 0.4 0:02.26 httpd
30931 nobody 15 0 19240 9700 3964 S 3.3 0.3 0:01.08 httpd
31624 nobody 16 0 18704 8928 3904 S 3.0 0.2 0:00.09 httpd
30886 nobody 15 0 20000 10m 3968 S 2.7 0.3 0:01.63 httpd
30908 nobody 15 0 20576 10m 3968 S 2.0 0.3 0:01.34 httpd
31027 nobody 15 0 20032 10m 3968 S 2.0 0.3 0:01.28 httpd
30744 nobody 15 0 20024 10m 3968 S 1.3 0.3 0:01.73 httpd
30974 nobody 15 0 19964 10m 3972 S 1.3 0.3 0:00.98 httpd
30717 nobody 15 0 20884 11m 3968 S 1.0 0.3 0:03.48 httpd
31396 nobody 15 0 16484 6700 3796 S 1.0 0.2 0:00.07 httpd
27530 nobody 15 0 20000 10m 3968 S 0.7 0.3 0:03.58 httpd
30498 nobody 16 0 0 0 0 Z 0.7 0.0 0:02.95 httpd <defunct>
6 root RT 0 0 0 0 S 0.3 0.0 6:42.11 migration/2
28518 mysql 15 0 55692 37m 2084 S 0.3 1.0 0:04.26 mysqld
28484 root 15 0 3364 1044 744 R 0.3 0.0 0:01.03 top
30358 nobody 16 0 0 0 0 Z 0.3 0.0 0:03.73 httpd <defunct>
30932 nobody 15 0 19996 10m 3968 S 0.3 0.3 0:01.77 httpd
31154 nobody 15 0 19996 10m 3968 S 0.3 0.3 0:01.09 httpd
31641 nobody 15 0 16484 6680 3784 S 0.3 0.2 0:00.01 httpd
31647 mysql 15 0 55692 37m 2084 S 0.3 1.0 0:00.01 mysqld
31654 mysql 16 0 55692 37m 2084 R 0.3 1.0 0:00.01 mysqld
1 root 16 0 2916 552 476 S 0.0 0.0 0:01.40 init
2 root RT 0 0 0 0 S 0.0 0.0 0:00.14 migration/0
3 root 34 19 0 0 0 S 0.0 0.0 0:00.01 ksoftirqd/0
4 root RT 0 0 0 0 S 0.0 0.0 0:00.06 migration/1
5 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/1
7 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/2
8 root RT 0 0 0 0 S 0.0 0.0 0:44.66 migration/3
9 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/3
10 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 events/0
11 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 events/1
12 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 events/2
root@server-598 (http://by106fd.bay106.hotmail.msn.com/cgi-bin/compose?mailto=1&msg=E2F9205F-FCE0-433B-9A66-C9BCB502EF2D&start=0&len=306130&src=&type=x&to=root@server-598&cc=&bcc=&subject=&body=&curmbox=00000000-0000-0000-0000-000000000001&a=8a8bca99191c81d44e7cbb710db77cb67d99becf0260d4b2 cf36f188548778b0) [~]# netstat -an | grep :80 | wc -l
2915
--- 2
top - 16:52:23 up 1 day, 25 min, 2 users, load average: 3.88, 3.49, 2.98
Tasks: 215 total, 1 running, 213 sleeping, 0 stopped, 1 zombie
Cpu(s): 38.8% us, 5.6% sy, 0.0% ni, 54.9% id, 0.8% wa, 0.0% hi, 0.0% si
Mem: 3764412k total, 1765856k used, 1998556k free, 138328k buffers
Swap: 1052248k total, 0k used, 1052248k free, 904532k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
345 nobody 15 0 19988 10m 3968 S 7.9 0.3 0:01.08 httpd
396 nobody 17 0 21152 11m 3968 S 7.9 0.3 0:00.80 httpd
395 nobody 15 0 19960 10m 3968 S 7.7 0.3 0:00.57 httpd
32496 nobody 16 0 22992 13m 3992 S 7.2 0.4 0:01.60 httpd
32347 nobody 16 0 22744 12m 3980 S 7.1 0.4 0:04.13 httpd
392 nobody 15 0 20016 10m 3968 S 7.1 0.3 0:00.53 httpd
32693 nobody 16 0 21356 11m 3980 S 6.7 0.3 0:01.57 httpd
32597 nobody 15 0 20052 10m 3968 S 6.1 0.3 0:01.81 httpd
32725 nobody 16 0 21100 11m 3968 S 6.1 0.3 0:01.34 httpd
323 nobody 16 0 19996 10m 3968 S 5.6 0.3 0:00.73 httpd
31926 nobody 15 0 19992 10m 3968 S 5.0 0.3 0:03.42 httpd
375 nobody 15 0 19988 10m 3968 S 5.0 0.3 0:00.40 httpd
32726 nobody 15 0 19984 10m 3968 S 4.7 0.3 0:01.48 httpd
32495 nobody 16 0 20272 10m 3976 S 4.3 0.3 0:02.79 httpd
32646 nobody 16 0 21248 11m 3968 S 3.8 0.3 0:01.52 httpd
32709 nobody 15 0 20012 10m 3984 S 3.6 0.3 0:01.19 httpd
355 nobody 16 0 19932 10m 3976 S 3.6 0.3 0:00.42 httpd
32485 nobody 15 0 23028 13m 3992 S 3.5 0.4 0:01.73 httpd
20937 nobody 15 0 0 0 0 Z 3.2 0.0 0:04.56 httpd <defunct>
32484 nobody 16 0 21268 11m 3968 S 3.2 0.3 0:02.62 httpd
374 nobody 15 0 19956 10m 3968 S 3.2 0.3 0:00.27 httpd
31914 nobody 15 0 20896 11m 3968 S 3.1 0.3 0:03.92 httpd
31925 nobody 16 0 21040 11m 3968 S 3.1 0.3 0:03.01 httpd
29177 nobody 15 0 20032 10m 3968 S 2.9 0.3 0:02.47 httpd
31867 nobody 15 0 19984 10m 3968 S 2.9 0.3 0:03.59 httpd
32581 nobody 15 0 20008 10m 3976 S 2.8 0.3 0:02.67 httpd
372 nobody 15 0 21252 11m 3968 S 2.5 0.3 0:00.45 httpd
393 nobody 15 0 21148 11m 3944 S 2.5 0.3 0:00.20 httpd
32416 nobody 15 0 21264 11m 3952 S 2.4 0.3 0:00.98 httpd
32144 nobody 15 0 20116 10m 3968 S 2.2 0.3 0:03.37 httpd
457 mysql 16 0 55884 37m 2084 S 2.2 1.0 0:00.16 mysqld
397 nobody 15 0 19812 10m 3952 S 1.8 0.3 0:00.13 httpd
6 root RT 0 0 0 0 S 1.7 0.0 6:43.75 migration/2
356 nobody 15 0 19972 10m 3968 S 1.3 0.3 0:00.37 httpd
28838 nobody 15 0 19976 10m 3968 S 1.0 0.3 0:03.93 httpd
32117 nobody 15 0 20964 11m 3976 S 1.0 0.3 0:03.96 httpd
32494 nobody 15 0 19984 10m 3968 S 0.7 0.3 0:01.56 httpd
32728 nobody 16 0 22560 12m 3980 S 0.7 0.3 0:01.16 httpd
32327 nobody 15 0 22844 12m 3992 S 0.6 0.4 0:04.19 httpd
32473 nobody 16 0 19980 10m 3968 S 0.6 0.3 0:01.48 httpd
28518 mysql 16 0 55884 37m 2084 S 0.3 1.0 0:04.43 mysqld
29086 nobody 15 0 22572 12m 3980 S 0.3 0.3 0:02.11 httpd
31899 root 16 0 3268 1040 744 R 0.3 0.0 0:00.48 top
32159 nobody 15 0 20032 10m 3984 S 0.3 0.3 0:02.73 httpd
425 mysql 16 0 55884 37m 2084 S 0.3 1.0 0:00.02 mysqld
471 mysql 16 0 55884 37m 2084 S 0.3 1.0 0:00.02 mysqld
429 mysql 17 0 55884 37m 2084 S 0.1 1.0 0:00.01 mysqld
469 mysql 17 0 55884 37m 2084 S 0.1 1.0 0:00.01 mysqld
475 mysql 16 0 55884 37m 2084 S 0.1 1.0 0:00.01 mysqld
477 mysql 16 0 55884 37m 2084 S 0.1 1.0 0:00.01 mysqld
--- 3
top - 16:41:00 up 1 day, 13 min, 2 users, load average: 2.49, 2.29, 2.56
Tasks: 206 total, 1 running, 204 sleeping, 0 stopped, 1 zombie
Cpu(s): 26.7% us, 4.1% sy, 0.0% ni, 68.8% id, 0.4% wa, 0.0% hi, 0.0% si
Mem: 3764412k total, 1736208k used, 2028204k free, 138276k buffers
Swap: 1052248k total, 0k used, 1052248k free, 897044k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
25805 nobody 15 0 22844 12m 3992 S 9.0 0.4 0:00.79 httpd
25467 nobody 15 0 20776 10m 3980 S 8.3 0.3 0:01.92 httpd
25808 nobody 16 0 20040 10m 3968 S 8.3 0.3 0:00.64 httpd
25811 nobody 16 0 19988 10m 3968 S 8.3 0.3 0:00.85 httpd
25261 nobody 15 0 21100 11m 3968 S 8.0 0.3 0:03.67 httpd
25809 nobody 15 0 20036 10m 3968 S 7.0 0.3 0:00.92 httpd
25825 nobody 15 0 20056 10m 3968 S 6.6 0.3 0:01.05 httpd
25810 nobody 16 0 20012 10m 3968 S 5.0 0.3 0:00.80 httpd
25823 nobody 15 0 19968 10m 3968 S 5.0 0.3 0:00.76 httpd
25832 nobody 15 0 21256 11m 3952 S 5.0 0.3 0:00.28 httpd
25481 nobody 16 0 20024 10m 3968 S 4.6 0.3 0:02.05 httpd
25468 nobody 15 0 22780 12m 3980 S 4.3 0.4 0:01.44 httpd
25795 nobody 16 0 19940 10m 3976 S 4.3 0.3 0:00.40 httpd
25523 nobody 16 0 20036 10m 3968 S 4.0 0.3 0:02.41 httpd
25541 nobody 15 0 23068 13m 3992 S 3.6 0.4 0:02.09 httpd
6 root RT 0 0 0 0 S 1.3 0.0 6:35.73 migration/2
22281 nobody 15 0 21232 11m 3968 S 1.3 0.3 0:02.26 httpd
25730 nobody 15 0 20872 11m 3968 S 1.3 0.3 0:01.05 httpd
22198 nobody 15 0 19988 10m 3968 S 1.0 0.3 0:03.19 httpd
24910 nobody 15 0 22844 12m 3992 S 1.0 0.4 0:02.76 httpd
25510 nobody 15 0 22596 12m 3980 S 1.0 0.3 0:02.20 httpd
25652 nobody 15 0 19980 10m 3968 S 1.0 0.3 0:01.14 httpd
25796 nobody 16 0 19976 10m 3968 S 1.0 0.3 0:00.82 httpd
25828 nobody 15 0 20868 11m 3952 S 1.0 0.3 0:00.60 httpd
30491 root 16 0 3880 1052 748 R 0.7 0.0 0:10.36 top
11093 nobody 15 0 20040 10m 3968 S 0.7 0.3 0:03.95 httpd
24909 nobody 15 0 21036 11m 3968 S 0.7 0.3 0:02.87 httpd
25289 nobody 15 0 21000 11m 3968 S 0.7 0.3 0:02.01 httpd
25479 nobody 16 0 20768 10m 3968 S 0.7 0.3 0:02.00 httpd
25522 nobody 15 0 20028 10m 3968 S 0.7 0.3 0:01.92 httpd
25729 nobody 15 0 19992 10m 3968 S 0.7 0.3 0:00.93 httpd
25777 nobody 15 0 19972 10m 3976 S 0.7 0.3 0:00.74 httpd
25787 nobody 15 0 20000 10m 3968 S 0.7 0.3 0:01.37 httpd
25788 nobody 15 0 19920 10m 3948 S 0.7 0.3 0:00.26 httpd
25807 nobody 16 0 19988 10m 3968 S 0.7 0.3 0:00.32 httpd
25812 nobody 15 0 19964 10m 3964 S 0.7 0.3 0:00.55 httpd
25830 nobody 15 0 0 0 0 Z 0.7 0.0 0:01.18 httpd <defunct>
25794 nobody 15 0 19952 10m 3964 S 0.3 0.3 0:00.33 httpd
25797 nobody 15 0 19820 10m 3936 S 0.3 0.3 0:00.21 httpd
25826 nobody 15 0 19956 10m 3944 S 0.3 0.3 0:00.28 httpd
25997 mysql 16 0 54392 37m 2084 S 0.3 1.0 0:00.01 mysqld
1 root 16 0 2916 552 476 S 0.0 0.0 0:01.40 init
2 root RT 0 0 0 0 S 0.0 0.0 0:00.14 migration/0
3 root 34 19 0 0 0 S 0.0 0.0 0:00.01 ksoftirqd/0
4 root RT 0 0 0 0 S 0.0 0.0 0:00.06 migration/1
5 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/1
25479 nobody 15 0 20768 10m 3968 S 0.6 0.3 0:01.98 httpd
25510 nobody 15 0 22596 12m 3980 S 0.6 0.3 0:02.17 httpd
25541 nobody 15 0 23068 13m 3992 S 0.6 0.4 0:01.98 httpd
--- 4
top - 16:42:53 up 1 day, 15 min, 2 users, load average: 2.73, 2.35, 2.54
Tasks: 205 total, 3 running, 202 sleeping, 0 stopped, 0 zombie
Cpu(s): 44.2% us, 5.1% sy, 0.0% ni, 50.3% id, 0.4% wa, 0.0% hi, 0.0% si
Mem: 3764412k total, 1704328k used, 2060084k free, 138284k buffers
Swap: 1052248k total, 0k used, 1052248k free, 897816k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
26357 nobody 16 0 19988 10m 3976 S 14.9 0.3 0:03.19 httpd
23529 nobody 16 0 20960 11m 3976 S 13.3 0.3 0:01.81 httpd
26895 nobody 17 0 19960 10m 3968 S 12.9 0.3 0:00.45 httpd
26771 nobody 16 0 21244 11m 3968 S 11.6 0.3 0:00.70 httpd
26882 nobody 16 0 20144 10m 3968 S 11.6 0.3 0:00.98 httpd
26460 nobody 15 0 20944 11m 3968 S 10.6 0.3 0:03.58 httpd
26606 nobody 15 0 20016 10m 3968 S 10.6 0.3 0:01.31 httpd
26758 nobody 15 0 20040 10m 3968 S 10.0 0.3 0:01.32 httpd
26564 nobody 16 0 20000 10m 3968 S 9.6 0.3 0:01.43 httpd
26643 nobody 17 0 19996 10m 3968 S 9.6 0.3 0:01.84 httpd
26711 nobody 15 0 20052 10m 3968 S 8.6 0.3 0:01.79 httpd
26748 nobody 15 0 19980 10m 3968 S 8.0 0.3 0:01.17 httpd
26712 nobody 16 0 20056 10m 3968 S 7.6 0.3 0:01.45 httpd
26456 nobody 15 0 19980 10m 3968 S 7.0 0.3 0:03.47 httpd
26189 nobody 15 0 20284 10m 3976 S 6.6 0.3 0:02.25 httpd
26881 nobody 15 0 20036 10m 3968 S 5.3 0.3 0:00.94 httpd
27000 nobody 16 0 19948 10m 3936 S 4.6 0.3 0:00.14 httpd
26892 nobody 16 0 21392 11m 3980 R 2.3 0.3 0:00.98 httpd
26624 nobody 15 0 21020 11m 3968 S 1.3 0.3 0:01.99 httpd
26803 nobody 15 0 20028 10m 3968 S 1.3 0.3 0:01.01 httpd
26454 nobody 15 0 20004 10m 3968 S 1.0 0.3 0:03.65 httpd
26769 nobody 15 0 20000 10m 3944 S 1.0 0.3 0:00.40 httpd
26786 nobody 15 0 20116 10m 3984 S 1.0 0.3 0:01.53 httpd
6 root RT 0 0 0 0 S 0.7 0.0 6:36.95 migration/2
23242 nobody 15 0 22732 12m 3976 S 0.7 0.3 0:02.24 httpd
26180 nobody 15 0 20036 10m 3976 S 0.7 0.3 0:02.44 httpd
26426 nobody 15 0 22748 12m 3980 S 0.7 0.3 0:02.31 httpd
26703 nobody 15 0 20004 10m 3984 S 0.7 0.3 0:01.62 httpd
26863 nobody 15 0 19928 10m 3940 S 0.7 0.3 0:00.16 httpd
26883 nobody 15 0 19984 10m 3968 S 0.7 0.3 0:00.66 httpd
26988 nobody 15 0 16484 6676 3784 S 0.7 0.2 0:00.02 httpd
17636 root 16 0 16348 6476 3712 S 0.3 0.2 0:05.28 httpd
26508 root 16 0 2788 1028 744 R 0.3 0.0 0:00.21 top
26757 nobody 15 0 22752 12m 3980 S 0.3 0.3 0:00.92 httpd
26880 nobody 15 0 20020 10m 3968 S 0.3 0.3 0:00.55 httpd
26999 nobody 15 0 16484 6672 3780 S 0.3 0.2 0:00.01 httpd
27005 mysql 17 0 55160 37m 2084 S 0.3 1.0 0:00.01 mysqld
1 root 16 0 2916 552 476 S 0.0 0.0 0:01.40 init
2 root RT 0 0 0 0 S 0.0 0.0 0:00.14 migration/0
3 root 34 19 0 0 0 S 0.0 0.0 0:00.01 ksoftirqd/0
4 root RT 0 0 0 0 S 0.0 0.0 0:00.06 migration/1
5 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/1
7 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/2
8 root RT 0 0 0 0 S 0.0 0.0 0:44.14 migration/3
9 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/3
10 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 events/0
11 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 events/1
12 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 events/2
13 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 events/3
14 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 khelper
6. your mysql configuration variables located at /etc/my.cnf or c:\my.cnf so post the contents inside of my.cnf (minus any passwords of course). If on Windows server if you don't have that file you need to log into telnet and as root user type
---
+---------------------------------+---------------------------------------------------+
| Variable_name | Value |
+---------------------------------+---------------------------------------------------+
| back_log | 50 |
| basedir | / |
| binlog_cache_size | 32768 |
| bulk_insert_buffer_size | 8388608 |
| character_set | latin1 |
| character_sets | latin1 big5 czech euc_kr gb2312 gbk latin1_de sjis tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 |
| concurrent_insert | ON |
| connect_timeout | 5 |
| convert_character_set | |
| datadir | /var/lib/mysql/ |
| default_week_format | 0 |
| delay_key_write | ON |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| flush | OFF |
| flush_time | 0 |
| ft_boolean_syntax | + -><()~*:""&| |
| ft_min_word_len | 4 |
| ft_max_word_len | 254 |
| ft_max_word_len_for_sort | 20 |
| ft_stopword_file | (built-in) |
| have_bdb | NO |
| have_crypt | YES |
| have_innodb | YES |
| have_isam | YES |
| have_raid | NO |
| have_symlink | YES |
| have_openssl | NO |
| have_query_cache | YES |
| init_file | |
| innodb_additional_mem_pool_size | 1048576 |
| innodb_autoextend_increment | 8 |
| innodb_buffer_pool_size | 8388608 |
| innodb_data_file_path | ibdata1:10M:autoextend |
| innodb_data_home_dir | |
| innodb_file_io_threads | 4 |
| innodb_force_recovery | 0 |
| innodb_thread_concurrency | 8 |
| innodb_flush_log_at_trx_commit | 1 |
| innodb_fast_shutdown | ON |
| innodb_flush_method | |
| innodb_lock_wait_timeout | 50 |
| 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_mirrored_log_groups | 1 |
| innodb_max_dirty_pages_pct | 90 |
| innodb_max_purge_lag | 0 |
| innodb_table_locks | ON |
| interactive_timeout | 28800 |
| join_buffer_size | 131072 |
| key_buffer_size | 8388600 |
| language | /usr/share/mysql/english/ |
| large_files_support | ON |
| license | GPL |
| local_infile | ON |
| locked_in_memory | OFF |
| log | OFF |
| log_update | OFF |
| log_bin | OFF |
| log_slave_updates | OFF |
| log_slow_queries | 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 | 1048576 |
| max_binlog_cache_size | 4294967295 |
| max_binlog_size | 1073741824 |
| max_connections | 950 |
| max_connect_errors | 10 |
| max_delayed_threads | 20 |
| max_insert_delayed_threads | 20 |
| max_heap_table_size | 16777216 |
| max_join_size | 4294967295 |
| max_relay_log_size | 0 |
| max_seeks_for_key | 4294967295 |
| max_sort_length | 1024 |
| max_user_connections | 0 |
| max_tmp_tables | 32 |
| max_write_lock_count | 4294967295 |
| myisam_max_extra_sort_file_size | 268435456 |
| myisam_max_sort_file_size | 2147483647 |
| myisam_repair_threads | 1 |
| myisam_recover_options | OFF |
| myisam_sort_buffer_size | 8388608 |
| net_buffer_length | 16384 |
| net_read_timeout | 30 |
| net_retry_count | 10 |
| net_write_timeout | 60 |
| new | OFF |
| open_files_limit | 4760 |
| pid_file | /var/lib/mysql/server-598.saudiprovider.net.pid |
| log_error | |
| port | 3306 |
| protocol_version | 10 |
| query_alloc_block_size | 8192 |
| query_cache_limit | 1048576 |
| query_cache_size | 0 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 8192 |
| range_alloc_block_size | 2048 |
| read_buffer_size | 131072 |
| read_only | OFF |
| read_rnd_buffer_size | 262144 |
| rpl_recovery_rank | 0 |
| server_id | 0 |
| slave_net_timeout | 3600 |
| skip_external_locking | ON |
| skip_networking | OFF |
| skip_show_database | OFF |
| slow_launch_time | 2 |
| socket | /var/lib/mysql/mysql.sock |
| sort_buffer_size | 2097144 |
| sql_mode | 0 |
| table_cache | 64 |
| table_type | MYISAM |
| thread_cache_size | 0 |
| thread_stack | 126976 |
| tx_isolation | REPEATABLE-READ |
| timezone | AST |
| tmp_table_size | 33554432 |
| tmpdir | /tmp/ |
| transaction_alloc_block_size | 8192 |
| transaction_prealloc_size | 4096 |
| version | 4.0.25-standard |
| version_comment | Official MySQL RPM |
| version_compile_os | pc-linux-gnu |
| wait_timeout | 28800 |
+---------------------------------+---------------------------------------------------+
7. your mysql extended-status output which shows entire server's mysql activity status (preferably with a day or 2 worth of mysql uptime for better indication of real activity) either:
---
+--------------------------+-----------+
| Variable_name | Value |
+--------------------------+-----------+
| Aborted_clients | 4 |
| Aborted_connects | 1 |
| Bytes_received | 189989341 |
| Bytes_sent | 300431971 |
| Com_admin_commands | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 36860 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_commit | 0 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 0 |
| Com_delete | 2422 |
| Com_delete_multi | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_flush | 0 |
| Com_grant | 0 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_insert | 33923 |
| Com_insert_select | 569 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 69 |
| Com_optimize | 0 |
| Com_purge | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 1373 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 393052 |
| Com_set_option | 38 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_create | 0 |
| Com_show_databases | 1 |
| Com_show_fields | 0 |
| Com_show_grants | 0 |
| Com_show_keys | 0 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_processlist | 37 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 13 |
| Com_show_innodb_status | 0 |
| Com_show_tables | 4 |
| Com_show_variables | 10 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 66 |
| Com_update | 66818 |
| Com_update_multi | 3 |
| Connections | 36975 |
| Created_tmp_disk_tables | 168 |
| Created_tmp_tables | 8238 |
| Created_tmp_files | 3 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 25295 |
| Handler_read_first | 70021 |
| Handler_read_key | 11711099 |
| Handler_read_next | 53214891 |
| Handler_read_prev | 376058 |
| Handler_read_rnd | 11421946 |
| Handler_read_rnd_next | 34450456 |
| Handler_rollback | 0 |
| Handler_update | 68887 |
| Handler_write | 6794275 |
| Key_blocks_used | 7793 |
| Key_read_requests | 41069612 |
| Key_reads | 127802 |
| Key_write_requests | 43704 |
| Key_writes | 49905 |
| Max_used_connections | 58 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 64 |
| Open_files | 89 |
| Open_streams | 0 |
| Opened_tables | 7651 |
| Questions | 572190 |
| Qcache_queries_in_cache | 0 |
| Qcache_inserts | 0 |
| Qcache_hits | 0 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 0 |
| Qcache_free_memory | 0 |
| Qcache_free_blocks | 0 |
| Qcache_total_blocks | 0 |
| Rpl_status | NULL |
| Select_full_join | 409 |
| Select_full_range_join | 0 |
| Select_range | 96752 |
| Select_range_check | 0 |
| Select_scan | 83408 |
| Slave_open_temp_tables | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 1 |
| Slow_queries | 0 |
| Sort_merge_passes | 0 |
| Sort_range | 88669 |
| Sort_rows | 11430587 |
| Sort_scan | 10198 |
| Table_locks_immediate | 834783 |
| Table_locks_waited | 9815 |
| Threads_cached | 0 |
| Threads_created | 36974 |
| Threads_connected | 28 |
| Threads_running | 1 |
| Uptime | 5494 |
+--------------------------+-----------+
8. is your vB the only thing on the server? or other scripts & sites which utilise php and mysql?
--- Only vB
9. how many average and max concurrent users on your vB forum ? and what your cookie timeout is ? 1200 - 1800 User - Timeout : 900
10. create a file named phpinfo.php and place this code in it and post the url/link to it from your web site
--- http://www.hawamer.com/phpinfo.php (javascript:ol('http://www.hawamer.com/phpinfo.php');)
11. if you run Apache and you have your own dedicated server or access to your httpd.conf (apache configuration file) can you post the values you have set for the following :
KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 10
MinSpareServers 5
MaxSpareServers 10
StartServers 5
MaxClients 396
AND Maxrequestsperchild value = 100
12. what version of vB are you running ?
--- 3.5.1
13. check to see if any files i.e. apache log files are hitting 2GB or 4GB max file size limits i.e. see if you have max file size exceeded messages in apache error log
--- nothing there
----------------------
some times the server is down
--- Dedicated Server
2. your server specs. For example:
cpu speed/type single or dual cpus): --- Dual Xeon 2.80GHz
how much memory installed: --- 4GB ram
hard drive type/configuration: --- Primary- 36GB SCSI / secondary- 40Gb EIDE non raid
linux distributor or windows version: --- CentOS 4.2
apache/IIS version: --- apache 1.3.34
PHP version: --- 4.4.1
MySQL version: --- 4.0.25-standard
3. if you use mysql 4.x instead of mysql 3.23.x, do you have any innodb type databases/tables on your server ? non
4. if possible how mysql was compiled/installed --- One
5. your top stats
--- 1
top - 16:50:15 up 1 day, 23 min, 2 users, load average: 5.26, 3.42, 2.89
Tasks: 203 total, 10 running, 191 sleeping, 0 stopped, 2 zombie
Cpu(s): 48.2% us, 6.0% sy, 0.0% ni, 45.7% id, 0.0% wa, 0.0% hi, 0.0% si
Mem: 3764412k total, 1697728k used, 2066684k free, 138328k buffers
Swap: 1052248k total, 0k used, 1052248k free, 902972k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
30588 nobody 15 0 22840 12m 3992 S 20.6 0.4 0:03.53 httpd
30953 nobody 16 0 20488 10m 3968 R 13.3 0.3 0:01.58 httpd
31372 nobody 15 0 19988 10m 3968 S 12.9 0.3 0:00.92 httpd
27747 nobody 16 0 20104 10m 3968 S 11.9 0.3 0:01.55 httpd
31143 nobody 16 0 21032 11m 3968 S 10.6 0.3 0:01.13 httpd
30727 nobody 15 0 20868 11m 3968 S 10.0 0.3 0:03.88 httpd
31385 nobody 16 0 19992 10m 3968 S 9.6 0.3 0:00.86 httpd
30863 nobody 15 0 20008 10m 3968 S 8.0 0.3 0:03.33 httpd
30920 nobody 15 0 19980 10m 3968 S 8.0 0.3 0:02.62 httpd
30933 nobody 16 0 20080 10m 3968 S 8.0 0.3 0:02.90 httpd
30683 nobody 15 0 19980 10m 3968 S 7.6 0.3 0:03.06 httpd
20423 nobody 17 0 21176 11m 3968 R 7.3 0.3 0:02.38 httpd
30745 nobody 15 0 20960 11m 3968 S 7.3 0.3 0:03.82 httpd
31153 nobody 16 0 19972 10m 3968 S 7.0 0.3 0:01.20 httpd
30754 nobody 15 0 19988 10m 3984 S 6.3 0.3 0:01.10 httpd
31063 nobody 16 0 19984 10m 3968 S 6.0 0.3 0:00.67 httpd
30742 nobody 16 0 20900 11m 3976 S 5.3 0.3 0:03.34 httpd
30635 nobody 16 0 23020 13m 3992 R 3.7 0.4 0:03.41 httpd
30728 nobody 16 0 22984 13m 3992 R 3.7 0.4 0:02.26 httpd
30931 nobody 15 0 19240 9700 3964 S 3.3 0.3 0:01.08 httpd
31624 nobody 16 0 18704 8928 3904 S 3.0 0.2 0:00.09 httpd
30886 nobody 15 0 20000 10m 3968 S 2.7 0.3 0:01.63 httpd
30908 nobody 15 0 20576 10m 3968 S 2.0 0.3 0:01.34 httpd
31027 nobody 15 0 20032 10m 3968 S 2.0 0.3 0:01.28 httpd
30744 nobody 15 0 20024 10m 3968 S 1.3 0.3 0:01.73 httpd
30974 nobody 15 0 19964 10m 3972 S 1.3 0.3 0:00.98 httpd
30717 nobody 15 0 20884 11m 3968 S 1.0 0.3 0:03.48 httpd
31396 nobody 15 0 16484 6700 3796 S 1.0 0.2 0:00.07 httpd
27530 nobody 15 0 20000 10m 3968 S 0.7 0.3 0:03.58 httpd
30498 nobody 16 0 0 0 0 Z 0.7 0.0 0:02.95 httpd <defunct>
6 root RT 0 0 0 0 S 0.3 0.0 6:42.11 migration/2
28518 mysql 15 0 55692 37m 2084 S 0.3 1.0 0:04.26 mysqld
28484 root 15 0 3364 1044 744 R 0.3 0.0 0:01.03 top
30358 nobody 16 0 0 0 0 Z 0.3 0.0 0:03.73 httpd <defunct>
30932 nobody 15 0 19996 10m 3968 S 0.3 0.3 0:01.77 httpd
31154 nobody 15 0 19996 10m 3968 S 0.3 0.3 0:01.09 httpd
31641 nobody 15 0 16484 6680 3784 S 0.3 0.2 0:00.01 httpd
31647 mysql 15 0 55692 37m 2084 S 0.3 1.0 0:00.01 mysqld
31654 mysql 16 0 55692 37m 2084 R 0.3 1.0 0:00.01 mysqld
1 root 16 0 2916 552 476 S 0.0 0.0 0:01.40 init
2 root RT 0 0 0 0 S 0.0 0.0 0:00.14 migration/0
3 root 34 19 0 0 0 S 0.0 0.0 0:00.01 ksoftirqd/0
4 root RT 0 0 0 0 S 0.0 0.0 0:00.06 migration/1
5 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/1
7 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/2
8 root RT 0 0 0 0 S 0.0 0.0 0:44.66 migration/3
9 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/3
10 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 events/0
11 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 events/1
12 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 events/2
root@server-598 (http://by106fd.bay106.hotmail.msn.com/cgi-bin/compose?mailto=1&msg=E2F9205F-FCE0-433B-9A66-C9BCB502EF2D&start=0&len=306130&src=&type=x&to=root@server-598&cc=&bcc=&subject=&body=&curmbox=00000000-0000-0000-0000-000000000001&a=8a8bca99191c81d44e7cbb710db77cb67d99becf0260d4b2 cf36f188548778b0) [~]# netstat -an | grep :80 | wc -l
2915
--- 2
top - 16:52:23 up 1 day, 25 min, 2 users, load average: 3.88, 3.49, 2.98
Tasks: 215 total, 1 running, 213 sleeping, 0 stopped, 1 zombie
Cpu(s): 38.8% us, 5.6% sy, 0.0% ni, 54.9% id, 0.8% wa, 0.0% hi, 0.0% si
Mem: 3764412k total, 1765856k used, 1998556k free, 138328k buffers
Swap: 1052248k total, 0k used, 1052248k free, 904532k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
345 nobody 15 0 19988 10m 3968 S 7.9 0.3 0:01.08 httpd
396 nobody 17 0 21152 11m 3968 S 7.9 0.3 0:00.80 httpd
395 nobody 15 0 19960 10m 3968 S 7.7 0.3 0:00.57 httpd
32496 nobody 16 0 22992 13m 3992 S 7.2 0.4 0:01.60 httpd
32347 nobody 16 0 22744 12m 3980 S 7.1 0.4 0:04.13 httpd
392 nobody 15 0 20016 10m 3968 S 7.1 0.3 0:00.53 httpd
32693 nobody 16 0 21356 11m 3980 S 6.7 0.3 0:01.57 httpd
32597 nobody 15 0 20052 10m 3968 S 6.1 0.3 0:01.81 httpd
32725 nobody 16 0 21100 11m 3968 S 6.1 0.3 0:01.34 httpd
323 nobody 16 0 19996 10m 3968 S 5.6 0.3 0:00.73 httpd
31926 nobody 15 0 19992 10m 3968 S 5.0 0.3 0:03.42 httpd
375 nobody 15 0 19988 10m 3968 S 5.0 0.3 0:00.40 httpd
32726 nobody 15 0 19984 10m 3968 S 4.7 0.3 0:01.48 httpd
32495 nobody 16 0 20272 10m 3976 S 4.3 0.3 0:02.79 httpd
32646 nobody 16 0 21248 11m 3968 S 3.8 0.3 0:01.52 httpd
32709 nobody 15 0 20012 10m 3984 S 3.6 0.3 0:01.19 httpd
355 nobody 16 0 19932 10m 3976 S 3.6 0.3 0:00.42 httpd
32485 nobody 15 0 23028 13m 3992 S 3.5 0.4 0:01.73 httpd
20937 nobody 15 0 0 0 0 Z 3.2 0.0 0:04.56 httpd <defunct>
32484 nobody 16 0 21268 11m 3968 S 3.2 0.3 0:02.62 httpd
374 nobody 15 0 19956 10m 3968 S 3.2 0.3 0:00.27 httpd
31914 nobody 15 0 20896 11m 3968 S 3.1 0.3 0:03.92 httpd
31925 nobody 16 0 21040 11m 3968 S 3.1 0.3 0:03.01 httpd
29177 nobody 15 0 20032 10m 3968 S 2.9 0.3 0:02.47 httpd
31867 nobody 15 0 19984 10m 3968 S 2.9 0.3 0:03.59 httpd
32581 nobody 15 0 20008 10m 3976 S 2.8 0.3 0:02.67 httpd
372 nobody 15 0 21252 11m 3968 S 2.5 0.3 0:00.45 httpd
393 nobody 15 0 21148 11m 3944 S 2.5 0.3 0:00.20 httpd
32416 nobody 15 0 21264 11m 3952 S 2.4 0.3 0:00.98 httpd
32144 nobody 15 0 20116 10m 3968 S 2.2 0.3 0:03.37 httpd
457 mysql 16 0 55884 37m 2084 S 2.2 1.0 0:00.16 mysqld
397 nobody 15 0 19812 10m 3952 S 1.8 0.3 0:00.13 httpd
6 root RT 0 0 0 0 S 1.7 0.0 6:43.75 migration/2
356 nobody 15 0 19972 10m 3968 S 1.3 0.3 0:00.37 httpd
28838 nobody 15 0 19976 10m 3968 S 1.0 0.3 0:03.93 httpd
32117 nobody 15 0 20964 11m 3976 S 1.0 0.3 0:03.96 httpd
32494 nobody 15 0 19984 10m 3968 S 0.7 0.3 0:01.56 httpd
32728 nobody 16 0 22560 12m 3980 S 0.7 0.3 0:01.16 httpd
32327 nobody 15 0 22844 12m 3992 S 0.6 0.4 0:04.19 httpd
32473 nobody 16 0 19980 10m 3968 S 0.6 0.3 0:01.48 httpd
28518 mysql 16 0 55884 37m 2084 S 0.3 1.0 0:04.43 mysqld
29086 nobody 15 0 22572 12m 3980 S 0.3 0.3 0:02.11 httpd
31899 root 16 0 3268 1040 744 R 0.3 0.0 0:00.48 top
32159 nobody 15 0 20032 10m 3984 S 0.3 0.3 0:02.73 httpd
425 mysql 16 0 55884 37m 2084 S 0.3 1.0 0:00.02 mysqld
471 mysql 16 0 55884 37m 2084 S 0.3 1.0 0:00.02 mysqld
429 mysql 17 0 55884 37m 2084 S 0.1 1.0 0:00.01 mysqld
469 mysql 17 0 55884 37m 2084 S 0.1 1.0 0:00.01 mysqld
475 mysql 16 0 55884 37m 2084 S 0.1 1.0 0:00.01 mysqld
477 mysql 16 0 55884 37m 2084 S 0.1 1.0 0:00.01 mysqld
--- 3
top - 16:41:00 up 1 day, 13 min, 2 users, load average: 2.49, 2.29, 2.56
Tasks: 206 total, 1 running, 204 sleeping, 0 stopped, 1 zombie
Cpu(s): 26.7% us, 4.1% sy, 0.0% ni, 68.8% id, 0.4% wa, 0.0% hi, 0.0% si
Mem: 3764412k total, 1736208k used, 2028204k free, 138276k buffers
Swap: 1052248k total, 0k used, 1052248k free, 897044k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
25805 nobody 15 0 22844 12m 3992 S 9.0 0.4 0:00.79 httpd
25467 nobody 15 0 20776 10m 3980 S 8.3 0.3 0:01.92 httpd
25808 nobody 16 0 20040 10m 3968 S 8.3 0.3 0:00.64 httpd
25811 nobody 16 0 19988 10m 3968 S 8.3 0.3 0:00.85 httpd
25261 nobody 15 0 21100 11m 3968 S 8.0 0.3 0:03.67 httpd
25809 nobody 15 0 20036 10m 3968 S 7.0 0.3 0:00.92 httpd
25825 nobody 15 0 20056 10m 3968 S 6.6 0.3 0:01.05 httpd
25810 nobody 16 0 20012 10m 3968 S 5.0 0.3 0:00.80 httpd
25823 nobody 15 0 19968 10m 3968 S 5.0 0.3 0:00.76 httpd
25832 nobody 15 0 21256 11m 3952 S 5.0 0.3 0:00.28 httpd
25481 nobody 16 0 20024 10m 3968 S 4.6 0.3 0:02.05 httpd
25468 nobody 15 0 22780 12m 3980 S 4.3 0.4 0:01.44 httpd
25795 nobody 16 0 19940 10m 3976 S 4.3 0.3 0:00.40 httpd
25523 nobody 16 0 20036 10m 3968 S 4.0 0.3 0:02.41 httpd
25541 nobody 15 0 23068 13m 3992 S 3.6 0.4 0:02.09 httpd
6 root RT 0 0 0 0 S 1.3 0.0 6:35.73 migration/2
22281 nobody 15 0 21232 11m 3968 S 1.3 0.3 0:02.26 httpd
25730 nobody 15 0 20872 11m 3968 S 1.3 0.3 0:01.05 httpd
22198 nobody 15 0 19988 10m 3968 S 1.0 0.3 0:03.19 httpd
24910 nobody 15 0 22844 12m 3992 S 1.0 0.4 0:02.76 httpd
25510 nobody 15 0 22596 12m 3980 S 1.0 0.3 0:02.20 httpd
25652 nobody 15 0 19980 10m 3968 S 1.0 0.3 0:01.14 httpd
25796 nobody 16 0 19976 10m 3968 S 1.0 0.3 0:00.82 httpd
25828 nobody 15 0 20868 11m 3952 S 1.0 0.3 0:00.60 httpd
30491 root 16 0 3880 1052 748 R 0.7 0.0 0:10.36 top
11093 nobody 15 0 20040 10m 3968 S 0.7 0.3 0:03.95 httpd
24909 nobody 15 0 21036 11m 3968 S 0.7 0.3 0:02.87 httpd
25289 nobody 15 0 21000 11m 3968 S 0.7 0.3 0:02.01 httpd
25479 nobody 16 0 20768 10m 3968 S 0.7 0.3 0:02.00 httpd
25522 nobody 15 0 20028 10m 3968 S 0.7 0.3 0:01.92 httpd
25729 nobody 15 0 19992 10m 3968 S 0.7 0.3 0:00.93 httpd
25777 nobody 15 0 19972 10m 3976 S 0.7 0.3 0:00.74 httpd
25787 nobody 15 0 20000 10m 3968 S 0.7 0.3 0:01.37 httpd
25788 nobody 15 0 19920 10m 3948 S 0.7 0.3 0:00.26 httpd
25807 nobody 16 0 19988 10m 3968 S 0.7 0.3 0:00.32 httpd
25812 nobody 15 0 19964 10m 3964 S 0.7 0.3 0:00.55 httpd
25830 nobody 15 0 0 0 0 Z 0.7 0.0 0:01.18 httpd <defunct>
25794 nobody 15 0 19952 10m 3964 S 0.3 0.3 0:00.33 httpd
25797 nobody 15 0 19820 10m 3936 S 0.3 0.3 0:00.21 httpd
25826 nobody 15 0 19956 10m 3944 S 0.3 0.3 0:00.28 httpd
25997 mysql 16 0 54392 37m 2084 S 0.3 1.0 0:00.01 mysqld
1 root 16 0 2916 552 476 S 0.0 0.0 0:01.40 init
2 root RT 0 0 0 0 S 0.0 0.0 0:00.14 migration/0
3 root 34 19 0 0 0 S 0.0 0.0 0:00.01 ksoftirqd/0
4 root RT 0 0 0 0 S 0.0 0.0 0:00.06 migration/1
5 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/1
25479 nobody 15 0 20768 10m 3968 S 0.6 0.3 0:01.98 httpd
25510 nobody 15 0 22596 12m 3980 S 0.6 0.3 0:02.17 httpd
25541 nobody 15 0 23068 13m 3992 S 0.6 0.4 0:01.98 httpd
--- 4
top - 16:42:53 up 1 day, 15 min, 2 users, load average: 2.73, 2.35, 2.54
Tasks: 205 total, 3 running, 202 sleeping, 0 stopped, 0 zombie
Cpu(s): 44.2% us, 5.1% sy, 0.0% ni, 50.3% id, 0.4% wa, 0.0% hi, 0.0% si
Mem: 3764412k total, 1704328k used, 2060084k free, 138284k buffers
Swap: 1052248k total, 0k used, 1052248k free, 897816k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
26357 nobody 16 0 19988 10m 3976 S 14.9 0.3 0:03.19 httpd
23529 nobody 16 0 20960 11m 3976 S 13.3 0.3 0:01.81 httpd
26895 nobody 17 0 19960 10m 3968 S 12.9 0.3 0:00.45 httpd
26771 nobody 16 0 21244 11m 3968 S 11.6 0.3 0:00.70 httpd
26882 nobody 16 0 20144 10m 3968 S 11.6 0.3 0:00.98 httpd
26460 nobody 15 0 20944 11m 3968 S 10.6 0.3 0:03.58 httpd
26606 nobody 15 0 20016 10m 3968 S 10.6 0.3 0:01.31 httpd
26758 nobody 15 0 20040 10m 3968 S 10.0 0.3 0:01.32 httpd
26564 nobody 16 0 20000 10m 3968 S 9.6 0.3 0:01.43 httpd
26643 nobody 17 0 19996 10m 3968 S 9.6 0.3 0:01.84 httpd
26711 nobody 15 0 20052 10m 3968 S 8.6 0.3 0:01.79 httpd
26748 nobody 15 0 19980 10m 3968 S 8.0 0.3 0:01.17 httpd
26712 nobody 16 0 20056 10m 3968 S 7.6 0.3 0:01.45 httpd
26456 nobody 15 0 19980 10m 3968 S 7.0 0.3 0:03.47 httpd
26189 nobody 15 0 20284 10m 3976 S 6.6 0.3 0:02.25 httpd
26881 nobody 15 0 20036 10m 3968 S 5.3 0.3 0:00.94 httpd
27000 nobody 16 0 19948 10m 3936 S 4.6 0.3 0:00.14 httpd
26892 nobody 16 0 21392 11m 3980 R 2.3 0.3 0:00.98 httpd
26624 nobody 15 0 21020 11m 3968 S 1.3 0.3 0:01.99 httpd
26803 nobody 15 0 20028 10m 3968 S 1.3 0.3 0:01.01 httpd
26454 nobody 15 0 20004 10m 3968 S 1.0 0.3 0:03.65 httpd
26769 nobody 15 0 20000 10m 3944 S 1.0 0.3 0:00.40 httpd
26786 nobody 15 0 20116 10m 3984 S 1.0 0.3 0:01.53 httpd
6 root RT 0 0 0 0 S 0.7 0.0 6:36.95 migration/2
23242 nobody 15 0 22732 12m 3976 S 0.7 0.3 0:02.24 httpd
26180 nobody 15 0 20036 10m 3976 S 0.7 0.3 0:02.44 httpd
26426 nobody 15 0 22748 12m 3980 S 0.7 0.3 0:02.31 httpd
26703 nobody 15 0 20004 10m 3984 S 0.7 0.3 0:01.62 httpd
26863 nobody 15 0 19928 10m 3940 S 0.7 0.3 0:00.16 httpd
26883 nobody 15 0 19984 10m 3968 S 0.7 0.3 0:00.66 httpd
26988 nobody 15 0 16484 6676 3784 S 0.7 0.2 0:00.02 httpd
17636 root 16 0 16348 6476 3712 S 0.3 0.2 0:05.28 httpd
26508 root 16 0 2788 1028 744 R 0.3 0.0 0:00.21 top
26757 nobody 15 0 22752 12m 3980 S 0.3 0.3 0:00.92 httpd
26880 nobody 15 0 20020 10m 3968 S 0.3 0.3 0:00.55 httpd
26999 nobody 15 0 16484 6672 3780 S 0.3 0.2 0:00.01 httpd
27005 mysql 17 0 55160 37m 2084 S 0.3 1.0 0:00.01 mysqld
1 root 16 0 2916 552 476 S 0.0 0.0 0:01.40 init
2 root RT 0 0 0 0 S 0.0 0.0 0:00.14 migration/0
3 root 34 19 0 0 0 S 0.0 0.0 0:00.01 ksoftirqd/0
4 root RT 0 0 0 0 S 0.0 0.0 0:00.06 migration/1
5 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/1
7 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/2
8 root RT 0 0 0 0 S 0.0 0.0 0:44.14 migration/3
9 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/3
10 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 events/0
11 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 events/1
12 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 events/2
13 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 events/3
14 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 khelper
6. your mysql configuration variables located at /etc/my.cnf or c:\my.cnf so post the contents inside of my.cnf (minus any passwords of course). If on Windows server if you don't have that file you need to log into telnet and as root user type
---
+---------------------------------+---------------------------------------------------+
| Variable_name | Value |
+---------------------------------+---------------------------------------------------+
| back_log | 50 |
| basedir | / |
| binlog_cache_size | 32768 |
| bulk_insert_buffer_size | 8388608 |
| character_set | latin1 |
| character_sets | latin1 big5 czech euc_kr gb2312 gbk latin1_de sjis tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 |
| concurrent_insert | ON |
| connect_timeout | 5 |
| convert_character_set | |
| datadir | /var/lib/mysql/ |
| default_week_format | 0 |
| delay_key_write | ON |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| flush | OFF |
| flush_time | 0 |
| ft_boolean_syntax | + -><()~*:""&| |
| ft_min_word_len | 4 |
| ft_max_word_len | 254 |
| ft_max_word_len_for_sort | 20 |
| ft_stopword_file | (built-in) |
| have_bdb | NO |
| have_crypt | YES |
| have_innodb | YES |
| have_isam | YES |
| have_raid | NO |
| have_symlink | YES |
| have_openssl | NO |
| have_query_cache | YES |
| init_file | |
| innodb_additional_mem_pool_size | 1048576 |
| innodb_autoextend_increment | 8 |
| innodb_buffer_pool_size | 8388608 |
| innodb_data_file_path | ibdata1:10M:autoextend |
| innodb_data_home_dir | |
| innodb_file_io_threads | 4 |
| innodb_force_recovery | 0 |
| innodb_thread_concurrency | 8 |
| innodb_flush_log_at_trx_commit | 1 |
| innodb_fast_shutdown | ON |
| innodb_flush_method | |
| innodb_lock_wait_timeout | 50 |
| 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_mirrored_log_groups | 1 |
| innodb_max_dirty_pages_pct | 90 |
| innodb_max_purge_lag | 0 |
| innodb_table_locks | ON |
| interactive_timeout | 28800 |
| join_buffer_size | 131072 |
| key_buffer_size | 8388600 |
| language | /usr/share/mysql/english/ |
| large_files_support | ON |
| license | GPL |
| local_infile | ON |
| locked_in_memory | OFF |
| log | OFF |
| log_update | OFF |
| log_bin | OFF |
| log_slave_updates | OFF |
| log_slow_queries | 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 | 1048576 |
| max_binlog_cache_size | 4294967295 |
| max_binlog_size | 1073741824 |
| max_connections | 950 |
| max_connect_errors | 10 |
| max_delayed_threads | 20 |
| max_insert_delayed_threads | 20 |
| max_heap_table_size | 16777216 |
| max_join_size | 4294967295 |
| max_relay_log_size | 0 |
| max_seeks_for_key | 4294967295 |
| max_sort_length | 1024 |
| max_user_connections | 0 |
| max_tmp_tables | 32 |
| max_write_lock_count | 4294967295 |
| myisam_max_extra_sort_file_size | 268435456 |
| myisam_max_sort_file_size | 2147483647 |
| myisam_repair_threads | 1 |
| myisam_recover_options | OFF |
| myisam_sort_buffer_size | 8388608 |
| net_buffer_length | 16384 |
| net_read_timeout | 30 |
| net_retry_count | 10 |
| net_write_timeout | 60 |
| new | OFF |
| open_files_limit | 4760 |
| pid_file | /var/lib/mysql/server-598.saudiprovider.net.pid |
| log_error | |
| port | 3306 |
| protocol_version | 10 |
| query_alloc_block_size | 8192 |
| query_cache_limit | 1048576 |
| query_cache_size | 0 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 8192 |
| range_alloc_block_size | 2048 |
| read_buffer_size | 131072 |
| read_only | OFF |
| read_rnd_buffer_size | 262144 |
| rpl_recovery_rank | 0 |
| server_id | 0 |
| slave_net_timeout | 3600 |
| skip_external_locking | ON |
| skip_networking | OFF |
| skip_show_database | OFF |
| slow_launch_time | 2 |
| socket | /var/lib/mysql/mysql.sock |
| sort_buffer_size | 2097144 |
| sql_mode | 0 |
| table_cache | 64 |
| table_type | MYISAM |
| thread_cache_size | 0 |
| thread_stack | 126976 |
| tx_isolation | REPEATABLE-READ |
| timezone | AST |
| tmp_table_size | 33554432 |
| tmpdir | /tmp/ |
| transaction_alloc_block_size | 8192 |
| transaction_prealloc_size | 4096 |
| version | 4.0.25-standard |
| version_comment | Official MySQL RPM |
| version_compile_os | pc-linux-gnu |
| wait_timeout | 28800 |
+---------------------------------+---------------------------------------------------+
7. your mysql extended-status output which shows entire server's mysql activity status (preferably with a day or 2 worth of mysql uptime for better indication of real activity) either:
---
+--------------------------+-----------+
| Variable_name | Value |
+--------------------------+-----------+
| Aborted_clients | 4 |
| Aborted_connects | 1 |
| Bytes_received | 189989341 |
| Bytes_sent | 300431971 |
| Com_admin_commands | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 36860 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_commit | 0 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 0 |
| Com_delete | 2422 |
| Com_delete_multi | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_flush | 0 |
| Com_grant | 0 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_insert | 33923 |
| Com_insert_select | 569 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 69 |
| Com_optimize | 0 |
| Com_purge | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 1373 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 393052 |
| Com_set_option | 38 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_create | 0 |
| Com_show_databases | 1 |
| Com_show_fields | 0 |
| Com_show_grants | 0 |
| Com_show_keys | 0 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_processlist | 37 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 13 |
| Com_show_innodb_status | 0 |
| Com_show_tables | 4 |
| Com_show_variables | 10 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 66 |
| Com_update | 66818 |
| Com_update_multi | 3 |
| Connections | 36975 |
| Created_tmp_disk_tables | 168 |
| Created_tmp_tables | 8238 |
| Created_tmp_files | 3 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 25295 |
| Handler_read_first | 70021 |
| Handler_read_key | 11711099 |
| Handler_read_next | 53214891 |
| Handler_read_prev | 376058 |
| Handler_read_rnd | 11421946 |
| Handler_read_rnd_next | 34450456 |
| Handler_rollback | 0 |
| Handler_update | 68887 |
| Handler_write | 6794275 |
| Key_blocks_used | 7793 |
| Key_read_requests | 41069612 |
| Key_reads | 127802 |
| Key_write_requests | 43704 |
| Key_writes | 49905 |
| Max_used_connections | 58 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 64 |
| Open_files | 89 |
| Open_streams | 0 |
| Opened_tables | 7651 |
| Questions | 572190 |
| Qcache_queries_in_cache | 0 |
| Qcache_inserts | 0 |
| Qcache_hits | 0 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 0 |
| Qcache_free_memory | 0 |
| Qcache_free_blocks | 0 |
| Qcache_total_blocks | 0 |
| Rpl_status | NULL |
| Select_full_join | 409 |
| Select_full_range_join | 0 |
| Select_range | 96752 |
| Select_range_check | 0 |
| Select_scan | 83408 |
| Slave_open_temp_tables | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 1 |
| Slow_queries | 0 |
| Sort_merge_passes | 0 |
| Sort_range | 88669 |
| Sort_rows | 11430587 |
| Sort_scan | 10198 |
| Table_locks_immediate | 834783 |
| Table_locks_waited | 9815 |
| Threads_cached | 0 |
| Threads_created | 36974 |
| Threads_connected | 28 |
| Threads_running | 1 |
| Uptime | 5494 |
+--------------------------+-----------+
8. is your vB the only thing on the server? or other scripts & sites which utilise php and mysql?
--- Only vB
9. how many average and max concurrent users on your vB forum ? and what your cookie timeout is ? 1200 - 1800 User - Timeout : 900
10. create a file named phpinfo.php and place this code in it and post the url/link to it from your web site
--- http://www.hawamer.com/phpinfo.php (javascript:ol('http://www.hawamer.com/phpinfo.php');)
11. if you run Apache and you have your own dedicated server or access to your httpd.conf (apache configuration file) can you post the values you have set for the following :
KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 10
MinSpareServers 5
MaxSpareServers 10
StartServers 5
MaxClients 396
AND Maxrequestsperchild value = 100
12. what version of vB are you running ?
--- 3.5.1
13. check to see if any files i.e. apache log files are hitting 2GB or 4GB max file size limits i.e. see if you have max file size exceeded messages in apache error log
--- nothing there
----------------------
some times the server is down