Re: write lock and sql_cache
- Date: Wed, 12 Mar 2008 22:01:56 -0400
- From: "Baron Schwartz" <baron@xxxxxxxxx>
- Subject: Re: write lock and sql_cache
On Wed, Mar 12, 2008 at 3:22 PM, Daniel Brown <parasane@xxxxxxxxx> wrote:
> On Wed, Mar 12, 2008 at 3:15 PM, MAS! <urkapd@xxxxxxxxx> 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.
I agree. Don't duplicate posts or post to multiple lists. Jump on
the IRC channel if you need help right away :-)
The query_cache_wlock_invalidate server variable controls the behavior
you are seeing. You can configure it as desired.
Baron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx