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".
_______________________________________________
Mailing list: https://launchpad.net/~maria-developers
Post to : [email protected]
Unsubscribe : https://launchpad.net/~maria-developers
More help : https://help.launchpad.net/ListHelp