accyroy
Thu 29th Jul '04, 2:17pm
I've recently got a dedicated server but I'm not entirely happy with its performance. Most times it is ok but sometimes i get connections refused etc. I am certain the server is not overloaded, as the sites on it are not huge.
Anyway, if anyone can spot anything out of the order in the following then advice would really be appreciated.
Thanks in advance!
1. is this on dedicated or shared virual server
Dedicated
2. your server specs. For example:
cpu speed/type single or dual cpus): Single P4 2.8 Hyper Threading
how much memory installed: 1.5gig
hard drive type/configuration: 80gb IDE and 40gig backup drive.
linux distributor or windows version: Red Hat Enterprise Linux ES release 3 (Taroon Update 2) 2.4.21-15.ELsmp (SMP) (with cpanel)
apache/IIS version: apache 1.3.31
PHP version: php 4.3.7
MySQL version: mysql 4.0.20-standard
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
unknown
5. your top stats
Http processes currently running = 58
Mysql processes currently running = 22
17:41:32 up 1 day, 3:10, 1 user, load average: 0.23, 0.20, 0.24
156 processes: 155 sleeping, 1 running, 0 zombie, 0 stopped
total 0.4% 0.0% 0.0% 0.0% 0.0% 0.0% 99.5%
cpu00 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 100.0%
cpu01 0.9% 0.0% 0.0% 0.0% 0.0% 0.0% 99.0%
Mem: 1544588k av, 1526512k used, 18076k free, 0k shrd, 68680k buff
1079896k actv, 132236k in_d, 22016k in_c
Swap: 2040244k av, 928k used, 2039316k free 866440k cached
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
31987 nobody 21 0 1224 1224 812 R 0.4 0.0 0:00 1 top
4185 nobody 23 8 788 360 244 S N 0.0 0.0 0:00 0 proftpd
7182 mysql 21 6 77008 75M 1264 S N 0.0 4.9 0:06 1 mysqld
7244 mysql 21 6 77008 75M 1264 S N 0.0 4.9 0:01 0 mysqld
7245 mysql 21 6 77008 75M 1264 S N 0.0 4.9 0:15 0 mysqld
7258 mysql 21 6 77008 75M 1264 S N 0.0 4.9 2:18 1 mysqld
7336 mysql 21 6 77008 75M 1264 S N 0.0 4.9 2:12 0 mysqld
7360 mysql 21 6 77008 75M 1264 S N 0.0 4.9 43:10 1 mysqld
7387 mysql 21 6 77008 75M 1264 S N 0.0 4.9 2:16 0 mysqld
7389 mysql 21 6 77008 75M 1264 S N 0.0 4.9 2:22 1 mysqld
7405 mysql 21 6 77008 75M 1264 S N 0.0 4.9 2:48 1 mysqld
7406 mysql 21 6 77008 75M 1264 S N 0.0 4.9 2:30 0 mysqld
7412 nobody 23 0 768 768 24 S 0.0 0.0 0:00 1 entropychat
7416 nobody 26 6 248 248 0 S N 0.0 0.0 0:00 0 melange
7522 nobody 26 6 516 516 92 S N 0.0 0.0 0:00 1 urchinwebd
7523 nobody 26 6 492 492 68 S N 0.0 0.0 0:00 1 urchinwebd
7524 nobody 26 6 492 492 68 S N 0.0 0.0 0:00 1 urchinwebd
7525 nobody 26 6 488 488 64 S N 0.0 0.0 0:00 1 urchinwebd
7526 nobody 26 6 476 476 52 S N 0.0 0.0 0:00 1 urchinwebd
7528 nobody 15 0 276 276 80 S 0.0 0.0 0:05 0 urchind
17797 mysql 21 6 77008 75M 1264 S N 0.0 4.9 2:05 1 mysqld
26658 mysql 21 6 77008 75M 1264 S N 0.0 4.9 269:52 0 mysqld
1852 mysql 21 6 77008 75M 1264 S N 0.0 4.9 0:39 0 mysqld
1853 mysql 21 6 77008 75M 1264 S N 0.0 4.9 0:53 0 mysqld
19286 mysql 21 6 77008 75M 1264 S N 0.0 4.9 0:07 1 mysqld
19287 mysql 21 6 77008 75M 1264 S N 0.0 4.9 0:07 0 mysqld
19288 mysql 21 6 77008 75M 1264 S N 0.0 4.9 0:06 0 mysqld
19289 mysql 21 6 77008 75M 1264 S N 0.0 4.9 0:08 1 mysqld
19355 mysql 21 6 77008 75M 1264 S N 0.0 4.9 0:13 0 mysqld
29171 nobody 15 0 7524 7524 2736 S 0.0 0.4 0:03 1 httpd
29172 nobody 18 0 7448 7448 2828 S 0.0 0.4 0:03 0 httpd
29173 nobody 15 0 7556 7556 2852 S 0.0 0.4 0:04 1 httpd
29174 nobody 15 0 7544 7544 2532 S 0.0 0.4 0:07 0 httpd
29175 nobody 15 0 7404 7404 2764 S 0.0 0.4 0:03 1 httpd
29178 nobody 15 0 7732 7732 2724 S 0.0 0.5 0:04 0 httpd
29181 nobody 15 0 7700 7700 2712 S 0.0 0.4 0:03 1 httpd
29182 nobody 15 0 7388 7388 2700 S 0.0 0.4 0:03 0 httpd
29183 nobody 15 0 8412 8412 2656 S 0.0 0.5 0:02 0 httpd
29184 nobody 15 0 7308 7308 2724 S 0.0 0.4 0:04 0 httpd
29185 nobody 15 0 7648 7648 2712 S 0.0 0.4 0:02 1 httpd
29186 nobody 15 0 7532 7532 2816 S 0.0 0.4 0:02 0 httpd
29187 nobody 15 0 7884 7884 2820 S 0.0 0.5 0:05 1 httpd
29188 nobody 15 0 8428 8428 2808 S 0.0 0.5 0:03 1 httpd
29189 nobody 15 0 7404 7404 2764 S 0.0 0.4 0:02 0 httpd
29190 nobody 16 0 7676 7676 2832 S 0.0 0.4 0:04 0 httpd
29191 nobody 15 0 7428 7428 2680 S 0.0 0.4 0:03 1 httpd
29192 nobody 15 0 8100 8100 2836 S 0.0 0.5 0:03 0 httpd
29193 nobody 15 0 7792 7792 2804 S 0.0 0.5 0:03 1 httpd
29194 nobody 15 0 7632 7632 2776 S 0.0 0.4 0:03 1 httpd
29195 nobody 15 0 7428 7428 2780 S 0.0 0.4 0:03 0 httpd
29196 nobody 15 0 7356 7356 2676 S 0.0 0.4 0:03 1 httpd
29197 nobody 15 0 7432 7432 2764 S 0.0 0.4 0:03 0 httpd
29198 nobody 15 0 7692 7692 2836 S 0.0 0.4 0:04 0 httpd
29199 nobody 15 0 7324 7324 2804 S 0.0 0.4 0:03 1 httpd
29200 nobody 15 0 7680 7680 2848 S 0.0 0.4 0:03 0 httpd
29201 nobody 15 0 7484 7484 2640 S 0.0 0.4 0:04 1 httpd
29202 nobody 15 0 7432 7432 2792 S 0.0 0.4 0:04 1 httpd
29203 nobody 15 0 7820 7820 2624 S 0.0 0.5 0:02 1 httpd
29204 nobody 15 0 7452 7452 2752 S 0.0 0.4 0:02 1 httpd
29205 nobody 15 0 7316 7316 2684 S 0.0 0.4 0:02 0 httpd
29206 nobody 15 0 7364 7364 2756 S 0.0 0.4 0:03 0 httpd
29207 nobody 15 0 7656 7656 2924 S 0.0 0.4 0:03 0 httpd
29208 nobody 15 0 7340 7340 2704 S 0.0 0.4 0:03 0 httpd
29209 nobody 15 0 7516 7516 2756 S 0.0 0.4 0:03 1 httpd
29210 nobody 15 0 7460 7460 2756 S 0.0 0.4 0:04 1 httpd
29253 nobody 15 0 8004 8004 2684 S 0.0 0.5 0:03 1 httpd
29254 nobody 15 0 7512 7512 2804 S 0.0 0.4 0:02 1 httpd
29255 nobody 15 0 7628 7628 2700 S 0.0 0.4 0:03 0 httpd
29256 nobody 15 0 7552 7552 2872 S 0.0 0.4 0:03 0 httpd
29257 nobody 15 0 7632 7632 2732 S 0.0 0.4 0:03 0 httpd
29258 nobody 15 0 7800 7800 2908 S 0.0 0.5 0:02 1 httpd
29489 nobody 15 0 7708 7708 2932 S 0.0 0.4 0:03 1 httpd
29491 nobody 15 0 8276 8276 3044 S 0.0 0.5 0:03 0 httpd
29492 nobody 15 0 7564 7564 3040 S 0.0 0.4 0:01 1 httpd
29493 nobody 15 0 7176 7176 3040 S 0.0 0.4 0:02 0 httpd
29494 nobody 15 0 8080 8080 3028 S 0.0 0.5 0:02 0 httpd
30897 nobody 15 0 7648 7648 2936 S 0.0 0.4 0:01 0 httpd
31335 nobody 15 0 6968 6968 2936 S 0.0 0.4 0:00 1 httpd
31524 nobody 15 0 7404 7404 2928 S 0.0 0.4 0:01 0 httpd
31525 nobody 15 0 7916 7916 3136 S 0.0 0.5 0:01 0 httpd
31526 nobody 15 0 7608 7608 2928 S 0.0 0.4 0:01 0 httpd
31527 nobody 15 0 6968 6968 2920 S 0.0 0.4 0:00 1 httpd
31528 nobody 15 0 7576 7576 2928 S 0.0 0.4 0:00 1 httpd
31529 nobody 15 0 7320 7320 2928 S 0.0 0.4 0:00 1 httpd
31610 nobody 23 8 1956 1696 1192 S N 0.0 0.1 0:00 0 proftpd
6. your mysql configuration variables located at /etc/my.cnf or c:\my.cnf so post the contents inside of my.cnf (minus any passwords of course).
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
skip-innodb
query_cache_limit=1M
query_cache_size=32M
query_cache_type=1
max_connections=500
interactive_timeout=100
wait_timeout=100
connect_timeout=10
thread_cache_size=128
key_buffer=16M
join_buffer=1M
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=2M
record_buffer=1M
sort_buffer_size=2M
read_buffer_size=2M
max_connect_errors=10
# Try number of CPU's*2 for thread_concurrency
thread_concurrency=2
myisam_sort_buffer_size=64M
#log-bin
server-id=1
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192
[mysqldump]
quick
max_allowed_packet=16M
[mysql]
no-auto-rehash
#safe-updates
[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
7. your mysql extended-status output which shows entire server's mysql activity status (preferably with a day or 2 worth of mysql uptime for better indication of real activity) either:
http://www.accringtonweb.com/stat.php
8. is your vB the only thing on the server? or other scripts & sites which utilise php and mysql?
There are 2 vb's a photopost and a few invision power boards.
9. how many average and max concurrent users on your vB forum ? and what your cookie timeout is ?
Average 30-50 Max 177 - 1500 Cookie
10. create a file named phpinfo.php and place this code in it and post the url/link to it from your web site
http://www.accringtonweb.com/forum/index.php?&do=phpinfo
11. 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 :
KeepAlive on
MaxKeepAliveRequests 100
KeepAliveTimeout 15
MinSpareServers 20
MaxSpareServers 45
StartServers 5
MaxClients 150
12. what version of vB are you running ?
3.0.3
Anyway, if anyone can spot anything out of the order in the following then advice would really be appreciated.
Thanks in advance!
1. is this on dedicated or shared virual server
Dedicated
2. your server specs. For example:
cpu speed/type single or dual cpus): Single P4 2.8 Hyper Threading
how much memory installed: 1.5gig
hard drive type/configuration: 80gb IDE and 40gig backup drive.
linux distributor or windows version: Red Hat Enterprise Linux ES release 3 (Taroon Update 2) 2.4.21-15.ELsmp (SMP) (with cpanel)
apache/IIS version: apache 1.3.31
PHP version: php 4.3.7
MySQL version: mysql 4.0.20-standard
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
unknown
5. your top stats
Http processes currently running = 58
Mysql processes currently running = 22
17:41:32 up 1 day, 3:10, 1 user, load average: 0.23, 0.20, 0.24
156 processes: 155 sleeping, 1 running, 0 zombie, 0 stopped
total 0.4% 0.0% 0.0% 0.0% 0.0% 0.0% 99.5%
cpu00 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 100.0%
cpu01 0.9% 0.0% 0.0% 0.0% 0.0% 0.0% 99.0%
Mem: 1544588k av, 1526512k used, 18076k free, 0k shrd, 68680k buff
1079896k actv, 132236k in_d, 22016k in_c
Swap: 2040244k av, 928k used, 2039316k free 866440k cached
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
31987 nobody 21 0 1224 1224 812 R 0.4 0.0 0:00 1 top
4185 nobody 23 8 788 360 244 S N 0.0 0.0 0:00 0 proftpd
7182 mysql 21 6 77008 75M 1264 S N 0.0 4.9 0:06 1 mysqld
7244 mysql 21 6 77008 75M 1264 S N 0.0 4.9 0:01 0 mysqld
7245 mysql 21 6 77008 75M 1264 S N 0.0 4.9 0:15 0 mysqld
7258 mysql 21 6 77008 75M 1264 S N 0.0 4.9 2:18 1 mysqld
7336 mysql 21 6 77008 75M 1264 S N 0.0 4.9 2:12 0 mysqld
7360 mysql 21 6 77008 75M 1264 S N 0.0 4.9 43:10 1 mysqld
7387 mysql 21 6 77008 75M 1264 S N 0.0 4.9 2:16 0 mysqld
7389 mysql 21 6 77008 75M 1264 S N 0.0 4.9 2:22 1 mysqld
7405 mysql 21 6 77008 75M 1264 S N 0.0 4.9 2:48 1 mysqld
7406 mysql 21 6 77008 75M 1264 S N 0.0 4.9 2:30 0 mysqld
7412 nobody 23 0 768 768 24 S 0.0 0.0 0:00 1 entropychat
7416 nobody 26 6 248 248 0 S N 0.0 0.0 0:00 0 melange
7522 nobody 26 6 516 516 92 S N 0.0 0.0 0:00 1 urchinwebd
7523 nobody 26 6 492 492 68 S N 0.0 0.0 0:00 1 urchinwebd
7524 nobody 26 6 492 492 68 S N 0.0 0.0 0:00 1 urchinwebd
7525 nobody 26 6 488 488 64 S N 0.0 0.0 0:00 1 urchinwebd
7526 nobody 26 6 476 476 52 S N 0.0 0.0 0:00 1 urchinwebd
7528 nobody 15 0 276 276 80 S 0.0 0.0 0:05 0 urchind
17797 mysql 21 6 77008 75M 1264 S N 0.0 4.9 2:05 1 mysqld
26658 mysql 21 6 77008 75M 1264 S N 0.0 4.9 269:52 0 mysqld
1852 mysql 21 6 77008 75M 1264 S N 0.0 4.9 0:39 0 mysqld
1853 mysql 21 6 77008 75M 1264 S N 0.0 4.9 0:53 0 mysqld
19286 mysql 21 6 77008 75M 1264 S N 0.0 4.9 0:07 1 mysqld
19287 mysql 21 6 77008 75M 1264 S N 0.0 4.9 0:07 0 mysqld
19288 mysql 21 6 77008 75M 1264 S N 0.0 4.9 0:06 0 mysqld
19289 mysql 21 6 77008 75M 1264 S N 0.0 4.9 0:08 1 mysqld
19355 mysql 21 6 77008 75M 1264 S N 0.0 4.9 0:13 0 mysqld
29171 nobody 15 0 7524 7524 2736 S 0.0 0.4 0:03 1 httpd
29172 nobody 18 0 7448 7448 2828 S 0.0 0.4 0:03 0 httpd
29173 nobody 15 0 7556 7556 2852 S 0.0 0.4 0:04 1 httpd
29174 nobody 15 0 7544 7544 2532 S 0.0 0.4 0:07 0 httpd
29175 nobody 15 0 7404 7404 2764 S 0.0 0.4 0:03 1 httpd
29178 nobody 15 0 7732 7732 2724 S 0.0 0.5 0:04 0 httpd
29181 nobody 15 0 7700 7700 2712 S 0.0 0.4 0:03 1 httpd
29182 nobody 15 0 7388 7388 2700 S 0.0 0.4 0:03 0 httpd
29183 nobody 15 0 8412 8412 2656 S 0.0 0.5 0:02 0 httpd
29184 nobody 15 0 7308 7308 2724 S 0.0 0.4 0:04 0 httpd
29185 nobody 15 0 7648 7648 2712 S 0.0 0.4 0:02 1 httpd
29186 nobody 15 0 7532 7532 2816 S 0.0 0.4 0:02 0 httpd
29187 nobody 15 0 7884 7884 2820 S 0.0 0.5 0:05 1 httpd
29188 nobody 15 0 8428 8428 2808 S 0.0 0.5 0:03 1 httpd
29189 nobody 15 0 7404 7404 2764 S 0.0 0.4 0:02 0 httpd
29190 nobody 16 0 7676 7676 2832 S 0.0 0.4 0:04 0 httpd
29191 nobody 15 0 7428 7428 2680 S 0.0 0.4 0:03 1 httpd
29192 nobody 15 0 8100 8100 2836 S 0.0 0.5 0:03 0 httpd
29193 nobody 15 0 7792 7792 2804 S 0.0 0.5 0:03 1 httpd
29194 nobody 15 0 7632 7632 2776 S 0.0 0.4 0:03 1 httpd
29195 nobody 15 0 7428 7428 2780 S 0.0 0.4 0:03 0 httpd
29196 nobody 15 0 7356 7356 2676 S 0.0 0.4 0:03 1 httpd
29197 nobody 15 0 7432 7432 2764 S 0.0 0.4 0:03 0 httpd
29198 nobody 15 0 7692 7692 2836 S 0.0 0.4 0:04 0 httpd
29199 nobody 15 0 7324 7324 2804 S 0.0 0.4 0:03 1 httpd
29200 nobody 15 0 7680 7680 2848 S 0.0 0.4 0:03 0 httpd
29201 nobody 15 0 7484 7484 2640 S 0.0 0.4 0:04 1 httpd
29202 nobody 15 0 7432 7432 2792 S 0.0 0.4 0:04 1 httpd
29203 nobody 15 0 7820 7820 2624 S 0.0 0.5 0:02 1 httpd
29204 nobody 15 0 7452 7452 2752 S 0.0 0.4 0:02 1 httpd
29205 nobody 15 0 7316 7316 2684 S 0.0 0.4 0:02 0 httpd
29206 nobody 15 0 7364 7364 2756 S 0.0 0.4 0:03 0 httpd
29207 nobody 15 0 7656 7656 2924 S 0.0 0.4 0:03 0 httpd
29208 nobody 15 0 7340 7340 2704 S 0.0 0.4 0:03 0 httpd
29209 nobody 15 0 7516 7516 2756 S 0.0 0.4 0:03 1 httpd
29210 nobody 15 0 7460 7460 2756 S 0.0 0.4 0:04 1 httpd
29253 nobody 15 0 8004 8004 2684 S 0.0 0.5 0:03 1 httpd
29254 nobody 15 0 7512 7512 2804 S 0.0 0.4 0:02 1 httpd
29255 nobody 15 0 7628 7628 2700 S 0.0 0.4 0:03 0 httpd
29256 nobody 15 0 7552 7552 2872 S 0.0 0.4 0:03 0 httpd
29257 nobody 15 0 7632 7632 2732 S 0.0 0.4 0:03 0 httpd
29258 nobody 15 0 7800 7800 2908 S 0.0 0.5 0:02 1 httpd
29489 nobody 15 0 7708 7708 2932 S 0.0 0.4 0:03 1 httpd
29491 nobody 15 0 8276 8276 3044 S 0.0 0.5 0:03 0 httpd
29492 nobody 15 0 7564 7564 3040 S 0.0 0.4 0:01 1 httpd
29493 nobody 15 0 7176 7176 3040 S 0.0 0.4 0:02 0 httpd
29494 nobody 15 0 8080 8080 3028 S 0.0 0.5 0:02 0 httpd
30897 nobody 15 0 7648 7648 2936 S 0.0 0.4 0:01 0 httpd
31335 nobody 15 0 6968 6968 2936 S 0.0 0.4 0:00 1 httpd
31524 nobody 15 0 7404 7404 2928 S 0.0 0.4 0:01 0 httpd
31525 nobody 15 0 7916 7916 3136 S 0.0 0.5 0:01 0 httpd
31526 nobody 15 0 7608 7608 2928 S 0.0 0.4 0:01 0 httpd
31527 nobody 15 0 6968 6968 2920 S 0.0 0.4 0:00 1 httpd
31528 nobody 15 0 7576 7576 2928 S 0.0 0.4 0:00 1 httpd
31529 nobody 15 0 7320 7320 2928 S 0.0 0.4 0:00 1 httpd
31610 nobody 23 8 1956 1696 1192 S N 0.0 0.1 0:00 0 proftpd
6. your mysql configuration variables located at /etc/my.cnf or c:\my.cnf so post the contents inside of my.cnf (minus any passwords of course).
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
skip-innodb
query_cache_limit=1M
query_cache_size=32M
query_cache_type=1
max_connections=500
interactive_timeout=100
wait_timeout=100
connect_timeout=10
thread_cache_size=128
key_buffer=16M
join_buffer=1M
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=2M
record_buffer=1M
sort_buffer_size=2M
read_buffer_size=2M
max_connect_errors=10
# Try number of CPU's*2 for thread_concurrency
thread_concurrency=2
myisam_sort_buffer_size=64M
#log-bin
server-id=1
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192
[mysqldump]
quick
max_allowed_packet=16M
[mysql]
no-auto-rehash
#safe-updates
[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
7. your mysql extended-status output which shows entire server's mysql activity status (preferably with a day or 2 worth of mysql uptime for better indication of real activity) either:
http://www.accringtonweb.com/stat.php
8. is your vB the only thing on the server? or other scripts & sites which utilise php and mysql?
There are 2 vb's a photopost and a few invision power boards.
9. how many average and max concurrent users on your vB forum ? and what your cookie timeout is ?
Average 30-50 Max 177 - 1500 Cookie
10. create a file named phpinfo.php and place this code in it and post the url/link to it from your web site
http://www.accringtonweb.com/forum/index.php?&do=phpinfo
11. 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 :
KeepAlive on
MaxKeepAliveRequests 100
KeepAliveTimeout 15
MinSpareServers 20
MaxSpareServers 45
StartServers 5
MaxClients 150
12. what version of vB are you running ?
3.0.3