MySQL executes ' use databases; ' Is slow

Problem Description:

In this case, log in to the database to switch the library feel very card, need to wait a few seconds.

Case:

Shell > Mysql-uroot-ppasswordmysql>for-adatabase changedmysql >

# when the tables in the database are relatively large, and the single table is larger, executing this use databases command will be very card (also has a lot to do with machine performance)

Workaround:

# You can then follow the prompts to join the-a parameter

Shell > Mysql-a-uroot-ppasswordmysql> Use databases;database changed

# It's going to be fast and it's going to fly.

Parameter explanation:

-A,--no-auto-         rehash'rehash' to get        table and field completion. This gives a quicker start of        MySQL and disables rehashing on reconnect.

MySQL executes ' use databases; ' Is slow