MySQL query caching is simple to implement and very beneficial to high volume websites. Query cache actually caches the query results for a given SQL query. To see if MySQL has query caching enabled issue the following command:
mysql> show variables like ‘query%’;
+——————————+———+
| Variable_name [...]