Announcement

Collapse
No announcement yet.

Data base size increase after upgrade to 5.4.1

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • [Bug / Issue] Data base size increase after upgrade to 5.4.1

    Hi every body

    i have an issue with data base size increase after upgrade directly from 3.8.0 to 5.4.1.

    i tryied to reduce by shifting photos, avatares and attachments from data base but still size is high.

    The highest tables size are shown in the attcahed screenshot

    their is one table called cache always increases and it only reduces once I flush it form control panel. It might be coused of wrong setup from the Admincp, could you please help me in fixing it ?

    note when I check the size of the data base from myphpadmin the size showing for examele 750 MB however when I backup the data base or daownlad it it shows 400 MB is that normal ?





    Industrial Engineering forum
    Forum Mobile App ISO/Android
    industrial Engineering forum YouTube

  • #2
    The database for vBulletin 5.4.X will be larger than the database for 3.8.X. It can actually be two to three times larger. This is to be expected. The cache should manage itself as long as the database user has permissions to delete content from the database. None of the tables in your screenshot are very large in the grand scheme of things.

    The backup SQL file will not match the size mentioned in PHPMyAdmin.
    Translations provided by Google.

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

    Comment


    • #3
      Thanks wayne,

      could you recomend for me a hosting can take my data base which reaching 2.5 GB once search is fully indexed, running grand setting and Cache in place.

      or in general if i can ask what the sutable hosting fetures for 5.4.1 for forum with 95 K topics 127K threads and 26K members.
      Industrial Engineering forum
      Forum Mobile App ISO/Android
      industrial Engineering forum YouTube

      Comment


      • #4
        Most hosts offer "Unlimited Storage" these days. 2.5 GB isn't very large to be honest.

        Are you storing attachments in the database? Move them to the file system under Attachments -> Attachment Storage Type. That may alleviate some of your database size.
        Translations provided by Google.

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

        Comment


        • #5
          Attachments , avatares and templates moved befour,

          I appriciate if you can give me your recommendation for the hosting
          Industrial Engineering forum
          Forum Mobile App ISO/Android
          industrial Engineering forum YouTube

          Comment


          • #6
            We do not make hosting recommendations. Our recommendations for a server are Apache 2.4.X, PHP 7.1+, MySQL 5.7+ and at least 100GB of storage to account for future growth.
            Translations provided by Google.

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

            Comment


            • #7
              thanks alot, I already changed the hosting and I will follow your recommendation hopfully I will get better results
              Industrial Engineering forum
              Forum Mobile App ISO/Android
              industrial Engineering forum YouTube

              Comment

              Related Topics

              Collapse

              Working...
              X