[Maria-developers] doubt about query cache and write locks
hi guys, i'm with a doubt when i execute LOCK TABLE xxx WRITE any query at query cache could be executed without locking (waiting for table lock state) shouldn't the lock table invalidade the table query cache when using a write lock? -- Roberto Spadim
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 (waiting for table lock state) shouldn't the lock table invalidade the table query cache when using a write lock? See documentation https://mariadb.com/kb/en/mariadb/server-system-variables/#query_cache_wlock...
[skip]
On 24.06.15 10:17, Oleksandr Byelkin wrote:
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 (waiting for table lock state) shouldn't the lock table invalidade the table query cache when using a write lock? See documentation https://mariadb.com/kb/en/mariadb/server-system-variables/#query_cache_wlock...
Maybe you should not... here name of variable describe better what it do then the documentation.
[skip]
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
participants (2)
-
Oleksandr Byelkin -
Roberto Spadim