• Register
    • Help

    striker  0 Items
    Currently Supporting
    • Home
    • News
    • Forum
      • Try XenForo Demo
      • New Posts
      • FAQ
      • Calendar
      • Community
        • Groups
        • Albums
        • Member List
      • Forum Actions
        • Mark Forums Read
      • Quick Links
        • Today's Posts
        • Who's Online
      • Sponsor
        • Sponsor a Feature
        • List of Donors
    • Wiki
    • Support
    • What's New?
    • Buy Now
    • Manual
    • 
    • Forum
    • vBCms Comments
    • Article: VaultWiki 3.0.3

    1. Welcome to VaultWiki.org, home of the wiki add-on for vBulletin and XenForo!

      VaultWiki allows your existing forum users to collaborate on creating and managing a site's content pages. VaultWiki is a fully-featured and fully-supported wiki solution for vBulletin and XenForo.

      The VaultWiki Team encourages you to join our community of forum administrators and check out VaultWiki for yourself.

    Results 1 to 3 of 3

    Thread: Article: VaultWiki 3.0.3

    • Thread Tools
      • Show Printable Version
    1. August 17, 2010 #1
      pegasus
      • View Profile
      • View Forum Posts
      • View Blog Entries
      • Visit Homepage
      • View Articles
      pegasus is offline
      VaultWiki Team
      Join Date
      March 28, 2004
      Location
      New York, NY
      Posts
      2,934
      Blog Entries
      18
      Rep Power
      659

      Article: VaultWiki 3.0.3

      You can view the page at http://www.vaultwiki.org/content.php...aultWiki-3.0.3
      - lead developer for VaultWiki
      Reply With Quote Reply With Quote

    2. August 17, 2010 #2
      Moses
      • View Profile
      • View Forum Posts
      • View Blog Entries
      • Visit Homepage
      • View Articles
      Moses is offline
      Junior Member
      Join Date
      November 19, 2009
      Posts
      46
      Rep Power
      177
      Thanks for this update pegasus,
      Would you advise setting up a slave database, even if it's on the same physical box?
      Reply With Quote Reply With Quote

    3. August 18, 2010 #3
      pegasus
      • View Profile
      • View Forum Posts
      • View Blog Entries
      • Visit Homepage
      • View Articles
      pegasus is offline
      VaultWiki Team
      Join Date
      March 28, 2004
      Location
      New York, NY
      Posts
      2,934
      Blog Entries
      18
      Rep Power
      659
      Unless I'm mistaken, having the slave on the same box (while not ideal for CPU) would still be an improvement due to table/row-locking issues that occur whenever database reads occur. However, keep in mind that every write transaction will need (number_of_slaves + 1) * write_time rather than the standard write-time. But using slaves with vBulletin would only offer an improvement if you had multiple slaves setup, and you used a script to randomly select one for each vBulletin session. Otherwise, you will still have the problem where multiple users are accessing the same database table at once and need to queue. As far as I can tell, you would not get any saving from write-locks because vBulletin doesn't support slaves with delayed updates (you would have login and registration problems).
      Reply With Quote Reply With Quote

    Tags for this Thread

    able, any, box, database, for, get, issues, mind, pegasus, physical, problem, problems, quote, row, same, script, set, setting, standard, support, table, the, this, time, update, updates, vbulletin, you

    View Tag Cloud

    Bookmarks

    Bookmarks
    • Submit to Digg Digg
    • Submit to del.icio.us del.icio.us
    • Submit to StumbleUpon StumbleUpon
    • Submit to Google Google

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •  
    • BB code is On
    • Smilies are On
    • [IMG] code is Off
    • [VIDEO] code is
    • HTML code is Off

    Forum Rules

    • Contact Us
    • License Agreement
    • Privacy
    • Terms
    • Top
    All times are GMT -4. The time now is 4:55 AM.
    This site uses cookies to help personalize content, to tailor your experience, and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Learn more… Accept Remind me later
  • striker
    Powered by vBulletin® Version 4.2.5 Beta 2
    Copyright © 2023 vBulletin Solutions Inc. All rights reserved.
    Search Engine Optimisation provided by DragonByte SEO (Pro) - vBulletin Mods & Addons Copyright © 2023 DragonByte Technologies Ltd.
    Copyright © 2008 - 2013 VaultWiki Team, Cracked Egg Studios, LLC.