Skip to content

Disable auto analyze will cause mysql.tidb_ddl_notifier can't clear #64038

@lance6716

Description

@lance6716

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

use tagged playground to easily restart 😉

tiup playground v8.5.3 --tiflash 0 --without-monitor -T tmp
mysql --host 127.0.0.1 --port 4000 -u root -e 'set global tidb_enable_auto_analyze = OFF;'

restart tiup playground

tiup playground v8.5.3 --tiflash 0 --without-monitor -T tmp
$ mysql --host 127.0.0.1 --port 4000 -u root
...
mysql> select * from mysql.tidb_ddl_notifier;
Empty set (0.005 sec)

mysql> create table test.t (c int key);
Query OK, 0 rows affected (54.599 sec)

mysql> select * from mysql.tidb_ddl_notifier;
...
1 row in set (0.002 sec)

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

no rows in mysql.tidb_ddl_notifier table

3. What did you see instead (Required)

1 rows in mysql.tidb_ddl_notifier table

4. What is your TiDB version? (Required)

v8.5.3 and master

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions