20181221.sql 319 B

123456789
  1. -- 优化定时任务执行时间(统计流量)
  2. ALTER TABLE `user_traffic_log`
  3. DROP INDEX `idx_user`,
  4. DROP INDEX `idx_node`;
  5. ALTER TABLE `user_traffic_log`
  6. DROP INDEX `idx_user_node`,
  7. ADD INDEX `idx_user_node` (`user_id`, `log_time`, `node_id`) USING BTREE,
  8. ADD INDEX `idx_node_time` (`node_id`, `log_time`);