mysql> use mydb
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
一般产生这个问题是由于MYSQL中数据库太大,导致读取预读时间太长,从而显示这个提示,如果之前都没有遇到这个问题,
那么产生这个问题的原因可能是由于有改变数据库信息的操作,比如drop一个很大的表(几千万数据)而中途终止.
先查看当前的进程情况,:
mysql> show processlist;
+-----+---------+-----------------+--------+------------+-------+---------------------------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-----+---------+-----------------+--------+------------+-------+---------------------------------+------------------------------------------------------------------------------------------------------+
| 95 | MS_data | 127.0.0.1:47236 | Wumart | Query | 16165 | Sending data | CREATE TABLE temp_20150326a AS
SELECT a.*,b.U课描述 商品分类 FROM vipsale_2010 a LEFT OUTER |
| 104 | MS_data | 127.0.0.1:47245 | NULL | Sleep | 10584 | | NULL |
| 112 | MS_data | 127.0.0.1:47253 | NULL | Sleep | 7767 | | NULL |
| 113 | MS_data | 127.0.0.1:47254 | Wumart | Sleep | 7733 | | NULL |
| 123 | MS_data | 127.0.0.1:47261 | NULL | Sleep | 7388 | | NULL |
| 124 | MS_data | 127.0.0.1:47262 | Wumart | Sleep | 7384 | | NULL |
| 127 | root | localhost | Wumart | Field List | 253 | Waiting for table metadata lock | |
| 130 | root | localhost | Wumart | Query | 0 | NULL | show processlist |
+-----+---------+-----------------+--------+------------+-------+---------------------------------+------------------------------------------------------------------------------------------------------+
8 rows in set (0.00 sec)
mysql> kill 95
-> ;
Query OK, 0 rows affected (0.00 sec)
mysql> show processlist;
+-----+---------+-----------------+--------+---------+-------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-----+---------+-----------------+--------+---------+-------+-------+------------------+
| 104 | MS_data | 127.0.0.1:47245 | NULL | Sleep | 10601 | | NULL |
| 112 | MS_data | 127.0.0.1:47253 | NULL | Sleep | 7784 | | NULL |
| 113 | MS_data | 127.0.0.1:47254 | Wumart | Sleep | 7750 | | NULL |
| 123 | MS_data | 127.0.0.1:47261 | NULL | Sleep | 7405 | | NULL |
| 124 | MS_data | 127.0.0.1:47262 | Wumart | Sleep | 7401 | | NULL |
| 130 | root | localhost | Wumart | Query | 0 | NULL | show processlist |
+-----+---------+-----------------+--------+---------+-------+-------+------------------+
6 rows in set (0.00 sec)
mysql> use mydb
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>
删除这些锁表的情况,我的mysql就能正常访问了.
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
一般产生这个问题是由于MYSQL中数据库太大,导致读取预读时间太长,从而显示这个提示,如果之前都没有遇到这个问题,
那么产生这个问题的原因可能是由于有改变数据库信息的操作,比如drop一个很大的表(几千万数据)而中途终止.
先查看当前的进程情况,:
mysql> show processlist;
+-----+---------+-----------------+--------+------------+-------+---------------------------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-----+---------+-----------------+--------+------------+-------+---------------------------------+------------------------------------------------------------------------------------------------------+
| 95 | MS_data | 127.0.0.1:47236 | Wumart | Query | 16165 | Sending data | CREATE TABLE temp_20150326a AS
SELECT a.*,b.U课描述 商品分类 FROM vipsale_2010 a LEFT OUTER |
| 104 | MS_data | 127.0.0.1:47245 | NULL | Sleep | 10584 | | NULL |
| 112 | MS_data | 127.0.0.1:47253 | NULL | Sleep | 7767 | | NULL |
| 113 | MS_data | 127.0.0.1:47254 | Wumart | Sleep | 7733 | | NULL |
| 123 | MS_data | 127.0.0.1:47261 | NULL | Sleep | 7388 | | NULL |
| 124 | MS_data | 127.0.0.1:47262 | Wumart | Sleep | 7384 | | NULL |
| 127 | root | localhost | Wumart | Field List | 253 | Waiting for table metadata lock | |
| 130 | root | localhost | Wumart | Query | 0 | NULL | show processlist |
+-----+---------+-----------------+--------+------------+-------+---------------------------------+------------------------------------------------------------------------------------------------------+
8 rows in set (0.00 sec)
mysql> kill 95
-> ;
Query OK, 0 rows affected (0.00 sec)
mysql> show processlist;
+-----+---------+-----------------+--------+---------+-------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-----+---------+-----------------+--------+---------+-------+-------+------------------+
| 104 | MS_data | 127.0.0.1:47245 | NULL | Sleep | 10601 | | NULL |
| 112 | MS_data | 127.0.0.1:47253 | NULL | Sleep | 7784 | | NULL |
| 113 | MS_data | 127.0.0.1:47254 | Wumart | Sleep | 7750 | | NULL |
| 123 | MS_data | 127.0.0.1:47261 | NULL | Sleep | 7405 | | NULL |
| 124 | MS_data | 127.0.0.1:47262 | Wumart | Sleep | 7401 | | NULL |
| 130 | root | localhost | Wumart | Query | 0 | NULL | show processlist |
+-----+---------+-----------------+--------+---------+-------+-------+------------------+
6 rows in set (0.00 sec)
mysql> use mydb
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>
删除这些锁表的情况,我的mysql就能正常访问了.