ttl定时删除数据非常慢,执行计划看没有走索引

带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;