Limiting the number of fulltext indexes

I have a table (example 1): tblRegulations fldCountryID (int) fldRegualtionType (int) fldRegulationUpdated (date) fldRegulation (text) Each country can have up to 7 different regulation types. I have designed the table like this so I can have one fulltext index on fldRegulation, and thus search

Problem with FullText Indexes

I am trying to do a fulltext search with a multi-field index using MySQL 4.1.15. When I create a full text index of my Comments field which is of type TEXT. I can do a fulltext search fine. But when I add another field (like a varchar or even Text) to that index or change the name of the index I

Re: massive fulltext indexes - what hardware?

We won't be serving concurrent queries. On Sun, 2004-11-07 at 10:41, Michael J. Pawlowsky wrote: > Another thing to consider is how many transactions per minute/second you > will need to serve. > > Mark Maunder wrote: > > I'm busy building an application that will have 10 million records, each

Re: massive fulltext indexes - what hardware?

Another thing to consider is how many transactions per minute/second you will need to serve. Mark Maunder wrote: I'm busy building an application that will have 10 million records, each with a chunk of text - about 500 words each, on average. Does anyone have any benchmarks they can share with my

massive fulltext indexes - what hardware?

I'm busy building an application that will have 10 million records, each with a chunk of text - about 500 words each, on average. Does anyone have any benchmarks they can share with mysql's fulltext search performance on indexes of this size? What I'd like to know is what size server I need to run

Re: "Indexes use different block sizes" error with preloading fulltext indexes.

OK, thanks. I've reported this as a bug, and another, below. I must admit, this production release seems flakey: http://bugs.mysql.com/bug.php?id=6447 On Fri, 2004-11-05 at 04:03, Haitao Jiang wrote: > Mark > > It is a known problem with this feature. So far I am not aware of any > solution to it

Re: "Indexes use different block sizes" error with preloading fulltext indexes.

Mark It is a known problem with this feature. So far I am not aware of any solution to it. Just want to let you know that you are not alone having this problem. Haitao On Fri, 05 Nov 2004 02:16:49 +, Mark Maunder <[EMAIL PROTECTED]> wrote: > I keep getting this error when trying to preload

"Indexes use different block sizes" error with preloading fulltext indexes.

I keep getting this error when trying to preload a fulltext index. I've checked the block size of the fulltext index using myisamchk (is there an easier way to find out block size?) and it is 2048. The block size of the primary key on the same table is 1024. Is that what it means by "Indexes use di

Re: Repeated corruption with MySQL 4.1.x using FULLTEXT indexes

Hi! On Oct 06, Christopher L. Everett wrote: > I have an application where I create a faily large table (835MB) with a > fulltext index. One of our development workstations and our production > server will run the script to load the table, but afterwards we have a > pervasive corruption, with out

Re: Repeated corruption with MySQL 4.1.x using FULLTEXT indexes

Hi! On Oct 06, Christopher L. Everett wrote: > I've also found a problem with "myisamchk --sort-keys": I recently fixed one bug in myisamchk --sort-keys where fulltext indexes are present. Try 4.1.7 release. Regards, Sergei -- __ ___ ___ __ / |/ /_ __/ __

Re: Repeated corruption with MySQL 4.1.x using FULLTEXT indexes

