← Back to team overview

maria-developers team mailing list archive

RFC - query cache insert

 

Hi guys!
I was reading (again) the query cache source code of 10.0.3 ...
please tell me if i understood right

when we insert at query cache...
thread put a lock in query cache (no one can result from query cache)
thread read all data and write to network (caching the result to query cache)
after end of thread real the query cache is unlocked..

my doubts are...
what happen if the query is too slow? the query cache is disabled
while executing the query?
what happen if two equal queries (same SELECT) execute? the first one
is locked until the second one end the query and get the result from
query cache? or the first lock query cache and the second runs without
query cache?

the last one
there's any query cache changes in mind? i was reading the
sql_cache.cc of old mysql servers and there's a todo list (very old i
think) that didn't changed from old mysql to today mariadb 10.0.3,
this todo list is inside mysql bug tracker? or mariadb jira?

thanks guys!

-- 
Roberto Spadim


Follow ups