RE: Understanding Transaction Deadlocks with Innodb

2009-05-26 Thread Michael Caplan
né que les email > peuvent facilement être sujets à la manipulation, nous ne pouvons accepter > aucune responsabilité pour le contenu fourni. > > > > > > > Subject: Understanding Transaction Deadlocks with Innodb > > From: michael.cap...@henryschein.com > > To: mysql@list

Understanding Transaction Deadlocks with Innodb

2009-05-25 Thread Michael Caplan
Hi there, I am trying to sort through an occasional problem I am having with deadlocks I am facing with a series of inoodb tables: cases (PK id) |___ cases_workcodes (PK id, case_id / FK case_id) |___ cases_invoices (PK id, case_id / FK case_id) |___ cases_additional (PK id, case_id / FK case_