Mar
Fri
19
2. Server specs.:
CPU: Intel Core 2 Duo 2.66 GHz processor.
Memory: 2 GB
H.D.: Single 120 GB (No Raid)
O.S.: Linux Red Hat Fedora Core 4
Apache version: 2.0.54
PHP version: 5.0.4
MySQL version: 4.1.20
3. vBulletin version: 3.6.5
4. There are no innodb type databases/tables on server.
5. MySql was compiled/installed by the hosting company: GoDaddy.com (http://help.godaddy.com/article.php?article_id=124)
6. Top Stats:22563
7. MySql Configuration Variables: 22564
8. MySQL Stats & MySql Report: 22565 22566
9. vBulletin is the only thing on my server, and no other site & scripts utilizing php and mysql except vBSEO for this time.
10.My forum:
Average users: 20 to 100 users.
Max concurrent users: 1170 users.
Cookie timeout: 3600 seconds.
11.Temporary Link to php info file: phpinfo (http://shinqit.net/evaphpinfo.php)
12.Asked values from Apache configuration file:
KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 15
StartServers 8
MinSpareServers 5
MaxSpareServers 20
ServerLimit 256
MaxClients 256
MaxRequestsPerChild 4000
StartServers 2
MaxClients 150
MinSpareThreads 25
MaxSpareThreads 75
ThreadsPerChild 25
MaxRequestsPerChild 0
13. There are no files hitting 2GB or 4GB max file size limits: 22567
14. Output from the three commands "uname", "ulimit" and "cpuinfo": 22568
1. Upgrade MySQL server to 4.1.22
2. Downgrade to PHP 4.4.6 after upgrading MySQL and upgrade Apache to 2.0.59
3. Edit /etc/my.cnf and place the following mysql server settings in /etc/my.cnf and restart mysql server afterwards
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
safe-show-database
old_passwords
back_log = 75
skip-innodb
max_connections = 500
key_buffer = 256M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1800
thread_cache_size = 384
wait_timeout = 30
connect_timeout = 10
tmp_table_size = 64M
max_heap_table_size = 64M
max_allowed_packet = 64M
max_connect_errors = 10
thread_concurrency = 4
read_rnd_buffer_size = 524288
bulk_insert_buffer_size = 8M
query_cache_limit = 3M
query_cache_size = 48M
query_cache_type = 1
query_prealloc_size = 131072
query_alloc_block_size = 65536
default-storage-engine = MyISAM
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
nice = -5
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
[mysqlhotcopy]
interactive-timeout
4. Install APC Cache lastest version from http://pecl.php.net/package/APC. Read install guide at http://www.vbulletin.com/forum/showthread.php?t=165367 - please remove Zend Optimizer from php.ini before installing APC Cache. OR try the alternative PHP caching software, Xcache which seems to be a bit faster than APC Cache - http://www.vbulletin.com/forum/showthread.php?t=213267
5. If you just upgraded to vB 3.5.x/3.6.x try to disable these 4 options:
Admin CP -> vBulletin Options -> Forums Home Page Options -> Display Logged in Users?
Admin CP -> vBulletin Options -> Forum Display Options (forumdisplay) -> Show Users Browsing Forums
Admin CP -> vBulletin Options -> Thread Display Options -> Show Users Browsing Thread
Admin CP -> vBulletin Options -> Message Searching Options -> Automatic Similar Thread search
7. Edit httpd.conf values from
KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 15
StartServers 8
MinSpareServers 5
MaxSpareServers 20
ServerLimit 256
MaxClients 256
MaxRequestsPerChild 4000
to
KeepAlive On
MaxKeepAliveRequests 150
KeepAliveTimeout 5
StartServers 15
MinSpareServers 15
MaxSpareServers 20
ServerLimit 256
MaxClients 200
MaxRequestsPerChild 2000
restart apache
try xcache compiled from source rather than rpm.
In regards to mySql & php; I would rather wait for newer vBulletin and php optimizer software, as I don't really need to alter server software installed with FC4 except through "yum update" command, since the forum now looks faster than before ..
Installed Xcache and then had to remove it because browsing got stuck! even that I followed all steps mentioned by Jason with the provided src.rpm, I would give it a try later by asking his help.
Any other clue or advice is appreciated.
#If you have any other info about this subject , Please add it free.# |
- edit
