Server tuning - 1 Year later...
 

<div>Just requesting another server tuneup after my first one last year.. currently getting "Out of memory errors" from vbulletin in my inbox... originally it was related to a bad custom query but now it complains at random VB queries...

thanks in advance...

1. Dedicated

2. Server Specs:
CPU: Dual Harpertown 5405 2.0GHZ - 8CPUS
RAM: 10GB ram
H/D: 500GBx2 EIDE raid1
linux distributor: Centos
apache/IIS version: apache 2.2.10
PHP version: php 5.2.5
MySQL version: mysql 5.0.67-community


3. 3.8 RC1

4. N/A
5. via HOST
6.
Code:

top - 11:44:46 up 141 days, 22:24, 1 user, load average: 1.50, 1.64, 1.34
Tasks: 190 total, 2 running, 188 sleeping, 0 stopped, 0 zombie
Cpu(s): 4.8%us, 1.7%sy, 0.7%ni, 87.0%id, 5.7%wa, 0.0%hi, 0.1%si, 0.0%st
Mem: 10388768k total, 9920620k used, 468148k free, 141400k buffers
Swap: 20972728k total, 212k used, 20972516k free, 8170012k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
8037 nobody 20 0 44972 26m 6380 R 16 0.3 0:00.52 httpd
7845 nobody 20 0 42096 24m 6436 S 8 0.2 0:01.10 httpd
7623 nobody 20 0 43568 25m 6860 S 4 0.3 0:02.98 httpd
28754 root 38 18 7352 7204 3544 S 4 0.1 0:17.44 cpbackup
4789 mysql 10 -10 1476m 1.1g 8200 S 2 10.7 4605:30 mysqld
1 root 20 0 2092 1160 1080 S 0 0.0 2:25.15 init
2 root 15 -5 0 0 0 S 0 0.0 0:00.16 kthreadd
3 root RT -5 0 0 0 S 0 0.0 0:06.96 migration/0
4 root 15 -5 0 0 0 S 0 0.0 10:28.82 ksoftirqd/0
5 root RT -5 0 0 0 S 0 0.0 0:07.94 migration/1
6 root 15 -5 0 0 0 S 0 0.0 39:02.17 ksoftirqd/1
7 root RT -5 0 0 0 S 0 0.0 0:17.98 migration/2
8 root 15 -5 0 0 0 S 0 0.0 8:31.13 ksoftirqd/2
9 root RT -5 0 0 0 S 0 0.0 0:13.10 migration/3
10 root 15 -5 0 0 0 S 0 0.0 6:35.57 ksoftirqd/3
11 root RT -5 0 0 0 S 0 0.0 0:04.18 migration/4
12 root 15 -5 0 0 0 S 0 0.0 10:38.66 ksoftirqd/4

