Login to your server as root.
On mysql prompt fire the following command:
mysql> SHOW VARIABLES LIKE ‘%query_cache%’;
This will result the table as follows :
+——————————+———–+
| Variable_name | Value |
+——————————+———–+
| have_query_cache | YES |
| query_cache_limit | 1248376 |
| query_cache_min_res_unit | 3496 |
| query_cache_size | 134576828 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
+——————————+———–+
6 rows in set (0.20 sec)
query_cache_type will be set to ON or OFF as required.
