Full Text search with scandic letters crashes MySQL

1
votes

MySQL has lately been crashing often and I've tried to crack down what might cause it.

SHOW PROCESSLIST and mtop show that FULL TEXT queries with scandinavian letters (ÄÖ) are hanging and locking the table.

In the processlist the scandic letters are shown as "?FFFFFFFFFFC3?FFFFFFFFFFA4", so I'm not sure if this is some sort of character encoding problem.

Some example queries that are stuck in the processlist:

SELECT ... FROM comments WHERE (MATCH(word) AGAINST('%l?FFFFFFFFFFC3?FFFFFFFFFFA4pitunkeva*' IN BOOLEAN MODE)

should read 'läpitunkeva'

SELECT idiom FROM idioms WHERE MATCH (idiom) AGAINST ('hymi?ffffffffffc3?ffffffffffb6')

should read 'hymiö'

MySQL - 5.0.51a MyISAM UTF-8

2
mysqlcrashfull-text-searchcharacter

2 Answers

1
votes

This is a MySQL 5.0 bug found here http://bugs.mysql.com/bug.php?id=37067

Seems that MySQL upgrade to 5.1 is the only option.

I haven't found a solution to fix this without upgrading MySQL.

0
votes

Check the character set of your MySQL DB/schema. If it's not set, the default is latin1.

You can check the appropriate charsets in the MySQL docs. But I usually use 'utf8' in general. http://dev.mysql.com/doc/refman/5.1/en/charset-charsets.html