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

write lock and sql_cache

2008-03-12 Thread Marco Stagno
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: result of SELECT * .. and that's is, IMHO,

write lock and sql_cache

2008-03-12 Thread MAS!
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: result of SELECT * .. and that's is, IMHO,

write lock and sql_cache

2008-03-12 Thread MAS!
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: result of SELECT * .. and that's is, IMHO,

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 can't

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 you sent that

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: result of SELECT * ..