Hi guys,

We've noticed our query log get out of control recently and looking into it there seems to be an awful lot of cache updates for cid = 'context' per page request.

See a MySQL log here: http://drupal.pastebin.com/Y8v0SLAL

Note that while we've deployed context module to production, we aren't actually using it yet (plan to later this week). So these queries are being executed despite not having any contexts available or enabled. What's more all the queries appear to be largely identical. I might except one cache_set() per request but 14 makes me think I'm doing something wrong.

Is this level of cache updating normal, or are we doing something wrong here?

If this is a known issue please let me know which issue this is a duplicate of so that I can follow it.

Many thanks,
Ben

Comments

benkant’s picture

benkant commented

Just wanted to add this from our database team:

Some further information on the query, as follows:

UPDATE cache SET data = <20-kilobytes-of-serialised-PHP-object>, created = , expire = 0, headers = '', serialized = 1 WHERE cid = 'context'

Of the 20 minute period I analysed, 4494 of these queries were executed. In every case the query was byte-level identical, except for the "created = " which simply advanced as time advanced.

yhahn’s picture

yhahn commented
Status: Active » Fixed

This should be fixed in the latest dev and be in the next release.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.