Sergei,
I also have the same problem, but in my case the table size exceeds 2Gb,
average record size being around 50Kb.
I'm running 3.23.37 (i686) on a dual PIII 866/ 1Gb RAM / 36Mb SCSI RAID5 w/
RedHat 7.1 (kernel 2.4).
As I type this message, MySQL is still [fulltext-] indexing one of the tables,
for the 6th straight day now.
I'm getting desperate.
What's the completion state of v.4.0?
Will it also improve query performance on big tables?
Thanks,
Vadim.
Sergei Golubchik wrote:
>
> Hi!
>
> On Apr 19, Braxton Robbason wrote:
> > Hi all,
> >
> > I'm creating a fulltext index on a 400MB table, and the creation process
> > gets very slow. It's fast for the first 50MB of the index, and then it
> > grinds to what seemed like a halt after days. My question is - is there
> > anyone who's created fulltext indexes on this much data who can assure me
> > that it's possible?
> >
> > Merge tables are not an option because you can't query a merge table on a
> > fulltext index.
> >
> > thanks,
> > Braxton
> >
>
> Yes, FULLTEXT index works ok for 400 MB tables.
> In my tests FULLTEXT index was created (with CREATE INDEX)
> over 400 MB table in 15 minutes with new MySQL-4.0 code (not yet
> available, sorry).
>
> Everything works with 3.23 code too, but index creation
> is 50-100 times slower (and resulting index is ~10% bigger).
>
> Regards,
> Sergei
>
> --
> MySQL Development Team
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
> /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
> <___/
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
