Optimization Request

[sross]

I have answered all questions. This was done off peak hours, not sure if that matters. I have attached all info as a text file I hope that is not a hassle. Thanks for any info!

[eva2000]

In order to get support and post on vB support forums you must have a valid vBulletin license. Once you purchase one you will receive your customer details in an email. With those customer details you can login to the Members' Area and click on the 'Priority Support (http://www.vbulletin.com/members/membersupport_priority.php)' link in the left menu. On the page that loads you must enter the email address you registered with on this support forum. When done correctly you will show up as a licensed members and you will receive priority support.

If you do have a valid vBulletin license, I kindly request you to update (http://www.vbulletin.com/members/membersupport_priority.php) your information.

[sross]

In order to get support and post on vB support forums you must have a valid vBulletin license. Once you purchase one you will receive your customer details in an email. With those customer details you can login to the Members' Area and click on the 'Priority Support (http://www.vbulletin.com/members/membersupport_priority.php)' link in the left menu. On the page that loads you must enter the email address you registered with on this support forum. When done correctly you will show up as a licensed members and you will receive priority support.

If you do have a valid vBulletin license, I kindly request you to update (http://www.vbulletin.com/members/membersupport_priority.php) your information.
Sorry, i updated my email. should be ok now I have 2 licenses :)

[sross]

Also, I am upgrading to 3.6 in the next few days. Maybe I should wait for you to do your thing once I'm on 3.6?

Thanks!

[eva2000]

Do the vB 3.6 upgrade after the changes below so you can have a direct comparison with what you're currently running

1. Upgrade MySQL server to 4.1.21 http://www.vbulletin.com/forum/showthread.php?t=193353
2. Upgrade PHP to 4.4.3 or recompile 4.4.3 after updating MySQL
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 = 32M
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 = 90
connect_timeout = 10
tmp_table_size = 64M
max_heap_table_size = 64M
max_allowed_packet = 64M
max_connect_errors = 10
read_rnd_buffer_size = 524288
bulk_insert_buffer_size = 8M
query_cache_limit = 3M
query_cache_size = 80M
query_cache_type = 1
query_prealloc_size = 163840
query_alloc_block_size = 32768
default-storage-engine = MyISAM

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
nice = -5
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

[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

5. Edit httpd.conf values from

KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 15
MinSpareServers 5
MaxSpareServers 20
StartServers 8
MaxClients 256

AND Maxrequestsperchild value = 4000

to

KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 5
MinSpareServers 5
MaxSpareServers 15
StartServers 10
MaxClients 180

AND Maxrequestsperchild value = 500

restart apache

[sross]

Thank you very much George! I'll post an update after all is done.

[sross]

Hi George, I implemented your tuning and WOW my site is like greased lightning now! One problem though my plesk is broken:

ERROR: Unable to query: Can't find file: 'misc.MYI' (errno: 2) 0: /usr/local/psa/admin/plib/common_func.php3:203 psaerror(string "Unable to query: Can't find file: 'misc.MYI' (errno: 2)") 1: /usr/local/psa/admin/plib/common_func.php3:390 db_query(string "select param, val from misc") 2: /usr/local/psa/admin/plib/class.Session.php:113 get_param(string "login_timeout") 3: /usr/local/psa/admin/auto_prepend/auth.php3:139 Session->Session()

I've let my tech know (who put in the changes) but thought maybe you have seen this before. Do you think apc cache has broken my plesk?

Thanks

[sross]

here is what my tech said:

> do you think that apc has broken my plesk?


No. Plesk runs under its own installation of Apache that runs Plesk and only
Plesk. It has its own version of PHP and does not use the PHP code that has
APC enabled for it.


> ERROR: Unable to query: Can't find file: 'misc.MYI' (errno: 2) 0:


Yeah I see that. The reason for that is that almost all of the tables in the
PSA database that runs Plesk dropped off the face of the earth - simply
vanished. One of them was the index file for the misc table (misc.MYI) -
totally gone. But that wasn't the only one - the Bandwidth.MYD file was also
totally gone.

I was able to restore the PSA database from last night's backup; hopefully
nothing in Plesk was changed since then - if it was then those changes
should be done again.

I hope that the PSA database is the only one corrupted because at least
there was a backup for it - for the others there is no backup and the
database would just be gone. I have no real explanation for why MySql
dropped tables - only a hunch that some of the settings that vBulletin.com came
up with for the my.cnf file (which is the configuration file for MySql) are
not right - or at least don't work well on your server - and resulted in
lost data. For now I have restored the original settings for MySql because
unless and until we have some sort of backup I don't think we can afford to
try this again and lose your forum database.

[eva2000]

plesk needs innodb.. in /etc/my.cnf i recommended, remove this entry skip-innodb and restart mysql

you don't need to mess with databases like that!!!