Server Optimization Requst - Moved to new server

محروم.كوم · #1 08-02-2009, 10:30 AM

Hi there. We moved to a new server, so we would really appreciate some help tweaking the PHP and MySQL settings on this new machine for ideal vBulletin performace. Things seem pretty sluggish at the moment, and we're using better hardware (upgraded from a P4 2.4Ghz). Thanks in advance!

1.
Dedicated

2.
Dual Xeon 3.2Ghz/800Mhz/2MB
4 GB RAM
150GB SCSI 15K, RAID-1
CentOS 5.2 (64-bit) 2.6.18-92.1.22.el5
Apache 2.2.3
PHP 5.2.9
MySQL 5.0.83

3.
vBulletin 3.8.3

4.
Not sure about Innodb, however I don't think anything is using it.

5.
MySQL installed using Virtualmin, which installs by RPM i believe

6.
Code:
top - 01:47:52 up 37 days, 1:16, 2 users, load average: 0.37, 0.20, 0.12
Tasks: 171 total, 1 running, 170 sleeping, 0 stopped, 0 zombie
Cpu0 : 25.4%us, 0.0%sy, 0.0%ni, 74.6%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu1 : 0.0%us, 1.6%sy, 0.0%ni, 98.4%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu2 : 6.6%us, 0.0%sy, 0.0%ni, 91.8%id, 0.0%wa, 0.0%hi, 1.6%si, 0.0%st
Cpu3 : 3.3%us, 0.0%sy, 0.0%ni, 96.7%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 4044508k total, 3873340k used, 171168k free, 159484k buffers
Swap: 4194296k total, 10040k used, 4184256k free, 1975984k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
1288 apache 15 0 495m 73m 26m S 16 1.9 0:56.81 httpd
31299 apache 15 0 494m 75m 28m S 7 1.9 0:42.95 httpd
31311 apache 15 0 491m 70m 26m S 5 1.8 0:42.65 httpd
31312 apache 15 0 516m 95m 26m S 5 2.4 0:48.31 httpd

1286 apache 15 0 492m 73m 29m S 2 1.9 0:58.07 httpd
16997 root 15 0 14792 1180 844 R 2 0.0 0:00.41 top
31315 apache 15 0 502m 81m 26m S 2 2.1 0:43.78 httpd
1 root 15 0 12404 760 636 S 0 0.0 0:02.90 init
7.
Code:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

max_connections=500
key_buffer_size=384M
max_allowed_packet=16M
table_cache=256
sort_buffer_size=2M
read_buffer_size=2M
join_buffer_size=2M

read_rnd_buffer_size=2M

max_heap_table_size=256M

tmp_table_size=256M

myisam_sort_buffer_size=64M

thread_cache=256

query_cache_type=1
query_cache_limit=1M
query_cache_size=32M

thread_concurrency=16

log-slow-queries=/var/log/mysqld.log

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[mysqldump]
quick
max_allowed_packet=16M

[isamchk]
key_buffer=128M
sort_buffer_size=128M
read_buffer=2M
write_buffer=2M

[myisamchk]
key_buffer=128M
sort_buffer_size=128M
read_buffer=2M
write_buffer=2M

[mysqlhotcopy]
interactive-timeout
8.
Code:
#
# Beginning report, 0 0:0:0
#
MySQL 5.0.83-log uptime 20 10:29:32 Sun Aug 2 01:42:15 2009

__ Key __________________________________________________ _______________
Buffer used 9.54M of 384.00M %Used: 2.49
Current 75.88M %Usage: 19.76
Write hit 8.13%
Read hit 99.17%

__ Questions __________________________________________________ _________
Total 4.91M 2.8/s
QC Hits 3.31M 1.9/s %Total: 67.40
Com_ 673.14k 0.4/s 13.70
DMS 672.93k 0.4/s 13.70
+Unknown 133.56k 0.1/s 2.72
COM_QUIT 121.90k 0.1/s 2.48
Slow 10 s 42 0.0/s 0.00 %DMS: 0.01 Log: OFF
DMS 672.93k 0.4/s 13.70
SELECT 464.02k 0.3/s 9.44 68.95
UPDATE 137.59k 0.1/s 2.80 20.45
INSERT 48.72k 0.0/s 0.99 7.24
DELETE 18.46k 0.0/s 0.38 2.74
REPLACE 4.14k 0.0/s 0.08 0.62
Com_ 673.14k 0.4/s 13.70
set_option 281.87k 0.2/s 5.74
change_db 101.13k 0.1/s 2.06
show_fields 90.40k 0.1/s 1.84

__ SELECT and Sort __________________________________________________ ___
Scan 404.55k 0.2/s %SELECT: 87.18
Range 34.00k 0.0/s 7.33
Full join 238 0.0/s 0.05
Range check 0 0/s 0.00
Full rng join 16 0.0/s 0.00
Sort scan 26.01k 0.0/s
Sort range 23.53k 0.0/s
Sort mrg pass 0 0/s

