mysql故障排查
mysql -h**** -u*** -p*** -P3306 ***
ERROR 1205 (HY000) at line 10208: Lock wait timeout exceeded; try restarting transaction
Solution: Add / modify the parameter TransactionDeadlockDetectionTimeout in config.ini
Default value = 1200 milliseconds
Changed the value to TransactionDeadlockDetectionTimeout=15000
The timeout parameter states how long the transaction coordinator waits for the query execution by another node before aborting the transaction and is important for both node failure handling and deadlock detection.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29665621/viewspace-2082005/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
mysql开窗函数
下一篇：
sqoop抽取问题汇总
请登录后发表评论
登录
全部评论
