title: MySQL best practices to use SQL_CACHE and SQL_NO_CACHE
body: <p>MySQL allows us to create select statements with usage of <code>SQL_CACHE</code> and <code>SQL_NO_CACHE</code> options. These options affect caching of query results in the query cache. But for which queries is it better to use <code>SQL_CACHE</code> option and for which <code>SQL_NO_CACHE</code> one? Or maybe it is better doesn't use it at all?</p>