After a few days of playing around I finally was able to come up with a
solution:
Even though it says it will be much faster to populate the table, then
add the fulltext index, it appears the opposite is true for large tables.
I built an empty copy of the table I wanted to index, added the fu
I have a smaller database but am still unable to fulltext index one of
the tables that is only about 600mb and has rougly 3.5 million rows.
I tried both 3.23.47 and 4.0.1 and in both cases it was about the same.
I watched the temporary table that it was building and in both cases
it got up t
Hi!
On Jan 21, Steve Rapaport wrote:
> Okay, does anyone know how long this will take?
> 22 million records, fulltext index on a single field, first 40 chars.
> record length 768 chars, variable.
>
> It's been running for 2 days, processlist quotes time at around 10.
> Index file still growi
t; <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Sunday, January 20, 2002 5:25 PM
Subject: Fulltext build 2 days and counting...
> Okay, does anyone know how long this will take?
> 22 million records, fulltext index on a single field, first 40 chars.
> re
Okay, does anyone know how long this will take?
22 million records, fulltext index on a single field, first 40 chars.
record length 768 chars, variable.
It's been running for 2 days, processlist quotes time at around 10.
Index file still growing occasionally, up to 3Gb.
Should I let it conti
