[drupal-devel] Menu cache

[Dries Buytaert]

On 10 May 2005, at 14:53, Gerhard Killesreiter wrote:
>> mysql> SELECT data, created, headers, expire FROM cache WHERE cid =
>> 'menu:<uid>:en'
>
> According to database.mysql there is no index on cid. Can you try  
> adding
> one? Length 15 or so should do.

We have an index:

mysql> EXPLAIN SELECT data FROM cache WHERE cid = 'menu:9446:en';
+-------+-------+---------------+---------+---------+-------+------ 
+-------+
| table | type  | possible_keys | key     | key_len | ref   | rows |  
Extra |
+-------+-------+---------------+---------+---------+-------+------ 
+-------+
| cache | const | PRIMARY       | PRIMARY |     255 | const |    1 |     
    |
+-------+-------+---------------+---------+---------+-------+------ 
+-------+

--
Dries Buytaert  ::  http://www.buytaert.net/