<p>Sounds like you probably have a stuck or error'd "Delete Stale Template Cache" task.</p>

<p>You can tell if a task is stuck because there will be a circular progress bar in the upper-right hand corner of the CP that isn't progressing.</p>

<p>If it error'd, it will be red and you'll have the option to re-try it.</p>

<p>Regardless, here's the general troubleshooting steps necessary for both cases: <a href="http://buildwithcraft.com/help/stuck-tasks" rel="nofollow">http://buildwithcraft.com/help/stuck-tasks</a></p>

CC BY-SA 3.0
2014-12-01T18:31:38.250Z
2014-12-01T18:31:38.250Z
Brad Bell
<p>We are running Craft on a site that gets a decent level of traffic, thousands of hits per day. We are running craft caching to try and keep things quick. The caching tables have been growing significantly over the past few days and don't appear to be clearing out. These are the three tables and the row counts. 1+ million rows in two of them.</p>

<p>| craft_templatecaches                |      34685 |
| craft_templatecachecriteria         |    1197874 |
| craft_templatecacheelements         |    1364424 |</p>

<p>Any ideas on why these tables would be growing so large and why they don't appear to be removing any old rows?</p>

CC BY-SA 3.0
2014-12-01T14:43:58.433Z
Could you be using the cache tag without the `globally` parameter so you get one set of cached content per URL?
naboovalley
<database><cache>
Caching tables not clearing out
# Caching tables not clearing out

(Asked by: username_0 on 2014-12-01)

We are running Craft on a site that gets a decent level of traffic, thousands of hits per day. We are running craft caching to try and keep things quick. The caching tables have been growing significantly over the past few days and don't appear to be clearing out. These are the three tables and the row counts. 1+ million rows in two of them.

| craft\_templatecaches | 34685 |
| craft\_templatecachecriteria | 1197874 |
| craft\_templatecacheelements | 1364424 |

Any ideas on why these tables would be growing so large and why they don't appear to be removing any old rows?

**Tags:** database, cache

> **Comments:**
> **username_1**: Could you be using the cache tag without the `globally` parameter so you get one set of cached content per URL?  

---

## 1 answers

### Answer by username_2 on 2014-12-01. Score: 2

Sounds like you probably have a stuck or error'd "Delete Stale Template Cache" task.

You can tell if a task is stuck because there will be a circular progress bar in the upper-right hand corner of the CP that isn't progressing.

If it error'd, it will be red and you'll have the option to re-try it.

Regardless, here's the general troubleshooting steps necessary for both cases: <http://buildwithcraft.com/help/stuck-tasks>


---