__ Query Cache __________________________________________________ _______
Memory usage 23.75M of 32.00M %Used: 74.23
Block Fragmnt 12.97%
Hits 3.31M 1.9/s
Inserts 344.86k 0.2/s
Insrt:Prune 5.40:1 0.2/s
Hit:Insert 9.60:1

__ Table Locks __________________________________________________ _______
Waited 134 0.0/s %Total: 0.02
Immediate 888.97k 0.5/s

__ Tables __________________________________________________ ____________
Open 256 of 256 %Cache: 100.00
Opened 203.16k 0.1/s

__ Connections __________________________________________________ _______
Max used 14 of 500 %Max: 2.80
Total 121.91k 0.1/s

__ Created Temp __________________________________________________ ______
Disk table 184.11k 0.1/s
Table 304.51k 0.2/s Size: 256.0M
File 5 0.0/s

__ Threads __________________________________________________ ___________
Running 1 of 1
Cached 13 of 256 %Hit: 99.99
Created 14 0.0/s
Slow 0 0/s

__ Aborted __________________________________________________ ___________
Clients 1 0.0/s
Connects 14 0.0/s

__ Bytes __________________________________________________ _____________
Sent 43.73G 24.8k/s
Received 563.00M 318.8/s

__ InnoDB Buffer Pool __________________________________________________
Usage 7.98M of 8.00M %Used: 99.80
Read hit 98.15%
Pages
Free 1 %Total: 0.20
Data 510 99.61 %Drty: 0.78
Misc 1 0.20
Latched 0.00
Reads 614.25k 0.3/s
From file 11.34k 0.0/s 1.85
Ahead Rnd 833 0.0/s
Ahead Sql 0 0/s
Writes 16.40k 0.0/s
Flushes 5.97k 0.0/s
Wait Free 0 0/s

__ InnoDB Lock __________________________________________________ _______
Waits 0 0/s
Current 0
Time acquiring
Total 0 ms
Average 0 ms
Max 0 ms

__ InnoDB Data, Pages, Rows ____________________________________________
Data
Reads 13.43k 0.0/s
Writes 8.37k 0.0/s
fsync 5.15k 0.0/s
Pending
Reads 0
Writes 0
fsync 0

Pages
Created 88 0.0/s
Read 16.59k 0.0/s
Written 5.97k 0.0/s

Rows
Deleted 832 0.0/s
Inserted 858 0.0/s
Read 102.84k 0.1/s
Updated 303 0.0/s

#
# Interval report 1, +0 0:0:10
#
MySQL 5.0.83-log uptime 20 10:29:42 Sun Aug 2 01:42:25 2009

__ Key __________________________________________________ _______________
Buffer used 9.54M of 384.00M %Used: 2.49
Current 384.00M %Usage: 100.00
Write hit 0.00%
Read hit 100.00%

__ Questions __________________________________________________ _________
Total 569 56.9/s
QC Hits 512 51.2/s %Total: 89.98
DMS 34 3.4/s 5.98
Com_ 17 1.7/s 2.99
+Unknown 3 0.3/s 0.53
COM_QUIT 3 0.3/s 0.53
Slow 10 s 0 0/s 0.00 %DMS: 0.00 Log: OFF
DMS 34 3.4/s 5.98
SELECT 24 2.4/s 4.22 70.59
INSERT 4 0.4/s 0.70 11.76
UPDATE 4 0.4/s 0.70 11.76
DELETE 2 0.2/s 0.35 5.88
REPLACE 0 0/s 0.00 0.00
Com_ 17 1.7/s 2.99
set_option 6 0.6/s 1.05
show_tables 3 0.3/s 0.53
commit 2 0.2/s 0.35

__ SELECT and Sort __________________________________________________ ___
Scan 8 0.8/s %SELECT: 33.33
Range 0 0/s 0.00
Full join 0 0/s 0.00
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 3 0.3/s
Sort range 0 0/s
Sort mrg pass 0 0/s

__ Query Cache __________________________________________________ _______
Memory usage 23.76M of 32.00M %Used: 74.24
Block Fragmnt 12.97%
Hits 512 51.2/s
Inserts 6 0.6/s
Insrt:Prune 6:1 0.5/s
Hit:Insert 85.33:1

__ Table Locks __________________________________________________ _______
Waited 0 0/s %Total: 0.00
Immediate 21 2.1/s

__ Tables __________________________________________________ ____________
Open 256 of 256 %Cache: 100.00
Opened 0 0/s

__ Connections __________________________________________________ _______
Max used 14 of 500 %Max: 2.80
Total 5 0.5/s

__ Created Temp __________________________________________________ ______
Disk table 0 0/s
Table 8 0.8/s Size: 256.0M
File 0 0/s

__ Threads __________________________________________________ ___________
Running 1 of 1
Cached 13 of 256 %Hit: 100
Created 0 0/s
Slow 0 0/s

__ Aborted __________________________________________________ ___________
Clients 0 0/s
Connects 0 0/s

