← Back to team overview

maria-developers team mailing list archive

Thread
Date

Re: doubt about query cache and write locks

To: Roberto Spadim <roberto@xxxxxxxxxxxxx>, "maria-developers@xxxxxxxxxxxxxxxxxxx" <maria-developers@xxxxxxxxxxxxxxxxxxx>
From: Oleksandr Byelkin <sanja@xxxxxxxxxxxxxxxx>
Date: Wed, 24 Jun 2015 10:17:18 +0200
In-reply-to: <CAH3kUhEmDzQ=jMjd-tBh0He=eqXqPx0sYROr=k9T-p45iGSJLw@mail.gmail.com>
User-agent: Mozilla/5.0 (X11; Linux x86_64; rv:31.0) Gecko/20100101 Thunderbird/31.7.0

Hi!

On 23.06.15 19:26, Roberto Spadim wrote:

hi guys, i'm with a doubt

when i execute LOCK TABLE xxx WRITE
any query at query cache could be executed without locking (waitingfor table lock state)shouldn't the lock table invalidade the table query cache when using awrite lock?

See documentationhttps://mariadb.com/kb/en/mariadb/server-system-variables/#query_cache_wlock_invalidate


[skip]

Follow ups

Re: doubt about query cache and write locks
From: Oleksandr Byelkin, 2015-06-24

References

doubt about query cache and write locks
From: Roberto Spadim, 2015-06-23