Waiting for table metadata lock问题的解决
来源:互联网 发布:appstore更新不了软件 编辑:程序博客网 时间:2024/04/30 02:04
session1:
mysql> start transaction ;
Query OK, 0 rows affected (0.00 sec)
mysql> select * from t2;
+----+------+------+------+------+
| id | a | b | c | e |
+----+------+------+------+------+
| 0 | 0 | NULL | 0 | 0 |
| 1 | 1 | 1 | 1 | 1 |
| 2 | 2 | 1 | 2 | 2 |
| 3 | 3 | 1 | 1 | 3 |
| 4 | 4 | 2 | 1 | 4 |
| 5 | 5 | 2 | 2 | 5 |
| 6 | 6 | 1 | 1 | 6 |
| 7 | 7 | 2 | 2 | 7 |
| 8 | 8 | 3 | 3 | 8 |
| 9 | 9 | 4 | 5 | NULL |
+----+------+------+------+------+
10 rows in set (0.03 sec)
mysql> select * from t3;
+----+------+------+------+------+
| id | a | b | c | e |
+----+------+------+------+------+
| 0 | 0 | NULL | 0 | 0 |
| 1 | 1 | 1 | 1 | 1 |
| 2 | 2 | 1 | 2 | 2 |
| 3 | 3 | 1 | 1 | 3 |
| 4 | 4 | 2 | 1 | 4 |
| 5 | 5 | 2 | 2 | 5 |
| 6 | 6 | 1 | 1 | 6 |
| 8 | 8 | 3 | 3 | 8 |
| 9 | 9 | 4 | 5 | NULL |
+----+------+------+------+------+
9 rows in set (0.04 sec)
session2:
mysql> drop table t2;
session3:
mysql> show processlist;
+----+------+-----------+------+---------+------+---------------------------------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+------+-----------+------+---------+------+---------------------------------+------------------+
| 9 | root | localhost | test | Sleep | 122 | | NULL |
| 10 | root | localhost | test | Query | 49 | Waiting for table metadata lock | drop table t2 |
| 11 | root | localhost | NULL | Query | 0 | init | show processlist |
+----+------+-----------+------+---------+------+---------------------------------+------------------+
3 rows in set (0.01 sec)
session1:
mysql> commit;
Query OK, 0 rows affected (0.00 sec)
session3:
mysql> show processlist;
+----+------+-----------+------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+------+-----------+------+---------+------+-------+------------------+
| 9 | root | localhost | test | Sleep | 30 | | NULL |
| 10 | root | localhost | test | Sleep | 202 | | NULL |
| 11 | root | localhost | NULL | Query | 0 | init | show processlist |
+----+------+-----------+------+---------+------+-------+------------------+
3 rows in set (0.00 sec)
0 0
- Waiting for table metadata lock问题的解决
- Waiting for table metadata lock
- Waiting for table metadata lock
- Waiting for table metadata lock
- Waiting for table metadata lock
- drop表提示Waiting for table metadata lock 解决
- waiting for table metadata lock 问题深入分析
- 一次关于Waiting for table metadata lock的处理
- MySQL出现Waiting for table metadata lock的场景浅析
- 一次Waiting for table metadata lock的处理
- MySQL出现Waiting for table metadata lock的场景浅析
- mysql-之Waiting for table metadata lock
- 记一次Waiting for table metadata lock
- mysql Waiting for table metadata lock
- Hive 元数据“waiting for table metadata lock”
- mysql AWS 性能监控案例 Waiting for table metadata lock
- mysql ALTER TBALE出现waiting for table metadata lock错误
- MySQL DDL中碰到Waiting for table metadata lock
- PHP 性能分析与实验(二)——PHP 性能的微观分析
- LeetCode----First Missing Positive
- 可解锁当前VMware workstation Pro 12.0.0创建好os x10的虚拟机 亲测
- 用AjaxPro实现二级联动
- C# 获取系统时间及时间格式
- Waiting for table metadata lock问题的解决
- 数据结构 列表
- 动态规划解决找零钱问题
- Eclipse使用--奇淫技巧
- 今生,只想做一个平凡的人
- iOS开发 之数组初解
- 代码面试最常用的10大算法
- 获取Windwos的版本和名称 -- GetVersion|GetVersionEx
- iOS远程推送之使用极光推送