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

Database size???

Discussion in 'XenForo Questions and Support' started by Mr. Goodie2Shoes, Feb 22, 2012.

  1. Mr. Goodie2Shoes

    Mr. Goodie2Shoes Well-Known Member

    Okay... I dunno about others but why is my database size THIS big?!?!?!

    My community aint that big... only 2.5k posts and the database size in about 250MB... :eek:
  2. Walter

    Walter Well-Known Member

    Take a look at the tables (if you use phpmyadmin sort by table size). Usually the search index is by far the biggest table, bigger than posts.
  3. principia

    principia Well-Known Member

    Mmmh, seems to be big for 2.5posts. I have 80000 posts and db is about 120MB
  4. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Yeah check the tables in the database. There must be something else in the database besides XF to account for that usage.

    ...unless you have lots of attachments?
  5. Brogan

    Brogan XenForo Moderator Staff Member

    I found my admin log table had ballooned to 80MB due to a lot of template saving, etc.
  6. EasyTarget

    EasyTarget Well-Known Member

    250MB does it really matter? Are you trying to run the forum in a space constrained server, of some sort?
  7. Mr. Goodie2Shoes

    Mr. Goodie2Shoes Well-Known Member

    yeah... thats what I am worried about :(
    nope... I use different databases for different scripts ;)
    nope... just a little worried and curious as why does it take so much space... I used to manage a community running on vBulletin with about 100k posts and the DB size was about 100MB...
  8. EasyTarget

    EasyTarget Well-Known Member

    did you figure out which table was the culprit?
  9. Mr. Goodie2Shoes

    Mr. Goodie2Shoes Well-Known Member

    as expected: xf_templates_compiled & templates :p
  10. EasyTarget

    EasyTarget Well-Known Member

    Well there's your problem.... you keep changing things! :D
    alexD likes this.
  11. Mr. Goodie2Shoes

    Mr. Goodie2Shoes Well-Known Member

    I only added icons in the sidebar :p
  12. Calamity James

    Calamity James Active Member

    It could be worse! ;)


Share This Page