Today i did a rebuild search index and noticed that my XF database grew from 1.8 Gb to 3.7 Gb right after the rebuild process finishes.
Any idea why this is happening?
Any idea why this is happening?
XF 2.2 Rebuild search index
- Thread starter Marcel Broekema
- Start date
Yes i did delete the index before rebuilding.
How are you determining DB size? Many cases can just be estimates. Alternatively, InnoDB generally doesn't shrink its data files, so if there was once a large amount of data and it was subsequently deleted, that space would still be allocated.
Beyond that, the search index does take up a fair amount of space. If you didn't have much of an index before and you built the full index now, DB size growth would very much be expected.
Beyond that, the search index does take up a fair amount of space. If you didn't have much of an index before and you built the full index now, DB size growth would very much be expected.
inspected with phpmyadmin. Thx for the info, it's a large forum with 26K members and over 1.5 milj. postings.
Similar threads
- Question
