Hyphen in FULLTEXT

[Mikko L]

Table have 26 milj rows, 2,3GiB (simple key, value table). InnoDB.

When i do query with hyphen, query is really slow (3sec). Every other query run smootly. What can I do to fix this?

Examples:

SELECT value FROM tablename WHERE MATCH(value) AGAINST ('"978-951-1-47590-3"' IN BOOLEAN MODE) LIMIT 1;
+-------------------+
| value |
+-------------------+
| 978-951-1-47590-3 |
+-------------------+
1 row in set (2.908 sec)

SELECT value FROM tablename WHERE MATCH(value) AGAINST ('"9789511475903"' IN BOOLEAN MODE) LIMIT 1;
+---------------+
| value |
+---------------+
| 9789511475903 |
+---------------+
1 row in set (0.025 sec)

SELECT value FROM tablename WHERE MATCH(value) AGAINST ('"Parhaat neuvot sadan vuoden takaa."' IN BOOLEAN MODE) LIMIT 1;
+------------------------------------+
| value |
+------------------------------------+
| Parhaat neuvot sadan vuoden takaa. |
+------------------------------------+
1 row in set (0.001 sec)