Server optimization request [Archive] - vBulletin Community Forum

View Full Version : Server optimization request

Alawadat

Sun 3rd Feb '08, 3:29pm

Hi,
Eva2000 can you please provide us with the best configuration to optimize our *new* server?

This is the requested information:
> 1. dedicated server.
> 2. server specs.:
Intel Xeon Quad-Core E5345 2.33GHz 1333MHz CPU
4 GB DDR2-667 ECC RAM
36 GB SCSI HDD
Dual 250 GB SATA RAID1 Hard Drives
Intel Pro100M Network Card
Server Type Linux CentOS 5.0 Final
Web Server Apache v2.2.3
PHP 5.1.6
PHP Max Post Size 8.00 MB
PHP Maximum Upload Size 2.00 MB
PHP Memory Limit 32.00 MB
MySQL Version 5.0.22
MySQL Packet Size 64.00 MB
> 3. version of vB is: (vBulletin 3.6.8 Patch Level 2)
> 4. yes we have innodb databases
> 5. mysql version that comes with CentOS 5.0 final
> 6. top
top - 19:14:03 up 3:11, 2 users, load average: 2.27, 1.39, 1.25
Tasks: 227 total, 2 running, 225 sleeping, 0 stopped, 0 zombie
Cpu(s): 8.1%us, 0.8%sy, 0.0%ni, 82.0%id, 9.0%wa, 0.0%hi, 0.1%si, 0.0%st
Mem: 4149608k total, 2796792k used, 1352816k free, 240528k buffers
Swap: 2104504k total, 0k used, 2104504k free, 1745012k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
13591 apache 16 0 39744 17m 4296 S 10 0.4 0:02.29 httpd
14056 apache 15 0 37280 14m 4240 R 4 0.4 0:00.53 httpd
1 root 15 0 2044 644 552 S 0 0.0 0:00.94 init
2 root RT 0 0 0 0 S 0 0.0 0:00.02 migration/0
3 root 34 19 0 0 0 S 0 0.0 0:00.00 ksoftirqd/0
4 root RT 0 0 0 0 S 0 0.0 0:00.00 watchdog/0
5 root RT 0 0 0 0 S 0 0.0 0:00.15 migration/1
6 root 34 19 0 0 0 S 0 0.0 0:00.00 ksoftirqd/1
7 root RT 0 0 0 0 S 0 0.0 0:00.00 watchdog/1
8 root RT 0 0 0 0 S 0 0.0 0:02.51 migration/2
9 root 34 19 0 0 0 S 0 0.0 0:00.00 ksoftirqd/2
10 root RT 0 0 0 0 S 0 0.0 0:00.00 watchdog/2
11 root RT 0 0 0 0 S 0 0.0 0:00.23 migration/3
12 root 34 19 0 0 0 S 0 0.0 0:00.00 ksoftirqd/3
13 root RT 0 0 0 0 S 0 0.0 0:00.00 watchdog/3
14 root 10 -5 0 0 0 S 0 0.0 0:00.00 events/0
15 root 10 -5 0 0 0 S 0 0.0 0:00.00 events/1
16 root 10 -5 0 0 0 S 0 0.0 0:00.00 events/2
17 root 10 -5 0 0 0 S 0 0.0 0:00.00 events/3
18 root 10 -5 0 0 0 S 0 0.0 0:00.00 khelper
19 root 12 -5 0 0 0 S 0 0.0 0:00.00 kthread
25 root 20 -5 0 0 0 S 0 0.0 0:00.00 kblockd/0
26 root 10 -5 0 0 0 S 0 0.0 0:00.02 kblockd/1
27 root 10 -5 0 0 0 S 0 0.0 0:00.00 kblockd/2
28 root 13 -5 0 0 0 S 0 0.0 0:00.01 kblockd/3
29 root 14 -5 0 0 0 S 0 0.0 0:00.00 kacpid
136 root 14 -5 0 0 0 S 0 0.0 0:00.00 cqueue/0
137 root 14 -5 0 0 0 S 0 0.0 0:00.00 cqueue/1
138 root 14 -5 0 0 0 S 0 0.0 0:00.00 cqueue/2
139 root 14 -5 0 0 0 S 0 0.0 0:00.00 cqueue/3
142 root 10 -5 0 0 0 S 0 0.0 0:00.00 khubd
144 root 10 -5 0 0 0 S 0 0.0 0:00.00 kseriod
219 root 19 0 0 0 0 S 0 0.0 0:00.00 pdflush
220 root 15 0 0 0 0 S 0 0.0 0:00.25 pdflush
221 root 14 -5 0 0 0 S 0 0.0 0:00.00 kswapd0
222 root 14 -5 0 0 0 S 0 0.0 0:00.00 aio/0
223 root 15 -5 0 0 0 S 0 0.0 0:00.00 aio/1
224 root 15 -5 0 0 0 S 0 0.0 0:00.00 aio/2
225 root 14 -5 0 0 0 S 0 0.0 0:00.00 aio/3
387 root 11 -5 0 0 0 S 0 0.0 0:00.00 kpsmoused
438 root 17 -5 0 0 0 S 0 0.0 0:00.00 scsi_eh_0
459 root 15 -5 0 0 0 S 0 0.0 0:00.00 ksnapd
460 root 10 -5 0 0 0 S 0 0.0 0:16.59 kjournald
487 root 10 -5 0 0 0 S 0 0.0 0:00.00 kauditd
521 root 21 -4 2216 628 384 S 0 0.0 0:00.07 udevd
1080 root 16 -5 0 0 0 S 0 0.0 0:00.00 scsi_eh_1
1088 root 17 -5 0 0 0 S 0 0.0 0:00.00 ata/0
1089 root 18 -5 0 0 0 S 0 0.0 0:00.00 ata/1
1092 root 19 -5 0 0 0 S 0 0.0 0:00.00 ata/2
1096 root 19 -5 0 0 0 S 0 0.0 0:00.00 ata/3
1098 root 20 -5 0 0 0 S 0 0.0 0:00.00 ata_aux
1569 root 20 -5 0 0 0 S 0 0.0 0:00.00 kmpathd/0
1570 root 10 -5 0 0 0 S 0 0.0 0:00.00 kmpathd/1
1571 root 10 -5 0 0 0 S 0 0.0 0:00.00 kmpathd/2
1572 root 10 -5 0 0 0 S 0 0.0 0:00.00 kmpathd/3
1597 root 10 -5 0 0 0 S 0 0.0 0:00.00 kjournald
2217 root 16 -3 12060 644 488 S 0 0.0 0:00.01 auditd
2219 root 12 -3 10084 3932 2296 S 0 0.1 0:00.05 python
2237 root 16 0 1700 576 488 S 0 0.0 0:10.86 syslogd
2240 root 15 0 1656 396 328 S 0 0.0 0:00.00 klogd
2257 root 18 0 2412 368 260 S 0 0.0 0:00.03 irqbalance
2286 dbus 15 0 2720 888 712 S 0 0.0 0:00.00 dbus-daemon
2311 root 22 0 9360 1120 884 S 0 0.0 0:00.00 automount
2335 root 18 0 1652 532 448 S 0 0.0 0:00.00 acpid
2364 root 18 0 6148 1032 668 S 0 0.0 0:00.05 sshd
2402 root 23 0 2680 868 700 S 0 0.0 0:02.54 xinetd
2437 root 25 0 5828 732 560 S 0 0.0 0:00.00 couriertcpd
2439 root 25 0 4676 920 768 S 0 0.0 0:00.00 courierlogger
2447 root 25 0 5832 732 560 S 0 0.0 0:00.00 couriertcpd
2449 root 25 0 4680 752 612 S 0 0.0 0:00.00 courierlogger
2455 root 18 0 5828 744 572 S 0 0.0 0:00.01 couriertcpd
2457 root 17 0 4680 812 660 S 0 0.0 0:00.00 courierlogger
2464 root 25 0 5828 812 568 S 0 0.0 0:00.00 couriertcpd
2466 root 25 0 4676 752 612 S 0 0.0 0:00.00 courierlogger
2481 qmails 16 0 1824 732 404 S 0 0.0 0:13.90 qmail-send
2483 qmaill 16 0 1648 472 400 S 0 0.0 0:03.99 splogger
2484 root 25 0 1672 380 284 S 0 0.0 0:01.56 qmail-lspawn
2485 qmailr 16 0 1668 400 300 S 0 0.0 0:00.84 qmail-rspawn
2486 qmailq 18 0 1640 352 288 S 0 0.0 0:01.73 qmail-clean
2546 named 25 0 68656 3276 1892 S 0 0.1 0:00.00 named
2613 root 25 0 4496 1188 1036 S 0 0.0 0:00.00 mysqld_safe
2646 mysql 15 0 270m 126m 4992 S 0 3.1 3:46.38 mysqld
2759 postgres 18 0 20896 3156 2756 S 0 0.1 0:00.66 postmaster
2815 root 15 0 31148 26m 2352 S 0 0.6 0:00.35 spamd
2817 postgres 18 0 10676 736 332 S 0 0.0 0:00.00 postmaster
2819 postgres 15 0 20896 992 588 S 0 0.0 0:00.00 postmaster
2820 postgres 18 0 11676 720 316 S 0 0.0 0:00.00 postmaster
2821 postgres 21 0 10908 916 388 S 0 0.0 0:00.00 postmaster
2822 popuser 18 0 31148 24m 828 S 0 0.6 0:00.00 spamd
2823 popuser 18 0 31148 24m 792 S 0 0.6 0:00.00 spamd
2841 root 18 0 33248 13m 7488 S 0 0.3 0:00.27 httpd
2851 apache 18 0 22928 4436 492 S 0 0.1 0:00.00 httpd
2873 root 15 0 37904 5332 3416 S 0 0.1 0:00.01 httpsd
2876 psaadm 15 0 45456 17m 10m S 0 0.4 0:00.47 httpsd
2923 psaadm 17 0 44080 15m 9.9m S 0 0.4 0:00.23 httpsd
2941 drweb 15 0 23820 16m 488 S 0 0.4 0:00.00 drwebd
2942 drweb 15 0 23820 16m 804 S 0 0.4 0:00.05 drwebd
2943 drweb 15 0 23820 16m 808 S 0 0.4 0:00.08 drwebd
2944 drweb 18 0 23820 16m 372 S 0 0.4 0:00.00 drwebd
2945 drweb 15 0 23820 16m 808 S 0 0.4 0:00.06 drwebd
2960 root 18 0 5244 1116 580 S 0 0.0 0:00.00 crond
3006 root 18 0 2220 420 300 S 0 0.0 0:00.00 atd
3022 root 15 0 33200 19m 3588 S 0 0.5 0:02.73 yum-updatesd
3037 haldaemo 17 0 5348 3496 1608 S 0 0.1 0:00.41 hald
3038 root 25 0 3116 968 820 S 0 0.0 0:00.00 hald-runner
3046 haldaemo 19 0 1976 784 696 S 0 0.0 0:00.00 hald-addon-acpi
3229 root 16 0 1916 364 292 S 0 0.0 0:00.00 smartd
3232 root 20 0 1636 432 376 S 0 0.0 0:00.00 mingetty
3233 root 20 0 1636 432 376 S 0 0.0 0:00.00 mingetty
3234 root 18 0 1636 428 376 S 0 0.0 0:00.00 mingetty
3235 root 22 0 1640 436 376 S 0 0.0 0:00.00 mingetty
3237 root 22 0 1636 428 376 S 0 0.0 0:00.00 mingetty
3239 root 20 0 1640 436 376 S 0 0.0 0:00.00 mingetty
4421 apache 15 0 40724 18m 4648 S 0 0.5 0:10.45 httpd
4476 apache 16 0 39884 17m 4644 S 0 0.4 0:09.31 httpd
5637 qmailr 18 0 3360 672 556 S 0 0.0 0:00.00 qmail-remote
5639 qmailr 17 0 4720 1048 880 S 0 0.0 0:00.00 qmail-remote.mo
5674 qmailr 18 0 3360 668 556 S 0 0.0 0:00.00 qmail-remote
5677 qmailr 15 0 4716 1048 880 S 0 0.0 0:00.00 qmail-remote.mo
5727 apache 15 0 40800 18m 5000 S 0 0.5 0:11.78 httpd
5728 apache 15 0 40428 17m 4356 S 0 0.4 0:08.61 httpd
5880 qmailr 18 0 3360 792 612 S 0 0.0 0:00.00 qmail-remote
5881 qmailr 15 0 4720 1048 880 S 0 0.0 0:00.00 qmail-remote.mo
6660 qmaild 17 0 4744 1028 864 S 0 0.0 0:00.00 qmail-smtpd
6802 drweb 17 0 1776 664 580 S 0 0.0 0:00.00 qmail-queue
7024 apache 15 0 40952 18m 4720 S 0 0.5 0:08.70 httpd
8136 apache 18 0 39032 16m 4640 S 0 0.4 0:06.85 httpd
8234 qmaild 17 0 4740 1028 868 S 0 0.0 0:00.00 qmail-smtpd
8300 drweb 18 0 1772 664 580 S 0 0.0 0:00.00 qmail-queue
8409 apache 15 0 39764 17m 4712 S 0 0.4 0:06.88 httpd
8411 apache 15 0 39692 17m 4716 S 0 0.4 0:07.51 httpd
8708 apache 15 0 39936 17m 4948 S 0 0.4 0:06.27 httpd
8709 apache 15 0 40804 18m 4928 S 0 0.5 0:04.50 httpd
8922 qmailr 18 0 3360 672 560 S 0 0.0 0:00.00 qmail-remote
8923 qmailr 18 0 4720 1048 880 S 0 0.0 0:00.00 qmail-remote.mo
9542 apache 16 0 39756 17m 4628 S 0 0.4 0:06.33 httpd
9786 apache 21 0 38284 16m 4940 S 0 0.4 0:03.68 httpd
10965 qmailr 18 0 3360 788 612 S 0 0.0 0:00.00 qmail-remote
10966 qmailr 17 0 4716 1044 880 S 0 0.0 0:00.00 qmail-remote.mo
11063 qmailr 18 0 3360 668 556 S 0 0.0 0:00.00 qmail-remote
11064 qmailr 18 0 3364 672 556 S 0 0.0 0:00.00 qmail-remote
11065 qmailr 18 0 4720 1048 880 S 0 0.0 0:00.00 qmail-remote.mo
11066 qmailr 18 0 4720 1048 880 S 0 0.0 0:00.00 qmail-remote.mo
11188 root 16 0 10900 3024 2396 S 0 0.1 0:00.02 sshd
11204 apache 15 0 38332 15m 4272 S 0 0.4 0:02.95 httpd
11211 apache 15 0 41684 19m 4952 S 0 0.5 0:04.83 httpd
11212 apache 15 0 40712 18m 4640 S 0 0.5 0:03.89 httpd
11224 apache 15 0 39764 17m 4644 S 0 0.4 0:04.46 httpd
11228 apache 15 0 38296 15m 4252 S 0 0.4 0:02.25 httpd
11229 apache 15 0 40008 17m 4364 S 0 0.4 0:04.32 httpd
11356 root 16 0 4632 1436 1164 S 0 0.0 0:00.01 bash
11468 root 16 0 2300 1096 792 S 0 0.0 0:00.97 top
11504 qmailr 18 0 3360 668 556 S 0 0.0 0:00.00 qmail-remote
11505 qmailr 18 0 4720 1052 884 S 0 0.0 0:00.00 qmail-remote.mo
11532 qmailr 18 0 3364 672 556 S 0 0.0 0:00.00 qmail-remote
11533 qmailr 18 0 4720 1048 880 S 0 0.0 0:00.00 qmail-remote.mo
11740 qmailr 18 0 3364 672 556 S 0 0.0 0:00.00 qmail-remote
11741 qmailr 15 0 4720 1048 880 S 0 0.0 0:00.00 qmail-remote.mo
11751 qmailr 18 0 3360 664 556 S 0 0.0 0:00.00 qmail-remote
11752 qmailr 15 0 4716 1044 880 S 0 0.0 0:00.00 qmail-remote.mo
11996 qmaild 16 0 4740 1024 860 S 0 0.0 0:00.00 qmail-smtpd
12147 apache 15 0 38448 16m 4636 S 0 0.4 0:02.27 httpd
12157 apache 15 0 41620 18m 4280 S 0 0.5 0:03.61 httpd
12161 apache 15 0 40304 18m 4688 S 0 0.4 0:02.72 httpd
12167 qmailr 18 0 3360 668 556 S 0 0.0 0:00.00 qmail-remote
12168 qmailr 17 0 4716 1048 880 S 0 0.0 0:00.00 qmail-remote.mo
12191 apache 15 0 38756 16m 4292 S 0 0.4 0:02.59 httpd
12193 apache 15 0 40812 18m 4284 S 0 0.4 0:03.70 httpd
12335 qmaild 15 0 4744 1028 864 S 0 0.0 0:00.00 qmail-smtpd
12388 apache 15 0 39248 16m 4620 S 0 0.4 0:02.40 httpd
12389 qmailr 18 0 3360 672 556 S 0 0.0 0:00.00 qmail-remote
12390 qmailr 18 0 4720 1048 880 S 0 0.0 0:00.00 qmail-remote.mo
12660 qmaild 18 0 4744 996 828 S 0 0.0 0:00.00 qmail-smtpd
12834 drweb 16 0 1776 664 580 S 0 0.0 0:00.00 qmail-queue
12974 apache 15 0 40764 18m 4304 S 0 0.4 0:02.12 httpd
12975 apache 15 0 40356 18m 4680 S 0 0.4 0:02.71 httpd
13075 qmailr 18 0 3364 672 556 S 0 0.0 0:00.00 qmail-remote
13077 qmailr 18 0 4720 1048 880 S 0 0.0 0:00.00 qmail-remote.mo
13122 qmailr 18 0 3360 668 556 S 0 0.0 0:00.00 qmail-remote
13123 qmailr 18 0 4716 1048 880 S 0 0.0 0:00.00 qmail-remote.mo
13131 qmailr 18 0 3364 672 556 S 0 0.0 0:00.00 qmail-remote
13132 qmailr 18 0 4716 1044 880 S 0 0.0 0:00.00 qmail-remote.mo
13261 qmailr 18 0 3364 796 612 S 0 0.0 0:00.00 qmail-remote
13262 qmailr 17 0 4720 1048 880 S 0 0.0 0:00.00 qmail-remote.mo
13330 qmaild 15 0 4740 980 820 S 0 0.0 0:00.00 qmail-smtpd
13339 qmaild 15 0 4744 1028 864 S 0 0.0 0:00.00 qmail-smtpd
13528 qmaild 15 0 4744 984 820 S 0 0.0 0:00.00 qmail-smtpd
13535 qmailr 21 0 3364 672 556 S 0 0.0 0:00.00 qmail-remote
13536 qmailr 18 0 4716 1048 880 S 0 0.0 0:00.00 qmail-remote.mo
13559 qmailr 18 0 3360 672 556 S 0 0.0 0:00.00 qmail-remote
13560 qmailr 17 0 4716 1048 880 S 0 0.0 0:00.00 qmail-remote.mo
13585 apache 15 0 38916 16m 4224 S 0 0.4 0:02.04 httpd
13588 apache 15 0 40828 18m 4236 S 0 0.4 0:01.37 httpd
13589 apache 15 0 38360 15m 4576 S 0 0.4 0:01.81 httpd
13592 apache 15 0 39544 17m 4572 S 0 0.4 0:01.80 httpd
13594 apache 15 0 40776 18m 4544 S 0 0.5 0:02.10 httpd
13606 apache 15 0 38532 16m 4628 S 0 0.4 0:01.65 httpd
13607 apache 16 0 39532 17m 4656 S 0 0.4 0:01.01 httpd
13612 apache 16 0 37696 15m 4272 S 0 0.4 0:01.00 httpd
13613 apache 15 0 39332 16m 4188 S 0 0.4 0:01.43 httpd
13623 qmaild 18 0 4744 992 820 S 0 0.0 0:00.00 qmail-smtpd
13743 apache 16 0 42920 20m 4896 S 0 0.5 0:01.28 httpd
13807 drweb 17 0 1776 664 584 S 0 0.0 0:00.00 qmail-queue
13821 apache 15 0 38048 15m 4536 S 0 0.4 0:01.62 httpd
13822 apache 15 0 38212 15m 4524 S 0 0.4 0:00.83 httpd
13823 apache 16 0 39092 16m 4520 S 0 0.4 0:00.75 httpd
13873 qmaild 16 0 4744 976 808 S 0 0.0 0:00.00 qmail-smtpd
13891 qmaild 16 0 4744 976 812 S 0 0.0 0:00.00 qmail-smtpd
13912 qmailr 18 0 3364 672 556 S 0 0.0 0:00.00 qmail-remote
13913 qmailr 15 0 4716 1048 880 S 0 0.0 0:00.00 qmail-remote.mo
13954 apache 15 0 37800 15m 4192 S 0 0.4 0:01.06 httpd
13998 apache 15 0 37120 14m 4164 S 0 0.4 0:00.16 httpd
14006 apache 15 0 37640 14m 4184 S 0 0.4 0:00.56 httpd
14007 apache 15 0 40708 17m 4204 S 0 0.4 0:00.51 httpd
14227 qmaild 15 0 4740 1024 864 S 0 0.0 0:00.00 qmail-smtpd
14281 drweb 18 0 1772 660 580 S 0 0.0 0:00.00 qmail-queue
14294 qmaild 18 0 4744 1032 864 S 0 0.0 0:00.00 qmail-smtpd
14298 qmaild 16 0 4744 1028 864 S 0 0.0 0:00.00 qmail-smtpd
14317 drweb 16 0 1772 664 580 S 0 0.0 0:00.00 qmail-queue
14318 qmaild 20 0 4744 992 828 S 0 0.0 0:00.00 qmail-smtpd
14319 root 15 0 2296 976 692 R 0 0.0 0:00.00 top
14320 drweb 19 0 1772 660 580 S 0 0.0 0:00.00 qmail-queue
17640 root 15 0 11060 3036 2384 S 0 0.1 0:00.30 sshd
17882 root 15 0 4636 1496 1208 S 0 0.0 0:00.13 bash
20564 qmaild 18 0 4740 1024 864 S 0 0.0 0:00.00 qmail-smtpd
21563 drweb 17 0 1772 664 580 S 0 0.0 0:00.00 qmail-queue
31144 qmaild 24 0 4740 1028 864 S 0 0.0 0:00.00 qmail-smtpd

