New Server Optimization Request

محروم.كوم · #1 07-04-2009, 05:40 AM

Hi,
Lately I have been getting database errors, and large overloads.

1. Dedicated Server
2. server specs:

cpu speed/type single or dual cpus):
2 Intel \ 3.2 GHz 800FSB \ P4 Xeon

how much memory installed: 2GB Ram

hard drive type/configuration: 2 Seagate \ 73.4 GB:SCSI:10kRPM: \ ST373307LC

linux distributor or windows version: CentOS Enterprise Linux - OS ES 5.0
apache/IIS version: Apache v2.0.63
PHP version: php 5.2.9
MySQL version: 5.0.81-community

3. 3.8.3 + vBSEO

4. No
5. was already installed

6. top stats

Code:

top - 17:07:23 up 11:27, 1 user, load average: 3.46, 2.64, 2.15
Tasks: 280 total, 1 running, 279 sleeping, 0 stopped, 0 zombie
Cpu(s): 6.0%us, 1.0%sy, 0.1%ni, 91.3%id, 1.5%wa, 0.0%hi, 0.1%si, 0.0%st
Mem: 2075308k total, 1662228k used, 413080k free, 16420k buffers
Swap: 2040212k total, 14804k used, 2025408k free, 453348k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
12949 mysql 15 0 130m 30m 4416 S 202.2 1.5 7:46.75 mysqld
15394 nobody 15 0 90724 24m 9884 S 15.4 1.2 0:01.07 httpd
14107 nobody 15 0 89012 31m 17m S 9.6 1.6 0:03.84 httpd
16190 nobody 16 0 89112 26m 13m S 9.6 1.3 0:01.55 httpd
15960 nobody 15 0 88080 22m 9896 S 5.8 1.1 0:01.31 httpd
14035 nobody 15 0 89872 25m 11m S 1.9 1.3 0:03.56 httpd
16300 nobody 15 0 87832 20m 8588 S 1.9 1.0 0:00.19 httpd
16327 nobody 15 0 88888 23m 9776 S 1.9 1.1 0:00.84 httpd
16871 root 15 0 2324 1040 712 R 1.9 0.1 0:00.02 top
1 root 18 0 2064 616 528 S 0.0 0.0 0:00.79 init
2 root RT -5 0 0 0 S 0.0 0.0 0:00.22 migration/0
3 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/0
4 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/0
5 root RT -5 0 0 0 S 0.0 0.0 0:00.12 migration/1
6 root 39 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/1
7 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/1
8 root RT -5 0 0 0 S 0.0 0.0 0:00.13 migration/2
9 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/2
10 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/2
11 root RT -5 0 0 0 S 0.0 0.0 0:00.10 migration/3
12 root 35 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/3
13 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/3
14 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 events/0
15 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 events/1
16 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 events/2
17 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 events/3
18 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 khelper
19 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 kthread
25 root 10 -5 0 0 0 S 0.0 0.0 0:00.01 kblockd/0
26 root 10 -5 0 0 0 S 0.0 0.0 0:00.23 kblockd/1
27 root 10 -5 0 0 0 S 0.0 0.0 0:00.01 kblockd/2
28 root 15 -5 0 0 0 S 0.0 0.0 0:00.00 kblockd/3
29 root 20 -5 0 0 0 S 0.0 0.0 0:00.00 kacpid
93 root 20 -5 0 0 0 S 0.0 0.0 0:00.00 cqueue/0
94 root 20 -5 0 0 0 S 0.0 0.0 0:00.00 cqueue/1
95 root 20 -5 0 0 0 S 0.0 0.0 0:00.00 cqueue/2
96 root 20 -5 0 0 0 S 0.0 0.0 0:00.00 cqueue/3
99 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 khubd
101 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 kseriod
175 root 11 -5 0 0 0 S 0.0 0.0 0:11.25 kswapd0
176 root 14 -5 0 0 0 S 0.0 0.0 0:00.00 aio/0
177 root 15 -5 0 0 0 S 0.0 0.0 0:00.00 aio/1
178 root 15 -5 0 0 0 S 0.0 0.0 0:00.00 aio/2
179 root 16 -5 0 0 0 S 0.0 0.0 0:00.00 aio/3
334 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 kpsmoused
385 root 13 -5 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_0
386 root 12 -5 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_1
392 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 ata/0
393 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 ata/1
394 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 ata/2
395 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 ata/3
396 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 ata_aux
412 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 kstriped
433 root 10 -5 0 0 0 S 0.0 0.0 0:00.50 kjournald
460 root 11 -5 0 0 0 S 0.0 0.0 0:00.01 kauditd
Code:

