Antony - how does the server handle views and virtual columns, in terms of the query cache?
Is a storage engine able to tell the server that it shouldn't cache its tables?
How does the query cache know that an underlying table has been modified - is that done by the server somewhere in the execution of insert/update/delete and other relevant statements, or is there a notification mechanism up from engines that we could perhaps also use?
Antony - how does the server handle views and virtual columns, in terms of the query cache?
Is a storage engine able to tell the server that it shouldn't cache its tables?
How does the query cache know that an underlying table has been modified - is that done by the server somewhere in the execution of insert/ update/ delete and other relevant statements, or is there a notification mechanism up from engines that we could perhaps also use?