Re: index failure, cannot generate.
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 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 search takes 1.5 Minutes. It seems to me like MySQL fails to generate the index correctly. Is this a bug ? Does anyone know what's going on ? Thanks in advance. Herbert -- Herbert Michael Kunzmann Binary Chaos Magician signature.asc Description: This is a digitally signed message part
Re: index failure, cannot generate.
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
index failure, cannot generate.
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 search takes 1.5 Minutes. It seems to me like MySQL fails to generate the index correctly. Is this a bug ? Does anyone know what's going on ? Thanks in advance. Herbert -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: index failure, cannot generate.
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 -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.13: up 3 days, processed 118,789,190 queries (395/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: index failure, cannot generate.
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 records. I'm curious. What's the structure for your 1.5GB table with only 400 records look like? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.13: up 3 days, processed 118,789,190 queries (395/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]