MySQL Forums
Forum List  »  Full-Text Search

Re: Full-text crash mySql
Posted by: Nick Mott
Date: March 16, 2005 02:27AM

I have the same problem too:

I have tried various releases of mySQL and all crash unpredictably: 4.0.2a, 4.1.8. The problem also is duplicated on my hosts server too. I can run about 1000 successful queries before it crashes.

Here is an example of a query that causes a problem. It works fine normally though:

SELECT search_index.search_ID, search_index.search_table, search_index.search_title, search_index.search_text,
MATCH (search_title, search_text) AGAINST ("Obstetrics Gynaecologyhttp cmf org search searches") AS relevance
FROM search_index
WHERE
(
MATCH (search_title, search_text) AGAINST ("Obstetrics")
AND
MATCH (search_title, search_text) AGAINST ("Gynaecologyhttp")
AND
MATCH (search_title, search_text) AGAINST ("cmf")
AND
MATCH (search_title, search_text) AGAINST ("org")
AND
MATCH (search_title, search_text) AGAINST ("search searches")
)
ORDER BY relevance DESC;

Nick Mott

music for the soul: www.fromabrokenheart.com

Options: ReplyQuote


Subject
Views
Written By
Posted
4674
January 22, 2005 03:38PM
2959
February 04, 2005 07:01AM
2912
February 17, 2005 12:57AM
Re: Full-text crash mySql
2906
March 16, 2005 02:27AM
2951
March 23, 2005 05:49AM


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.