MySQL Forums
Forum List  »  Full-Text Search

MySQL hangs with 100% CPU (Full text search - Windows)
Posted by: JJWR
Date: February 22, 2005 03:32AM

I run MySQL version 4.1.10 on Windows 2003 Server with a UTF8 table having a fulltext search index on a field (besides other normal indexes). The table has about 700.000 records, and the fulltext indexed field has about 5-10 words for each record. I am using my own stop words file.

MySQL receives about 10-20 fulltext queries per minute and the fulltext queries run very fast, but suddenly MySQL start to use 100% CPU forever. Looking at the running threads when MySQL is hanged I can see a thread in state “FULLTEXT INITILIZATION” and many other threads with fulltext querys in “LOCKED” state. It happens about 10 times at day.

Repair table or drop the full text index and create again does not help.

After restarting the server all works again.

I hope someone can help me.

Options: ReplyQuote

Written By
MySQL hangs with 100% CPU (Full text search - Windows)
February 22, 2005 03:32AM

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.