MySQL Forums
Forum List  »  Full-Text Search

Double Quotes and Full-Text Search -- Memory Exhaustion
Posted by: techupin techu
Date: March 18, 2015 07:30AM


I have a table with approximately 4 million rows. The DB Engine is InnoDB.

One of the columns is a Full-Text Index.

when I do a match(X) against ('Y')... I get the results.

when I do a match(X) against ('"Y"')... the memory gets exhausted and I get an error

``ERROR 2013 (HY000): Lost connection to MySQL server during query''

the reason for using double quotes in my against phrase is that I actually have a do a match against two consecutive words, .e.g., against('"food chain"').

I tried fiddling with the max_allowed_packet with different values in the increasing order, but no luck.

Any help greatly appreciated.



Options: ReplyQuote

Written By
Double Quotes and Full-Text Search -- Memory Exhaustion
March 18, 2015 07:30AM

Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

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.