blank的编程之路


  • 首页

  • 归档

  • 搜索
consul atomikos mybatisplus druid nexus nas named bind mysqldump acme.sh Dockerfile rsync keepalived swarm kibana ubuntu linux scp bugfix https ssl certbot curl gogs adminer harbor yum portainer python kubernetes idea java springboot maven docker-compose redis nginx mysql brew git chocolatey jenkins elasticsearch docker haproxy rabbitmq centos

mysql 的锁等待超时解决 [mysql Lock wait timeout execeded; try restarting transaction]

发表于 2019-07-29 | 分类于 运维 | 0 | 阅读次数 692

mysql Lock wait timeout execeded; try restarting transaction

1

SELECT trx_id, trx_requested_lock_id, trx_mysql_thread_id, trx_query FROM information_schema.innodb_trx WHERE trx_state = 'LOCK WAIT';

kill {trx_mysql_thread_id}

编辑 mysql 配置文件 添加/修改 innodb_lock_wait_timeout = 500

vim /etc/my.cnf

3

重启 mysql

systemctl restart mysqld

4

  • 本文作者: blank
  • 本文链接: https://blankhang.com/2019/07/29/mysql 的锁等待超时解决[
  • 版权声明: 本博客所有文章除特别声明外,均采用CC BY-NC-SA 3.0 许可协议。转载请注明出处!
# consul # atomikos # mybatisplus # druid # nexus # nas # named # bind # mysqldump # acme.sh # Dockerfile # rsync # keepalived # swarm # kibana # ubuntu # linux # scp # bugfix # https # ssl # certbot # curl # gogs # adminer # harbor # yum # portainer # python # kubernetes # idea # java # springboot # maven # docker-compose # redis # nginx # mysql # brew # git # chocolatey # jenkins # elasticsearch # docker # haproxy # rabbitmq # centos
docker 镜像运行时 时区问题解决
不小心执行 rm -f,先别忙着跑路 转载自 justmine
© 2022 blank
Everything is energy and everything has a frequency