Comment 4 for bug 796647

Revision history for this message
Arjen Lentz (arjen-lentz) wrote :

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?