max_predicted_time не работает. версия 9.3.2
есть конечно ненулевой вариант, что я не правильно понял дку, если это так, поправьте меня.
mysql> SELECT id FROM tbl WHERE MATCH('*00*') option max_predicted_time=100;
20 rows in set, 1 warning (34.48 sec)
--- 20 out of 16611039 results in 34s 473ms ---
mysql> show warnings;
+---------+------+----------------------------------------------------------------+
| Level | Code | Message |
+---------+------+----------------------------------------------------------------+
| warning | 1000 | table tbl: predicted query time exceeded max_predicted_time |
+---------+------+----------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> SELECT id FROM tbl WHERE MATCH('*00*') option max_query_time=100;
20 rows in set, 1 warning (0.30 sec)
--- 20 out of 122 results in 292ms ---
mysql> show warnings;
+---------+------+--------------------------------------------------+
| Level | Code | Message |
+---------+------+--------------------------------------------------+
| warning | 1000 | table tbl: query time exceeded max_query_time |
+---------+------+--------------------------------------------------+
1 row in set (0.00 sec)