• 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
    • VaultWiki How-Tos
    • VaultWiki Questions
    • MySQL 5.5?

    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 5 of 5

    Thread: MySQL 5.5?

    • Thread Tools
      • Show Printable Version
    1. May 19, 2011 #1
      Alfa1
      • View Profile
      • View Forum Posts
      • View Blog Entries
      • View Articles
      Alfa1 is offline
      Distinguished Member
      Join Date
      September 26, 2007
      Posts
      597
      Rep Power
      284

      MySQL 5.5?

      Would upgrading to mysql 5.5 and php 5.3 cause any issue with VW?
      Last edited by Alfa1; May 19, 2011 at 7:40 AM.
      Reply With Quote Reply With Quote

    2. May 19, 2011 #2
      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,959
      Blog Entries
      18
      Rep Power
      687
      We use PHP 5.3.5 here without any issues.

      From the looks of the changelog for MySQL 5.5, I don't see any issues with VaultWiki if you're already on the latest version or are installing fresh. There is a compatibility issue with one vBulletin function that we use in earlier upgrade steps <= 3.0.1. I have reported the issue to vBulletin devs now, because they probably use it more frequently: http://tracker.vbulletin.com/browse/VBIV-12134

      Another thing I would be concerned about in MySQL 5.5 is that InnoDB is now the default engine for new tables. From my experience, InnoDB tables crashed more than MyISAM tables with the same configuration did, even though InnoDB claims reliability. It also claims crash recovery, but every time I've seen an InnoDB table crash, it was not possible to recover without dropping the table and starting over (so use backups, still). Perhaps related to the following.

      Another downside is that InnoDB uses a different INDEX structure than MyISAM. Indexes that aren't aligned with the PRIMARY KEY are much slower than their MyISAM counterparts, so InnoDB is only good for tables where data is fetched via ID or by a field that shares a key with the ID. If many new users are going to be moving to MySQL 5.5, then we need to change the installer to force MyISAM for certain tables.
      - lead developer for VaultWiki
      Reply With Quote Reply With Quote

    3. May 19, 2011 #3
      Alfa1
      • View Profile
      • View Forum Posts
      • View Blog Entries
      • View Articles
      Alfa1 is offline
      Distinguished Member
      Join Date
      September 26, 2007
      Posts
      597
      Rep Power
      284
      You'll see on vb.com that IB staff is actively promoting (in blogs and posts) the use of MySQL 5.5 due to its performance benefits. See the performance blogs by Anders and various posts by Anders / Eva2000.

      I was not planning to move from MyIsam to InnoBD, but am considering MySQL 5.5
      Reply With Quote Reply With Quote

    4. May 19, 2011 #4
      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,959
      Blog Entries
      18
      Rep Power
      687
      Well, if they are promoting it they better fix that compatibility issue. I would say I want to try it, by it looks like all the MySQL stuff takes < .02s on this page. PHP appears the bottleneck. Wish there was a way to make that faster. XCache reduced 50% but there's still room for improvement. I've been thinking it's probably disk seeks for each included file, but I was under the impression that XCache strings it all together and removes the extra seeks on cache-hits.
      - lead developer for VaultWiki
      Reply With Quote Reply With Quote

    5. May 19, 2011 #5
      Alfa1
      • View Profile
      • View Forum Posts
      • View Blog Entries
      • View Articles
      Alfa1 is offline
      Distinguished Member
      Join Date
      September 26, 2007
      Posts
      597
      Rep Power
      284
      http://www.vbulletin.com/forum/blog....categoryid=993
      Reply With Quote Reply With Quote

    Similar Threads

    1. WHen I turn VW on, articles and threads give me MYSQL errors
      By gosborne in forum VaultWiki Questions
      Replies: 1
      Last Post: May 11, 2010, 12:16 PM
    2. Strange MYSQL error after installing Wikiw
      By jwocky in forum VaultWiki Questions
      Replies: 4
      Last Post: June 18, 2009, 11:57 AM
    3. MySQL Error
      By HellRazor in forum VaultWiki Questions
      Replies: 2
      Last Post: August 31, 2008, 9:51 PM
    4. MySQL Error when trying to use Books
      By Home Alone in forum VaultWiki Questions
      Replies: 3
      Last Post: August 30, 2008, 10:47 PM

    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 12:00 PM.
    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 © 2025 vBulletin Solutions Inc. All rights reserved.
    Search Engine Optimisation provided by DragonByte SEO (Pro) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
    Copyright © 2008 - 2024 VaultWiki Team, Cracked Egg Studios, LLC.