top - 17:49:39 up 12:09, 1 user, load average: 4.06, 4.45, 3.62
Tasks: 288 total, 1 running, 287 sleeping, 0 stopped, 0 zombie
Cpu(s): 7.6%us, 1.2%sy, 0.1%ni, 89.5%id, 1.6%wa, 0.0%hi, 0.1%si, 0.0%st
Mem: 2075308k total, 1928364k used, 146944k free, 11500k buffers
Swap: 2040212k total, 33264k used, 2006948k free, 500840k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
28966 nobody 16 0 92460 29m 12m S 36.9 1.5 0:03.78 httpd
29887 nobody 16 0 92156 26m 10m S 25.2 1.3 0:01.07 httpd
28976 nobody 15 0 89112 24m 10m S 13.6 1.2 0:02.93 httpd
12949 mysql 15 0 176m 50m 4452 S 7.8 2.5 32:43.66 mysqld
31218 root 15 0 2324 1048 712 R 3.9 0.1 0:00.02 top
28177 nobody 15 0 88216 23m 10m S 1.9 1.2 0:04.28 httpd
29874 nobody 15 0 88832 29m 15m S 1.9 1.5 0:01.97 httpd
30159 nobody 15 0 89596 24m 9m S 1.9 1.2 0:01.31 httpd
1 root 15 0 2064 608 528 S 0.0 0.0 0:00.79 init
2 root RT -5 0 0 0 S 0.0 0.0 0:00.26 migration/0
3 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/0
4 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/0
5 root RT -5 0 0 0 S 0.0 0.0 0:00.12 migration/1
6 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/1
7 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/1
8 root RT -5 0 0 0 S 0.0 0.0 0:00.15 migration/2
9 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/2
10 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/2
11 root RT -5 0 0 0 S 0.0 0.0 0:00.10 migration/3
12 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/3
13 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/3
14 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 events/0
15 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 events/1
16 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 events/2
17 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 events/3
18 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 khelper
19 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 kthread
25 root 10 -5 0 0 0 S 0.0 0.0 0:00.02 kblockd/0
26 root 10 -5 0 0 0 S 0.0 0.0 0:00.24 kblockd/1
27 root 10 -5 0 0 0 S 0.0 0.0 0:00.01 kblockd/2
28 root 10 -5 0 0 0 S 0.0 0.0 0:00.01 kblockd/3
29 root 20 -5 0 0 0 S 0.0 0.0 0:00.00 kacpid
93 root 20 -5 0 0 0 S 0.0 0.0 0:00.00 cqueue/0
94 root 20 -5 0 0 0 S 0.0 0.0 0:00.00 cqueue/1
95 root 20 -5 0 0 0 S 0.0 0.0 0:00.00 cqueue/2
96 root 20 -5 0 0 0 S 0.0 0.0 0:00.00 cqueue/3
99 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 khubd
101 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 kseriod
175 root 10 -5 0 0 0 S 0.0 0.0 0:11.71 kswapd0
176 root 14 -5 0 0 0 S 0.0 0.0 0:00.00 aio/0
177 root 15 -5 0 0 0 S 0.0 0.0 0:00.00 aio/1
178 root 15 -5 0 0 0 S 0.0 0.0 0:00.00 aio/2
179 root 16 -5 0 0 0 S 0.0 0.0 0:00.00 aio/3
334 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 kpsmoused
385 root 13 -5 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_0
386 root 12 -5 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_1
392 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 ata/0
393 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 ata/1
394 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 ata/2
395 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 ata/3
396 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 ata_aux
412 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 kstriped
433 root 10 -5 0 0 0 S 0.0 0.0 0:00.53 kjournald
460 root 16 -5 0 0 0 S 0.0 0.0 0:00.01 kauditd
494 root 21 -4 2252 516 392 S 0.0 0.0 0:00.11 udevd
7. my.cnf

Code:
[mysqld]

safe-show-database
max_connections = 500
8. Mysql Stats

Code:

MySQL 5.0.81-community uptime 0 059 Fri Jul 3 1706 2009

__ Key __________________________________________________ _______________
Buffer used 7.08M of 8.00M %Used: 88.48
Current 7.99M %Usage: 99.91
Write hit 6.43%
Read hit 99.63%

