2014年1月10日
mysql deadlock处理
摘要： 1、SHOW ENGINE INNODB STATUS得到最后一次死锁发生的状况=====================================140110 11:43:07 INNODB MONITOR OUTPUT=====================================Per second averages calculated from the last 54 seconds-----------------BACKGROUND THREAD-----------------srv_master_thread loops: 5037089 1_second, 阅读全文
posted @ 2014-01-10 11:53 Django's blog 阅读(1158) 评论(0) 推荐(0)
How to Cope with Deadlocks
摘要： http://dev.mysql.com/doc/refman/5.0/en/innodb-deadlocks.htmlHow to Cope with DeadlocksThis section builds on the conceptual information about deadlocks inSection14.2.7.8, “Deadlock Detection and Rollback”. It explains how to organize database operations to minimize deadlocks and the subsequent error 阅读全文
posted @ 2014-01-10 11:16 Django's blog 阅读(875) 评论(0) 推荐(0)