top - 11:44:59 up 141 days, 22:24, 1 user, load average: 1.38, 1.60, 1.34
Tasks: 189 total, 3 running, 186 sleeping, 0 stopped, 0 zombie
Cpu0 : 5.3%us, 2.3%sy, 1.3%ni, 83.9%id, 7.2%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu1 : 3.3%us, 1.8%sy, 1.4%ni, 84.9%id, 8.6%wa, 0.0%hi, 0.1%si, 0.0%st
Cpu2 : 5.6%us, 2.5%sy, 1.2%ni, 77.4%id, 13.2%wa, 0.0%hi, 0.1%si, 0.0%st
Cpu3 : 12.8%us, 2.8%sy, 0.7%ni, 74.2%id, 9.2%wa, 0.0%hi, 0.2%si, 0.0%st
Cpu4 : 4.1%us, 1.6%sy, 0.5%ni, 91.6%id, 2.2%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu5 : 2.8%us, 1.0%sy, 0.3%ni, 93.8%id, 2.2%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu6 : 3.3%us, 1.3%sy, 0.4%ni, 93.4%id, 1.6%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu7 : 1.3%us, 0.6%sy, 0.1%ni, 96.6%id, 1.3%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 10388768k total, 9934764k used, 454004k free, 141516k buffers
Swap: 20972728k total, 212k used, 20972516k free, 8174080k cached
7. Code:
root@server [~]# cat /etc/my.cnf
[mysqld]
#skip-name-resolve
safe-show-database
#old_passwords
back_log = 50
skip-innodb
max_connections = 800
key_buffer_size = 2048M
myisam_sort_buffer_size = 128M
join_buffer_size = 128M
read_buffer_size = 128M
sort_buffer_size = 128M
table_cache = 50000
thread_cache_size = 512
wait_timeout = 180
connect_timeout = 10
tmp_table_size = 128M
max_heap_table_size = 128M
max_allowed_packet = 128M
net_buffer_length = 2048
max_connect_errors = 10
thread_concurrency = 16
concurrent_insert = 2
table_lock_wait_timeout = 30
read_rnd_buffer_size = 32M
bulk_insert_buffer_size = 16M
query_cache_limit = 32M
query_cache_size = 512M
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 = 16
[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 = 128M
[myisamchk]
key_buffer = 384M
sort_buffer = 64M
read_buffer = 64M
write_buffer = 64M
root@server [~]#
8.
Code:
root@server [~]# mysqladmin -u root var ext stat ver proc
+---------------------------------+------------------------------------------------+
| Variable_name | Value |
+---------------------------------+------------------------------------------------+
| auto_increment_increment | 1 |
| auto_increment_offset | 1 |
| automatic_sp_privileges | ON |
| back_log | 50 |
| basedir | / |
| binlog_cache_size | 32768 |
| bulk_insert_buffer_size | 16777216 |
| 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 | 2 |
| 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 |
| keep_files_on_create | OFF |
| engine_condition_pushdown | OFF |
| expire_logs_days | 0 |
| flush | OFF |
| flush_time | 0 |
| ft_boolean_syntax | + -> Photopost 6.1 Gallery
> Custom audio database/script that streams mp3's (total of 3K records)
> Video Script. Only encoding is done on server. The streaming is done on another server.

10. 70 members 250 guests

11. http://72.18.156.138/~admin/phpinfo.php

12.
Timeout 300
KeepAlive On
MaxKeepAliveRequests 100
KeepAliveTimeout 5
StartServers 2
MaxClients 250
MinSpareThreads 25
MaxSpareThreads 75
ThreadsPerChild 25
MaxRequestsPerChild 20

13.
Code:
root@server [~]# ls -alh /usr/local/apache/logs/|grep log
-rw-r--r-- 1 root root 117M Jun 4 11:45 access_log
-rw-r--r-- 1 root root 109M Jun 4 11:41 error_log
-rw-r--r-- 1 root nobody 29K Jun 4 09:16 suexec_log
-rw-r--r-- 1 root root 6 Jun 3 02:18 suexec_log.offset
root@server [~]#
14.
Code:
[~]# cat /proc/cpuinfo
processor : 0
vendor_id : GenuineIntel
cpu family : 6
model : 23
model name : Intel(R) Xeon(R) CPU E5405 @ 2.00GHz
stepping : 6
cpu MHz : 2000.220
cache size : 6144 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 mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe nx lm constant_tsc arch_pe rfmon pebs bts pni monitor ds_cpl vmx tm2 ssse3 cx16 xtpr dca sse4_1 lahf_lm
bogomips : 4003.30
clflush size : 64
processor : 1
vendor_id : GenuineIntel
cpu family : 6
model : 23
model name : Intel(R) Xeon(R) CPU E5405 @ 2.00GHz
stepping : 6
cpu MHz : 2000.220
cache size : 6144 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 mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe nx lm constant_tsc arch_pe rfmon pebs bts pni monitor ds_cpl vmx tm2 ssse3 cx16 xtpr dca sse4_1 lahf_lm
bogomips : 4000.43
clflush size : 64
processor : 2
vendor_id : GenuineIntel
cpu family : 6
model : 23
model name : Intel(R) Xeon(R) CPU E5405 @ 2.00GHz
stepping : 6
cpu MHz : 2000.220
cache size : 6144 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 mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe nx lm constant_tsc arch_pe rfmon pebs bts pni monitor ds_cpl vmx tm2 ssse3 cx16 xtpr dca sse4_1 lahf_lm
bogomips : 4000.45
clflush size : 64
processor : 3
vendor_id : GenuineIntel
cpu family : 6
model : 23
model name : Intel(R) Xeon(R) CPU E5405 @ 2.00GHz
stepping : 6
cpu MHz : 2000.220
cache size : 6144 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 mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe nx lm constant_tsc arch_pe rfmon pebs bts pni monitor ds_cpl vmx tm2 ssse3 cx16 xtpr dca sse4_1 lahf_lm
bogomips : 4000.48
clflush size : 64
processor : 4
vendor_id : GenuineIntel
cpu family : 6
model : 23
model name : Intel(R) Xeon(R) CPU E5405 @ 2.00GHz
stepping : 6
cpu MHz : 2000.220
cache size : 6144 KB
physical id : 1
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 mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe nx lm constant_tsc arch_pe rfmon pebs bts pni monitor ds_cpl vmx tm2 ssse3 cx16 xtpr dca sse4_1 lahf_lm
bogomips : 4000.45
clflush size : 64
processor : 5
vendor_id : GenuineIntel
cpu family : 6
model : 23
model name : Intel(R) Xeon(R) CPU E5405 @ 2.00GHz
stepping : 6
cpu MHz : 2000.220
cache size : 6144 KB
physical id : 1
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 mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe nx lm constant_tsc arch_pe rfmon pebs bts pni monitor ds_cpl vmx tm2 ssse3 cx16 xtpr dca sse4_1 lahf_lm
bogomips : 4000.46
clflush size : 64
processor : 6
vendor_id : GenuineIntel
cpu family : 6
model : 23
model name : Intel(R) Xeon(R) CPU E5405 @ 2.00GHz
stepping : 6
cpu MHz : 2000.220
cache size : 6144 KB
physical id : 1
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 mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe nx lm constant_tsc arch_pe rfmon pebs bts pni monitor ds_cpl vmx tm2 ssse3 cx16 xtpr dca sse4_1 lahf_lm
bogomips : 4000.47
clflush size : 64
processor : 7
vendor_id : GenuineIntel
cpu family : 6
model : 23
model name : Intel(R) Xeon(R) CPU E5405 @ 2.00GHz
stepping : 6
cpu MHz : 2000.220
cache size : 6144 KB
physical id : 1
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 mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe nx lm constant_tsc arch_pe rfmon pebs bts pni monitor ds_cpl vmx tm2 ssse3 cx16 xtpr dca sse4_1 lahf_lm
bogomips : 4000.47
clflush size : 64
Code:
Linux server 2.6.24.5-grsec #1 SMP Sat May 24 11:53:58 MDT 2008 i686 i686 i386 GNU/Linux
[email protected] [~]# ulimit -aH
core file size (blocks, -c) 200000
data seg size (kbytes, -d) 200000
scheduling priority (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 88064
max locked memory (kbytes, -l) 32
max memory size (kbytes, -m) 200000
open files (-n) 100
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) 20
virtual memory (kbytes, -v) 200000
file locks (-x) unlimited