MySQL Installed a fresh 2.1 XF and the database is 260mb? Is this normal?

Discussion in 'Servers and Control Panels' started by tokyoice, Jun 7, 2019.

  1. tokyoice

    tokyoice Adherent

    435
    135
    +34
    Surely this isn't normal?

    Take a look here.. as you can see, it's a fresh installation with only 8 members, but yet quite a large database? https://bit.ly/2Ip71Xw
     

    Attached Files:

  2. Dubbed Navigator

    Dubbed Navigator Enthusiast

    249
    63
    +83
    That does seem big, worth having a look at the tables and seeing whats going on?
     
  3. tokyoice

    tokyoice Adherent

    435
    135
    +34
    Hey :thumb:

    Got to the bottom of this (with Xenforo support, and support from the developers of the theme I am using)

    Essentially, when I have been testing some add-ons and new theme installations, and then removing them, the data has been deleted by me but not reclaimed automatically in the tables.

    Apparently, this is how innodb works? Kind of annoying..
     
  4. Dubbed Navigator

    Dubbed Navigator Enthusiast

    249
    63
    +83
    Seems a bit odd, thats a similar size to mine.
     
  5. tokyoice

    tokyoice Adherent

    435
    135
    +34
    And you have nearly 2.5K members and a much large post/thread ratio! Yep, something not right here lol.

    Let me ask, when you made a fresh install of Xenforo - was your, out of the box installation 70mb to 100mb? (Note, this is a fresh installation with Xenforo 2.)
     
  6. Dubbed Navigator

    Dubbed Navigator Enthusiast

    249
    63
    +83
    Crikey now you are asking :rofl:

    I'm doing a conversion early next week, ill try and remember to take note of the size.
     
  7. tokyoice

    tokyoice Adherent

    435
    135
    +34
    Conversion? Are you upgrading from XenForo 1 to Xenforo 2?
     
  8. Dubbed Navigator

    Dubbed Navigator Enthusiast

    249
    63
    +83
    No converting into XF2. Itll be empty until I import into it though.
     
  9. tokyoice

    tokyoice Adherent

    435
    135
    +34
    You'll love XenForo 2 - a great improvement - still some feels I miss in XenForo 1 though. Did you ever own/use a vBulletin license back in the day?
     
  10. Dubbed Navigator

    Dubbed Navigator Enthusiast

    249
    63
    +83
    Should be <50MB
     
    • Appreciation Appreciation x 1
    • List
  11. mysiteguy

    mysiteguy Devotee

    2,852
    887
    +2,186
    Innodb allocates file space as it needs it. When data shrinks in the file space, the space is still allocated on the drive, but Innodb marks portions of is as unused and new data will go into those positions. If you're using Mariadb, you can turn on Innodb optimization which will reclaim the drive space when optimizing the table.
     
    • Informative! Informative! x 1
    • Appreciation Appreciation x 1
    • List
  12. tokyoice

    tokyoice Adherent

    435
    135
    +34
    I just did a two fresh installations. One was 70mb the other 100mb.

    I do remember XF being much much lower than this on a fresh installation!
     
  13. tokyoice

    tokyoice Adherent

    435
    135
    +34
    Did not know this - will look into the optimisation feature. Thank you!
     
  14. palhanow

    palhanow Participant

    72
    73
    +63
    Sorry, can't help.

    My XF have almost 5gb of database with less than one year of life.
     
    • Appreciation Appreciation x 1
    • List
Verification:
Draft saved Draft deleted
  1. This site uses cookies to help personalise content, 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.