execute “show full tables from schema like table_name” slowly
- Dominant language
- Go
- Stars
- 40.5k
- Forks
- 6.2k
- PR merge metrics
- PR metrics pending
Description
## Bug Report TiDB 8.5.3
execute “show full tables from schema like table_name” ,It takes 0.46 s for TiDB to return,MySQL is 0.01s;The entire database contains 3000 tables, and initialization takes a long time,MySQL only takes a few minutes;


After executing this statement, the expected result is consistent with MySQL;
set @@global.tidb_schema_cache_size=0

question:
Doesn't TiDB cache metadata? When global.tidb_schema_cache_size is not 0, will the returned results meet expectations
Contributor guide
Assessment
This issue has not been assessed yet.