After using BR restore the table, the stats_healthy is 100.

[winoros]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

Using br to restore a table without stats.

2. What did you expect to see? (Required)

The show stats_heathy tells us the table's statistics is not in a good situation so we can auto analyze it soon.

3. What did you see instead (Required)

The show stats_healthy tells us the table's healthy rate is 100%.

4. What is your TiDB version? (Required)

Current master

[xuyifangreeneyes]

/assign

[Rustin170506]

Tested locally:

1. Backup some tables with: tiup br backup full --pd "127.0.0.1:2379" --storage "s3://qe-testing/kernel-testing/xxxx/testdata/sbtest500rustin/?access-key=xxxxx&secret-access-key=xxxx&endpoint=http%3a%2f%2fks3-cn-xxxxx-internal.ksyuncs.com&force-path-style=false&region=Beijing&provider=ks" --ignore-stats
2. Start a new TiDB cluster: tiup playground nightly
3. Disable the auto-analyze: set global tidb_enable_auto_analyze = 0
4. Restore: tiup br restore db --pd "127.0.0.1:2379" --db sbtest1 --storage "s3://qe-testing/kernel-testing/xxxxxx/testdata/sbtest500rustin/?access-key=xxx&secret-access-key=xxxx&endpoint=http%3a%2f%2fks3-cn-xxxx-internal.ksyuncs.com&force-path-style=false&region=Beijing&provider=ks"
5. Check the healthy:

MySQL [(none)]> show stats_healthy;
+---------+------------+----------------+---------+
| Db_name | Table_name | Partition_name | Healthy |
+---------+------------+----------------+---------+
| sbtest1 | sbtest10   |                |       0 |
| sbtest1 | sbtest5    |                |       0 |
| sbtest1 | sbtest3    |                |       0 |
| sbtest1 | sbtest2    |                |       0 |
| sbtest1 | sbtest7    |                |       0 |
| sbtest1 | sbtest8    |                |       0 |
| sbtest1 | sbtest6    |                |       0 |
| sbtest1 | sbtest4    |                |       0 |
| sbtest1 | sbtest1    |                |       0 |
| sbtest1 | sbtest9    |                |       0 |
+---------+------------+----------------+---------+
10 rows in set (0.02 sec)

MySQL [(none)]> show stats_meta;
+---------+------------+----------------+---------------------+--------------+-----------+-------------------+
| Db_name | Table_name | Partition_name | Update_time         | Modify_count | Row_count | Last_analyze_time |
+---------+------------+----------------+---------------------+--------------+-----------+-------------------+
| sbtest1 | sbtest10   |                | 2024-04-10 18:19:14 |            0 |   5000000 | NULL              |
| sbtest1 | sbtest5    |                | 2024-04-10 18:19:14 |            0 |   5000000 | NULL              |
| sbtest1 | sbtest3    |                | 2024-04-10 18:19:14 |            0 |   5000000 | NULL              |
| sbtest1 | sbtest4    |                | 2024-04-10 18:19:14 |            0 |   5000000 | NULL              |
| sbtest1 | sbtest1    |                | 2024-04-10 18:19:14 |            0 |   5000000 | NULL              |
| sbtest1 | sbtest9    |                | 2024-04-10 18:19:14 |            0 |   5000000 | NULL              |
| sbtest1 | sbtest2    |                | 2024-04-10 18:19:14 |            0 |   5000000 | NULL              |
| sbtest1 | sbtest7    |                | 2024-04-10 18:19:14 |            0 |   5000000 | NULL              |
| sbtest1 | sbtest8    |                | 2024-04-10 18:19:14 |            0 |   5000000 | NULL              |
| sbtest1 | sbtest6    |                | 2024-04-10 18:19:13 |            0 |   5000000 | NULL              |
+---------+------------+----------------+---------------------+--------------+-----------+-------------------+
10 rows in set (0.00 sec)

[seiya-annie]

/found customer