MySQL Forums
Forum List  »  MyISAM

Re: How to resolve this issue with the mySQL engine?
Posted by: Rick James
Date: September 14, 2013 12:12PM

> If I lock the table, start the loop and then somewhere on the iteration the insertion fails - does this mean the database will end up with only some records?

True.

> declared as TEXT and it is possible it will be selected to be part of the index

Well, how big are the values in that field? If small, change it to VARCHAR and declare an INDEX.

> MyISAM engine support full text search

FULLTEXT is useful for searching for English words in the middle of fields. Is that what you are doing?

InnoDB, in 5.6, has FULLTEXT.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: How to resolve this issue with the mySQL engine?
1388
September 14, 2013 12:12PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.