---
title: "Enable and Test MySQL Query Cache"
date: "2009-02-12"
modified: "2013-03-04"
path: "/29-enable-and-test-mysql-query-cache.html"
section: "/ramblings"
aliases:
  - "/29"
  - "/29-enable-and-test-mysql-query-cache"
  - "/29.html"
  - "/ramblings/29-enable-and-test-mysql-query-cache.html"
---

Edit the config file and add the query cache lines:

```
nano /etc/mysql/my.cnf
```

```
query-cache-type = 1
query-cache-size = 200M
```

```
/etc/init.d/mysql restart
```

To test it's functioning you will need to add an extra phrase to the SQL statement called "SQL_CACHE". This will create SQL statements looking like:

```
SELECT SQL_CACHE * FROM my_table;
```

You can then test that its doing something by simply running the following queries after repeating the above query a few times:

```
SHOW VARIABLES LIKE ‘%query_cache%’;
SHOW STATUS LIKE ‘%qcache%’;
```

You can see that the status output shows that after executing the statement a few times that the cache is being hit:

![](/images/query-cache.jpg)