__ Bytes __________________________________________________ _____________
Sent 839.71k 84.0k/s
Received 48.98k 4.9k/s

__ InnoDB Buffer Pool __________________________________________________
Usage 7.98M of 8.00M %Used: 99.80
Read hit 100.00%
Pages
Free 1 %Total: 0.20
Data 510 99.61 %Drty: 0.59
Misc 1 0.20
Latched 0.00
Reads 92 9.2/s
From file 0 0/s 0.00
Ahead Rnd 0 0/s
Ahead Sql 0 0/s
Writes 28 2.8/s
Flushes 12 1.2/s
Wait Free 0 0/s

__ InnoDB Lock __________________________________________________ _______
Waits 0 0/s
Current 0
Time acquiring
Total 0 ms
Average 0 ms
Max 0 ms

__ InnoDB Data, Pages, Rows ____________________________________________
Data
Reads 0 0/s
Writes 15 1.5/s
fsync 8 0.8/s
Pending
Reads 0
Writes 0
fsync 0

Pages
Created 0 0/s
Read 0 0/s
Written 12 1.2/s

Rows
Deleted 0 0/s
Inserted 0 0/s
Read 12 1.2/s
Updated 2 0.2/s
9.
Not the only script, but its the most resource hungry script. Other scripts running:

WordPress (a few instances, all low traffic)
Vivvo (two instances, both low traffic)
Dzoic Handshakes (one instance, low traffic)

10.

Most users ever online was 85, 07-02-2007 at 12:35 PM.
Currently Active Users: 36 (21 members and 15 guests)
Threads: 19,650, Posts: 700,855, Members: 721

Default cookie timeout.

11.

http://www.rezilient.com/phpinfoz/phpinfoz.php

12.

KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 15

Not sure which one of these we are using...?

# prefork MPM

StartServers 8
MinSpareServers 5
MaxSpareServers 20
ServerLimit 256
MaxClients 256
MaxRequestsPerChild 4000

# worker MPM

StartServers 2
MaxClients 150
MinSpareThreads 25
MaxSpareThreads 75
ThreadsPerChild 25
MaxRequestsPerChild 0

13.

Checked, they are small.

14.

Linux cp.datacolony.com 2.6.18-92.1.22.el5 #1 SMP Tue Dec 16 11:57:43 EST 2008 x86_64 x86_64 x86_64 GNU/Linux

Code:
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
scheduling priority (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 40960
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
real-time priority (-r) 0
stack size (kbytes, -s) unlimited
cpu time (seconds, -t) unlimited
max user processes (-u) 150
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
Code:
processor : 0
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 3.20GHz
stepping : 3
cpu MHz : 3192.310
cache size : 2048 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 1
fpu : yes
fpu_exception : yes
cpuid level : 5
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 syscall nx lm constant_tsc pni monitor ds_cpl cid cx16 xtpr
bogomips : 6388.80
clflush size : 64
cache_alignment : 128
address sizes : 36 bits physical, 48 bits virtual
power management:

processor : 1
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 3.20GHz
stepping : 3
cpu MHz : 3192.310
cache size : 2048 KB
physical id : 3
siblings : 2
core id : 0
cpu cores : 1
fpu : yes
fpu_exception : yes
cpuid level : 5
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 syscall nx lm constant_tsc pni monitor ds_cpl cid cx16 xtpr
bogomips : 6384.43
clflush size : 64
cache_alignment : 128
address sizes : 36 bits physical, 48 bits virtual
power management:

processor : 2
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 3.20GHz
stepping : 3
cpu MHz : 3192.310
cache size : 2048 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 1
fpu : yes
fpu_exception : yes
cpuid level : 5
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 syscall nx lm constant_tsc pni monitor ds_cpl cid cx16 xtpr
bogomips : 6384.46
clflush size : 64
cache_alignment : 128
address sizes : 36 bits physical, 48 bits virtual
power management:

processor : 3
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 3.20GHz
stepping : 3
cpu MHz : 3192.310
cache size : 2048 KB
physical id : 3
siblings : 2
core id : 0
cpu cores : 1
fpu : yes
fpu_exception : yes
cpuid level : 5
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 syscall nx lm constant_tsc pni monitor ds_cpl cid cx16 xtpr
bogomips : 6384.44
clflush size : 64
cache_alignment : 128
address sizes : 36 bits physical, 48 bits virtual
power management:
Thanks! __DEFINE_LIKE_SHARE__

المواضيع المتشابهه
الموضوع	كاتب الموضوع	المنتدى	مشاركات	آخر مشاركة
Web Server + DB Server Optimization Request	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	07-29-2009 08:30 PM
Web Server + DB Server Optimization Request	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	07-29-2009 08:20 PM
Web Server + DB Server Optimization Request	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	07-29-2009 08:40 AM
Server Optimization - Server about to explode	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	05-25-2009 08:00 AM
Server Optimization Request - Please help! Server loads way too high!	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	05-05-2009 02:00 AM