Q6600 - Optimization request

محروم.كوم · #1 05-27-2009, 01:50 AM

My concerns:
- New server, as needed to upgrade.
- Users are growing fast
- mysql backup nightly bogs the server down for ~10 mins

Notes: currently running xcache and lovin it.

Thank you for your time.

1. Dedicated server.

2.
CPU: Intel(R) Core(TM)2 Quad CPU Q6600 @ 2.40GHz
Mem: 4Gb
HD: 2x160 Gb non-raid
OS: CentOS release 5.3 (Final)
Apache: Apache/2.2.11
PHP: PHP 5.2.9
MySQL: 5.0.77-community

3.
vBulletin 3.8.2

4. innodb are used by other website, but that site is currently suspended indefinitely.

5. yum through Cpanel

6.
Code:
top - 16:27:05 up 5 days, 22:39, 1 user, load average: 0.18, 0.38, 0.34
Tasks: 142 total, 1 running, 140 sleeping, 0 stopped, 1 zombie
Cpu(s): 0.2%us, 0.2%sy, 0.0%ni, 99.7%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 4054252k total, 3691072k used, 363180k free, 177976k buffers

Swap: 2096472k total, 12588k used, 2083884k free, 2588780k cached
Code:
top - 16:27:28 up 5 days, 22:39, 1 user, load average: 0.18, 0.37, 0.33
Tasks: 133 total, 1 running, 132 sleeping, 0 stopped, 0 zombie
Cpu0 : 0.6%us, 0.2%sy, 0.3%ni, 96.7%id, 1.5%wa, 0.0%hi, 0.6%si, 0.0%st
Cpu1 : 1.0%us, 0.3%sy, 0.2%ni, 95.7%id, 2.7%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu2 : 2.5%us, 1.2%sy, 0.3%ni, 90.2%id, 5.8%wa, 0.1%hi, 0.0%si, 0.0%st
Cpu3 : 5.5%us, 0.7%sy, 0.1%ni, 90.6%id, 2.8%wa, 0.0%hi, 0.2%si, 0.0%st
Mem: 4054252k total, 3629608k used, 424644k free, 178000k buffers
Swap: 2096472k total, 12588k used, 2083884k free, 2588788k cached
atop if interested:
Code:
PRC | sys 33m20s | user 24m33s | #proc 132 | #zombie 0 | #exit 0 |
CPU | sys 2% | user 11% | irq 1% | idle 373% | wait 13% |
cpu | sys 1% | user 6% | irq 0% | idle 91% | cpu003 w 3% |
cpu | sys 1% | user 3% | irq 0% | idle 90% | cpu002 w 6% |
cpu | sys 0% | user 1% | irq 1% | idle 97% | cpu000 w 2% |
cpu | sys 0% | user 1% | irq 0% | idle 96% | cpu001 w 3% |
CPL | avg1 0.27 | avg5 0.37 | avg15 0.34 | csw 276377e3 | intr 85655e4 |
MEM | tot 3.9G | free 416.6M | cache 2.5G | buff 173.9M | slab 155.7M |
SWP | tot 2.0G | free 2.0G | | vmcom 1.3G | vmlim 3.9G |
PAG | scan 2515e4 | stall 0 | | swin 21774 | swout 30338 |
DSK | hda | busy 10% | read 2036688 | write 4009e3 | avio 8 ms |
DSK | hdc | busy 3% | read 44201 | write 125710 | avio 77 ms |
NET | transport | tcpi 17211e3 | tcpo 14043e3 | udpi 310841 | udpo 310894 |
NET | network | ipi 20160408 | ipo 14375794 | ipfrw 0 | deliv 1754e4 |
NET | eth0 0% | pcki 51047e3 | pcko 12933e3 | si 256 Kbps | so 128 Kbps |
NET | lo ---- | pcki 1447005 | pcko 1447005 | si 3 Kbps | so 3 Kbps |
7.
Code:
[mysqld]
safe-show-database
old_passwords
back_log = 50
max_connections = 500
key_buffer_size = 256M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 3M
table_cache = 5000
thread_cache_size = 256
wait_timeout = 260
connect_timeout = 10
tmp_table_size = 64M
max_heap_table_size = 64M
max_allowed_packet = 64M
net_buffer_length = 16384
max_connect_errors = 100000
thread_concurrency = 8
concurrent_insert = 2
table_lock_wait_timeout = 30
read_rnd_buffer_size = 786432
bulk_insert_buffer_size = 8M
query_cache_limit = 4M
query_cache_size = 96M
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
max_write_lock_count = 4

[mysqld_safe]
nice = -5
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 16M

[myisamchk]
key_buffer = 64M
sort_buffer = 16M
read_buffer = 16M
write_buffer = 16M
8. (linked for readability)
http://www.debatepolitics.com/tester/mysql.txt
and
http://www.debatepolitics.com/tester/mysql_stats3.txt

9. There are two other websites currently. One I plan on doing something with eventually. I will not be using innode tables however. For now, only 1 site is active.

10. Average users ~82, this is increasing fast.

11. http://www.debatepolitics.com/tester/phpinfo.php

12. Unsure what to put here, cpanel flubbers all this up the following is from /usr/local/apache/conf/extra/http-mpm.conf
Code:
# prefork MPM
# StartServers: number of server processes to start
# MinSpareServers: minimum number of server processes which are kept spare
# MaxSpareServers: maximum number of server processes which are kept spare
# MaxClients: maximum number of server processes allowed to start
# MaxRequestsPerChild: maximum number of requests a server process serves

StartServers 5
MinSpareServers 5
MaxSpareServers 10
MaxClients 150
MaxRequestsPerChild 0

# worker MPM
# StartServers: initial number of server processes to start
# MaxClients: maximum number of simultaneous client connections
# MinSpareThreads: minimum number of worker threads which are kept spare
# MaxSpareThreads: maximum number of worker threads which are kept spare
# ThreadsPerChild: constant number of worker threads in each server process
# MaxRequestsPerChild: maximum number of requests a server process serves

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

13. No files of that size or greater.

14.
Linux q6600.debatepolitics.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

Code:
core file size (blocks, -c) 1000000
data seg size (kbytes, -d) unlimited
scheduling priority (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 34816
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
real-time priority (-r) 0
stack size (kbytes, -s) 8192
cpu time (seconds, -t) unlimited
max user processes (-u) 14335
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
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 : 1600.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 : 4790.05
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 : 1600.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 : 4787.36
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 : 1600.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 : 4787.37
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 : 1600.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 : 4787.31
clflush size : 64
cache_alignment : 64
address sizes : 36 bits physical, 48 bits virtual
power management: __DEFINE_LIKE_SHARE__

المواضيع المتشابهه
الموضوع	كاتب الموضوع	المنتدى	مشاركات	آخر مشاركة
Server Optimization Request	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	07-29-2009 09:30 PM
Server Optimization Request	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	07-27-2009 07:10 AM
Server Optimization Request. First time optimization	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	06-08-2009 04:40 AM
Optimization Request	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	06-08-2009 12:30 AM
Server Optimization Request	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	05-02-2009 08:50 AM