<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/chixie7691</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; chixie7691]]></copyright><item><title><![CDATA[数据库死锁问题解决]]></title><link>https://blog.youkuaiyun.com/chixie7691/article/details/100649508</link><guid>https://blog.youkuaiyun.com/chixie7691/article/details/100649508</guid><author>chixie7691</author><pubDate>Sat, 31 Aug 2019 10:47:00 +0800</pubDate><description><![CDATA[数据库执行超时处理办法
一般数据库执行超时
尝试以下方法
显示所有活跃连接
SHOW FULL PROCESSLIST

查询数据库死锁
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS; 

lock_id：锁 ID。
lock_trx_id：拥有锁...]]></description><category></category></item></channel></rss>