No announcement yet.

Database size during upgrade

  • Filter
  • Time
  • Show
Clear All
new posts

  • 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?

  • #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.

    TalkNewsUK - My vBulletin 5.5.2 Demo
    AdminAmmo - My Cloud Demo


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


      • #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 customization and demonstration site.
        vBulletin 5 Documentation - Updated every Friday. Report issues here.
        vBulletin 5 API - Full / Mobile
        I am not currently available for vB Messenger Chats.


        • #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?

          GIPHY for vB5 AutoLinker Auto-Create Flag Report Topic Social Icons in Postbit Clear Cache Cron DragDrop Upload Topic AJAX AutoUpdate Custom Avatars Selector Stop Links in Posts...and more!


          Related Topics