version2
Thu 29th Jul '04, 12:26pm
I am getting quite a few erratic false connect errors and I cant figure out what is causing it. So, I wanted to make sure my server is optimized.
1. is this on dedicated or shared virual server
Dedicated.
2. your server specs. For example:
cpu speed/type single or dual cpus): P4 2.4 Ghz single
how much memory installed: 1 gig ram
hard drive type/configuration: 2 x 80GB EIDE non raid
linux distributor or windows version: redhat linux enterprise
apache/IIS version: apache 2.0.50
PHP version: php 4.3.8
MySQL version: mysql 4.0.20
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
Using RPM's from mysql.com.
5. your top stats
10:25:52 up 76 days, 21:48, 1 user, load average: 0.84, 1.05, 0.83
88 processes: 86 sleeping, 2 running, 0 zombie, 0 stopped
CPU states: cpu user nice system irq softirq iowait idle
total 31.3% 0.0% 6.7% 0.0% 0.0% 0.1% 61.6%
Mem: 1028484k av, 1008616k used, 19868k free, 0k shrd, 29404k buff
777776k actv, 6888k in_d, 14640k in_c
Swap: 2048276k av, 169364k used, 1878912k free 717748k cached
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). If on Windows server if you don't have that file you need to log into telnet and as root user type
I cant get these to show up in the post correctly. So I will just give you a link to a text file that displays this info:
http://angrygeeks.org/mysqlvars.txt
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://angrygeeks.org/myextstat.php
8. is your vB the only thing on the server? or other scripts & sites which utilise php and mysql?
Vb only.
9. how many average and max concurrent users on your vB forum ? and what your cookie timeout is ?
Avg: 350 users
Max: 567
Timeout: 3600
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.angrygeeks.org/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 20
StartServers 8
MaxClients 256
12. what version of vB are you running ?
3.0.3
1. is this on dedicated or shared virual server
Dedicated.
2. your server specs. For example:
cpu speed/type single or dual cpus): P4 2.4 Ghz single
how much memory installed: 1 gig ram
hard drive type/configuration: 2 x 80GB EIDE non raid
linux distributor or windows version: redhat linux enterprise
apache/IIS version: apache 2.0.50
PHP version: php 4.3.8
MySQL version: mysql 4.0.20
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
Using RPM's from mysql.com.
5. your top stats
10:25:52 up 76 days, 21:48, 1 user, load average: 0.84, 1.05, 0.83
88 processes: 86 sleeping, 2 running, 0 zombie, 0 stopped
CPU states: cpu user nice system irq softirq iowait idle
total 31.3% 0.0% 6.7% 0.0% 0.0% 0.1% 61.6%
Mem: 1028484k av, 1008616k used, 19868k free, 0k shrd, 29404k buff
777776k actv, 6888k in_d, 14640k in_c
Swap: 2048276k av, 169364k used, 1878912k free 717748k cached
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). If on Windows server if you don't have that file you need to log into telnet and as root user type
I cant get these to show up in the post correctly. So I will just give you a link to a text file that displays this info:
http://angrygeeks.org/mysqlvars.txt
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://angrygeeks.org/myextstat.php
8. is your vB the only thing on the server? or other scripts & sites which utilise php and mysql?
Vb only.
9. how many average and max concurrent users on your vB forum ? and what your cookie timeout is ?
Avg: 350 users
Max: 567
Timeout: 3600
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.angrygeeks.org/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 20
StartServers 8
MaxClients 256
12. what version of vB are you running ?
3.0.3