MySQL drop空表时处于Waiting for table metadata lock状态,解决办法
来源:互联网 发布:怎么可以微信扫淘宝店 编辑:程序博客网 时间:2024/05/16 12:46
#将以下语句修改一下后复制粘贴到linux命令行
方法1:
alias db_conn="mysql -h 127.0.0.1 -uroot -proot@123 -P 3320"
db_conn -ss -e "select concat(\"kill \",b.ID,\";\") as kill_id from information_schema.INNODB_TRX a,information_schema.PROCESSLIST b where a.trx_mysql_thread_id=b.ID and a.trx_state='RUNNING' and b.TIME >=30; "|db_conn
方法2:
alias db_conn="mysql -h 127.0.0.1 -uroot -proot@123 -P3320"
db_conn -ss -e "selectconcat(\"kill \",trx_mysql_thread_id,\";\") as kill_id frominformation_schema.INNODB_TRX where trx_lock_structs=0 andtrx_weight=0 and trx_rows_locked=0 and trx_rows_modified=0 andtrx_state='RUNNING';"|db_conn
0 0
- MySQL drop空表时处于Waiting for table metadata lock状态,解决办法
- mysql-之Waiting for table metadata lock
- mysql Waiting for table metadata lock
- drop、delete、truncate、alter表时show processlist出现Waiting for table metadata lock状态
- drop、delete、truncate、alter表时show processlist出现Waiting for table metadata lock状态
- drop表提示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
- MySQL出现Waiting for table metadata lock的场景浅析
- mysql AWS 性能监控案例 Waiting for table metadata lock
- MySQL出现Waiting for table metadata lock的场景浅析
- mysql ALTER TBALE出现waiting for table metadata lock错误
- MySQL DDL中碰到Waiting for table metadata lock
- 记一次Waiting for table metadata lock
- alter table Waiting for table metadata lock, mysql 5.6 看不到锁在哪儿
- mysql出现Waiting for table metadata lock的原因及解决方案
- Mysql insert语句的优化
- MySQL innodb_fast_shutdown参数讲解
- 12个免费学习编程的网站
- MySQL技术内幕InnoDB存储引擎(表&索引算法和锁)
- MySQL InnoDB小结
- MySQL drop空表时处于Waiting for table metadata lock状态,解决办法
- Android 编程下 Touch 事件的分发和消费机制
- 工作中使用的mysqldunp命令
- mysqlrplms(实现mysql一主多从)工具
- Server-U服务器的配置(域和用户)备份
- mysql数据库安装
- MySQL InnoDB存储引擎详解
- 【转载】mysql权限管理
- 导出mysql表的部分记录