The answer is that a fulltext index can only be built on
a TEXT field. Even though the mysql documentation describes
MEDIUMTEXT and LONGTEXT fields as 'BLOB or TEXT field that can hold..',
they can not be used.
On Fri, 2003-06-06 at 09:36, H M Kunzmann wrote:
Hi all.
I am running RH9.0 with
I'm guessing blob data? ~1500MB / 400rows = ~3.75MB /row
Perfect guess.
Two columns: Filename (char len 20) and Text ~ 3.75MB/row.
--
Herbert Michael Kunzmann
Binary Chaos Magician
signature.asc
Description: This is a digitally signed message part
Hi all.
I am running RH9.0 with MySQL 4.0.13
I am trying to create a fulltext index on a 1.5GB table with 400
records. Whenever I do a create index (retried this a couple of times),
the index size grows to only 8MB before the index completes. When using
this index in fulltext searches, the
On Fri, Jun 06, 2003 at 09:36:08AM +0200, H M Kunzmann wrote:
Hi all.
I am running RH9.0 with MySQL 4.0.13
I am trying to create a fulltext index on a 1.5GB table with 400
records.
I'm curious. What's the structure for your 1.5GB table with only 400
records look like?
Jeremy
--
I'm guessing blob data? ~1500MB / 400rows = ~3.75MB /row
On Fri, 6 Jun 2003, Jeremy Zawodny wrote:
On Fri, Jun 06, 2003 at 09:36:08AM +0200, H M Kunzmann wrote:
Hi all.
I am running RH9.0 with MySQL 4.0.13
I am trying to create a fulltext index on a 1.5GB table with 400