Re: write lock and sql_cache

2008-03-13 Thread MAS!
I agree. Don't duplicate posts or post to multiple lists. Jump on the IRC channel if you need help right away :-) sorry again, I was not in hurry, but I had a fault on my mailer, since I was trying to send the post from office and from the wrong account.. The query_cache_wlock_invalidat

Re: write lock and sql_cache

2008-03-12 Thread Werner Puschitz
MAS! wrote: > does the "lock table" on MySQL (I'm using 5.0.22 or 5.0.45) works even > for a cached result? > > this is my scenario, (I'm using MyIsam tables) > > thread 1: > LOCK TABLE foo WRITE; > > thread 2: > SELECT * FROM foo ; > (locked) > > thread 1: > UNLOCK TABLES; > > thread 2: > res

Re: write lock and sql_cache

2008-03-12 Thread Baron Schwartz
On Wed, Mar 12, 2008 at 3:22 PM, Daniel Brown <[EMAIL PROTECTED]> wrote: > On Wed, Mar 12, 2008 at 3:15 PM, MAS! <[EMAIL PROTECTED]> wrote: > > does the "lock table" on MySQL (I'm using 5.0.22 or 5.0.45) works > > even for a cached result? > > Hold your horses, dude. That's the third time y

Re: write lock and sql_cache

2008-03-12 Thread Daniel Brown
On Wed, Mar 12, 2008 at 3:15 PM, MAS! <[EMAIL PROTECTED]> wrote: > does the "lock table" on MySQL (I'm using 5.0.22 or 5.0.45) works > even for a cached result? Hold your horses, dude. That's the third time you sent that email. Someone will give you an answer if you're patient. If you