← Back to team overview

maria-developers team mailing list archive

Re: RFC - query cache insert

 

Hi!

08.08.2013 08:05, Roberto Spadim пишет:
hum...
check if i'm thinking wrong about the internal flow of mariadb/mysql ...

client send data over network
server receive data
server process data and check that it's a query command
server check query cache and return if found (that's how query cache
execute today, right?)
(here no query was found in query cache)
server parse/optimize the query
(here where i want to include the 'normalized' query cache)
server execute the query
server send result to client (caching to query cache when possible)
server end query command

It could be put just after parsing (you do not need optimize).

But again, it is huge overhead (in this schema query should be checked twice) and one should have very very high hit-rate of differently written but the same by semantic queries to get gain from it. So it is idea for very specific load which we can't meet in "wild nature".


Follow ups

References