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_

Transaction Deadlocks

2004-12-01 Thread Emmett Bishop
Howdy all, I've got a series of tables that are used to store a user's session information. The main table is a very simple table that stores a GUID and a last access data-time value. All other tables use the guid as a FK back to this main table. The main table's schema is as follows: CREATE TAB

Transaction Deadlocks

2004-11-15 Thread Emmett Bishop
Howdy all, We have a set of tables in a database that maintain session information of users of a website. Each user's session is identified by a GUID that we generate when they login. As the users perform various operations records are inserted/updated/deleted from these session tables. Some of th