Ed Lazor wrote: -Original Message- From: Christopher L. Everett [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 06, 2004 1:47 AM To: Mysql List Subject: Repeated corruption with MySQL 4.1.x using FULLTEXT indexes I have an application where I create a faily large table (835MB) with a

RE: Repeated corruption with MySQL 4.1.x using FULLTEXT indexes

> -Original Message- > From: Christopher L. Everett [mailto:[EMAIL PROTECTED] > Sent: Wednesday, October 06, 2004 1:47 AM > To: Mysql List > Subject: Repeated corruption with MySQL 4.1.x using FULLTEXT indexes > > I have an application where I create a faily large

Re: Repeated corruption with MySQL 4.1.x using FULLTEXT indexes

I've also found a problem with "myisamchk --sort-keys": christopher:/var/lib/mysql/dmoz# myisamchk -rq xurls - check record delete-chain - recovering (with sort) MyISAM-table 'xurls' Data records: 1981904 - Fixing index 1 - Fixing index 2 - Fixing index 3 Data records: 4332227 christopher:/var/lib/

Repeated corruption with MySQL 4.1.x using FULLTEXT indexes

I have an application where I create a faily large table (835MB) with a fulltext index. One of our development workstations and our production server will run the script to load the table, but afterwards we have a pervasive corruption, with out of range index index pointer errors. Oddly, my devel

Re: Cluster and Fulltext indexes?

Santino wrote: Hello, Does the cluster support fulltext indexes? After a quick reading of preliminary documentation it seems NO. Can someone confirm it? i had a meeting with the mysql cluster sales team and they said it is not supported. fulltext is for myisam only. cluster uses NDB storage

Re: Cluster and Fulltext indexes?

At 15:21 -0500 29-05-2004, mos wrote: At 01:39 PM 5/29/2004, you wrote: Hello, Does the cluster support fulltext indexes? After a quick reading of preliminary documentation it seems NO. Can someone confirm it? Thank you. Santino Cusimano - Santino, Where does it say that in the docs? Can

Re: Cluster and Fulltext indexes?

At 01:39 PM 5/29/2004, you wrote: Hello, Does the cluster support fulltext indexes? After a quick reading of preliminary documentation it seems NO. Can someone confirm it? Thank you. Santino Cusimano - Santino, Where does it say that in the docs? Can you post the documentation that says

Cluster and Fulltext indexes?

Hello, Does the cluster support fulltext indexes? After a quick reading of preliminary documentation it seems NO. Can someone confirm it? Thank you. Santino Cusimano -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Impossible to pre-load the MySQL fulltext indexes?

Hi, I tried to load a table's indexes into cache, however I noticed that full-text indexes have a different block-size than others (2048 vs. 1024), which caused load index command to fail. Any idea on how to solve this? Thanks a lot __ Do you Yahoo!? Yahoo! Small

Re: [BUG] SHOW INDEX bug for fulltext indexes in MySQl 4.0.17

Hi! On Jan 23, Dave Rolsky wrote: > Here's a recipe: > > create table foo (foo text, bar text); > > create fulltext index foo on foo (foo, bar); > > mysql> show index from foo; > > +---++--+--+-+---+-+--++-

[BUG] SHOW INDEX bug for fulltext indexes in MySQl 4.0.17

Here's a recipe: create table foo (foo text, bar text); create fulltext index foo on foo (foo, bar); mysql> show index from foo; +---++--+--+-+---+-+--++--++-+ | Table | Non_unique |

Re: FULLTEXT indexes and select query problem

At 21:56 -0500 3/3/03, Stitchin' wrote: I found some stuff in the mySql manual about setting columns as fulltext indexes for fulltext searches and the syntax is WHERE MATCH (column names...) AGAINST (the search stuff) So I went in and did an alter table statement to set my four search colum

FULLTEXT indexes and select query problem

I found some stuff in the mySql manual about setting columns as fulltext indexes for fulltext searches and the syntax is WHERE MATCH (column names...) AGAINST (the search stuff) So I went in and did an alter table statement to set my four search columns to be in a fulltext index. So here'

RE: fulltext indexes

Maybe this could help? Try changing the name of the index on the second table you 've created Thanks for the idea, but I think I've discovered the problem. Perhaps I chose my search phrase a little TOO well. It seems the problem occurs because of the 50% restriction for fulltext searching. Fr

Re: fulltext indexes

Hello Duncan, Thursday, February 27, 2003, 4:00:31 PM, you wrote: SD> I having some strange things occur with doing fulltext searches. I'm not SD> exactly sure how to tackle this problem, so I figured I would send it out SD> and see if anyone has any ideas or has seen this before. SD> Backgroun

fulltext indexes

I having some strange things occur with doing fulltext searches. I'm not exactly sure how to tackle this problem, so I figured I would send it out and see if anyone has any ideas or has seen this before. Background: I have been investigating the use of MySQL to do fulltext searches on emails. Th

Re: Cardinality for FULLTEXT-indexes MySQL 4.0.10

Hi! On Feb 24, Tobias Lind wrote: > Hello! > I never got any comment on this one... > Have noone else observed this behavior? > I'm a bit worried to use this in my production site without knowing if it's > and indication of some problem with FULLTEXT indexes... :) &g

Cardinality for FULLTEXT-indexes MySQL 4.0.10

Hello! I never got any comment on this one... Have noone else observed this behavior? I'm a bit worried to use this in my production site without knowing if it's and indication of some problem with FULLTEXT indexes... :) Regards, Tobias Lind Hi! I have a question regarding "C

Cardinality for FULLTEXT-indexes MySQL 4.0.10

Hi! I have a question regarding "Cardinality" for FULLTEXT-indexes. I have a table with 9 indexes - the last 3 indexes are FULLTEXT. When I run "show index from ", the last index (FULLTEXT) always shows cardinality=NULL... Is this normal? ...everything seems to work ok when I

browse the fulltext indexes

Hi all, I'd like to know if there is a way to browse the fulltext index of a field in a mysql database (e.g. accessing to the tables where the full text indexes are stored). Thanks, Luca Lelli __ Per te Blu American Express è g

Question about FULLTEXT indexes

Hi, I'm using MySQl 3.23.52 on RedHat Linux 6.2 I have a table that is indexed on the description column as FULLTEXT. I allow the user to enter text in an input field and I return matching rows. I've noticed that writing a query such as: SELECT EDescript FROM HSCodes WHERE MATCH(EDescript) AGAI

slow inserts and selects for fulltext indexes (mysql4)

Hi, Is there a way to speed up inserts on a table with three fulltext indexes? I'm using the multiple value insert format like: insert into blah (field1, field2) values ('val1', 'val2'), ('val2', 'val3'), etc.. Perhaps this is a bug in the current m

Re: fulltext indexes for innodb?

On Thu, Aug 30, 2001 at 01:44:56PM +0200, Sergei Golubchik wrote: : Hi! : : On Aug 30, Alexander wrote: : > Hello, mysql team! : > : > Any chance (in the near future) to get FullText indexing working with innodb : > table handler? : > : > Alexander : : I doubt it will be done it the near futur

Re: fulltext indexes for innodb?

Hi , Ahh... Ok, thanks for reply. Fulltext searching can be done in application level, but productivity of this solution... > Hi! > > On Aug 30, Alexander wrote: > > Hello, mysql team! > > > > Any chance (in the near future) to get FullText indexing working with innodb > > table handler? > > > >

Re: fulltext indexes for innodb?

Hi! On Aug 30, Alexander wrote: > Hello, mysql team! > > Any chance (in the near future) to get FullText indexing working with innodb > table handler? > > Alexander I doubt it will be done it the near future (unless a customer would like to pay for the feature, of course). Regards, Sergei --

fulltext indexes for innodb?

Hello, mysql team! Any chance (in the near future) to get FullText indexing working with innodb table handler? Alexander - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.

FULLTEXT indexes

i have a table with a FULLTEXT index that correctly matches certain words: mysql> select title from movie where title like 'little%'; ++ | title | ++ | Little Fugitive| | Little Kidnappers, The | | Little Mermaid, The| |