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

Database Larger after Beta 6?

Discussion in 'XenForo Questions and Support' started by Jaxel, Jan 20, 2011.

  1. Jaxel

    Jaxel Well-Known Member

    Yesterday, my database size was 420mb. After upgrading to Beta 6, it is now 480mb... Is there a reason for this?
  2. Mike

    Mike XenForo Developer Staff Member

    Assuming no data changed, then no not really. It's just minor changes between b5 and b6.
  3. Jaxel

    Jaxel Well-Known Member

    Well I'm in an odd situation... today the database is 540mb...

    Its going up 60mb a day.
  4. Andy.N

    Andy.N Well-Known Member

    Jaxel, maybe some of your mods are adding data to database?
  5. Jaxel

    Jaxel Well-Known Member

    Nope... I did a database compare, and it in the base XenForo tables... mostly searches
  6. Mike

    Mike XenForo Developer Staff Member

    Searches should be cleared out after 24 hours (IIRC), so there shouldn't be too many records there (we have about 5000). How are you determining the size increase? Dumps? File sizes? phpMyAdmin reports?
  7. Tigratrus

    Tigratrus Well-Known Member

  8. Jaxel

    Jaxel Well-Known Member

    file sizes of export dumps
  9. Mike

    Mike XenForo Developer Staff Member

    A diff should show 40 MB worth of differences then. The search table may change (it looks like our search table contains about 50MB of data right now), but in theory it should be rolling so it shouldn't grow from day to day.
  10. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    There are many syntax, formatting, and compression options that can affect the size of database dumps.

    If you have two recent dumps then you can compare them side-by-side to see what is different. If you restore them to separate databases then you can compare record counts and sizes of individual tables using phpmyadmin.
  11. Jaxel

    Jaxel Well-Known Member

    According to PhpMyAdmin:

    xf_post: 134.6mb (~240,912 rows)
    xf_search: 248.6mb (~27,589 rows)
    xf_search_index: 187.6mb (209,680 rows)

    I doubt my users are generating 20K+ searches a day.

    As well... shouldn't the number of rows in xf_search_index be the same as xf_post?

Share This Page