subject:"MySQL locking problem"

Re: MySQL locking problem

2010-10-15 Thread Tom Evans

SHOW FULL PROCESSLIST; EXPLAIN ; On Thu, Oct 14, 2010 at 6:02 PM, Nick Arnett wrote: > I am having a problem with locking on MySQL and can't quite figure out > what's causing it. Although I have some scripts that do raw SQL, none of > them are running, I see no other

MySQL locking problem

2010-10-14 Thread Nick Arnett

I am having a problem with locking on MySQL and can't quite figure out what's causing it. Although I have some scripts that do raw SQL, none of them are running, I see no other transactions in the process list, yet when I call save() on one of my objects, the transaction locks, seemingly forever.