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

Database size question

Discussion in 'XenForo Questions and Support' started by Dodgeboard, Feb 26, 2011.

  1. Dodgeboard

    Dodgeboard Well-Known Member

    My database size was 263 mb in vBulletin, before importing to XF.
    After import to Xenforo, 541 mb.

    I expected it to drop because of it being "clean", without all the addons and stuff.

    Why did it double in size? Same data. Less junk.
     
  2. Dean

    Dean Well-Known Member

    xf_search_index table...
     
  3. Dodgeboard

    Dodgeboard Well-Known Member

    So...there's nothing that I can do about the size then...is that what you are saying?
     
  4. Dean

    Dean Well-Known Member

    Is it causing a problem? Maybe overloading your automated backup systems you may have in place? (that is an issue I am addressing at the moment for my forum).

    I will not profess to be a database expert, but in my vb database I see no huge search index, but I do in xf. I do know it has been disscussed at length a while back... but I have extremely limited internet connection at the moment so I cannot search at the moment.
     
  5. Dodgeboard

    Dodgeboard Well-Known Member

    Longer to download a sql backup and I can no longer do an entire site backup via cpanel as it says it's too large.
     
  6. Walter

    Walter Well-Known Member

    The growth is pretty normal due to the search index.
     
  7. Mike

    Mike XenForo Developer Staff Member

    Generally speaking, you'll see more size usage from InnoDB than MyISAM, as well.
     
  8. Floris

    Floris Guest

    Regardless of how big the size is, I prefer to use shell, rather than the browser - to ensure complete back ups.

    ssh2 into your box and


    mysqldump --opt -Q -u dbusername -p databasename > backupname.sql

    it will then ask for your password, this is the then the dbuserPassword
     
    Dean likes this.
  9. Keith

    Keith Member

    My apologies for the thread necromancy. :rolleyes:

    But could someone explain why the search table is so much larger than the ipb one I had previously.

    It's not an issue (presuming its supposed to be the largest table in the database (20% larger and the xf_post table)) just curious as to why the big jump when everything else is smaller than in IPB.
     
  10. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    XenForo duplicates all posts in the xf_search_index table. That is where the fulltext indexes are stored.

    There must be a technical reason for offloading these indexes to another table. Maybe to speed up post operations.
     
  11. p4guru

    p4guru Well-Known Member

    does IPB use innodb table for that search table ? if not , then as Kier explained difference in disk space consumption is due to using innodb instead of myisam tables for xenforo. MyISAM tables used in vB compresses it's indexes while InnoDB doesn't. That's partially the reason why InnoDB tables are larger.

    InnoDB tables can be between 50-300% larger in size than MyISAM tables.

    You can test this out actually, just take a MyISAM table and convert it to InnoDB and note differences in sizes. Or take a InnoDB table and convert it to MyISAM and compare. You can convert via ALTER TABLE command

    Backup database BEFORE testing!

    to convert to InnoDB

    alter table tablename engine=InnoDB;

    to convert to MyISAM

    alter table tablename engine=MyISAM;
     

Share This Page