定时采集指定表索引

//设置数据开启定时任务 一般默认时开启的 SET GLOBAL event_scheduler = ON; //定时任务创建 CREATE EVENT ev_index_snapshot_daily ON SCHEDULE EVERY 1 DAY STARTS '2025-12-11 14:00:00' COMMENT '每天14:00采集索引快照' DO INSERT INTO snakeadmin.index_usage_snapshot (snap_time, table_schema, table_name, index_name, rows_read, scan_used) SELECT NOW(), TABLE_SCHEMA, TABLE_NAME, INDEX_NAME, ROWS_READ, SCAN_USED FROM information_schema.INDEX_STATISTICS WHERE TABLE_SCHEMA = 'snakeadmin' AND TABLE_NAME IN ('snake_pack_2020', 'snake_goods_2020', 'snake_account_log', 'snake_admin_log_2020'); //查询定时任务 SHOW EVENTS FROM snakeadmin; //删除指定定时任务 DROP EVENT IF EXISTS ev_index_snapshot_daily;