Server optimization request

محروم.كوم · #1 07-12-2009, 12:00 PM

1. Dedicated server

2. Server specs:
Quote:
CPU: Q6600 (4x2.4Ghz)
Ram: 4Gbs
HDD: Harware Raid-1 2x36GB SAS drives (15'000rpm) + 250gb SATA (for backups and vbulletin attachments)
OS: Centos 5.1 64bits
Apache 2.2.11
PHP: 5.2.8
MySQL: 5.1.30-community
3. what version of vB are you running ?
Quote:
vbulletin 3.8.3

4. if you use mysql 4.x instead of mysql 3.23.x, do you have any innodb type databases/tables on your server?
Quote:
No innodb databases/tables

5. if possible how mysql was compiled/installed
Quote:
Don't know, most probably default installation

6. your top stats
Quote:
Originally Posted by off peak
top - 02:22:10 up 55 min, 1 user, load average: 0.67, 0.63, 0.66
Tasks: 185 total, 2 running, 182 sleeping, 0 stopped, 1 zombie
Cpu0 : 0.0%us, 0.0%sy, 1.0%ni, 99.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu1 : 0.0%us, 0.3%sy, 5.7%ni, 94.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu2 : 1.3%us, 1.0%sy, 14.0%ni, 83.7%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu3 : 1.0%us, 1.3%sy, 23.4%ni, 74.2%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 4051548k total, 2645364k used, 1406184k free, 82756k buffers
Swap: 2096472k total, 0k used, 2096472k free, 1567728k cached

7. your mysql configuration variables located at /etc/my.cnf or c:\my.cnf or my.ini.
Quote:
[mysqld]
max_connections=700
max_user_connections=700
table_cache=1024
wait_timeout=7200
key_buffer=16M
sort_buffer=2M
record_buffer=2M
join_buffer=2M
thread_cache_size=128
interactive_timeout=100
connect_timeout=10
max_allowed_packet=16M
max_connect_errors=10
query_cache_limit=1M
query_cache_size=16M
query_cache_type=1
tmp_table_size=16Mf
safe-show-database

8. MySQL stats from ssh telnet as root user type:
Code:
#
# Beginning report, 0 0:0:0
#
MySQL 5.1.30-community uptime 0 1:27:2 Sun Jul 12 0234 2009

__ Key __________________________________________________ _______________
Buffer used 13.08M of 16.00M %Used: 81.76
Current 16.00M %Usage: 100.00
Write hit 70.12%
Read hit 97.75%

__ Questions __________________________________________________ _________
Total 293.96k 56.3/s
DMS 142.28k 27.2/s %Total: 48.40
QC Hits 87.20k 16.7/s 29.66
Com_ 32.57k 6.2/s 11.08
COM_QUIT 31.94k 6.1/s 10.87
-Unknown 36 0.0/s 0.01
Slow 10 s 37 0.0/s 0.01 %DMS: 0.03 Log: OFF
DMS 142.28k 27.2/s 48.40
SELECT 109.21k 20.9/s 37.15 76.76
UPDATE 18.56k 3.6/s 6.31 13.04
INSERT 13.06k 2.5/s 4.44 9.18
DELETE 726 0.1/s 0.25 0.51
REPLACE 720 0.1/s 0.24 0.51
Com_ 32.57k 6.2/s 11.08
change_db 31.96k 6.1/s 10.87
show_table_ 193 0.0/s 0.07
lock_tables 79 0.0/s 0.03

__ SELECT and Sort __________________________________________________ ___
Scan 33.46k 6.4/s %SELECT: 30.64
Range 24.18k 4.6/s 22.14
Full join 108 0.0/s 0.10
Range check 0 0/s 0.00
Full rng join 4 0.0/s 0.00
Sort scan 20.81k 4.0/s
Sort range 27.76k 5.3/s
Sort mrg pass 20 0.0/s

__ Query Cache __________________________________________________ _______
Memory usage 15.47M of 16.00M %Used: 96.72
Block Fragmnt 7.63%
Hits 87.20k 16.7/s
Inserts 90.18k 17.3/s
Insrt:Prune 3.56:1 12.4/s
Hit:Insert 0.97:1

__ Table Locks __________________________________________________ _______
Waited 1.08k 0.2/s %Total: 0.33
Immediate 326.04k 62.4/s

__ Tables __________________________________________________ ____________
Open 671 of 1024 %Cache: 65.53
Opened 722 0.1/s

__ Connections __________________________________________________ _______
Max used 110 of 700 %Max: 15.71
Total 31.97k 6.1/s

__ Created Temp __________________________________________________ ______
Disk table 3.27k 0.6/s
Table 25.36k 4.9/s Size: 16.0M
File 21 0.0/s

__ Threads __________________________________________________ ___________
Running 1 of 10
Cached 100 of 128 %Hit: 99.66
Created 110 0.0/s
Slow 0 0/s

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

__ Bytes __________________________________________________ _____________
Sent 19.48G 3.7M/s
Received 100.75M 19.3k/s

__ InnoDB Buffer Pool __________________________________________________
Usage 336.00k of 8.00M %Used: 4.10
Read hit 89.31%
Pages
Free 491 %Total: 95.90
Data 21 4.10 %Drty: 0.00
Misc 0 0.00
Latched 0.00
Reads 131 0.0/s
From file 14 0.0/s 10.69
Ahead Rnd 1 0.0/s
Ahead Sql 0 0/s
Writes 0 0/s
Flushes 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 27 0.0/s
Writes 3 0.0/s
fsync 3 0.0/s
Pending
Reads 0
Writes 0
fsync 0

Pages
Created 0 0/s
Read 21 0.0/s
Written 0 0/s

Rows
Deleted 0 0/s
Inserted 0 0/s
Read 0 0/s
Updated 0 0/s

#
# Interval report 1, +0 0:0:10
#
MySQL 5.1.30-community uptime 0 1:27:12 Sun Jul 12 0244 2009

__ Key __________________________________________________ _______________
Buffer used 13.08M of 16.00M %Used: 81.76
Current 16.00M %Usage: 100.00

Write hit 91.15%
Read hit 97.78%

__ Questions __________________________________________________ _________
Total 494 49.4/s
DMS 242 24.2/s %Total: 48.99
QC Hits 141 14.1/s 28.54
Com_ 56 5.6/s 11.34
COM_QUIT 52 5.2/s 10.53
+Unknown 3 0.3/s 0.61
Slow 10 s 0 0/s 0.00 %DMS: 0.00 Log: OFF
DMS 242 24.2/s 48.99
SELECT 190 19.0/s 38.46 78.51
UPDATE 36 3.6/s 7.29 14.88
INSERT 15 1.5/s 3.04 6.20
REPLACE 1 0.1/s 0.20 0.41
DELETE 0 0/s 0.00 0.00
Com_ 56 5.6/s 11.34
change_db 53 5.3/s 10.73
show_status 1 0.1/s 0.20
set_option 1 0.1/s 0.20

__ SELECT and Sort __________________________________________________ ___
Scan 55 5.5/s %SELECT: 28.95
Range 27 2.7/s 14.21
Full join 0 0/s 0.00
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 42 4.2/s
Sort range 32 3.2/s
Sort mrg pass 0 0/s

__ Query Cache __________________________________________________ _______
Memory usage 15.35M of 16.00M %Used: 95.97
Block Fragmnt 12.14%
Hits 141 14.1/s
Inserts 153 15.3/s
Insrt:Prune 1.14:1 1.9/s
Hit:Insert 0.92:1

__ Table Locks __________________________________________________ _______
Waited 0 0/s %Total: 0.00
Immediate 543 54.3/s

__ Tables __________________________________________________ ____________
Open 671 of 1024 %Cache: 65.53
Opened 0 0/s

__ Connections __________________________________________________ _______
Max used 110 of 700 %Max: 15.71
Total 54 5.4/s

__ Created Temp __________________________________________________ ______
Disk table 10 1.0/s
Table 43 4.3/s Size: 16.0M
File 0 0/s

__ Threads __________________________________________________ ___________
Running 2 of 9
Cached 101 of 128 %Hit: 100
Created 0 0/s
Slow 0 0/s

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

__ Bytes __________________________________________________ _____________
Sent 32.97M 3.3M/s
Received 161.03k 16.1k/s

__ InnoDB Buffer Pool __________________________________________________
Usage 336.00k of 8.00M %Used: 4.10
Read hit 0.00%
Pages
Free 491 %Total: 95.90
Data 21 4.10 %Drty: 0.00
Misc 0 0.00
Latched 0.00
Reads 0 0/s
From file 0 0/s 0.00
Ahead Rnd 0 0/s
Ahead Sql 0 0/s
Writes 0 0/s
Flushes 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 0 0/s
Writes 0 0/s
fsync 0 0/s
Pending
Reads 0
Writes 0
fsync 0

Pages
Created 0 0/s
Read 0 0/s
Written 0 0/s

Rows
Deleted 0 0/s
Inserted 0 0/s
Read 0 0/s
Updated 0 0/s
9. is your vB the only thing on the server? or other scripts & sites which utilise php and mysql?
Quote:
xcache

Main site: vbulletin 3.8.3, vBulletin blogs, vBadvanced
2 other small sites (combined total peak 20 concurrent users): wordpress, phpbb3 and smf 2

Xcache settings:

Code:
[xcache-common]

extension = xcache.so

[xcache.admin]
xcache.admin.auth = Off
xcache.admin.enable_auth = Off
xcache.admin.user =
xcache.admin.pass =

[xcache]
; ini only settings, all the values here is default unless explained

; select low level shm/allocator scheme implemenation
xcache.shm_scheme = "mmap"

; to disable: xcache.size=0
; to enable : xcache.size=64M etc (any size > 0) and your system mmap allows
xcache.size = 128M

; set to cpu count (cat /proc/cpuinfo |grep -c processor)
xcache.count = 4

; just a hash hints, you can always store count(items) > slots
xcache.slots = 8K

; ttl of the cache item, 0=forever
xcache.ttl = 72000

; interval of gc scanning expired items, 0=no scan, other values is in seconds
xcache.gc_interval = 5000

; same as aboves but for variable cache
xcache.var_size = 16M
xcache.var_count = 4
xcache.var_slots = 8K
; default ttl
xcache.var_ttl = 0
xcache.var_maxttl = 0
xcache.var_gc_interval = 300

xcache.test = Off
; N/A for /dev/zero
xcache.readonly_protection = Off
; for *nix, xcache.mmap_path is a file path, not directory.
; Use something like "/tmp/xcache" if you want to turn on ReadonlyProtection
; 2 group of php won't share the same /tmp/xcache
; for win32, xcache.mmap_path=anonymous map name, not file path
xcache.mmap_path = "/dev/zero"

; leave it blank(disabled) or "/tmp/phpcore/"
; make sure it's writable by php (without checking open_basedir)
xcache.coredump_directory = ""

; per request settings
xcache.cacher = On
xcache.stat = On
xcache.optimizer = On

[xcache.coverager]
; per request settings
; enable coverage data collecting for xcache.coveragedump_directory and xcache_coverager_start/stop/get/clean() functions (will hurt executi$
xcache.coverager = Off

10. how many average and max concurrent users on your vB forum ? and what your cookie timeout is ?
Quote:
Cookie time-out 10 minutes
Average users 700-900
Peak 1300-1500
Max 1700

11. create a file named phpinfo.php
Quote:
phpinfo

12. 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 :
Code:
RLimitMEM 473489066
RLimitCPU 240

# prefork MPM

StartServers 5
MinSpareServers 5
MaxSpareServers 15
ServerLimit 500
MaxClients 500
MaxRequestsPerChild 1000

# worker MPM

StartServers 2
ServerLimit 500
MaxClients 500

MinSpareThreads 25
MaxSpareThreads 75
ThreadsPerChild 25
MaxRequestsPerChild 1000

# BeOS MPM

StartThreads 10
MaxClients 50
MaxRequestsPerThread 10000

# NetWare MPM

ThreadStackSize 65536
StartThreads 250
MinSpareThreads 25
MaxSpareThreads 250
MaxThreads 1000
MaxRequestsPerChild 0
MaxMemFree 100

# OS/2 MPM

StartServers 2
MinSpareThreads 5
MaxSpareThreads 10
MaxRequestsPerChild 0

# WinNT MPM

ThreadsPerChild 150
MaxRequestsPerChild 0

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
Quote:
No files bigger than 2000000k

14. Post output from these 3 commands

uname -a
Quote:
Linux wallabee.elrincondelmanga.com 2.6.18-128.1.10.el5 #1 SMP Thu May 7 10:35:59 EDT 2009 x86_64 x86_64 x86_64 GNU/Linux
ulimit -aH
Quote:
core file size (blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
max nice (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 36864
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) 36864
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
cat /proc/cpuinfo
Code:
processor : 0
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Core(TM)2 Quad CPU Q6600 @ 2.40GHz
stepping : 11
cpu MHz : 2394.000
cache size : 4096 KB
physical id : 0
siblings : 4
core id : 0
cpu cores : 4
apicid : 0
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 syscall nx lm constant_tsc pni monitor ds_cpl vmx est tm2 cx16 xtpr lahf_lm
bogomips : 4802.12
clflush size : 64
cache_alignment : 64
address sizes : 36 bits physical, 48 bits virtual
power management:

processor : 1
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Core(TM)2 Quad CPU Q6600 @ 2.40GHz
stepping : 11
cpu MHz : 2394.000
cache size : 4096 KB
physical id : 0
siblings : 4
core id : 1
cpu cores : 4
apicid : 1
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 syscall nx lm constant_tsc pni monitor ds_cpl vmx est tm2 cx16 xtpr lahf_lm
bogomips : 4799.46
clflush size : 64
cache_alignment : 64
address sizes : 36 bits physical, 48 bits virtual
power management:

processor : 2
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Core(TM)2 Quad CPU Q6600 @ 2.40GHz
stepping : 11
cpu MHz : 2394.000
cache size : 4096 KB
physical id : 0
siblings : 4
core id : 2
cpu cores : 4
apicid : 2
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 syscall nx lm constant_tsc pni monitor ds_cpl vmx est tm2 cx16 xtpr lahf_lm
bogomips : 4799.54
clflush size : 64
cache_alignment : 64
address sizes : 36 bits physical, 48 bits virtual
power management:

processor : 3
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Core(TM)2 Quad CPU Q6600 @ 2.40GHz
stepping : 11
cpu MHz : 2394.000
cache size : 4096 KB
physical id : 0
siblings : 4
core id : 3
cpu cores : 4
apicid : 3
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 syscall nx lm constant_tsc pni monitor ds_cpl vmx est tm2 cx16 xtpr lahf_lm
bogomips : 4799.48
clflush size : 64
cache_alignment : 64
address sizes : 36 bits physical, 48 bits virtual
power management:
Thanks for the help __DEFINE_LIKE_SHARE__

المواضيع المتشابهه
الموضوع	كاتب الموضوع	المنتدى	مشاركات	آخر مشاركة
Server optimization request	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	06-20-2009 04:10 PM
Server Optimization Request. First time optimization	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	06-08-2009 04:40 AM
Server Optimization Request	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	05-07-2009 05:50 AM
Server Optimization Request - Please help! Server loads way too high!	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	05-05-2009 02:00 AM
Server Optimization Request	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	04-20-2009 03:30 PM