Host '10.0.2.2' is not allowed to connect to this MariaDB server

Waiting for table metadata lock解锁

妙音 posted @ 2014年11月20日 16:53 in mysql , 5413 阅读
在用alter修改mysql表结构时,可能出现一直在执行中. 这个时候可能就是因为锁表了.
  • 查看锁表 
show processlist 
Id User Host db Command Time State Info
3367062 root 192.168.10.114:61503 pkPlatform Sleep 5444 \N
3572758 root 192.168.10.116:51713 pkPlatform Sleep 9348 \N
...
  • 锁表提示
State子段出现: Waiting for table metadata lock表明存在锁表
  • 解锁
kill 3631200  --(3631200为Id字段值)
 
Avatar_small
John 111 说:
2021年3月16日 14:16

We have sell some products of different custom boxes.it is very useful and very low price please visits this site thanks and please share this post with your friends. his comment is here

Avatar_small
John 111 说:
2021年4月08日 14:50

Wow! Such an amazing and helpful post this is. I really really love it. It's so good and so awesome. I am just amazed. I hope that you continue to do your work like this in the future also testosterone booster

Avatar_small
Digital Ali 说:
2021年9月06日 15:40

This is my first time visit to your blog and I am very interested in the articles that you serve. Provide enough knowledge for me. Thank you for sharing useful and don't forget, keep sharing useful info: movies123


登录 *


loading captcha image...
(输入验证码)
or Ctrl+Enter