Shulou(Shulou.com)06/01 Report--

Mysql-A does not pre-read database information (use dbname is faster)-Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with-A

Mysql > use dbname

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with-A

After giving way, it gets stuck here.

The reason why it gets stuck is:

It is because the database is too large, that is, there are many tables in the database, so if you pre-read the database information, it will be very slow, so it will be stuck, if there are very few tables in the database, there will be no problem.

The reasons for the problems are:

When we entered mysql, we did not use the-A parameter

That is, we use

Enter data by mysql-hhostname-uusername-ppassword-Pport

Without using it.

Enter the database by mysql-hhostname-uusername-ppassword-Pport-A.

When we open the database, that is, use dbname, we pre-read the database information, and when we use the-A parameter, we do not pre-read the database information.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.