Database size during upgrade

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • enak
    New Member
    • Dec 2012
    • 12

    Database size during upgrade

    Upgrading vBulletin 4.2.5 -> 5.5.2 and my database size is initially 524MB. During the upgrade it gets part way through and freezes. When I checked the database size it had grown to 1040MB and since the host limit is 1GB it switched to read only.

    Is the database space requirements much greater in vB5 or is this just part of the upgrade process. If so, is there a workaround?
  • Mark.B
    vBulletin Support
    • Feb 2004
    • 24286
    • 6.0.X

    #2
    vB5 databases are considerably larger than vB4 databases, though they will be higher still during an upgrade as things are changed and rewritten. There is no way round this.
    MARK.B
    vBulletin Support
    ------------
    My Unofficial vBulletin 6.0.0 Demo: https://www.talknewsuk.com
    My Unofficial vBulletin Cloud Demo: https://www.adminammo.com

    Comment

    • In Omnibus
      Senior Member
      • Apr 2010
      • 2310

      #3
      Find a better host. A 1GB limit is ridiculous.

      Comment

      • Wayne Luke
        vBulletin Technical Support Lead
        • Aug 2000
        • 73976

        #4
        During upgrade, your data is often doubled as it is converted to the new storage format from the previous tables. As the process continues, we will delete old and unneeded tables.

        However, a vBulletin 5 database will still be larger. Most tables in a vBulletin 4 database use a Latin character set. This allots one byte per character. In today's world with modern languages, this is insufficient so you need a database that uses UTF-8 as its storage mechanism. This takes up 2-3 times the space as a Latin character set. For full compatibility with modern devices, we recommend using the UTF8MB4 character set. This uses 4 bytes per character or 4 times the space as a Latin character set.
        Translations provided by Google.

        Wayne Luke
        The Rabid Badger - a vBulletin Cloud demonstration site.
        vBulletin 5 API

        Comment

        • glennrocksvb
          Former vBulletin Developer
          • Mar 2011
          • 4011
          • 5.7.X

          #5
          Even if the database size was 1GB or lower after the upgrade, you would have the same issue in the immediate future when your site gets more content. As what In Omnibus said, find a better host. You must be in a Shared Plan to have a 1GB db size limit?

          Flag Icon Postbit Insert GIPHY Impersonate User BETTER INITIALS AVATAR Better Name Card Quote Selected Text Bookmark Posts Post Footer Translate Stop Links in Posts +MORE!

          Comment

          Related Topics

          Collapse

          Working...