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

    443
    135
    +35
    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 Adherent

    275
    75
    +97
    That does seem big, worth having a look at the tables and seeing whats going on?
     
  3. tokyoice

    tokyoice Adherent

    443
    135
    +35
    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 Adherent

    275
    75
    +97
    Seems a bit odd, thats a similar size to mine.
     
  5. tokyoice

    tokyoice Adherent

    443
    135
    +35
    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 Adherent

    275
    75
    +97
    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

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

    Dubbed Navigator Adherent

    275
    75
    +97
    No converting into XF2. Itll be empty until I import into it though.
     
  9. tokyoice

    tokyoice Adherent

    443
    135
    +35
    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 Adherent

    275
    75
    +97
    Should be <50MB
     
    • Appreciation Appreciation x 1
    • List
  11. mysiteguy

    mysiteguy Devotee

    2,906
    887
    +2,236
    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

    443
    135
    +35
    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

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

    palhanow Enthusiast

    116
    105
    +111
    Sorry, can't help.

    My XF have almost 5gb of database with less than one year of life.
     
    • Appreciation Appreciation x 1
    • List
  15. mysiteguy

    mysiteguy Devotee

    2,906
    887
    +2,236
    You asked me privately for additional help. Not going to answer privately as that helps no one else needing this information now or in the future.

    Optimizing is done on a table by table basis. If you access the database via phpMyAdmin, normally found with CPanel installs, you can select table and use the "with selected" drop down box to optimize tables. However, it won't compact the table unless you're running Mariadb instead of Mysql, or a version of mysql 5.7+ (IIRC) and the database must have been created with Mysql/Mariadb's innodb_file_per_table enabled.

    If it wasn't enabled, you'll need to backup that database, enable the option, restart the database, and restore the database.
     
    • Like Like x 1
    • Informative! Informative! x 1
    • Appreciation Appreciation x 1
    • List
  16. Xon

    Xon Adherent

    302
    207
    +437
    I have no idea why innodb_file_per_table is disabled by default.
     
  17. eva2000

    eva2000 Habitué

    1,717
    857
    +789
    indeed I've had it enabled by default on every server I create for past decade !!!
     
  18. tokyoice

    tokyoice Adherent

    443
    135
    +35
    Thank you!
     
  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.