Is there a scheduled job in the TiDB cluster every Saturday at 11 AM that causes cluster operations to be unstable, resulting in a failure every 7 days?

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: 请问每周六上午11点,TIDB集群是否有定时作业,导致集群操作不稳定,每隔7天故障一次

| username: francislee

May I ask if there is a scheduled job in the TiDB cluster every Saturday at 11 AM that causes cluster operations to be unstable, resulting in failures every 7 days, with some TiKV IO being very high, many slow query table analysis statements, and particularly high memory usage?

| username: 张雨齐0720 | Original post link

Find the IP that initiated the SQL from the logs, and then identify whose cause it is.

| username: 托马斯滑板鞋 | Original post link

In the past 7 days, have there been a large number of table deletions or DDL operations in the business?
Also, what are the values of these parameters:
tidb_auto_analyze_ratio
tidb_auto_analyze_start_time
tidb_auto_analyze_end_time

| username: zhimadi | Original post link

List the execution username and client address to take a look.

| username: francislee | Original post link

There are no large table deletion operations or DLL.
tidb_auto_analyze_ratio
tidb_auto_analyze_start_time
tidb_auto_analyze_end_time
These three parameters are all default values.

| username: francislee | Original post link

The IPs initiating without SQL are all internal.

| username: francislee | Original post link

The image you provided is not accessible. Please provide the text you need translated.

| username: 托马斯滑板鞋 | Original post link

The source code contains the relevant steps for clearing statistics.
Source code link
It seems to be caused by the periodic update of statistics?

| username: francislee | Original post link

Okay, thank you, :handshake: I’ll check if the information above is okay.

| username: jansu-dev | Original post link

Analyze maxes out the IO. Follow this idea to adjust the parameters (regarding analyze), or upgrade the hardware.

| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.