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

get a quicker startup with -A

sunyang@127:~$ mysql -uroot -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6133
Server version: 5.5.62-0ubuntu0.14.04.1 (Ubuntu)

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| alex               |
| bill               |
| cheng              |
| karat              |
| karat_earth        |
| karat_lollicup     |
| magento            |
| mysql              |
| performance_schema |
| php_bb             |
| phpmyadmin         |
| sun                |
| teazone            |
+--------------------+
14 rows in set (0.00 sec)

mysql> use sun;
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

出现上述 : xxxxxxxxxxxxxxxxx with -A 的原因是

我们进入mysql 时,没有使用-A参数;

       即我们使用

           mysql -uusername -ppassword -hhostname -Pport 的方式进入数据,

而没有使用

           mysql -uusername -ppassword -hhostname -Pport  -A的方式进入数据库。

 当数据库比较庞大的时候,我们打开数据库,即use dbname时,要预读数据库信息,这样系统会出现卡顿问题,当使用-A参数时,就不预读数据库信息。

MariaDB [(none)]> use laravel -A;

Reading table information for completion of table and column names,

下面是参考例子:

不加参数-A 效果
添加参数-A的效果