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".