Jan Klerks
Wed 5th Jan '05, 2:03pm
I added the relevant info here for at times the server can go slow. Then again, at other times it's just fast with the same number of people on the list. Any tips are welcome. But what I really like to know is what my next step would be in case the project keeps on growing. Should I go for adding ram, or is it best to go load balancing on multiple servers? In case of the last option, what sort of systems should I ask for. Thanks,
1. is this on dedicated or shared virual server
Dedicated
2. your server specs For example:
cpu speed/type single or dual cpus): Intel(R) Xeon(TM) CPU 2.66GHz
how much memory installed: real memory = 2147418112 (2097088K bytes)
hard drive type/configuration: ad2: 39205MB [79656/16/63] at ata1-master UDMA100
Operating system FreeBSD
Apache version 1.3.31 (Unix)
PHP version 4.3.8
MySQL version 4.0.15
3. if you use mysql 4.x instead of mysql 3.23.x, do you have any innodb type databases/tables on your server ?
Not that I am aware off
4. if possible how mysql was compiled/installed
cPanel
5. your top stats
last pid: 31616; load averages: 2.54, 2.87, 2.92 up 26+09:00:09 10:01:08
227 processes: 4 running, 223 sleeping
CPU states: 61.9% user, 0.0% nice, 35.8% system, 0.4% interrupt, 1.9% idle
Mem: 322M Active, 940M Inact, 472M Wired, 55M Cache, 199M Buf, 220M Free
Swap: 1000M Total, 40M Used, 960M Free, 3% Inuse
6. your mysql configuration variables located at /etc/my.cnf
[mysqld]
safe-show-database
skip-innodb
socket=/tmp/mysql.sock
pid-file=/var/db/mysql/mysql.pid
max_connections = 650
key_buffer = 32M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1024
thread_cache_size = 64
wait_timeout = 3600
connect_timeout = 10
max_allowed_packet = 16M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1
[mysqld_safe]
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
7. your mysql extended-status output which shows entire server's mysql activity status
Click here (http://www.skyscrapercity.com/extended_status.php)
8. is your vB the only thing on the server? or other scripts & sites which utilise php and mysql?
There is a closed PhotoPost on it and some 3,000 images used in a database of buildings, running on some other server though
9. how many average and max concurrent users on your vB forum ? and what your cookie timeout is ?
As set for 15 minutes: busy: around 700+, slow: 350 users and visitors online
10. create a file named phpinfo.php and place this code in it and post the url/link to it from your web site
Click here (http://www.skyscrapercity.com/phpinfo.php)
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: 5
MaxSpareServers: 10
StartServers: 5
MaxClients: 200
12. what version of vB are you running ?
3.0.0
1. is this on dedicated or shared virual server
Dedicated
2. your server specs For example:
cpu speed/type single or dual cpus): Intel(R) Xeon(TM) CPU 2.66GHz
how much memory installed: real memory = 2147418112 (2097088K bytes)
hard drive type/configuration: ad2: 39205MB [79656/16/63] at ata1-master UDMA100
Operating system FreeBSD
Apache version 1.3.31 (Unix)
PHP version 4.3.8
MySQL version 4.0.15
3. if you use mysql 4.x instead of mysql 3.23.x, do you have any innodb type databases/tables on your server ?
Not that I am aware off
4. if possible how mysql was compiled/installed
cPanel
5. your top stats
last pid: 31616; load averages: 2.54, 2.87, 2.92 up 26+09:00:09 10:01:08
227 processes: 4 running, 223 sleeping
CPU states: 61.9% user, 0.0% nice, 35.8% system, 0.4% interrupt, 1.9% idle
Mem: 322M Active, 940M Inact, 472M Wired, 55M Cache, 199M Buf, 220M Free
Swap: 1000M Total, 40M Used, 960M Free, 3% Inuse
6. your mysql configuration variables located at /etc/my.cnf
[mysqld]
safe-show-database
skip-innodb
socket=/tmp/mysql.sock
pid-file=/var/db/mysql/mysql.pid
max_connections = 650
key_buffer = 32M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1024
thread_cache_size = 64
wait_timeout = 3600
connect_timeout = 10
max_allowed_packet = 16M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1
[mysqld_safe]
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
7. your mysql extended-status output which shows entire server's mysql activity status
Click here (http://www.skyscrapercity.com/extended_status.php)
8. is your vB the only thing on the server? or other scripts & sites which utilise php and mysql?
There is a closed PhotoPost on it and some 3,000 images used in a database of buildings, running on some other server though
9. how many average and max concurrent users on your vB forum ? and what your cookie timeout is ?
As set for 15 minutes: busy: around 700+, slow: 350 users and visitors online
10. create a file named phpinfo.php and place this code in it and post the url/link to it from your web site
Click here (http://www.skyscrapercity.com/phpinfo.php)
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: 5
MaxSpareServers: 10
StartServers: 5
MaxClients: 200
12. what version of vB are you running ?
3.0.0