Site is slow after upgrading from 3.0.14 to 3.6.0

[mIRCnet]

I have upgraded my board from 3.0.14 to 3.6.0, and after that my board becomes funny..
I can access the ForumHome and ForumDisplay in a good speed , but reading the posts takes a long long time to open the page.

All the informations are in the attached file

[eva2000]

Okay try the following

1. Downgrade PHP to 4.4.3
2. Edit /etc/my.cnf and place the following mysql server settings in /etc/my.cnf and restart mysql server afterwards


[mysqld]
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

[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

[mysqlhotcopy]
interactive-timeout


3. 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

4. Edit httpd.conf values from

KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 8
MinSpareServers 10
MaxSpareServers 15
StartServers 10
MaxClients 300
Maxrequestsperchild 0

to

KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 5
MinSpareServers 10
MaxSpareServers 15
StartServers 10
MaxClients 150
Maxrequestsperchild 500

restart apache

[mIRCnet]

Thanks George,
Notice that I have APC installed in my server,
so if you would tell me how to uninstall it, and how to remove the Zend from my server because i think there is a conflect.
More over I am allready using VB 3.6.0 and I dont think i can downgrade to 3.5.x without losing data

[eva2000]

nope Zend Optimizer isn't installed according to your phpinfo so that is fine..

no need to downgrade from 3.6.0 to 3.5.x.. but if you followed my upgrade guide at http://www.vbulletin.com/forum/showthread.php?t=187770 you would have a backup or the live 3.5.x database intact which you can revert to easily

But yes there is not downgrading script for 3.6.0 to 3.5.x AFAIK

[mIRCnet]

REgarding the upgrade steps , I did it almost exactly the same , I did backup the database and I do have a copy of it in my server and another one in my PC,
Now how to remove the old APC cash? or should i just go on with the confegurations changes right away ignoring this step?

[eva2000]

for APC questions best to ask in the APC cache thread.

[mIRCnet]

Eva,
Forum home and forumdisplay are fast enough, the probleme existes in showthread only.

I have deabled Admin CP -> vBulletin Options -> Message Searching Options -> Automatic Similar Thread search

Any adea?

[eva2000]

how large are the threads in terms of posts ? how many posts per thread page have you set as forum default ? and the are they're alot of attachments ? sig images from vB forum database ? etc

any hacks ?

[mIRCnet]

The threads are as pefore upgrading
20 post @ page
5 attachments @ post, DB not Filesystem (Due to ability of uploading and running codes) (Table size: about 3GB + now)
Signatures are allowed, but I dont show it for me.
No hacks at all , just pure vB

[eva2000]

yeah attachments in db will SLOOOOOOOOOW things down and increase cpu loads

1. move attachments to filesystem and keep PHP up to date PHP 4.4.4 latest

2. increase posts per page value if you have alot of page spanning right now.. i.e. 50 posts per thread page etc

[mIRCnet]

ok Eva , regarding the attachments , i will move it to filesystem ..
But is there is a way to disable codes to be called there ? like uploading a flile named file.php.jpg and calling it so it will run as shell which is very danger as u know .. or if you would give me a file to just protect the attachments directory.

Regarding the post per page , i will increase it after fixing the attachments probleme.

Thanks

[Zachery]

All files are stored as


attachmentid.attach inside of a path you specific then

/yourpath/u/s/e/r/i/d/

So the end result is something like this

/home/vbulletin.com/attachments/1/2/3/4/5/6/7/8/2/5.attach

[eva2000]

yeah i think as long as PHP is up to date you can't execute code as such