XF 2.2 Rebuild search index

[Marcel Broekema]

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?

 

[Marcel Broekema]

No one has any idea about this?

 

[duderuud]

Did you delete the index before rebuilding? My guess is that your index is duplicated in some way.

 

[Marcel Broekema]

Yes i did delete the index before rebuilding.

 

[Mike]

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.

 

[Marcel Broekema]

inspected with phpmyadmin. Thx for the info, it's a large forum with 26K members and over 1.5 milj. postings.