__ Questions __________________________________________________ _________
Total 101.57k 80.7/s
DMS 89.31k 70.9/s %Total: 87.93
Com_ 7.08k 5.6/s 6.97
COM_QUIT 5.22k 4.1/s 5.14
-Unknown 40 0.0/s 0.04
Slow 10 s 0 0/s 0.00 %DMS: 0.00 Log: OFF
DMS 89.31k 70.9/s 87.93
SELECT 80.46k 63.9/s 79.22 90.09
UPDATE 5.05k 4.0/s 4.97 5.65
INSERT 3.13k 2.5/s 3.08 3.50
DELETE 361 0.3/s 0.36 0.40
REPLACE 311 0.2/s 0.31 0.35
Com_ 7.08k 5.6/s 6.97
change_db 6.58k 5.2/s 6.48
show_fields 367 0.3/s 0.36
admin_comma 49 0.0/s 0.05

__ SELECT and Sort __________________________________________________ ___
Scan 16.68k 13.3/s %SELECT: 20.74
Range 19.28k 15.3/s 23.96
Full join 10 0.0/s 0.01
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 2.66k 2.1/s
Sort range 8.77k 7.0/s

Sort mrg pass 4 0.0/s

__ Table Locks __________________________________________________ _______
Waited 3.50k 2.8/s %Total: 2.64
Immediate 129.00k 102.5/s

__ Tables __________________________________________________ ____________
Open 64 of 64 %Cache: 100.00
Opened 14.68k 11.7/s

__ Connections __________________________________________________ _______
Max used 32 of 500 %Max: 6.40
Total 5.22k 4.1/s

__ Created Temp __________________________________________________ ______
Disk table 635 0.5/s
Table 7.24k 5.8/s Size: 32.0M
File 13 0.0/s

__ Threads __________________________________________________ ___________
Running 1 of 5
Cached 0 of 0 %Hit: 0.02
Created 5.22k 4.1/s
Slow 0 0/s

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

__ Bytes __________________________________________________ _____________
Sent 1.92G 1.5M/s
Received 26.32M 20.9k/s

__ InnoDB Buffer Pool __________________________________________________
Usage 320.00k of 8.00M %Used: 3.91
Read hit 89.68%
Pages
Free 492 %Total: 96.09
Data 20 3.91 %Drty: 0.00
Misc 0 0.00
Latched 0.00
Reads 126 0.1/s
From file 13 0.0/s 10.32
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 26 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 20 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. vBulletin + vBSeo + Wordpress

10. Average: 1500/1900 Max. 2000 - Cookie Timeout 1500

11. http://www.gamerzlove.com/info.php

12. httpd.conf

KeepAlive On
MaxKeepAliveRequests 100
KeepAliveTimeout 3
MinSpareServers 10
MaxSpareServers 15
StartServers 10
MaxClients 150
MaxRequestsPerChild 1000

13.

root@host [~]# find / -size +2000000k
find: /proc/31517/task/31517/fd/4: No such file or directory
find: /proc/31517/fd/4: No such file or directory
/root/firstboot.verbose.log

14.

uname -a

Code:

Linux host.gamerzlove.com 2.6.18-128.1.16.el5 #1 SMP Tue Jun 30 0628 EDT 2009 i686 i686 i386 GNU/Linux
ulimit -aH

Code:

core file size (blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
scheduling priority (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 32764
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) 32764
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
cat /proc/cpuinfo

Code:

processor : 0
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 3.20GHz

stepping : 3
cpu MHz : 3200.368
cache size : 2048 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 1
apicid : 0
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 5
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 pni monitor ds_cpl cid cx16 xtpr
bogomips : 6403.70

processor : 1
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 3.20GHz
stepping : 3
cpu MHz : 3200.368
cache size : 2048 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 1
apicid : 1
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 5
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 pni monitor ds_cpl cid cx16 xtpr
bogomips : 6400.26

processor : 2
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 3.20GHz
stepping : 3
cpu MHz : 3200.368
cache size : 2048 KB
physical id : 3
siblings : 2
core id : 0
cpu cores : 1
apicid : 6
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 5
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 pni monitor ds_cpl cid cx16 xtpr
bogomips : 6400.32

processor : 3
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 3.20GHz
stepping : 3
cpu MHz : 3200.368
cache size : 2048 KB
physical id : 3
siblings : 2
core id : 0
cpu cores : 1
apicid : 7
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 5
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 pni monitor ds_cpl cid cx16 xtpr
bogomips : 6400.28
Thanks! __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