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.
Subject
Views
Written By
Posted
2466
September 10, 2013 03:07PM
Re: How to resolve this issue with the mySQL engine?
1492
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.