› NGINX
› NGINX Trac
› 3rd Party Modules
› Security Advisories
› CHANGES
› OpenResty
› ngx_lua
› Tengine
在线学习资源
› NGINX 开发从入门到精通
NGINX Modules
› ngx_echo
Nginx 经常 502 错误怎么解决？最近报的错误是： Lock wait timeout exceeded; try restarting transaction
ioioioioioioi · Jan 3, 2017 · 3341 viewsThis topic created in 3436 days ago, the information mentioned may be changed or developed.
6 replies • 2017-01-03 14:58:27 +08:00
 |
1
Mcatt Jan 3, 2017  1
|
 |
2
johnj Jan 3, 2017
这是你应用数据层报的错
|
 |
3
ioioioioioioi OP |
 |
4
aru Jan 3, 2017
优化逻辑，优化 sql
2 万多的数据量很少，你将表结构和 sql 语句发出来看看 |
 |
5
b821025551b Jan 3, 2017
第一反应是死锁了
|
|
6
johnj Jan 3, 2017
@ioioioioioioi 命令行登录 mysql ，然后 show engine innodb status\G; 看一下死锁信息 是哪些语句造成的 然后修改程序
|
Select Language