...

Alawadat

Sun 3rd Feb '08, 3:30pm

...

> 7. /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
safe-show-database
#skip-innodb
max_connections = 500
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 = 360
connect_timeout = 10
tmp_table_size = 64M
max_allowed_packet = 64M
max_connect_errors = 10
thread_concurrency = 4
query_cache_limit = 1M
query_cache_size = 64M
query_cache_type = 1
query_prealloc_size = 16384
query_alloc_block_size = 16384
old_passwords
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M

> 8. mysqladmin -u root -p var ext stat ver
+---------------------------------+--------------------------------------------------------+
| Variable_name | Value |
+---------------------------------+--------------------------------------------------------+
| auto_increment_increment | 1 |
| auto_increment_offset | 1 |
| automatic_sp_privileges | ON |
| back_log | 50 |
| basedir | /usr/ |
| bdb_cache_size | 8388600 |
| bdb_home | /var/lib/mysql/ |
| bdb_log_buffer_size | 921600 |
| bdb_logdir | |
| bdb_max_lock | 10000 |
| bdb_shared_data | OFF |
| bdb_tmpdir | /tmp/ |
| binlog_cache_size | 32768 |
| bulk_insert_buffer_size | 8388608 |
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| 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 |
| completion_type | 0 |
| concurrent_insert | 1 |
| 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 |
| div_precision_increment | 4 |
| engine_condition_pushdown | OFF |
| expire_logs_days | 0 |
| flush | OFF |
| flush_time | 0 |
| ft_boolean_syntax | + -><()~*:""&| |
| ft_max_word_len | 84 |
| ft_min_word_len | 4 |
| ft_query_expansion_limit | 20 |
| ft_stopword_file | (built-in) |
| group_concat_max_len | 1024 |
| have_archive | NO |
| have_bdb | YES |
| have_blackhole_engine | NO |
| have_compress | YES |
| have_crypt | YES |
| have_csv | NO |
| have_example_engine | NO |
| have_federated_engine | NO |
| have_geometry | YES |
| have_innodb | YES |
| have_isam | NO |
| have_ndbcluster | NO |
| have_openssl | DISABLED |
| 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_checksums | ON |
| innodb_commit_concurrency | 0 |
| innodb_concurrency_tickets | 500 |
| innodb_data_file_path | ibdata1:10M:autoextend |
| innodb_data_home_dir | |
| innodb_doublewrite | ON |
| innodb_fast_shutdown | 1 |
| 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_support_xa | ON |
| innodb_sync_spin_loops | 20 |
| innodb_table_locks | ON |
| innodb_thread_concurrency | 8 |
| innodb_thread_sleep_delay | 10000 |
| 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 |
| large_page_size | 0 |
| large_pages | OFF |
| license | GPL |
| local_infile | ON |
| locked_in_memory | OFF |
| log | OFF |
| log_bin | OFF |
| log_bin_trust_function_creators | OFF |
| log_error | |
| 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 | 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 | 16777216 |
| max_insert_delayed_threads | 20 |
| max_join_size | 4294967295 |
| max_length_for_sort_data | 1024 |
| max_prepared_stmt_count | 16382 |
| max_relay_log_size | 0 |
| max_seeks_for_key | 4294967295 |
| max_sort_length | 1024 |
| max_sp_recursion_depth | 0 |
| max_tmp_tables | 32 |
| max_user_connections | 0 |
| max_write_lock_count | 4294967295 |
| multi_range_count | 256 |
| myisam_data_pointer_size | 6 |
| myisam_max_sort_file_size | 2147483647 |
| myisam_recover_options | OFF |
| myisam_repair_threads | 1 |
| myisam_sort_buffer_size | 67108864 |
| myisam_stats_method | nulls_unequal |
| net_buffer_length | 16384 |
| net_read_timeout | 30 |
| net_retry_count | 10 |
| net_write_timeout | 60 |
| new | OFF |
| old_passwords | ON |
| open_files_limit | 4110 |
| optimizer_prune_level | 1 |
| optimizer_search_depth | 62 |
| pid_file | /var/run/mysqld/mysqld.pid |
| prepared_stmt_count | 0 |
| port | 3306 |
| preload_buffer_size | 32768 |
| protocol_version | 10 |
| query_alloc_block_size | 16384 |
| query_cache_limit | 1048576 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 67108864 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 16384 |
| range_alloc_block_size | 2048 |
| read_buffer_size | 1044480 |
| read_only | OFF |
| read_rnd_buffer_size | 262144 |
| 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_compressed_protocol | OFF |
| slave_load_tmpdir | /tmp/ |
| slave_net_timeout | 3600 |
| slave_skip_errors | OFF |
| slave_transaction_retries | 10 |
| 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 |
| system_time_zone | GMT |
| table_cache | 1800 |
| table_lock_wait_timeout | 50 |
| table_type | MyISAM |
| thread_cache_size | 384 |
| thread_stack | 196608 |
| time_format | %H:%i:%s |
| time_zone | SYSTEM |
| timed_mutexes | OFF |
| tmp_table_size | 67108864 |
| tmpdir | |
| transaction_alloc_block_size | 8192 |
| transaction_prealloc_size | 4096 |
| tx_isolation | REPEATABLE-READ |
| updatable_views_with_limit | YES |
| version | 5.0.22 |
| version_bdb | Sleepycat Software: Berkeley DB 4.1.24: (May 25, 2006) |
| version_comment | Source distribution |
| version_compile_machine | i686 |
| version_compile_os | redhat-linux-gnu |
| wait_timeout | 360 |
+---------------------------------+--------------------------------------------------------+
+-----------------------------------+------------+
| Variable_name | Value |
+-----------------------------------+------------+
| Aborted_clients | 118 |
| Aborted_connects | 1 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 57789477 |
| Bytes_sent | 3230509379 |
| Com_admin_commands | 5 |
| Com_alter_db | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 18610 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_checksum | 0 |
| Com_commit | 0 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 20 |
| Com_dealloc_sql | 0 |
| Com_delete | 2112 |
| Com_delete_multi | 6 |
| Com_do | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 20 |
| Com_drop_user | 0 |
| Com_execute_sql | 0 |
| Com_flush | 0 |
| Com_grant | 0 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_help | 0 |
| Com_insert | 6249 |
| Com_insert_select | 20 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 0 |
| 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 | 884 |
| 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 | 62075 |
| Com_set_option | 13408 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_charsets | 56 |
| Com_show_collations | 0 |
| Com_show_column_types | 0 |
| Com_show_create_db | 56 |
| Com_show_create_table | 0 |
| Com_show_databases | 0 |
| Com_show_errors | 0 |
| Com_show_fields | 137 |
| 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 | 0 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 4 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 0 |
| Com_show_triggers | 0 |
| Com_show_variables | 6677 |
| Com_show_warnings | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_stmt_close | 0 |
| Com_stmt_execute | 0 |
| Com_stmt_fetch | 0 |
| Com_stmt_prepare | 0 |
| Com_stmt_reset | 0 |
| Com_stmt_send_long_data | 0 |
| Com_truncate | 22 |
| Com_unlock_tables | 0 |
| Com_update | 17053 |
| Com_update_multi | 20 |
| Com_xa_commit | 0 |
| Com_xa_end | 0 |
| Com_xa_prepare | 0 |
| Com_xa_recover | 0 |
| Com_xa_rollback | 0 |
| Com_xa_start | 0 |
| Compression | OFF |
| Connections | 24502 |
| Created_tmp_disk_tables | 526 |
| Created_tmp_files | 31 |
| Created_tmp_tables | 11469 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 23 |
| Handler_delete | 2273 |
| Handler_discover | 0 |
| Handler_prepare | 0 |
| Handler_read_first | 12322 |
| Handler_read_key | 2313496 |
| Handler_read_next | 7579563 |
| Handler_read_prev | 49975 |
| Handler_read_rnd | 460838 |
| Handler_read_rnd_next | 10095260 |
| Handler_rollback | 0 |
| Handler_savepoint | 0 |
| Handler_savepoint_rollback | 0 |
| Handler_update | 29360 |
| Handler_write | 414476 |
| Innodb_buffer_pool_pages_data | 146 |
| Innodb_buffer_pool_pages_dirty | 0 |
| Innodb_buffer_pool_pages_flushed | 26 |
| Innodb_buffer_pool_pages_free | 365 |
| Innodb_buffer_pool_pages_latched | 0 |
| Innodb_buffer_pool_pages_misc | 1 |
| Innodb_buffer_pool_pages_total | 512 |
| Innodb_buffer_pool_read_ahead_rnd | 4 |
| Innodb_buffer_pool_read_ahead_seq | 0 |
| Innodb_buffer_pool_read_requests | 4741 |
| Innodb_buffer_pool_reads | 112 |
| Innodb_buffer_pool_wait_free | 0 |
| Innodb_buffer_pool_write_requests | 128 |
| Innodb_data_fsyncs | 38 |
| Innodb_data_pending_fsyncs | 0 |
| Innodb_data_pending_reads | 0 |
| Innodb_data_pending_writes | 0 |
| Innodb_data_read | 4575232 |
| Innodb_data_reads | 133 |
| Innodb_data_writes | 56 |
| Innodb_data_written | 868352 |
| Innodb_dblwr_pages_written | 26 |
| Innodb_dblwr_writes | 8 |
| Innodb_log_waits | 0 |
| Innodb_log_write_requests | 10 |
| Innodb_log_writes | 14 |
| Innodb_os_log_fsyncs | 22 |
| Innodb_os_log_pending_fsyncs | 0 |
| Innodb_os_log_pending_writes | 0 |
| Innodb_os_log_written | 12288 |
| Innodb_page_size | 16384 |
| Innodb_pages_created | 0 |
| Innodb_pages_read | 146 |
| Innodb_pages_written | 26 |
| Innodb_row_lock_current_waits | 0 |
| Innodb_row_lock_time | 0 |
| Innodb_row_lock_time_avg | 0 |
| Innodb_row_lock_time_max | 0 |
| Innodb_row_lock_waits | 0 |
| Innodb_rows_deleted | 2 |
| Innodb_rows_inserted | 5 |
| Innodb_rows_read | 1346 |
| Innodb_rows_updated | 42 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 12962 |
| Key_blocks_used | 45028 |
| Key_read_requests | 7988708 |
| Key_reads | 45276 |
| Key_write_requests | 45729 |
| Key_writes | 34072 |
| Last_query_cost | 0.000000 |
| Max_used_connections | 20 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 613 |
| Open_streams | 0 |
| Open_tables | 391 |
| Opened_tables | 480 |
| Qcache_free_blocks | 1120 |
| Qcache_free_memory | 47611896 |
| Qcache_hits | 104256 |
| Qcache_inserts | 61795 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 7152 |
| Qcache_queries_in_cache | 3290 |
| Qcache_total_blocks | 8229 |
| Questions | 256121 |
| Rpl_status | NULL |
| Select_full_join | 55 |
| Select_full_range_join | 0 |
| Select_range | 13710 |
| Select_range_check | 0 |
| Select_scan | 17741 |
| Slave_open_temp_tables | 0 |
| Slave_retried_transactions | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 3 |
| Sort_merge_passes | 13 |
| Sort_range | 10993 |
| Sort_rows | 1939819 |
| Sort_scan | 4661 |
| Ssl_accept_renegotiates | 0 |
| Ssl_accepts | 0 |
| Ssl_callback_cache_hits | 0 |
| Ssl_cipher | |
| Ssl_cipher_list | |
| Ssl_client_connects | 0 |
| Ssl_connect_renegotiates | 0 |
| Ssl_ctx_verify_depth | 0 |
| Ssl_ctx_verify_mode | 0 |
| Ssl_default_timeout | 0 |
| Ssl_finished_accepts | 0 |
| Ssl_finished_connects | 0 |
| Ssl_session_cache_hits | 0 |
| Ssl_session_cache_misses | 0 |
| Ssl_session_cache_mode | NONE |
| Ssl_session_cache_overflows | 0 |
| Ssl_session_cache_size | 0 |
| Ssl_session_cache_timeouts | 0 |
| Ssl_sessions_reused | 0 |
| Ssl_used_session_cache_entries | 0 |
| Ssl_verify_depth | 0 |
| Ssl_verify_mode | 0 |
| Ssl_version | |
| Table_locks_immediate | 173618 |
| Table_locks_waited | 170 |
| Tc_log_max_pages_used | 0 |
| Tc_log_page_size | 0 |
| Tc_log_page_waits | 0 |
| Threads_cached | 17 |
| Threads_connected | 3 |
| Threads_created | 20 |
| Threads_running | 1 |
| Uptime | 6160 |
+-----------------------------------+------------+
Uptime: 6160 Threads: 3 Questions: 256122 Slow queries: 0 Opens: 0 Flush tables: 1 Open tables: 391 Queries per second avg: 41.578
mysqladmin Ver 8.41 Distrib 5.0.22, for redhat-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 5.0.22
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 1 hour 42 min 40 sec
Threads: 3 Questions: 256122 Slow queries: 0 Opens: 0 Flush tables: 1 Open tables: 391 Queries per second avg: 41.578

