Re: Innodb Buffer Pool vs Query Cache

2009-11-12 Thread Johan De Meersman
The query cache lays at the server level, above individual engine implementations, and thus affects all of them. It (case-sensitively!) compares the current query with the queries in the query cache, and if there's an EXACT match (including all parameter positions, wheres, and whatnot), it returns

Innodb Buffer Pool vs Query Cache

2009-11-12 Thread Aveek Misra
I am using the innodb storage engine for a table that is used for a lot of SELECT's on columns that are defined as indexes. I have not enabled the query cache as of now since the innodb buffer pool already caches data and index information for InnoDB tables. So my question is - is the query ca