Server Opt Request

[DigiCrime]

I expected things to be a little bit faster moving to this type of system but seems its still kinda dragging a bit, installed APC but it segfaults and site shows up blank so it doesn't work, on both 4.4.2 and 5x

Dedicated Server, Dual Opteron 246 2x200 gig SATA drives, PC3300DDR Ram 2gigs
CentOS 4.3
Apache 1.3.36 / PHP 5.1.4
MySQL 4.1.19-standard
Cpanel Software, php/mysql built from cpanel easyapache and /scripts/mysqlup
Kernel: 2.6.16.20
top - 14:58:22 up 1 day, 21:19, 1 user, load average: 0.06, 0.24, 0.74
Tasks: 118 total, 1 running, 117 sleeping, 0 stopped, 0 zombie
Cpu(s): 2.7% us, 0.2% sy, 0.0% ni, 97.0% id, 0.2% wa, 0.0% hi, 0.0% si
Mem: 2070964k total, 1894836k used, 176128k free, 60200k buffers
Swap: 2096440k total, 128k used, 2096312k free, 1539840k cached

mysqladmin -u root -p var ext stat ver
http://www.z28.com/opt/mysqlstuff.txt
my.cnf
http://www.z28.com/opt/my.txt
mysqlstatistics
http://www.z28.com/opt/statistics.txt
8) Vbulleting and photopost are the only two things on the server, also is the only site on the server
9) users average from 200-400 at any given time, 100 average are mostly members, rest are guests.
10) php info http://www.z28.com/opt/phpinfo.php
11)
Timeout 300
KeepAlive On (usually have it off but doesnt seem to matter)
MaxKeepAliveRequests 100
KeepAliveTimeout 5
MinSpareServers 10
MaxSpareServers 15
StartServers 10
MaxClients 200
MaxRequestsPerChild 500

12) 3.5.4

13)/usr/local/apache/domlogs/ |head
total 3.7G
-rw-r----- 1 root root 2.0G Jun 17 21:28 z28.com.old
-rw-r----- 1 root zackman 1.6G Jun 18 15:05 z28.com
-rw-r--r-- 1 root root 100M Jun 18 15:05 z28.com-bytes_log
-rw-r----- 1 root root 2.5M Jun 17 21:27 z28.com-smtpbytes_log

ok, i know about the 2 gig limit so were getting there :)
/usr/local/apache/logs]# du -sh
2.3M .(just set the system up few days ago so not enough to cause a problem)

14) uname
Linux jason.z28.com 2.6.16.20 #1 SMP Fri Jun 16 16:24:11 EDT 2006 i686 athlon i386 GNU/Linux

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

cat /proc/cpuinfo
processor : 0
vendor_id : AuthenticAMD
cpu family : 15
model : 37
model name : AMD Opteron(tm) Processor 246
stepping : 1
cpu MHz : 2009.439
cache size : 1024 KB
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 1
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 syscall nx mmxext fxsr_opt lm 3dnowext 3dnow pni lahf_lm ts fid vid ttp
bogomips : 4027.52

processor : 1
vendor_id : AuthenticAMD
cpu family : 15
model : 37
model name : AMD Opteron(tm) Processor 246
stepping : 1
cpu MHz : 2009.439
cache size : 1024 KB
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 1
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 syscall nx mmxext fxsr_opt lm 3dnowext 3dnow pni lahf_lm ts fid vid ttp
bogomips : 4018.83


Show users browsing threads/forums, similar search is turned off. System and apache logs are split up between two drives. Posting takes a little longer

[eva2000]

1. Upgrade MySQL server to 4.1.20 http://www.vbulletin.com/forum/showthread.php?t=186856
2. Downgrade PHP to 4.4.2
3. Edit /etc/my.cnf and place the following mysql server settings in /etc/my.cnf and restart mysql server afterwards


[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
safe-show-database
back_log = 75
skip-innodb
max_connections = 650
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 = 45
connect_timeout = 10
tmp_table_size = 256M
max_heap_table_size = 80M
max_allowed_packet = 64M
max_connect_errors = 10
read_rnd_buffer_size = 524288
bulk_insert_buffer_size = 8M
query_cache_limit = 6M
query_cache_size = 96M
query_cache_type = 1
query_prealloc_size = 163840
query_alloc_block_size = 32768
default-storage-engine = MyISAM

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

[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
nice = -5
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 16M

[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M

[mysqlhotcopy]
interactive-timeout


4. Install APC Cache lastest version from http://pecl.php.net/package/APC. Read install guide at http://www.vbulletin.com/forum/showthread.php?t=165367 - please remove Zend Optimizer from php.ini before installing APC Cache

5. This file might be the problem

-rw-r----- 1 root root 2.0G Jun 17 21:28 z28.com.old

delete it and see what happens

6. If you just upgraded to vB 3.5.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