MySQL Forums
Forum List  »  Performance

Hyphen in FULLTEXT
Posted by: Mikko L
Date: November 16, 2023 03:19PM

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)

Options: ReplyQuote


Subject
Views
Written By
Posted
Hyphen in FULLTEXT
151
November 16, 2023 03:19PM
92
November 16, 2023 08:12PM
68
November 18, 2023 10:56AM
71
November 20, 2023 12:12PM


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.