FAZO
Sun 24th Dec '06, 1:42pm
1.dedicated server
2.
cpu speed/type single or dual cpus): Dual Xeon 5130 Dual Core (Woodcrest) 3.60GHz
how much memory installed: 4 GB RAM
hard drive type/configuration: 120GB 7200RPM SATA
linux distributor or windows version: CentOS 4.4 x86_64
apache/IIS version: apache 1.3.37
PHP version: php 4.4.4
MySQL version: mysql 4.1.21
3.
if you use mysql 4.x instead of mysql 3.23.x, do you have any innodb type databases/tables on your server ? No
4. if possible how mysql was compiled/installed ? By Cpanel
5.
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
8289 nobody 15 0 83396 27m 3704 R 30 0.7 0:07.24 httpd
8355 nobody 16 0 80800 26m 3468 S 19 0.7 0:06.88 httpd
2952 mysql 15 0 661m 114m 3784 S 17 2.9 229:32.01 mysqld
8409 nobody 15 0 81492 26m 3240 S 10 0.7 0:05.73 httpd
8349 nobody 15 0 127m 28m 4264 S 9 0.7 0:07.12 httpd
8412 nobody 16 0 81584 26m 3336 S 6 0.7 0:06.65 httpd
8322 nobody 15 0 127m 28m 3504 S 6 0.7 0:05.33 httpd
8311 nobody 16 0 83136 27m 3632 S 5 0.7 0:03.92 httpd
8331 nobody 16 0 82688 27m 3840 S 4 0.7 0:06.15 httpd
8285 nobody 15 0 127m 27m 4288 S 3 0.7 0:06.60 httpd
8296 nobody 16 0 81772 26m 3324 S 3 0.7 0:04.54 httpd
8313 nobody 15 0 125m 26m 3528 S 3 0.7 0:04.93 httpd
8339 nobody 16 0 81224 26m 3204 S 3 0.7 0:05.35 httpd
8354 nobody 15 0 124m 25m 3412 S 3 0.6 0:05.74 httpd
8362 nobody 16 0 146m 47m 3540 S 3 1.2 0:06.23 httpd
8308 nobody 16 0 127m 27m 4236 S 2 0.7 0:04.18 httpd
8415 nobody 16 0 81468 26m 3304 S 2 0.7 0:03.98 httpd
6. my.cnf
[mysqld]
set-variable = max_connections=750
safe-show-database
skip-locking
key_buffer = 384M
max_allowed_packet = 1M
table_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 32M
thread_concurrency = 8
7.
root@host [~]# ./mysqlreport --all -tab statistics.txt
MySQL 4.1.21-standard uptime 3 2:40:34 Sun Dec 24 12:24:24 2006
__ Key __________________________________________________ _______________
Buffer used 77.39M of 384.00M %Used: 20.15
Current 79.68M %Usage: 20.75
Write ratio 0.035
Read ratio 0.003
__ Questions __________________________________________________ _________
Total 4.92M 18.3/s
QC Hits 2.08M 7.7/s %Total: 42.20
DMS 2.04M 7.6/s 41.34
Com_ 539.00k 2.0/s 10.95
COM_QUIT 271.20k 1.0/s 5.51
+Unknown 188 0.0/s 0.00
Slow 3.89k 0.0/s 0.08 %DMS: 0.19
DMS 2.04M 7.6/s 41.34
SELECT 1.39M 5.2/s 28.22 68.25
UPDATE 340.89k 1.3/s 6.92 16.75
INSERT 225.16k 0.8/s 4.57 11.06
DELETE 59.29k 0.2/s 1.20 2.91
REPLACE 20.91k 0.1/s 0.42 1.03
Com_ 539.00k 2.0/s 10.95
change_db 303.12k 1.1/s 6.16
set_option 38.55k 0.1/s 0.78
unlock_tabl 35.89k 0.1/s 0.73
__ SELECT and Sort __________________________________________________ ___
Scan 433.86k 1.6/s %SELECT: 31.23
Range 192.08k 0.7/s 13.83
Full join 4.30k 0.0/s 0.31
Range check 58 0.0/s 0.00
Full rng join 20 0.0/s 0.00
Sort scan 199.64k 0.7/s
Sort range 223.88k 0.8/s
Sort mrg pass 9.21k 0.0/s
__ Query Cache __________________________________________________ _______
Memory usage 29.91M of 32.00M %Used: 93.47
Block Fragmnt 3.97%
Hits 2.08M 7.7/s
Inserts 1.34M 5.0/s
Insrt:Prune 3.01:1 3.3/s
Hit:Insert 1.55:1
__ Table Locks __________________________________________________ _______
Waited 7.49k 0.0/s %Total: 0.24
Immediate 3.05M 11.4/s
__ Tables __________________________________________________ ____________
Open 512 of 512 %Cache: 100.00
Opened 193.03k 0.7/s
__ Connections __________________________________________________ _______
Max used 166 of 750 %Max: 22.13
Total 271.86k 1.0/s
__ Created Temp __________________________________________________ ______
Disk table 3.15k 0.0/s
Table 167.24k 0.6/s
File 18.26k 0.1/s
__ Threads __________________________________________________ ___________
Running 1 of 12
Cached 5 of 8 %Hit: 97.58
Created 6.59k 0.0/s
Slow 0 0/s
__ Aborted __________________________________________________ ___________
Clients 1.32k 0.0/s
Connects 53 0.0/s
__ Bytes __________________________________________________ _____________
Sent 85.76G 319.0k/s
Received 2.89G 10.8k/s
8.
Their are about 60-70 sites that using mysql and php
5-6 big vbulletin sites
9.
how many average and max concurrent users on your vB forum ? 9000
10.
http://www.idealhosting.org/phpini.php
11.
MaxKeepAliveRequests : 100
KeepAliveTimeout : 15
MinSpareServers : 5
MaxSpareServers : 10
StartServers : 5
MaxClients : 150
AND Maxrequestsperchild value = 0
12. vBulletin 3.6.4
13. heck 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
You can use this command to find such files
nothing ........
14.
uname -a
Linux host.idealhosting.org 2.6.9-42.0.2.ELsmp #1 SMP Wed Aug 23 13:38:27 BST 2006 x86_64 x86_64 x86_64 GNU/Linux
ulimit -aH
core file size (blocks, -c) 1000000
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
pending signals (-i) 1024
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
stack size (kbytes, -s) 8192
cpu time (seconds, -t) unlimited
max user processes (-u) 14335
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
cat /proc/cpuinfo
processor : 0
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 3.60GHz
stepping : 10
cpu MHz : 3600.299
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 lm pni monitor ds_cpl est tm2 cid cx16 xtpr
bogomips : 7207.76
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.60GHz
stepping : 10
cpu MHz : 3600.299
cache size : 2048 KB
physical id : 3
siblings : 2
core id : 3
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 lm pni monitor ds_cpl est tm2 cid cx16 xtpr
bogomips : 7199.35
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.60GHz
stepping : 10
cpu MHz : 3600.299
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 lm pni monitor ds_cpl est tm2 cid cx16 xtpr
bogomips : 7199.24
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.60GHz
stepping : 10
cpu MHz : 3600.299
cache size : 2048 KB
physical id : 3
siblings : 2
core id : 3
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 lm pni monitor ds_cpl est tm2 cid cx16 xtpr
bogomips : 7199.34
clflush size : 64
cache_alignment : 128
address sizes : 36 bits physical, 48 bits virtual
power management:
2.
cpu speed/type single or dual cpus): Dual Xeon 5130 Dual Core (Woodcrest) 3.60GHz
how much memory installed: 4 GB RAM
hard drive type/configuration: 120GB 7200RPM SATA
linux distributor or windows version: CentOS 4.4 x86_64
apache/IIS version: apache 1.3.37
PHP version: php 4.4.4
MySQL version: mysql 4.1.21
3.
if you use mysql 4.x instead of mysql 3.23.x, do you have any innodb type databases/tables on your server ? No
4. if possible how mysql was compiled/installed ? By Cpanel
5.
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
8289 nobody 15 0 83396 27m 3704 R 30 0.7 0:07.24 httpd
8355 nobody 16 0 80800 26m 3468 S 19 0.7 0:06.88 httpd
2952 mysql 15 0 661m 114m 3784 S 17 2.9 229:32.01 mysqld
8409 nobody 15 0 81492 26m 3240 S 10 0.7 0:05.73 httpd
8349 nobody 15 0 127m 28m 4264 S 9 0.7 0:07.12 httpd
8412 nobody 16 0 81584 26m 3336 S 6 0.7 0:06.65 httpd
8322 nobody 15 0 127m 28m 3504 S 6 0.7 0:05.33 httpd
8311 nobody 16 0 83136 27m 3632 S 5 0.7 0:03.92 httpd
8331 nobody 16 0 82688 27m 3840 S 4 0.7 0:06.15 httpd
8285 nobody 15 0 127m 27m 4288 S 3 0.7 0:06.60 httpd
8296 nobody 16 0 81772 26m 3324 S 3 0.7 0:04.54 httpd
8313 nobody 15 0 125m 26m 3528 S 3 0.7 0:04.93 httpd
8339 nobody 16 0 81224 26m 3204 S 3 0.7 0:05.35 httpd
8354 nobody 15 0 124m 25m 3412 S 3 0.6 0:05.74 httpd
8362 nobody 16 0 146m 47m 3540 S 3 1.2 0:06.23 httpd
8308 nobody 16 0 127m 27m 4236 S 2 0.7 0:04.18 httpd
8415 nobody 16 0 81468 26m 3304 S 2 0.7 0:03.98 httpd
6. my.cnf
[mysqld]
set-variable = max_connections=750
safe-show-database
skip-locking
key_buffer = 384M
max_allowed_packet = 1M
table_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 32M
thread_concurrency = 8
7.
root@host [~]# ./mysqlreport --all -tab statistics.txt
MySQL 4.1.21-standard uptime 3 2:40:34 Sun Dec 24 12:24:24 2006
__ Key __________________________________________________ _______________
Buffer used 77.39M of 384.00M %Used: 20.15
Current 79.68M %Usage: 20.75
Write ratio 0.035
Read ratio 0.003
__ Questions __________________________________________________ _________
Total 4.92M 18.3/s
QC Hits 2.08M 7.7/s %Total: 42.20
DMS 2.04M 7.6/s 41.34
Com_ 539.00k 2.0/s 10.95
COM_QUIT 271.20k 1.0/s 5.51
+Unknown 188 0.0/s 0.00
Slow 3.89k 0.0/s 0.08 %DMS: 0.19
DMS 2.04M 7.6/s 41.34
SELECT 1.39M 5.2/s 28.22 68.25
UPDATE 340.89k 1.3/s 6.92 16.75
INSERT 225.16k 0.8/s 4.57 11.06
DELETE 59.29k 0.2/s 1.20 2.91
REPLACE 20.91k 0.1/s 0.42 1.03
Com_ 539.00k 2.0/s 10.95
change_db 303.12k 1.1/s 6.16
set_option 38.55k 0.1/s 0.78
unlock_tabl 35.89k 0.1/s 0.73
__ SELECT and Sort __________________________________________________ ___
Scan 433.86k 1.6/s %SELECT: 31.23
Range 192.08k 0.7/s 13.83
Full join 4.30k 0.0/s 0.31
Range check 58 0.0/s 0.00
Full rng join 20 0.0/s 0.00
Sort scan 199.64k 0.7/s
Sort range 223.88k 0.8/s
Sort mrg pass 9.21k 0.0/s
__ Query Cache __________________________________________________ _______
Memory usage 29.91M of 32.00M %Used: 93.47
Block Fragmnt 3.97%
Hits 2.08M 7.7/s
Inserts 1.34M 5.0/s
Insrt:Prune 3.01:1 3.3/s
Hit:Insert 1.55:1
__ Table Locks __________________________________________________ _______
Waited 7.49k 0.0/s %Total: 0.24
Immediate 3.05M 11.4/s
__ Tables __________________________________________________ ____________
Open 512 of 512 %Cache: 100.00
Opened 193.03k 0.7/s
__ Connections __________________________________________________ _______
Max used 166 of 750 %Max: 22.13
Total 271.86k 1.0/s
__ Created Temp __________________________________________________ ______
Disk table 3.15k 0.0/s
Table 167.24k 0.6/s
File 18.26k 0.1/s
__ Threads __________________________________________________ ___________
Running 1 of 12
Cached 5 of 8 %Hit: 97.58
Created 6.59k 0.0/s
Slow 0 0/s
__ Aborted __________________________________________________ ___________
Clients 1.32k 0.0/s
Connects 53 0.0/s
__ Bytes __________________________________________________ _____________
Sent 85.76G 319.0k/s
Received 2.89G 10.8k/s
8.
Their are about 60-70 sites that using mysql and php
5-6 big vbulletin sites
9.
how many average and max concurrent users on your vB forum ? 9000
10.
http://www.idealhosting.org/phpini.php
11.
MaxKeepAliveRequests : 100
KeepAliveTimeout : 15
MinSpareServers : 5
MaxSpareServers : 10
StartServers : 5
MaxClients : 150
AND Maxrequestsperchild value = 0
12. vBulletin 3.6.4
13. heck 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
You can use this command to find such files
nothing ........
14.
uname -a
Linux host.idealhosting.org 2.6.9-42.0.2.ELsmp #1 SMP Wed Aug 23 13:38:27 BST 2006 x86_64 x86_64 x86_64 GNU/Linux
ulimit -aH
core file size (blocks, -c) 1000000
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
pending signals (-i) 1024
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
stack size (kbytes, -s) 8192
cpu time (seconds, -t) unlimited
max user processes (-u) 14335
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
cat /proc/cpuinfo
processor : 0
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 3.60GHz
stepping : 10
cpu MHz : 3600.299
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 lm pni monitor ds_cpl est tm2 cid cx16 xtpr
bogomips : 7207.76
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.60GHz
stepping : 10
cpu MHz : 3600.299
cache size : 2048 KB
physical id : 3
siblings : 2
core id : 3
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 lm pni monitor ds_cpl est tm2 cid cx16 xtpr
bogomips : 7199.35
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.60GHz
stepping : 10
cpu MHz : 3600.299
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 lm pni monitor ds_cpl est tm2 cid cx16 xtpr
bogomips : 7199.24
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.60GHz
stepping : 10
cpu MHz : 3600.299
cache size : 2048 KB
physical id : 3
siblings : 2
core id : 3
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 lm pni monitor ds_cpl est tm2 cid cx16 xtpr
bogomips : 7199.34
clflush size : 64
cache_alignment : 128
address sizes : 36 bits physical, 48 bits virtual
power management: