The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
Optimize tips & tricks Details »»
|
|||||||||||||||||||||||||
Hello,
Anyone have big boards tips & tricks for vbulletin big board (ajo.pl) ?? Before post this theard, i search in this forum without results. Show Your Support
|
|||||||||||||||||||||||||
About Developer
No support by the author.| Comments |
|
#2
01-09-2007, 03:17 AM
|
||||
|
||||
Quote:
First... If you haven't already, posting a thread in the server optimization forum at vbulletin.com is a good idea. Some fine tuning of the mysql and apache parameters can help a little. And a lot more if you have never given mysql some tuning. A good server helps... it's often not enough. I found that with an IDE/SATA drive the hard disk was constantly a bottleneck. A fast disk helps, a lot. But if you need to decide between adding more RAM and a fast disk, I'll always go with more RAM. Anything less than 2Gb of RAM is not enough for running a large forum. Apache seems to come short for larger server loads. I recently tried litespeed, and other lite web server solutions. They helped. They can reduce the load of the server a 30 o 40%, that's really nice. Apache is a good server, but somehow litespeed runs faster specially when processing a lot of php. Do not run php without a cache or accelerator, eaccelerator, mturck cache, x-cache... you can do some homework and check which one is better, or which one you like most. They do the work of compiling php. The cache alone reduced the load of my server by 50%. I use eaccelerator. Install an image server... I serve dynamic content with one web server, and the images with another web server. Of course you need two servers or at least two IP addresses for doing this. By doing this you can turn keepalive off on your main server (that servers dynamic content), and have a server dedicated to static content that can also be cached for a long time (like images). If you can afford it, separate the database from the web/content server. Have apache/litespeed run in one server, this server needs a lot of processing power. Have another server run the mysql database. This server needs a lot of RAM and a fast disk. You can even load-balance the sites this way. I do archive posts. I only keep 3 months or less. That's like 600,000 posts. I had to do that when I had millions of posts that were never read, and were keeping mysql busy especially with searches. I keep two forums, one for the main, updated, recently read content, and another forum with the archived content. I use a custom-solution for my archiving needs. And I use two vbulletin licenses for this strategy. If you are fan of hacks and mods, keep in mind performance. Never, ever, install a hack that adds a query to every page. Any hack that queries or modifies the post table should be a warning, it must be well written or it will make your forums very slow. Hacks for showthread are often more intensive that hacks for say, newthread. Make an habit of keeping an eye on your server load and memory usage. Memorize those numbers, or at least be familiar with them, with the "usual" load of the server. After installing a hack, keep an eye on the load, if something strange happens, most likely it's because of the hack you just installed. The tiniest hack, that only adds a couple plugins can have a negative effect on performance if, for example, makes some bad regexps. Sometimes a hack can run beautifully with 10 users online, and take the forum down with 100 users. Because of that, never install more than one modification at once, check your server, install the mod, monitor your server(s). If anything weird comes up, be ready to disable the mod.... check your server again. A test environment helps, but you'll need to test it with a heavy load sometime. Installing several hacks in a unattended way is dangerous. Of course, this is only my experience, and some "quick tips" that I can give. Results may vary from person to person, and from forum to forum as each forum and each environment is unique  Feel free to share your comments.
|
|
#4
01-11-2007, 11:42 AM
|
||||
|
||||
|
I have a forum (Spanish BMW owners), with more that 2 million of posts and 30.000 members.
My setup for this is a Dual dual xeon 2.8, 2 gb of ram and ultra scsi disks with Fedora core 4. I use php 4.4 compile by hand and eAccelerator (php cache), mysql 4.0.21 compiled with the intel c++ compiler (20% faster that with gcc), and many tweakings in tcp/ip stack, apache and php. I can handle 1000 constants users within a load more higher off 1.4 If you need more that this, put a lighthttpd as image server, one server for database or memcached and another server for apache Excuse my broken English
|
|
#5
01-12-2007, 01:40 PM
|
|||
|
|||
|
Hola Kentaurus!! La sigo en ingles para que nos entiendan todos
 I'm the owner of www.psicofxp.com a spanish forum with 200.000 users, 2.4 MM posts, 2800 users online on peak hours and 100.000+ visits per day (unique ips). I have 2 DB servers (1 Master and 1 Slave) and 4 Webservers in a load balance solution provided by the hosting, the load balance solution is caching the static content so I don?t need to implement an image server. The slave DB server had 2 more roles: memcached and nfs server (all the php files resides in this server). I?m very interested in your custom solution to archive old posts, can you explain me how you did that? Or at least help me somehow? Tnx in advance! Ismael Briasco
|
|
#6
01-12-2007, 10:44 PM
|
||||
|
||||
|
Quote:
With this, I can run two different mysql servers, one for the archive and one for the main forum, in different servers. And I can load balance with a little more flexibility. I can implement rules for deactivating the archive without deactivating the main forums... I just can manage them separately. Also, the mysql load went down by a lot, leaving 4M posts in a single mysql table makes joins a little painful. it was faster to just leave the 200-300,000 posts that people want to read and check everyday, and the rest is in an archive, still accesible, but you cannot longer reply, and if the archive loads 5 times slower... it doesn't matter to me because that's not the active users.
|
|
#7
01-14-2007, 10:15 AM
|
|||
|
|||
|
Yes, actually i use :
Dual xeon 2.6, 2 GB ram lighttpd with php 4.4.4 (xcache) and load above 50  - 900 onlineQuote:
|
|
#8
01-23-2007, 01:01 AM
|
|||
|
|||
|
thank you very much, it is very useful for me!
|
|
#9
01-23-2007, 01:30 PM
|
|||
|
|||
|
Quote:
|
|
#10
01-24-2007, 10:40 PM
|
||||
|
||||
|
Quote:
|
 |
«
Previous Thread
|
Next Thread
»
| Thread Tools | |
|
|
All times are GMT. The time now is 10:30 AM.