[Bug] use dbname clause cost almost 10s long

[zhangguichuan]

Search before asking

• I had searched in the issues and found no similar issues.

Version

branch: branch-1.1-lts
commit: 844cfce

What's Wrong?

use clause cost almost 10 seconds long, I use ssb dataset to test and other database also meet the problem. and meta data size is small.

mysql> use ssb;
No connection. Trying to reconnect...
Connection id:    95217
Current database: *** NONE ***

Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> 

meta data size:

[root@app1:image_0]# ll -h
total 44M
-rw-r--r-- 1 starcross starcross 21M Nov 12 16:20 image.11627250
-rw-r--r-- 1 starcross starcross 23M Nov 14 13:58 image.11677250
-rw-r--r-- 1 starcross starcross  78 Oct 12 16:19 ROLE
-rw-r--r-- 1 starcross starcross  93 Oct 12 16:19 VERSION

What You Expected?

use ssb; use database; this kind of command should be fast, bu it cost too long

How to Reproduce?

No response

Anything Else?

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct