Hey,
Currently, afaik, when you update a table, MySQL will flush all query
cache entries for that table. I've heard that work was ongoing to
change this behavior to only the affected rows, but I can't seem to
find much information on it.
Does anyone know the status of this ?
Thx,
Johan
--
That
On Wed, Jun 27, 2007 at 01:27:24PM +1200, Ian Collins wrote:
> Are HANDLER queries cached in the query cache?
No, they are not. The query cache only caches the results of SELECT
statements.
Jim Winstead
MySQL Inc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Hi,
I have an application that is using the MySQL HANDLER heavily. The
application was ported from a legacy ISAM database to use MySQL.
The upshot is that the application works by "index walking" - i.e.,
HANDLER tablename OPEN
HANDLER tablename OPEN as indexname
HANDLER indexname READ indexname
Actually no, I'm not using any prepared statements. But thanks for the
pointer on that.
-Original Message-
From: Jay Pipes [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 30, 2006 2:24 PM
To: Mazur Worden, Kathy
Cc: mysql@lists.mysql.com
Subject: RE: query cache question
Ah, I
; From: Jay Pipes [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 30, 2006 2:12 PM
> To: Mazur Worden, Kathy
> Cc: mysql@lists.mysql.com
> Subject: RE: query cache question
>
> Please show the output of:
>
> SELECT @@global.query_cache_type;
>
> and then:
>
: Jay Pipes [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 30, 2006 2:12 PM
To: Mazur Worden, Kathy
Cc: mysql@lists.mysql.com
Subject: RE: query cache question
Please show the output of:
SELECT @@global.query_cache_type;
and then:
SHOW GLOBAL STATUS LIKE 'Qc%';
Thanks!
On Wed, 200
orden
> Prairie Area Library System
>
> -Original Message-
> From: Jay Pipes [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 30, 2006 12:42 PM
> To: Mazur Worden, Kathy
> Cc: mysql@lists.mysql.com
> Subject: RE: query cache question
>
> Those queries loo
athy Mazur Worden
> Prairie Area Library System
>
> -Original Message-
> From: Jay Pipes [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 30, 2006 12:07 PM
> To: Mazur Worden, Kathy
> Cc: mysql@lists.mysql.com
> Subject: Re: query cache question
>
> C
orden
> Prairie Area Library System
>
> -Original Message-
> From: Jay Pipes [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 30, 2006 12:07 PM
> To: Mazur Worden, Kathy
> Cc: mysql@lists.mysql.com
> Subject: Re: query cache question
>
> Could you post an ex
What else would prevent queries from getting into the cache?
Anything with NOW() in it or any of it's related functions...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
e Area Library System
-Original Message-
From: Jay Pipes [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 30, 2006 12:07 PM
To: Mazur Worden, Kathy
Cc: mysql@lists.mysql.com
Subject: Re: query cache question
Could you post an example of a query you are expecting to be cached?
On Wed, 20
Could you post an example of a query you are expecting to be cached?
On Wed, 2006-08-30 at 11:43 -0500, Mazur Worden, Kathy wrote:
> Hi,
>
>
>
> I just turned on the query cache by modifying its size and limit and
> restarting the server. However queries aren't being stored to it:
>
>
>
>
Hi,
I just turned on the query cache by modifying its size and limit and
restarting the server. However queries aren't being stored to it:
Variable_name
Value
Qcache_free_blocks
1
Qcache_free_memory
10477008
Qcache_hits
0
Qcache_inserts
0
Qcache_lowmem_prunes
0
Qcache_not_cache
13 matches
Mail list logo
