Large Vb Site Optimization Request
Filed Under zjbr.com |
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
backup original and change /etc/my.cnf to below and restart mysql
[mysqld]
max_connections = 500
key_buffer = 16M
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 = 1800
connect_timeout = 10
max_allowed_packet = 16M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1
skip-innodb
[mysqld_safe]
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
Max_used_connections 100 Max. connections reached
I changed my my.cnf, but I am STILL getting connect failed emails.
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
max_connections = 500
key_buffer = 16M
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 = 1800
connect_timeout = 10
max_allowed_packet = 16M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1
skip-innodb
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
#If you have any other info about this subject , Please add it free.# |