Announcement

Collapse
No announcement yet.

Some questions about vBulletin handling large amounts of visitors.

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts
    chrispadfield
    Senior Member

  • chrispadfield
    replied
    Re: Some questions about vBulletin handling large amounts of visitors.

    Originally posted by agentd
    post is finished until they can continue using the forum.
    Even worse, vBB also has write accesses to the post table during display of the threads (namely for the updating of the view counts), so any thread views can only happen sequentially. And this is what usually breaks large forums."

    Thanks
    This has been solved, this information is stored seperatly (and updated on mass via a new inbuilt cron system) drastically reducing the problem mentioned here

    Leave a comment:

  • George L
    Former vBulletin Support

  • George L
    replied
    Yes there are plenty of large vB forums listed at http://www.vbulletin.com/forum/showt...threadid=47430 who get 600 - 1,500 users and up to 14,000 - 20,000 posts/day (granted you'd need 2 server setups when you get to that kind of activity)

    the vB table locking issue is with mainly thread views updating and the searchindex, both of which in vB 3.x have been redone to drastically ease this issue.

    Most (and not all) vB forums which claim to have performance issues with vB in fact have unoptimised mysql configuration settings causing the unwanted loads or place vB on under performing server hardware (like expecting WinXP OS to run the same on a P166MMX with 32MB ram as it does on a P4 1.6A, 256MB DDRAM or even a P3 1ghz, 256MB)

    I'm basically the mysql tweaking guy, and I've probably handled 100s of support issues where the client's vB was causing high loads, and 85-95% of time it was due to poorly or inadequately configured mysql configuration settings or that mysql was left at default mysql settings which were originally meant for light mysql use.

    there's plenty of ways to optimise mysql

    http://mysql.he.net/doc/M/y/MySQL_Optimisation.html

    http://mysql.he.net/doc/O/p/Optimising_the_Server.html

    http://i4net.tv/marticle/get.php?act...le&articleid=3

    Now the other 5% of issues, can usually be attributed to other server side application bugs (i.e. PHP 4.2.1's memory leak/handling bug, some linux 2.4 earlier kernels with memory management problems, mysql 3.23.x earlier versions with memory leaks and other bugs, apache bugs), unoptimised settings and yes mysql table locking issues for vB forums with very high concurrent mysql connections.

    to find out if it's a table locking issue you'd have to look at the mysql processlist via shell as root user - the table locking mainly occurs on updating thread views and searches

    for vB 2.2.x users who experience this they can apply 2 hacks from vbulletin.org, deferred threadviews and auto shutdown search based on specific load average

    in vB 3.x you'll have admin options available to defer thread view updates to be scheduled to be updated at a later time easing the issues

    Note: I'm not a vB developer only a moderator/tech guy

    Leave a comment:

  • Techguy1
    Senior Member

  • Techguy1
    replied
    Well, take a look at features sites on the vbulletin.com homepage, those usually have more than 500 online users at once, and have no problems. And vbulletin, from my experience is not CPU intensive.
    I recently switched from 'another' forum software and I am very happy with vb

    Leave a comment:

  • agentd
    New Member

  • agentd
    replied
    Originally posted by HFT :: Techguy
    Many busy sites switched to vbulletin... Why? Perhaps because it handles traffic well?
    I know a forum that has 300 people on it at once usually, and vBulletin handles it very poorly. He had to take out all kinds of features and hire someone to optimize his code.

    From what I gather, vBulletin is awesome and bandwidth handling, but when it comes to CPU cycles, it eats them up. It's flexible, but the downside of that is that it strains MySQL.

    Can any techie comment on this?

    Leave a comment:

  • Techguy1
    Senior Member

  • Techguy1
    replied
    Many busy sites switched to vbulletin... Why? Perhaps because it handles traffic well?

    Leave a comment:

  • agentd
    New Member

  • Some questions about vBulletin handling large amounts of visitors.

    Hi guys,

    I have heard from people on another forum that vBulletin cannot handle large amounts of visitors because of the strain it is on MySQL. Can you offer some counter arguments for these?

    Please note that most of these people usually know their stuff, but I'm not saying they're right.

    "The problem with MySQL is that it only supports table level locking. This means that while a write operation is happening on a table, the whole table is blocked for any other access to avoid corruption. So, any time a user posts, all other people have to wait until that post is finished until they can continue using the forum.
    Even worse, vBB also has write accesses to the post table during display of the threads (namely for the updating of the view counts), so any thread views can only happen sequentially. And this is what usually breaks large forums."

    "MySQL is also only fast when the concurrent connections are low. Get a high traffic site and it all starts to fall apart, and just about anything will out-perform it then. "

    "If you want to improve vBulletin for heavy load environments, you have to get rid of the often called UPDATE and INSERTS. "

    Thanks
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X