首先查看当前binlog位点文件，记录下当前binlog文件编号mysql-bin.000090 mysql> show master status; +------------------+-----------+--------------+------------------+-------------------+ | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set | +------------------+-----------+--------------+------------------+-------------------+ | mysql-bin.000090 | 124426364 | | | | +------------------+-----------+--------------+------------------+-------------------+ 1 row in set (0.00 sec) mysql> 根据sql修改大致时间段.... 基于mysql的binlog还原sql及flashback对应sql语句 mysql
用SchedulingConfigurer接口只能统一修改，要分开控制的话有多少个job就要有多少个实现。比较麻烦 配置线程池ThreadPoolTaskScheduler Copy@Configuration public class JobConfig { @Bean("taskExecutor") public ThreadPoolTaskScheduler taskExecutor() { ThreadPoolTaskScheduler executor = new ThreadPoolTaskScheduler(); executor.setPoolSize(20); executor.setThreadNamePrefix("taskExecutor-"); executor.setWaitForTasksToCompleteOnShutdown(true); executor.setAwaitTerminationSeconds(300); return executor; } } 封装实现 Copy@Component @Slf4j public class Job.... 使用ThreadPoolTaskScheduler动态修改调度时间 java
暴风之鸟