Lock wait timeout exceeded; try restarting transaction
来源:互联网 发布:win10qq远程控制mac 编辑:程序博客网 时间:2024/05/09 12:44
可供参考的网址:
http://blog.itpub.net/195110/viewspace-1080898/
You should consider increasing the lock wait timeout value for InnoDB by setting theinnodb_lock_wait_timeout, default is 50 sec
mysql> show variables like 'innodb_lock_wait_timeout';+--------------------------+-------+| Variable_name | Value |+--------------------------+-------+| innodb_lock_wait_timeout | 50 |+--------------------------+-------+1 row in set (0.01 sec)
You can set it to higher value in /etc/my.cnf
permanently with this line
[mysqld]innodb_lock_wait_timeout=120
and restart mysql. If you cannot restart mysql at this time, run this:
SET GLOBAL innodb_lock_wait_timeout = 120;
You could also just set it for the duration of your session
SET innodb_lock_wait_timeout = 120;
0 0
- Lock wait timeout exceeded; try restarting transaction
- Lock wait timeout exceeded; try restarting transaction
- Lock wait timeout exceeded; try restarting transaction
- Lock wait timeout exceeded; try restarting transaction
- Lock wait timeout exceeded; try restarting transaction
- Lock wait timeout exceeded; try restarting transaction
- Lock wait timeout exceeded; try restarting transaction
- Lock wait timeout exceeded; try restarting transaction
- Lock wait timeout exceeded; try restarting transaction
- Lock wait timeout exceeded; try restarting transaction
- mysql : Lock wait timeout exceeded; try restarting transaction
- 1205 Lock wait timeout exceeded try restarting transaction
- mysql错误:Lock wait timeout exceeded; try restarting transaction
- mysql : Lock wait timeout exceeded; try restarting transaction
- ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
- mysql : Lock wait timeout exceeded; try restarting transaction
- mysql : Lock wait timeout exceeded; try restarting transaction
- lock wait timeout exceeded try restarting transaction mysql
- Thread 线程
- C语言中const和#define的区别
- 【C++】模板类链表
- ActionBar随ScorllView上下拖动而透明度渐变效果
- 【BZOJ】4690 Never Wait for Weights
- Lock wait timeout exceeded; try restarting transaction
- activeMQ 使用 用activeMQ做RPC调用demo
- 关于freecodecamp网站
- JVM,JRE和JDK的区别
- Android之Keystore文件签名(获取查看apk签名)
- Go-Testing
- OSI七层模型简介
- android获取短信验证码并自动填写的实现一
- connect: network is unreachable 问题的解决 eth0的恢复