Hi Rick,
Thanks for the advise. I have now set my query-cache to zero.
(I take your point about query cache too large. I understand that a
smaller cache size, and the use of the SQL_NO_CACHE and SQL_CACHE
directives can be used to control which queries are cached. Therefore
trying to get t
As for the crash, I don't know. Instead, I recommend either shrinking the size
(if you use a big QC) or turning it off. This would make the issue go away.
ANY modification to a particular table leads to ALL entries in the Query cache
being purged. For that reason, we (Yahoo) almost never use
okie..got u
On 9/17/08, Bard Aase <[EMAIL PROTECTED]> wrote:
>
> On Wed, Sep 17, 2008 at 12:42 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote:
> >>query_cache_limit is the maximum size of a single resultset in the
> >> cache. If your query results in a bigger resultset it will never get
> >> into the
On Wed, Sep 17, 2008 at 12:42 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote:
>>query_cache_limit is the maximum size of a single resultset in the
>> cache. If your query results in a bigger resultset it will never get
>> into the cache even if its room for it in the cache itself.
>
>
>
> Even if there
>query_cache_limit is the maximum size of a single resultset in the
> cache. If your query results in a bigger resultset it will never get
> into the cache even if its room for it in the cache itself.
Even if there is room why will it not fit into the cache.
On 9/17/08, Bard Aase <[EMAIL PRO
On Wed, Sep 17, 2008 at 11:54 AM, Uwe Kiewel <[EMAIL PROTECTED]> wrote:
> Bard Aase schrieb:
>> On Wed, Sep 17, 2008 at 11:37 AM, Uwe Kiewel <[EMAIL PROTECTED]> wrote:
>>> Hi,
>>>
>>> I have two questions regarding the query cache:
>>>
>>> 1. What is the difference between query_cache_limit and que
Bard Aase schrieb:
> On Wed, Sep 17, 2008 at 11:37 AM, Uwe Kiewel <[EMAIL PROTECTED]> wrote:
>> Hi,
>>
>> I have two questions regarding the query cache:
>>
>> 1. What is the difference between query_cache_limit and query_cache_size?
>
> query_cache_limit is the maximum size of a single resultset
On Wed, Sep 17, 2008 at 11:37 AM, Uwe Kiewel <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have two questions regarding the query cache:
>
> 1. What is the difference between query_cache_limit and query_cache_size?
query_cache_limit is the maximum size of a single resultset in the
cache. If your query re
http://rpbouman.blogspot.com/2008/07/inspect-query-cahce-using-mysql.html
- parvesh
On Wed, Sep 17, 2008 at 1:15 AM, Edson Noboru Yamada <[EMAIL PROTECTED]> wrote:
> Hey, Guys
>
> Is there a way to know what queries are in the query cache?
>
>
> thanks
>
--
MySQL General Mailing List
For list a
Hi,
Your questions are answered in the manual:
http://dev.mysql.com/doc/refman/5.0/en/query-cache-how.html
It is a known limitation.
Edoardo Serra wrote:
Hi all,
I'm benchmarking performance improvement with MySQL Query Cache
turned on but I'm facing some problem with queries inside store
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
This is our problem:
http://bugs.mysql.com/bug.php?id=27210
Thanks,
Paul
Baron Schwartz wrote:
Hi,
Paul J. Boyes wrote:
Hello,
I am hoping to get pointed in the right direction/save some time...
I have a db in which some web services are constantly
inserting/updating data. However, whe
Hi,
Paul J. Boyes wrote:
Hello,
I am hoping to get pointed in the right direction/save some time...
I have a db in which some web services are constantly inserting/updating
data. However, when I run selects from the command line mysql app, I do
not see the changes that these services have m
Chris,
Thanks for clearing that up. You are right, I don't want the general
log or the mysql shell history.
I'm not happy that I can't get at the Query Cache. I am sure there are
tools which MySql developers must use to test the cache. I'll have to
look at the source code directories...
Mohsen Pahlevanzadeh wrote:
Ben Clewett wrote:
Hi Mohsen,
Thanks for the reply.
I'm looking in the home directory, as well as the other directories
used by mysql and I can't see any files which I do not recognise. (I
am UNIX so there are no hidden files.)
I am also a little confuses as t
Hi Mohsen,
I see, the difference between the home of mysql and the mysql home...
As you asked:
mysql:*:204:1::/home/mysql:/usr/bin/ksh
# ls -la /home/mysql
4 -rwxr- 1 mysqlstaff 254 14 Feb 2005 .profile
Regards,
Ben
Mohsen Pahlevanzadeh wrote:
Ben Clewett wrote:
Ben Clewett wrote:
Hi Mohsen,
Thanks for the advise. On my AIX system as root, dot files not
hidden. For instance my mysql home directory looks like:
drwxr-xr-x 16 mysqlmysql 4096 04 Dec 20:18 .
drwxr-xr-x 31 root system 4096 09 Nov 15:12 ..
drwxr-xr-x 2 mysql
Hi Mohsen,
Thanks for the advise. On my AIX system as root, dot files not hidden.
For instance my mysql home directory looks like:
drwxr-xr-x 16 mysqlmysql 4096 04 Dec 20:18 .
drwxr-xr-x 31 root system 4096 09 Nov 15:12 ..
drwxr-xr-x 2 mysqlmysql 409
Ben Clewett wrote:
Hi Mohsen,
Thanks for the reply.
I'm looking in the home directory, as well as the other directories
used by mysql and I can't see any files which I do not recognise. (I
am UNIX so there are no hidden files.)
I am also a little confuses as the Query Cache is entirely a
Hi Mohsen,
Thanks for the reply.
I'm looking in the home directory, as well as the other directories used
by mysql and I can't see any files which I do not recognise. (I am UNIX
so there are no hidden files.)
I am also a little confuses as the Query Cache is entirely a memory
structure, do
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:
>
>
>
>
--On August 2, 2006 5:25:51 PM +0800 wangxu <[EMAIL PROTECTED]> wrote:
I have a problem about the performance of federated engine. The
mysql5.0 reference manual says that the FEDERATED tables do not work with
the query cache, aren't they? How about the query cache used by the
federated eng
Hello.
My $0.05 :)
If you find out the unique queries (they often contain date and time),
add SQL_NO_CACHE to SELECT statement - this will decrease the number
of inserts of unique queries.
Brent Baisley <[EMAIL PROTECTED]> wrote:
> You tripled the amount of memory assigned to the cac
You tripled the amount of memory assigned to the cache, but your
Qcache_lowmem_prunes value went up 10x and Qcache_not_cached went up
6x. I would say that you have enough queries that are unique, that
most of your queries are getting cached then flushed before the same
query comes up again.
Hello.
Yes. See a long discussion at:
http://bugs.mysql.com/bug.php?id=6511
"Thomas van Gulick" <[EMAIL PROTECTED]> wrote:
> Try this:
>
> Setup a database server, with MySQL 4.1, with query cache turned on
>
> Setup a client machine with MySQL 4.0
> Setup a client machine with M
t has been returned from the Cache
rather than the Direct from Raw Tables.
Hope that is a bit clearer
Cheers
Skex
-Original Message-
From: Eric Bergen [mailto:[EMAIL PROTECTED]
Sent: 07 December 2004 17:30
To: Alexis Cheshire
Cc: [EMAIL PROTECTED]
Subject: Re: Query Cache
'show'
t; Sent: 07 December 2004 16:50
> To: Alexis Cheshire
> Cc: [EMAIL PROTECTED]
> Subject: Re: Query Cache
>
> Skex,
>
> show status like 'Qcache%';
> Will give you status of the query cache. There isn't a way to tell if a query
> result came from the cache
]
Subject: Re: Query Cache
Skex,
show status like 'Qcache%';
Will give you status of the query cache. There isn't a way to tell if a query
result came from the cache or not other than the time it took to return or if
it's the only query ran between checks of the show statu
Skex,
show status like 'Qcache%';
Will give you status of the query cache. There isn't a way to tell if
a query result
came from the cache or not other than the time it took to return or if
it's the only query ran
between checks of the show status. Neither of these methods is very
reliable. Cac
Thanks to all who replied.
Regards
Terry Riley
- Original Message -
> We have the query cache turned on, and it appears to be working well.
>
> However, there appears to be no indication in the manual as to the time
> that a cached query remains in memory. In the absence of this
> in
In the last episode (Aug 07), Paul DuBois said:
> At 23:16 +0100 8/7/04, Terry Riley wrote:
> > However, there appears to be no indication in the manual as to the
> > time that a cached query remains in memory. In the absence of this
> > information, is it safe to assume that a cached query remains
At 23:16 +0100 8/7/04, Terry Riley wrote:
We have the query cache turned on, and it appears to be working well.
However, there appears to be no indication in the manual as to the time
that a cached query remains in memory. In the absence of this information,
is it safe to assume that a cached query
Yes, a query cache is only removed when one of it's tables is updated
or the server is restarted.
-Eric
On Sat, 7 Aug 2004 23:16 +0100 (BST), Terry Riley <[EMAIL PROTECTED]> wrote:
> We have the query cache turned on, and it appears to be working well.
>
> However, there appears to be no indicat
"G B U" <[EMAIL PROTECTED]> wrote:
> Recently I've come around that mysql (4.1.0 at least) treats different
> queries containing non-english characters (in my case characters from
> cp1251 charset) as the same query and therefore returns wrong results.
> For example the following queries are regard
Hi Daniel,
Yes, query_cache_type is 1 by default if you don't set it. :-) It's not
used by default, however, because query_cache_size is 0. You need to set
query_cache_size to 16M, 32M, etc.
Hope that helps.
Matt
- Original Message -
From: "Daniel Kasak"
Sent: Thursday, September 25,
On Mon, Aug 18, 2003 at 04:51:17PM -0700, Michael S. Fischer wrote:
> Jeremy Zawodny writes:
>
> > Perhaps you could tell us more about the queries that take
> > too long. Maybe there are some things you can do to reduce that time?
>
> You don't want to go there.
>
> But because you do... :-)
Jeremy Zawodny writes:
> Perhaps you could tell us more about the queries that take
> too long. Maybe there are some things you can do to reduce that time?
You don't want to go there.
But because you do... :-)
As far as I can tell, the queries are as optimized as they're going to
get. I'm doi
On Mon, Aug 18, 2003 at 11:53:29AM -0700, Michael S. Fischer wrote:
>
> I'm using MySQL 4.0.13 for a web application, and one of my queries
> is sufficiently complex such that it might take several seconds to
> return the results to the user. I'd like to return a "please wait"
> page if the query
Hey There,
Our MySQL database server is:
1. Sun Ultra Enterprise 4500 System Chassis with SBus I/O
4. 6 System Boards, each with 2 UltraSPARC II 400 mhz CPU's and 2 GB's
of memory (12 CPU, 12 GB memory)
2. 1 SBus I/O board, with SCSI-2 and dual fibre channel interfaces on
it.
3. The SCSI-2 inte
Hi!
> In MySQL 4.0, query cache hits are counted in Qcache_hits, but not in
> Com_select. The documentation for Com_select implies that they should be
> there. Is this the intended behavior, or is it a bug?
>
> - JD
It is intended behaviour.
Com_select is incremented each time SELECT query is
On Saturday 08 March 2003 23:38, John David Duncan wrote:
> In MySQL 4.0, query cache hits are counted in Qcache_hits, but not in
> Com_select. The documentation for Com_select implies that they should be
> there. Is this the intended behavior, or is it a bug?
No, it's not a bug, but a known b
In the last episode (Jan 29), Rusch (ext) Reiner said:
> I've got one question which belongs to the new query cache in 4.01.
>
> I wonder why the cache should be deleted if there's a statement like
> update, insert etc. I think it must be considered that there are
> possible situations where this
Thank you very much for the speedy response.
Because of your positive attitude I'm going to try and talk my boss into
purchasing a few MySQL licences to help you with development. (the query
caching has effectively helped us to reduce hardware costs as 65% of our
queries are coming out of memory
Hi!
On Dec 16, Magnus Enbom wrote:
> Hi,
>
> I'm trying out the new query cache features in mysql4.
> Are the cache supposed to work with innodb tables? It's not according to the
> output of show status, works fine with myisam tables.
> I'm ran a 'bk pull -l' this morning and compiled with Suns
52 matches
Mail list logo
