1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Database size is huge

Discussion in 'General XenForo Discussion and Feedback' started by Rob, Mar 26, 2012.

  1. Rob

    Rob Well-Known Member

    After successfully importing vB3.8 I was suprised to see that the xF database is approximately 25% bigger in size. I am suprised because the vb database contains thousands of social groups posts and thousands of blog entries not to mention many many mods and their data - non of which have been imported.

    I'm not naive enough to think a bigger database is slower because that is always down to the schema and architecture... however i was just shocked at the size difference thats all.
     
    alexD likes this.
  2. Brogan

    Brogan XenForo Moderator Staff Member

    The main difference will more than likely be the search_index table, compared to the equivalent in vB.
     
  3. Rob

    Rob Well-Known Member

    I haent even run that step yet. im using elastic search too
     
  4. Floris

    Floris Guest

    It's correct that it's a bit bigger, because data is more specific. A user and it's data isn't just in the user table for example. This allows XF to be very specific when doing SQL queries with PHP and limit what data it's requesting, and in effect be more efficient than others who have it stuffed in a single place. This can also benefit caching quite a bit in certain situations.
     
  5. mrGTB

    mrGTB Well-Known Member

    Just to add that when I ran MyBB and had over 1000 or more threads listed, not counting replies. I did spot the database backup was much smaller than the XenForo one running alongside it with nothing listed at all "clean install", maybe one thread listed at most. I also then thought, how comes that's the case? Didn't bother me or anything, just something I spotted comparing things. Think I even checked how many tables they both used and saw XF only had a few extra ones, not sure now though.
     
  6. Solidus

    Solidus Well-Known Member

    I converted from MyBB recently, the XF database is 2.5x larger.
     
  7. Ingenious

    Ingenious Well-Known Member

    Mine went from 130MB (vB3) to 240MB (Xenforo).
     
  8. Paul

    Paul Well-Known Member

    Yup - mine increased from around 1.5Gb to around 3Gb, mostly sue to the search indexing. However it was too big for my then host, so i went on a pruning spree :D
     
    alexD likes this.
  9. digitalpoint

    digitalpoint Well-Known Member

    The biggest factor with database size is simply the storage engine you are using. It's pretty typical to see a InnoDB use 150-175% the storage space that MyISAM does. For what it's worth, I have my XenForo dev installation using all MyISAM tables for now (undecided what I'll use in production).
    http://mysqlha.blogspot.com/2009/01/innodb-myisam-and-disk-space_16.html
     
    Jarod and Digital Doctor like this.
  10. Rob

    Rob Well-Known Member

    So, what benefit does InnoDB give over MyISAM?

    There must be one - they've used it for a reason I assume?
     
  11. digitalpoint

    digitalpoint Well-Known Member

    Row based locking instead of table based locking and transactions basically.
     
  12. Rob

    Rob Well-Known Member

    I have always been led to believe that InnoDB is slower at SELECTs but maybe im wrong I guess.
     
  13. mrGTB

    mrGTB Well-Known Member

    I've read a few articles in the past about InnoDB v's MyISAM. From what I read InnoDB is the better of the two because of the locking thing, but suffers slightly in speed performance to MyISAM but offers better stability. Overall InnoDB was said to be the best, especially when coming to big board use. Or so I read.
     
  14. Adam Howard

    Adam Howard Well-Known Member

    InnoDB is more stable and you have less of chance from database corruption. The #1 issue when converting from vBulletin to "X" (Xenforo, phpBB, ect...) is database corruption. I can't tell you how many times people have sent me a PM asking me why to conversion doesn't work. 1st thing I tell them to do is run the repair & optimize function... All so far have always (100%) lead to a successful resolve.

    InnoDB started out slower, this is true. But as development has progressed, it's just a little shy from equallying out to MyISAM. MySQL 5.6 actually breezes by without any noticable speed loss. I suspect as time goes into further development, it could actually become faster than MyISAM. After all, it's still being developed and is already (almost) equal in speed.
     
  15. dojo

    dojo Active Member

    Aha, so I though I am crazy when a NEW forum (2 months, with around 4K is has a bigger database than a 5 year VB with 60K posts). Well, can't complain about how it runs, am actually pleased with XF, but it's good you guys clarified this. Was about to start a useless thread here and make a fool of myself :D
     

Share This Page