• 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?

Jaxel

Well-known member
#1
Yesterday, my database size was 420mb. After upgrading to Beta 6, it is now 480mb... Is there a reason for this?
 

Mike

XenForo developer
Staff member
#6
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?
 

Jaxel

Well-known member
#8
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
 

Mike

XenForo developer
Staff member
#9
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.
 

Jake Bunce

XenForo moderator
Staff member
#10
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.
 

Jaxel

Well-known member
#11
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?