见到 MySQL 死锁了

最新推荐文章于 2024-12-19 19:12:37 发布

最新推荐文章于 2024-12-19 19:12:37 发布 · 154 阅读

文章标签：

#MySQL #SQL

难道这就是传说中的数据库死锁？

mysql> show PROCESSLIST \G
*************************** 1. row ***************************
     Id: 1
   User: root
   Host: localhost:2792
     db: stock
Command: Query
   Time: 303
  State: Waiting for table metadata lock
   Info: drop table stockinfo20110315
*************************** 2. row ***************************
     Id: 2
   User: root
   Host: localhost:2850
     db: NULL
Command: Sleep
   Time: 398
  State:
   Info: NULL
*************************** 3. row ***************************
     Id: 4
   User: root
   Host: localhost:2852
     db: stock
Command: Query
   Time: 222
  State: Waiting for table metadata lock
   Info: DROP TABLE `stockinfo20110315`
*************************** 4. row ***************************
     Id: 6
   User: root
   Host: localhost:2854
     db: stock
Command: Query
   Time: 237
  State: Waiting for table metadata lock
   Info: drop table stockinfo20110315
*************************** 5. row ***************************
     Id: 8
   User: root
   Host: localhost:2856
     db: stock
Command: Query
   Time: 92
  State: Waiting for table metadata lock
   Info: select * from stockinfo20110315
*************************** 6. row ***************************
     Id: 10
   User: root
   Host: localhost:2858
     db: stock
Command: Query
   Time: 187
  State: Waiting for table metadata lock
   Info: DROP TABLE `stockinfo20110315`
*************************** 7. row ***************************
     Id: 12
   User: root
   Host: localhost:2869
     db: NULL
Command: Query
   Time: 0
  State: NULL
   Info: show PROCESSLIST
7 rows in set (0.00 sec)