Pretty straightforward question:
Let's say I have a specific query that I know is regularly used, can I tell MySQL to always cache it "automatically" ... i.e. once the cached query results are flushed the
mysqld immediately runs that query again to have the cached data ready for the next user?
Or the other way round: can I tell MySQL to not cache specific queries? What about other caching options, not necessarily related to queries?
I searched through the web on this but can't really find anything related.