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
366
November 16, 2023 03:19PM
464
November 16, 2023 08:12PM
222
November 18, 2023 10:56AM
227
November 20, 2023 12:12PM


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.