Re: Befuddled Why This Locks

2006-12-22 Thread Dan Nelson
In the last episode (Dec 22), Jason J. W. Williams said: > I guess I'm curious why this query acquires a read lock. Is it > because its in a transaction? Thank you very much in advance! You mean as opposed to a write lock? Only inserts and updates need write locks. Or do you mean why is it lock

Re: Befuddled Why This Locks

2006-12-22 Thread Jason J. W. Williams
Hi Dan, I guess I'm curious why this query acquires a read lock. Is it because its in a transaction? Thank you very much in advance! -J On 12/22/06, Dan Nelson <[EMAIL PROTECTED]> wrote: In the last episode (Dec 21), Jason J. W. Williams said: > If someone could suggest some advice/guidance I

Re: rhel4 mysql max rpm question

2006-12-22 Thread Joerg Bruehe
Hi Yong, all, Yong Lee wrote: Hi All, I noticed that there are RPM downloads for RHEL4 but that these do not contain the ndb storage engine (ie: these are standard builds). As such, I've resolved to just use the generic x86 rpm bundles that are offered but I'm curious if the ndb storage e

Re: Befuddled Why This Locks

2006-12-22 Thread Dan Nelson
In the last episode (Dec 21), Jason J. W. Williams said: > If someone could suggest some advice/guidance I would be very > grateful. I'm trying to determine why the following SELECT query > table locks the "bad_behavior" table referenced the query. > > 'bad_behavior' is MyISAM > 'c' is InnoDB > 'a