> 9. No we have other sites and modules on the same server that utilise php and mysql.
Also we have two installations of VB one for English and the other one for Arabic (with separated database and language interface for each)
> 10.
Avg. concurrent users: ~ 400
Max concurrent users: ~ 780
Cookie timeout: 900

> 11. http://www.mahjoob.com/TellMeYourStoryNOW.php
> 12.
KeepAlive off
MaxKeepAliveRequests 100
KeepAliveTimeout 15
StartServers 8
MinSpareServers 5
MaxSpareServers 20
ServerLimit 256
MaxClients 256
MaxRequestsPerChild 4000

>13. No "max file size exceeded" error(s) found in apache error log files, (we have large apache log file > 2GB).
> 14.
uname -a
Linux 206-225-86-196.dedicated.abac.net 2.6.18-53.1.4.el5PAE #1 SMP Fri Nov 30 01:21:20 EST 2007 i686 i686 i386 GNU/Linux

ulimit -aH
core file size (blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
max nice (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 77824
max locked memory (kbytes, -l) 32
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
max rt priority (-r) 0
stack size (kbytes, -s) unlimited
cpu time (seconds, -t) unlimited
max user processes (-u) 77824
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited

cat /proc/cpuinfo
processor : 0
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Xeon(R) CPU E5345 @ 2.33GHz
stepping : 7
cpu MHz : 2333.635
cache size : 4096 KB
physical id : 0
siblings : 4
core id : 0
cpu cores : 4
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 10
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 pbe nx lm constant_tsc pni monitor ds_cpl vmx est tm2 cx16 xtpr lahf_lm
bogomips : 4668.81
processor : 1
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Xeon(R) CPU E5345 @ 2.33GHz
stepping : 7
cpu MHz : 2333.635
cache size : 4096 KB
physical id : 0
siblings : 4
core id : 1
cpu cores : 4
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 10
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 pbe nx lm constant_tsc pni monitor ds_cpl vmx est tm2 cx16 xtpr lahf_lm
bogomips : 4666.16
processor : 2
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Xeon(R) CPU E5345 @ 2.33GHz
stepping : 7
cpu MHz : 2333.635
cache size : 4096 KB
physical id : 0
siblings : 4
core id : 2
cpu cores : 4
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 10
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 pbe nx lm constant_tsc pni monitor ds_cpl vmx est tm2 cx16 xtpr lahf_lm
bogomips : 4666.19
processor : 3
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Xeon(R) CPU E5345 @ 2.33GHz
stepping : 7
cpu MHz : 2333.635
cache size : 4096 KB
physical id : 0
siblings : 4
core id : 3
cpu cores : 4
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 10
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 pbe nx lm constant_tsc pni monitor ds_cpl vmx est tm2 cx16 xtpr lahf_lm
bogomips : 4666.20

Best,
Alawadat

eva2000

Wed 6th Feb '08, 1:19am

Try the following in this exact order. You can ignore any of the suggestions that you have already done.

1. Upgrade MySQL 5.0.45 or 5.0.51 if possible and then upgrade PHP to 5.2.5 or if you have problems install PHP 4.4.8 (in either case install as ISAPI module and NOT CGI)
2. Edit mysql server's /etc/my.cnf or c:\my.ini for windows and place the following mysql server settings in /etc/my.cnf and restart mysql server afterwards. Make sure to restart mysql server everytime you make changes to your my.cnf for the changes to take effect.

If mysql doesn't restart properly after my.cnf changes and you're on VPS server, make sure skip-innodb entry is removed or commented out from below my.cnf

[mysqld]
safe-show-database
old_passwords
back_log = 50
skip-innodb
max_connections = 500
key_buffer_size = 128M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 4000
thread_cache_size = 256
wait_timeout = 30
connect_timeout = 10
tmp_table_size = 64M
max_heap_table_size = 64M
max_allowed_packet = 64M
net_buffer_length = 16384
max_connect_errors = 10
thread_concurrency = 8
concurrent_insert = 2
table_lock_wait_timeout = 30
read_rnd_buffer_size = 786432
bulk_insert_buffer_size = 8M
query_cache_limit = 7M
query_cache_size = 144M
query_cache_type = 1
query_prealloc_size = 262144
query_alloc_block_size = 65536
transaction_alloc_block_size = 8192
transaction_prealloc_size = 4096
default-storage-engine = MyISAM

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
nice = -10
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 16M

[myisamchk]
key_buffer = 384M
sort_buffer = = 384M
read_buffer = 256M
write_buffer = 256M

If you get mysql server gone away error messages, then keep increasing wait_timeout value in my.cnf by 60 second increments, then restart mysql after my.cnf changes for it to take effect. Test for a few days and see if you get less or eliminate that error message. If it still occurs, then keep repeating the 60 second increment until the message goes away. Each vB forum and server will have different optimal wait_timeout values depending on your vB forum traffic patterns and server hardware specifications.

3. Remove Eaccelerator or APC Cache if they're installed (check phpinfo.php url of yours to see) and instead install Xcache v1.2.1 final release or Xcache v1.2.2 http://xcache.lighttpd.net/wiki/Release-1.2.2 which seems to be a bit faster than APC Cache - http://www.vbulletin.com/forum/showthread.php?t=213267. Xcache site http://xcache.lighttpd.net/, documentation http://trac.lighttpd.net/trac/wiki/Docs and forums http://forum.lighttpd.net/forum/4

4. Upgrade to vB 3.0.17 http://www.vbulletin.com/forum/showthread.php?t=209720 if you're on vB 3.0.xx or upgrade to vB 3.5.8 http://www.vbulletin.com/forum/showthread.php?t=221903 if you're on vB 3.5.x. Upgrade to vB 3.6.8 PL2 http://www.vbulletin.com/forum/showthread.php?t=247739 if you're on vB 3.6.x

5. If you just upgraded to vB 3.5.x/3.6.x try to disable these 4 options:

Admin CP -> vBulletin Options -> Forums Home Page Options -> Display Logged in Users?

Admin CP -> vBulletin Options -> Forum Display Options (forumdisplay) -> Show Users Browsing Forums

Admin CP -> vBulletin Options -> Thread Display Options -> Show Users Browsing Thread

Admin CP -> vBulletin Options -> Message Searching Options -> Automatic Similar Thread search

6. Check phpinfo.php url to see if you have mod_gzip (Apache 1.3.x) or mod_deflate (Apache 2.x) loaded/installed (on phpinfo.php url page in browser you can do CTRL+F to bring up find prompt and type in mod_gzip or mod_deflate to quickly see). If you have either mod_gzip or mod_deflate loaded, then ensure vB admincp gzip compression is disabled since it's the same thing as mod_gzip or mod_deflate and double compression will just increase cpu loads. If you don't have mod_gzip or mod_deflate installed, then DO NOT set vB admincp gzip compression to a level higher than 1. Higher than 1, will only increase cpu loads unncessarily.

7. Edit httpd.conf values to following and restart apache

KeepAlive: Off
MaxKeepAliveRequests: 100
KeepAliveTimeout: 1
MinSpareServers: 10
MaxSpareServers: 15
StartServers: 10
ServerLimit 256
MaxClients: 180
MaxRequestsPerChild: 2000