assassin85
Sat 1st Dec '07, 1:11pm
1. Is this on dedicated or shared virual server. If shared, how many sites share this server (ask web host if needed)
dedicated Server With 548 Sites
2. your server specs. cpu speed/type (single or dual cpus):
dual cpus
Processor #1 Vendor: GenuineIntel
Processor #1 Name: Intel(R) Pentium(R) D CPU 2.80GHz
Processor #1 speed: 2791.234 MHz
Processor #1 cache size: 1024 KB
Processor #2 Vendor: GenuineIntel
Processor #2 Name: Intel(R) Pentium(R) D CPU 2.80GHz
Processor #2 speed: 2791.234 MHz
Processor #2 cache size: 1024 KBhow much memory installed: 3.0 GB ram
hard drive type/configuration: 160GB SATA
linux distributor or windows version: FEDORA 5 i686 on standard
apache/IIS version: apache 1.3.39
PHP version: php 4.4.7
MySQL client version: 4.1.22
3. what version of vB are you running ?
3.6.x
5. if possible how mysql was compiled/installed
/scripts/easyapache
6. your top stats
top - 18:49:31 up 1 day, 1:27, 3 users, load average: 3.44, 3.54, 3.25
Tasks: 191 total, 1 running, 182 sleeping, 0 stopped, 8 zombie
Cpu(s): 43.8%us, 8.5%sy, 0.5%ni, 46.1%id, 0.5%wa, 0.0%hi, 0.7%si, 0.0%st
Mem: 3101476k total, 2979944k used, 121532k free, 128232k buffers
Swap: 2040244k total, 116k used, 2040128k free, 2271572k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
2057 mysql 15 0 297m 106m 3280 S 22 3.5 80:53.14 /usr/sbin/mysqld --basedir=/ --datadir
21020 athe 16 0 0 0 0 Z 11 0.0 0:00.32 [php] <defunct>
21027 radio 18 0 0 0 0 Z 5 0.0 0:00.16 [php] <defunct>
21022 dena 18 0 0 0 0 Z 5 0.0 0:00.14 [php] <defunct>
21021 ps1ps 17 0 0 0 0 Z 4 0.0 0:00.12 [php] <defunct>
21029 sherton 18 0 0 0 0 Z 4 0.0 0:00.11 [php] <defunct>
16721 glalol 35 19 22032 11m 2568 S 1 0.4 0:04.55 cpaneld - serving 91.140.150.219
15528 nobody 15 0 16776 11m 1332 S 1 0.4 0:04.02 /usr/local/apache/bin/httpd -DSSL
15540 nobody 15 0 16764 11m 1328 S 1 0.4 0:04.26 /usr/local/apache/bin/httpd -DSSL
12055 root 15 0 2308 1168 800 S 1 0.0 0:05.49 top
15523 nobody 15 0 16240 10m 1232 S 1 0.4 0:00.12 /usr/local/apache/bin/httpd -DSSL
15529 nobody 15 0 17284 11m 1340 S 1 0.4 0:04.50 /usr/local/apache/bin/httpd -DSSL
15542 nobody 15 0 16280 10m 1256 S 1 0.4 0:00.29 /usr/local/apache/bin/httpd -DSSL
15544 nobody 15 0 16372 10m 1292 S 1 0.4 0:03.88 /usr/local/apache/bin/httpd -DSSL
15545 nobody 17 0 16768 11m 1308 S 1 0.4 0:04.19 /usr/local/apache/bin/httpd -DSSL
15547 nobody 15 0 18784 12m 1324 S 1 0.4 0:04.23 /usr/local/apache/bin/httpd -DSSL
18782 nobody 15 0 16364 11m 1264 S 1 0.4 0:01.36 /usr/local/apache/bin/httpd -DSSL
19989 nobody 15 0 17052 11m 1224 S 1 0.4 0:00.72 /usr/local/apache/bin/httpd -DSSL
20034 nobody 15 0 16240 10m 1216 S 1 0.4 0:00.47 /usr/local/apache/bin/httpd -DSSL
20139 nobody 15 0 16240 10m 1248 S 1 0.4 0:00.57 /usr/local/apache/bin/httpd -DSSL
20148 nobody 15 0 16240 10m 1232 S 1 0.4 0:00.64 /usr/local/apache/bin/httpd -DSSL
411 root 10 -5 0 0 0 S 0 0.0 1:49.17 [kjournald]
15481 nobody 15 0 16796 11m 1308 S 0 0.4 0:03.61 /usr/local/apache/bin/httpd -DSSL
15483 nobody 17 0 16240 10m 1236 S 0 0.4 0:00.27 /usr/local/apache/bin/httpd -DSSL
15501 nobody 15 0 16724 11m 1344 S 0 0.4 0:03.80 /usr/local/apache/bin/httpd -DSSL
15522 nobody 15 0 16364 10m 1240 S 0 0.4 0:00.81 /usr/local/apache/bin/httpd -DSSL
15525 nobody 15 0 16648 11m 1232 S 0 0.4 0:00.43 /usr/local/apache/bin/httpd -DSSL
15538 nobody 15 0 20176 12m 1288 S 0 0.4 0:04.66 /usr/local/apache/bin/httpd -DSSL
7. your mysql configuration variables located at /etc/my.cnf or c:\my.cnf or my.ini so post the contents inside of my.cnf (minus any passwords of course).
[mysqld]
max_connections = 500
max_user_connections = 30
thread_concurrency = 2
key_buffer = 32M
myisam_sort_buffer_size = 32M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 1M
record_buffer = 1M
max_allowed_packet = 16M
table_cache = 500
thread_cache_size = 128
wait_timeout = 15
connect_timeout = 15
interactive_timeout = 15
max_connect_errors = 10
query_cache_type = 1
query_cache_limit = 2M
query_cache_size = 32M
skip-locking
skip-innodb
safe-show-database
log-slow-queries = /var/log/mysqld.slow.log
long_query_time = 2
old-passwords = 1
[mysqld_safe]
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 32M
read_buffer = 16M
write_buffer = 16M
8. MySQL stats from ssh telnet as root user
Variables (--variable-name=value)
and boolean options {FALSE|TRUE} Value (after reading options)
--------------------------------- -----------------------------
auto-rehash TRUE
character-sets-dir (No default value)
default-character-set latin1
compress FALSE
database (No default value)
delimiter ;
vertical FALSE
force FALSE
named-commands FALSE
local-infile FALSE
no-beep FALSE
host (No default value)
html FALSE
xml FALSE
line-numbers TRUE
unbuffered FALSE
column-names TRUE
sigint-ignore FALSE
port 3306
prompt mysql>
quick FALSE
raw FALSE
reconnect TRUE
socket (No default value)
table FALSE
debug-info FALSE
user root
safe-updates FALSE
i-am-a-dummy FALSE
connect_timeout 0
max_allowed_packet 16777216
net_buffer_length 16384
select_limit 1000
max_join_size 1000000
secure-auth FALSE
MySQL 4.1.22-standard-l uptime 1 1:33:6 Sat Dec 1 18:56:05 2007
__ Key __________________________________________________ _______________
Buffer used 26.76M of 32.00M %Used: 83.64
Current 6.67M %Usage: 20.83
Write hit 82.56%
Read hit 95.12%
__ Questions __________________________________________________ _________
Total 4.77M 51.8/s
Slow 4.26k 0.0/s %Total: 0.09 %DMS: 0.20
DMS 2.15M 23.4/s 45.08
__ Table Locks __________________________________________________ _______
Waited 389 0.0/s %Total: 0.01
Immediate 3.34M 36.3/s
__ Tables __________________________________________________ ____________
Open 500 of 500 %Cache: 100.00
Opened 627.44k 6.8/s
__ Connections __________________________________________________ _______
Max used 106 of 500 %Max: 21.20
Total 244.81k 2.7/s
__ Created Temp __________________________________________________ ______
Disk table 2.68k 0.0/s
Table 160.47k 1.7/s
File 11.71k 0.1/s
9. is your vB the only thing on the server? or other scripts & sites which utilise php and mysql?
90% of this sites have vbulletin forums and php scripts using mysql
10. how many average and max concurrent users on your vB forum ? and what your cookie timeout is ?
max concurrent users 500 - 1000 cookie timeout 900
11. create a file named phpinfo.php and place this code in it and post the url/link to it from your web site
in attachments
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 :
RLimitMEM 380726272
RLimitCPU 240
ServerType standalone
KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 15
MinSpareServers 5
MaxSpareServers 10
StartServers 5
MaxClients 700
MaxRequestsPerChild 1000
Port 80
14. Post output from these 3 commands
uname -a
Linux host.server.com 2.6.20.2 #1 SMP Fri May 25 00:39:15 CDT 2007 i686 i686 i386 GNU/Linux
ulimit -aH
core file size (blocks, -c) 1000000
data seg size (kbytes, -d) unlimited
max nice (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 49020
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
max rt 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
processor : 0
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Pentium(R) D CPU 2.80GHz
stepping : 7
cpu MHz : 2791.234
cache size : 1024 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 2
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 sep 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 lahf_lm
bogomips : 5585.22
clflush size : 64
processor : 1
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Pentium(R) D CPU 2.80GHz
stepping : 7
cpu MHz : 2791.234
cache size : 1024 KB
physical id : 0
siblings : 2
core id : 1
cpu cores : 2
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 sep 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 lahf_lm
bogomips : 5581.40
clflush size : 64
The problem with the forums on the server running too slow
Thanks Eva2000 for help ;)
dedicated Server With 548 Sites
2. your server specs. cpu speed/type (single or dual cpus):
dual cpus
Processor #1 Vendor: GenuineIntel
Processor #1 Name: Intel(R) Pentium(R) D CPU 2.80GHz
Processor #1 speed: 2791.234 MHz
Processor #1 cache size: 1024 KB
Processor #2 Vendor: GenuineIntel
Processor #2 Name: Intel(R) Pentium(R) D CPU 2.80GHz
Processor #2 speed: 2791.234 MHz
Processor #2 cache size: 1024 KBhow much memory installed: 3.0 GB ram
hard drive type/configuration: 160GB SATA
linux distributor or windows version: FEDORA 5 i686 on standard
apache/IIS version: apache 1.3.39
PHP version: php 4.4.7
MySQL client version: 4.1.22
3. what version of vB are you running ?
3.6.x
5. if possible how mysql was compiled/installed
/scripts/easyapache
6. your top stats
top - 18:49:31 up 1 day, 1:27, 3 users, load average: 3.44, 3.54, 3.25
Tasks: 191 total, 1 running, 182 sleeping, 0 stopped, 8 zombie
Cpu(s): 43.8%us, 8.5%sy, 0.5%ni, 46.1%id, 0.5%wa, 0.0%hi, 0.7%si, 0.0%st
Mem: 3101476k total, 2979944k used, 121532k free, 128232k buffers
Swap: 2040244k total, 116k used, 2040128k free, 2271572k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
2057 mysql 15 0 297m 106m 3280 S 22 3.5 80:53.14 /usr/sbin/mysqld --basedir=/ --datadir
21020 athe 16 0 0 0 0 Z 11 0.0 0:00.32 [php] <defunct>
21027 radio 18 0 0 0 0 Z 5 0.0 0:00.16 [php] <defunct>
21022 dena 18 0 0 0 0 Z 5 0.0 0:00.14 [php] <defunct>
21021 ps1ps 17 0 0 0 0 Z 4 0.0 0:00.12 [php] <defunct>
21029 sherton 18 0 0 0 0 Z 4 0.0 0:00.11 [php] <defunct>
16721 glalol 35 19 22032 11m 2568 S 1 0.4 0:04.55 cpaneld - serving 91.140.150.219
15528 nobody 15 0 16776 11m 1332 S 1 0.4 0:04.02 /usr/local/apache/bin/httpd -DSSL
15540 nobody 15 0 16764 11m 1328 S 1 0.4 0:04.26 /usr/local/apache/bin/httpd -DSSL
12055 root 15 0 2308 1168 800 S 1 0.0 0:05.49 top
15523 nobody 15 0 16240 10m 1232 S 1 0.4 0:00.12 /usr/local/apache/bin/httpd -DSSL
15529 nobody 15 0 17284 11m 1340 S 1 0.4 0:04.50 /usr/local/apache/bin/httpd -DSSL
15542 nobody 15 0 16280 10m 1256 S 1 0.4 0:00.29 /usr/local/apache/bin/httpd -DSSL
15544 nobody 15 0 16372 10m 1292 S 1 0.4 0:03.88 /usr/local/apache/bin/httpd -DSSL
15545 nobody 17 0 16768 11m 1308 S 1 0.4 0:04.19 /usr/local/apache/bin/httpd -DSSL
15547 nobody 15 0 18784 12m 1324 S 1 0.4 0:04.23 /usr/local/apache/bin/httpd -DSSL
18782 nobody 15 0 16364 11m 1264 S 1 0.4 0:01.36 /usr/local/apache/bin/httpd -DSSL
19989 nobody 15 0 17052 11m 1224 S 1 0.4 0:00.72 /usr/local/apache/bin/httpd -DSSL
20034 nobody 15 0 16240 10m 1216 S 1 0.4 0:00.47 /usr/local/apache/bin/httpd -DSSL
20139 nobody 15 0 16240 10m 1248 S 1 0.4 0:00.57 /usr/local/apache/bin/httpd -DSSL
20148 nobody 15 0 16240 10m 1232 S 1 0.4 0:00.64 /usr/local/apache/bin/httpd -DSSL
411 root 10 -5 0 0 0 S 0 0.0 1:49.17 [kjournald]
15481 nobody 15 0 16796 11m 1308 S 0 0.4 0:03.61 /usr/local/apache/bin/httpd -DSSL
15483 nobody 17 0 16240 10m 1236 S 0 0.4 0:00.27 /usr/local/apache/bin/httpd -DSSL
15501 nobody 15 0 16724 11m 1344 S 0 0.4 0:03.80 /usr/local/apache/bin/httpd -DSSL
15522 nobody 15 0 16364 10m 1240 S 0 0.4 0:00.81 /usr/local/apache/bin/httpd -DSSL
15525 nobody 15 0 16648 11m 1232 S 0 0.4 0:00.43 /usr/local/apache/bin/httpd -DSSL
15538 nobody 15 0 20176 12m 1288 S 0 0.4 0:04.66 /usr/local/apache/bin/httpd -DSSL
7. your mysql configuration variables located at /etc/my.cnf or c:\my.cnf or my.ini so post the contents inside of my.cnf (minus any passwords of course).
[mysqld]
max_connections = 500
max_user_connections = 30
thread_concurrency = 2
key_buffer = 32M
myisam_sort_buffer_size = 32M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 1M
record_buffer = 1M
max_allowed_packet = 16M
table_cache = 500
thread_cache_size = 128
wait_timeout = 15
connect_timeout = 15
interactive_timeout = 15
max_connect_errors = 10
query_cache_type = 1
query_cache_limit = 2M
query_cache_size = 32M
skip-locking
skip-innodb
safe-show-database
log-slow-queries = /var/log/mysqld.slow.log
long_query_time = 2
old-passwords = 1
[mysqld_safe]
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 32M
read_buffer = 16M
write_buffer = 16M
8. MySQL stats from ssh telnet as root user
Variables (--variable-name=value)
and boolean options {FALSE|TRUE} Value (after reading options)
--------------------------------- -----------------------------
auto-rehash TRUE
character-sets-dir (No default value)
default-character-set latin1
compress FALSE
database (No default value)
delimiter ;
vertical FALSE
force FALSE
named-commands FALSE
local-infile FALSE
no-beep FALSE
host (No default value)
html FALSE
xml FALSE
line-numbers TRUE
unbuffered FALSE
column-names TRUE
sigint-ignore FALSE
port 3306
prompt mysql>
quick FALSE
raw FALSE
reconnect TRUE
socket (No default value)
table FALSE
debug-info FALSE
user root
safe-updates FALSE
i-am-a-dummy FALSE
connect_timeout 0
max_allowed_packet 16777216
net_buffer_length 16384
select_limit 1000
max_join_size 1000000
secure-auth FALSE
MySQL 4.1.22-standard-l uptime 1 1:33:6 Sat Dec 1 18:56:05 2007
__ Key __________________________________________________ _______________
Buffer used 26.76M of 32.00M %Used: 83.64
Current 6.67M %Usage: 20.83
Write hit 82.56%
Read hit 95.12%
__ Questions __________________________________________________ _________
Total 4.77M 51.8/s
Slow 4.26k 0.0/s %Total: 0.09 %DMS: 0.20
DMS 2.15M 23.4/s 45.08
__ Table Locks __________________________________________________ _______
Waited 389 0.0/s %Total: 0.01
Immediate 3.34M 36.3/s
__ Tables __________________________________________________ ____________
Open 500 of 500 %Cache: 100.00
Opened 627.44k 6.8/s
__ Connections __________________________________________________ _______
Max used 106 of 500 %Max: 21.20
Total 244.81k 2.7/s
__ Created Temp __________________________________________________ ______
Disk table 2.68k 0.0/s
Table 160.47k 1.7/s
File 11.71k 0.1/s
9. is your vB the only thing on the server? or other scripts & sites which utilise php and mysql?
90% of this sites have vbulletin forums and php scripts using mysql
10. how many average and max concurrent users on your vB forum ? and what your cookie timeout is ?
max concurrent users 500 - 1000 cookie timeout 900
11. create a file named phpinfo.php and place this code in it and post the url/link to it from your web site
in attachments
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 :
RLimitMEM 380726272
RLimitCPU 240
ServerType standalone
KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 15
MinSpareServers 5
MaxSpareServers 10
StartServers 5
MaxClients 700
MaxRequestsPerChild 1000
Port 80
14. Post output from these 3 commands
uname -a
Linux host.server.com 2.6.20.2 #1 SMP Fri May 25 00:39:15 CDT 2007 i686 i686 i386 GNU/Linux
ulimit -aH
core file size (blocks, -c) 1000000
data seg size (kbytes, -d) unlimited
max nice (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 49020
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
max rt 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
processor : 0
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Pentium(R) D CPU 2.80GHz
stepping : 7
cpu MHz : 2791.234
cache size : 1024 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 2
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 sep 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 lahf_lm
bogomips : 5585.22
clflush size : 64
processor : 1
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Pentium(R) D CPU 2.80GHz
stepping : 7
cpu MHz : 2791.234
cache size : 1024 KB
physical id : 0
siblings : 2
core id : 1
cpu cores : 2
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 sep 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 lahf_lm
bogomips : 5581.40
clflush size : 64
The problem with the forums on the server running too slow
Thanks Eva2000 for help ;)