带LOW_PRIORITY SQL_NO_CACHE 支持CREATE GLOBAL BINDING?我试了下不行
去掉后
CREATE GLOBAL BINDING FOR SELECT
id
FROM
soa_vehicle
.t_track_ride_detail
WHERE
id
>= ?
AND id
< ?
AND create_time
< FROM_UNIXTIME(?) ORDER BY id
ASC LIMIT 500
USING
SELECT /+ use_index(soa_vehicle
.t_track_ride_detail
, feng
)/ id
FROM soa_vehicle
.t_track_ride_detail
WHERE id
>= ?
AND id
< ?
AND create_time
< FROM_UNIXTIME(?)
ORDER BY
id
ASC
LIMIT 500; 创建是成功了
但是匹配不了 select LOW_PRIORITY SQL_NO_CACHE id
FROM soa_vehicle
.t_track_ride_detail
WHERE id
>= 69546507906 AND id
< 159985579717 AND create_time
< FROM_UNIXTIME(1627146194) ORDER BY id
ASC LIMIT 500;