View Single Post
  #15  
Old 13 Mar 2008, 13:29
Princeton's Avatar
Princeton Princeton is offline
 
Join Date: Nov 2001
Real name: Joe Velez
In addition to the server suggestions at vbulletin.com.

Upgrade MySQL.

Make sure you have the latest Apache 2 - we also had problems with a particular version. (Don't remember which one.)


Check the # of queries running on your site (per page) ...

Check each custom query and make sure
1)__ they are optimized
2)__ are using index whenever possible
3)__ ensure that SELECTs are retrieving from the SLAVE server and not the MASTER (check processlist)

NOTES
- only use necessary plugins - those that add value to your site
--- I recommend removing the arcade.
- vbseo has all their queries fetching from MASTER.
- vbadvanced - I'm sure there's some queries that are going to MASTER when they should be going to SLAVE.
__________________
Former vBulletin.org Staff Member

Latest Articles:
Liquid Layout = Less Ad Revenue?
How to Monetize Your Site
Improve Web Page Performance
How To Write For The Web


If it needs instructions, there's room for improvement.
Give users what they actually want, not what they say they want. And whatever you do, don't give them new features just because your competitors have them!
Reply With Quote