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,
下面是参考例子:

