Database Larger after Beta 6?

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?
 
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?
 
file sizes of export dumps
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.
 
file sizes of export dumps

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.
 
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?
 
Top Bottom