为提高效率，请提供以下信息，问题描述清晰能够更快得到解决：
【 TiDB 使用环境】生产环境 tidb 6.1
不清楚为什么每隔5,10,15分钟会执行这个语句。
select HIGH_PRIORITY table_id, is_index, hist_id, count, repeats, lower_bound, upper_bound, ndv from mysql.stats_buckets order by table_id, is_index, hist_id, bucket_id;
【概述】
通过观察慢查询语句：发现间隔5分钟 有时是10分钟 15分钟会执行下面的语句。
select HIGH_PRIORITY table_id, is_index, hist_id, count, repeats, lower_bound, upper_bound, ndv from mysql.stats_buckets order by table_id, is_index, hist_id, bucket_id;
通过观察linux系统日志tidb每隔5分钟会重启tidb 4000 服务会重启
Aug 18 14:12:00 TIDB-PD1 systemd: tidb-4000.service: main process exited, code=exited, status=2/INVALIDARGUMENT
Aug 18 14:12:00 TIDB-PD1 systemd: Unit tidb-4000.service entered failed state.
Aug 18 14:12:00 TIDB-PD1 systemd: tidb-4000.service failed.
Aug 18 14:12:16 TIDB-PD1 systemd: tidb-4000.service holdoff time over, scheduling restart.
Aug 18 14:12:16 TIDB-PD1 systemd: Stopped tidb service.
Aug 18 14:12:16 TIDB-PD1 systemd: Started tidb service.
Aug 18 14:12:16 TIDB-PD1 bash: [2022/08/18 14:12:16.250 +08:00] [WARN] [config.go:1004] [“Some configuration options should be moved to [instance] section. Please use the latter config options in [instance] instead: (slow-threshold, tidb_slow_log_threshold).”]
Aug 18 14:14:12 TIDB-PD1 kernel: audit: audit_lost=5414193 audit_rate_limit=512 audit_backlog_limit=16384
Aug 18 14:16:51 TIDB-PD1 systemd: tidb-4000.service: main process exited, code=exited, status=2/INVALIDARGUMENT
Aug 18 14:16:51 TIDB-PD1 systemd: Unit tidb-4000.service entered failed state.
Aug 18 14:16:51 TIDB-PD1 systemd: tidb-4000.service failed.
Aug 18 14:17:06 TIDB-PD1 systemd: tidb-4000.service holdoff time over, scheduling restart.
Aug 18 14:17:06 TIDB-PD1 systemd: Stopped tidb service.
Aug 18 14:17:06 TIDB-PD1 systemd: Started tidb service.
Aug 18 14:17:06 TIDB-PD1 bash: [2022/08/18 14:17:06.498 +08:00] [WARN] [config.go:1004] [“Some configuration options should be moved to [instance] section. Please use the latter config options in [instance] instead: (slow-threshold, tidb_slow_log_threshold).”]
Aug 18 14:21:51 TIDB-PD1 systemd: tidb-4000.service: main process exited, code=exited, status=2/INVALIDARGUMENT
Aug 18 14:21:51 TIDB-PD1 systemd: Unit tidb-4000.service entered failed state.
Aug 18 14:21:51 TIDB-PD1 systemd: tidb-4000.service failed.
Aug 18 14:22:06 TIDB-PD1 systemd: tidb-4000.service holdoff time over, scheduling restart.
Aug 18 14:22:06 TIDB-PD1 systemd: Stopped tidb service.
Aug 18 14:22:06 TIDB-PD1 systemd: Started tidb service.
Aug 18 14:22:06 TIDB-PD1 bash: [2022/08/18 14:22:06.755 +08:00] [WARN] [config.go:1004] [“Some configuration options should be moved to [instance] section. Please use the latter config options in [instance] instead: (slow-threshold, tidb_slow_log_threshold).”]
Aug 18 14:24:14 TIDB-PD1 kernel: audit: audit_lost=5414540 audit_rate_limit=512 audit_backlog_limit=16384
Aug 18 14:27:01 TIDB-PD1 systemd: tidb-4000.service: main process exited, code=exited, status=2/INVALIDARGUMENT
Aug 18 14:27:01 TIDB-PD1 systemd: Unit tidb-4000.service entered failed state.
Aug 18 14:27:01 TIDB-PD1 systemd: tidb-4000.service failed.
Aug 18 14:27:16 TIDB-PD1 systemd: tidb-4000.service holdoff time over, scheduling restart.
Aug 18 14:27:16 TIDB-PD1 systemd: Stopped tidb service.
Aug 18 14:27:16 TIDB-PD1 systemd: Started tidb service.
Aug 18 14:27:16 TIDB-PD1 bash: [2022/08/18 14:27:16.754 +08:00] [WARN] [config.go:1004] [“Some configuration options should be moved to [instance] section. Please use the latter config options in [instance] instead: (slow-threshold, tidb_slow_log_threshold).”]
Aug 18 14:31:52 TIDB-PD1 systemd: tidb-4000.service: main process exited, code=exited, status=2/INVALIDARGUMENT
Aug 18 14:31:52 TIDB-PD1 systemd: Unit tidb-4000.service entered failed state.
Aug 18 14:31:52 TIDB-PD1 systemd: tidb-4000.service failed.
Aug 18 14:32:07 TIDB-PD1 systemd: tidb-4000.service holdoff time over, scheduling restart.
Aug 18 14:32:07 TIDB-PD1 systemd: Stopped tidb service.
Aug 18 14:32:07 TIDB-PD1 systemd: Started tidb service.
Aug 18 14:32:08 TIDB-PD1 bash: [2022/08/18 14:32:08.003 +08:00] [WARN] [config.go:1004] [“Some configuration options should be moved to [instance] section. Please use the latter config options in [instance] instead: (slow-threshold, tidb_slow_log_threshold).”]
Aug 18 14:34:16 TIDB-PD1 kernel: audit: audit_lost=5414736 audit_rate_limit=512 audit_backlog_limit=16384
Aug 18 14:36:50 TIDB-PD1 systemd: tidb-4000.service: main process exited, code=exited, status=2/INVALIDARGUMENT
Aug 18 14:36:50 TIDB-PD1 systemd: Unit tidb-4000.service entered failed state.
Aug 18 14:36:50 TIDB-PD1 systemd: tidb-4000.service failed.
Aug 18 14:37:05 TIDB-PD1 systemd: tidb-4000.service holdoff time over, scheduling restart.
Aug 18 14:37:05 TIDB-PD1 systemd: Stopped tidb service.
Aug 18 14:37:05 TIDB-PD1 systemd: Started tidb service.
Aug 18 14:37:05 TIDB-PD1 bash: [2022/08/18 14:37:05.504 +08:00] [WARN] [config.go:1004] [“Some configuration options should be moved to [instance] section. Please use the latter config options in [instance] instead: (slow-threshold, tidb_slow_log_threshold).”]
Aug 18 14:44:08 TIDB-PD1 systemd-logind: New session 6589 of user root.
Aug 18 14:44:08 TIDB-PD1 systemd: Started Session 6589 of user root.
Aug 18 14:44:09 TIDB-PD1 systemd-logind: New session 6590 of user root.
Aug 18 14:44:09 TIDB-PD1 systemd: Started Session 6590 of user root.
Aug 18 14:50:03 TIDB-PD1 systemd-logind: New session 6591 of user root.
Aug 18 14:50:03 TIDB-PD1 systemd: Started Session 6591 of user root.
Aug 18 14:50:03 TIDB-PD1 systemd-logind: New session 6592 of user root.
Aug 18 14:50:03 TIDB-PD1 systemd: Started Session 6592 of user root.
Aug 18 14:51:46 TIDB-PD1 systemd: tidb-4000.service: main process exited, code=exited, status=2/INVALIDARGUMENT
Aug 18 14:51:46 TIDB-PD1 systemd: Unit tidb-4000.service entered failed state.
Aug 18 14:51:46 TIDB-PD1 systemd: tidb-4000.service failed.
Aug 18 14:52:01 TIDB-PD1 systemd: tidb-4000.service holdoff time over, scheduling restart.
Aug 18 14:52:01 TIDB-PD1 systemd: Stopped tidb service.
Aug 18 14:52:01 TIDB-PD1 systemd: Started tidb service.
Aug 18 14:52:01 TIDB-PD1 bash: [2022/08/18 14:52:01.499 +08:00] [WARN] [config.go:1004] [“Some configuration options should be moved to [instance] section. Please use the latter config options in [instance] instead: (slow-threshold, tidb_slow_log_threshold).”]
Aug 18 14:54:19 TIDB-PD1 kernel: audit: audit_lost=5414925 audit_rate_limit=512 audit_backlog_limit=16384
Aug 18 15:01:01 TIDB-PD1 systemd: Started Session 6593 of user root.
Aug 18 15:01:55 TIDB-PD1 systemd: tidb-4000.service: main process exited, code=exited, status=2/INVALIDARGUMENT
Aug 18 15:01:55 TIDB-PD1 systemd: Unit tidb-4000.service entered failed state.
Aug 18 15:01:55 TIDB-PD1 systemd: tidb-4000.service failed.
Aug 18 15:02:10 TIDB-PD1 systemd: tidb-4000.service holdoff time over, scheduling restart.
Aug 18 15:02:10 TIDB-PD1 systemd: Stopped tidb service.
Aug 18 15:02:10 TIDB-PD1 systemd: Started tidb service.
Aug 18 15:02:10 TIDB-PD1 bash: [2022/08/18 15:02:10.248 +08:00] [WARN] [config.go:1004] [“Some configuration options should be moved to [instance] section. Please use the latter config options in [instance] instead: (slow-threshold, tidb_slow_log_threshold).”]
Aug 18 15:02:16 TIDB-PD1 systemd: tidb-4000.service: main process exited, code=exited, status=2/INVALIDARGUMENT
Aug 18 15:02:16 TIDB-PD1 systemd: Unit tidb-4000.service entered failed state.
Aug 18 15:02:16 TIDB-PD1 systemd: tidb-4000.service failed.
Aug 18 15:02:31 TIDB-PD1 systemd: tidb-4000.service holdoff time over, scheduling restart.
Aug 18 15:02:31 TIDB-PD1 systemd: Stopped tidb service.
Aug 18 15:02:31 TIDB-PD1 systemd: Started tidb service.
Aug 18 15:02:31 TIDB-PD1 bash: [2022/08/18 15:02:31.501 +08:00] [WARN] [config.go:1004] [“Some configuration options should be moved to [instance] section. Please use the latter config options in [instance] instead: (slow-threshold, tidb_slow_log_threshold).”]
Aug 18 15:04:21 TIDB-PD1 kernel: audit: audit_lost=5415368 audit_rate_limit=512 audit_backlog_limit=16384
Aug 18 15:06:48 TIDB-PD1 systemd: tidb-4000.service: main process exited, code=exited, status=2/INVALIDARGUMENT
Aug 18 15:06:48 TIDB-PD1 systemd: Unit tidb-4000.service entered failed state.
Aug 18 15:06:48 TIDB-PD1 systemd: tidb-4000.service failed.
Aug 18 15:07:03 TIDB-PD1 systemd: tidb-4000.service holdoff time over, scheduling restart.
Aug 18 15:07:03 TIDB-PD1 systemd: Stopped tidb service.
Aug 18 15:07:03 TIDB-PD1 systemd: Started tidb service.
Aug 18 15:07:03 TIDB-PD1 bash: [2022/08/18 15:07:03.503 +08:00] [WARN] [config.go:1004] [“Some configuration options should be moved to [instance] section. Please use the latter config options in [instance] instead: (slow-threshold, tidb_slow_log_threshold).”]
Aug 18 15:07:08 TIDB-PD1 systemd: tidb-4000.service: main process exited, code=exited, status=2/INVALIDARGUMENT
Aug 18 15:07:08 TIDB-PD1 systemd: Unit tidb-4000.service entered failed state.
Aug 18 15:07:08 TIDB-PD1 systemd: tidb-4000.service failed.
Aug 18 15:07:23 TIDB-PD1 systemd: tidb-4000.service holdoff time over, scheduling restart.
Aug 18 15:07:23 TIDB-PD1 systemd: Stopped tidb service.
Aug 18 15:07:23 TIDB-PD1 systemd: Started tidb service.
Aug 18 15:07:24 TIDB-PD1 bash: [2022/08/18 15:07:24.001 +08:00] [WARN] [config.go:1004] [“Some configuration options should be moved to [instance] section. Please use the latter config options in [instance] instead: (slow-threshold, tidb_slow_log_threshold).”]
Aug 18 15:11:46 TIDB-PD1 systemd: tidb-4000.service: main process exited, code=exited, status=2/INVALIDARGUMENT
Aug 18 15:11:46 TIDB-PD1 systemd: Unit tidb-4000.service entered failed state.
Aug 18 15:11:46 TIDB-PD1 systemd: tidb-4000.service failed.
Aug 18 15:12:01 TIDB-PD1 systemd: tidb-4000.service holdoff time over, scheduling restart.
Aug 18 15:12:01 TIDB-PD1 systemd: Stopped tidb service.
Aug 18 15:12:01 TIDB-PD1 systemd: Started tidb service.
Aug 18 15:12:01 TIDB-PD1 bash: [2022/08/18 15:12:01.754 +08:00] [WARN] [config.go:1004] [“Some configuration options should be moved to [instance] section. Please use the latter config options in [instance] instead: (slow-threshold, tidb_slow_log_threshold).”]
Aug 18 15:14:23 TIDB-PD1 kernel: audit: audit_lost=5415762 audit_rate_limit=512 audit_backlog_limit=16384
Aug 18 15:16:48 TIDB-PD1 systemd: tidb-4000.service: main process exited, code=exited, status=2/INVALIDARGUMENT
Aug 18 15:16:48 TIDB-PD1 systemd: Unit tidb-4000.service entered failed state.
Aug 18 15:16:48 TIDB-PD1 systemd: tidb-4000.service failed.
Aug 18 15:17:03 TIDB-PD1 systemd: tidb-4000.service holdoff time over, scheduling restart.
Aug 18 15:17:03 TIDB-PD1 systemd: Stopped tidb service.
Aug 18 15:17:03 TIDB-PD1 systemd: Started tidb service.
Aug 18 15:17:03 TIDB-PD1 bash: [2022/08/18 15:17:03.504 +08:00] [WARN] [config.go:1004] [“Some configuration options should be moved to [instance] section. Please use the latter config options in [instance] instead: (slow-threshold, tidb_slow_log_threshold).”]
Aug 18 15:17:08 TIDB-PD1 systemd: tidb-4000.service: main process exited, code=exited, status=2/INVALIDARGUMENT
Aug 18 15:17:08 TIDB-PD1 systemd: Unit tidb-4000.service entered failed state.
Aug 18 15:17:08 TIDB-PD1 systemd: tidb-4000.service failed.
Aug 18 15:17:23 TIDB-PD1 systemd: tidb-4000.service holdoff time over, scheduling restart.
Aug 18 15:17:23 TIDB-PD1 systemd: Stopped tidb service.
Aug 18 15:17:23 TIDB-PD1 systemd: Started tidb service.
Aug 18 15:17:23 TIDB-PD1 bash: [2022/08/18 15:17:23.756 +08:00] [WARN] [config.go:1004] [“Some configuration options should be moved to [instance] section. Please use the latter config options in [instance] instead: (slow-threshold, tidb_slow_log_threshold).”]
Aug 18 15:22:15 TIDB-PD1 systemd: tidb-4000.service: main process exited, code=exited, status=2/INVALIDARGUMENT
Aug 18 15:22:15 TIDB-PD1 systemd: Unit tidb-4000.service entered failed state.
Aug 18 15:22:15 TIDB-PD1 systemd: tidb-4000.service failed.
Aug 18 15:22:30 TIDB-PD1 systemd: tidb-4000.service holdoff time over, scheduling restart.
Aug 18 15:22:30 TIDB-PD1 systemd: Stopped tidb service.
Aug 18 15:22:30 TIDB-PD1 systemd: Started tidb service.
Aug 18 15:22:30 TIDB-PD1 bash: [2022/08/18 15:22:30.249 +08:00] [WARN] [config.go:1004] [“Some configuration options should be moved to [instance] section. Please use the latter config options in [instance] instead: (slow-threshold, tidb_slow_log_threshold).”]
Aug 18 15:24:24 TIDB-PD1 kernel: audit: audit_lost=5415998 audit_rate_limit=512 audit_backlog_limit=16384
Aug 18 15:26:52 TIDB-PD1 systemd: tidb-4000.service: main process exited, code=exited, status=2/INVALIDARGUMENT
Aug 18 15:26:52 TIDB-PD1 systemd: Unit tidb-4000.service entered failed state.
Aug 18 15:26:52 TIDB-PD1 systemd: tidb-4000.service failed.
Aug 18 15:27:07 TIDB-PD1 systemd: tidb-4000.service holdoff time over, scheduling restart.
Aug 18 15:27:07 TIDB-PD1 systemd: Stopped tidb service.
Aug 18 15:27:07 TIDB-PD1 systemd: Started tidb service.
Aug 18 15:27:07 TIDB-PD1 bash: [2022/08/18 15:27:07.246 +08:00] [WARN] [config.go:1004] [“Some configuration options should be moved to [instance] section. Please use the latter config options in [instance] instead: (slow-threshold, tidb_slow_log_threshold).”]
【背景】 做过哪些操作
tidb5.3 不停机滚动升级到tidb6.1
【问题】 当前遇到的问题
【TiDB 版本】
tidb6.1
【附件】 相关日志及配置信息
tidb_4000.log (226.8 KB)
若提问为性能优化、故障排查类问题，请下载脚本运行。终端输出的打印结果，请务必全选并复制粘贴上传。
