Hi!
On Jul 29, Niels Larsen wrote:
> Sergei,
>
> Will a future MySQL version combine the current nice and fast word-search
> with ability to add data in finite time? I saw "Make all operations with FULLTEXT
> index faster" on the TODO list .. are you able to say what is in the pipe?
Not really
Sergei,
Thank you for the nice help.
> Try to experiment with bulk_insert_buffer variable. You need both big
> keycache and big bulk_insert_buffer.
I lowered key_buffer_size from 512M to 256M and increased bulk_insert_buffer_size
from 8M to 128M.
> When MERGE tables will support fulltext sear
Hi!
On Jul 29, Niels Larsen wrote:
> Sergei,
>
> I had two columns indexes of type BTREE where the .MYI file was ~5 gb.
> Then I decided to drop one of them and replace it with a fulltext index. The
> dropping took 4 hours and fulltext indexing also 4 hours. There were about
You should've done i
Hi!
On Jul 28, Niels Larsen wrote:
> Greetings,
>
> Do anyone know where to find a description of how fulltext indexing
> and query speeds depend on data volume? I have 30-40 gb of text
> distributed across 30-40 million entries, a medium size database I
> suppose. But I have not even been abl
