Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

response time is much higher than max_query_time #1980

Closed
klirichek opened this issue Mar 19, 2024 · 0 comments
Closed

response time is much higher than max_query_time #1980

klirichek opened this issue Mar 19, 2024 · 0 comments
Assignees
Labels
bug rel::upcoming Upcoming release

Comments

@klirichek
Copy link
Contributor

mysql> select * from name where match('ов') option max_query_time=1000; show meta;
ERROR 1064 (42000): table name:
+----------------+--------------+
| Variable_name  | Value        |
+----------------+--------------+
| error          | table name:  |
| warning        | query error  |
| total          | 0            |
| total_found    | 0            |
| total_relation | eq           |
| time           | 6.415        |
| keyword[0]     | *ов*         |
| docs[0]        | 58369715     |
| hits[0]        | 58369715     |
| keyword[1]     | ов           |
| docs[1]        | 0            |
| hits[1]        | 0            |
+----------------+--------------+
12 rows in set (0.00 sec)

(index is located on our dev server and contains huge set of names. Here it is visible that having max_query_time set to 1000, it actually returned after 6415ms)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug rel::upcoming Upcoming release
Projects
None yet
Development

No branches or pull requests

2 participants