database – How much extra storage does MySQL fulltext index consume? – Education Career Blog

I am looking for a way to estimate how much extra storage will be needed if a MySQL TEXT column gets a fulltext index.

Intuitively speaking the size of the fulltext index is dependent on the total length of text but what exactly is affecting it?


“I have 200 MB of text data to index and the resulting index is 130 MB.”

So it’s comparable to the total size of data you index.

Leave a Comment