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
Hi MySql,
Since upgrading to 5.5.27 (5.5.27-ndb-7.2.8-cluster-gpl-log to be exact)
I have experienced problems with the query cache. I am wondering if I
am the only one?
Twice I have had a core-dump (show at end of mail) on two separate
servers running this version.
Now I had a complete
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
On Tue, Jun 8, 2010 at 10:57 PM, Machiel Richards machi...@rdc.co.za wrote:
Good morning all
I would like to try and find out how you can see what is using the
query cache.
My reason for asking is the following:
On one of our client databases
On Wed, Jun 9, 2010 at 8:04 PM, Kyong Kim kykim...@gmail.com wrote:
If the memory is available, why not use it? It seems like the default
buffer pool size out of the box was just never changed.
Agreed, of course, but if something happens on a system that is out of
the ordinary, it's very good
Absolutely. You don't want to obscure the cause by just throwing more
hardware at things.
That approach just buys you time until a bigger pile hits the fan if
the underlying issue remains unresolved.
At the same time, though, 8 MB production innodb buffer pool
allocation should be fairly high on
Good morning all
I would like to try and find out how you can see what is using the
query cache.
My reason for asking is the following:
On one of our client databases, the query cache is set to
128Mb and the usage always varied between 5% and 53
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
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
Hi,
I'm thinking of extending the query cache to deal with following scenarios,
1. stop invalidating the cache entries when updates take place for
columns which are not in the select list of the cached queries
2. when a second query contains a subset of columns from a first query
(which has
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
the
query-cache or something just like it.
BUT, I am doing this each time :
flush tables;
reset query cache;
set global query_cache_size=0;
SELECT SQL_NO_CACHE DISTINCT ca.conceptid AS headingid,
And still it's not avoiding the cache.
Is there a cache I'm missing?
Tim
the keywords searched for in the
where clauses, then they take a long time again... so it's the
query-cache or something just like it.
BUT, I am doing this each time :
flush tables;
reset query cache;
set global query_cache_size=0;
SELECT SQL_NO_CACHE DISTINCT ca.conceptid AS headingid,
And still
then). If I change the keywords searched for in the
where clauses, then they take a long time again... so it's the
query-cache or something just like it.
BUT, I am doing this each time :
flush tables;
reset query cache;
set global query_cache_size=0;
SELECT SQL_NO_CACHE DISTINCT ca.conceptid
to take that long after the first time (taking less
than a second then). If I change the keywords searched for in the
where clauses, then they take a long time again... so it's the
query-cache or something just like it.
BUT, I am doing this each time :
flush tables;
reset query cache
clauses, then they take a long time again... so it's the
query-cache or something just like it.
BUT, I am doing this each time :
flush tables;
reset query cache;
set global query_cache_size=0;
SELECT SQL_NO_CACHE DISTINCT ca.conceptid AS headingid,
And still it's not avoiding
I wonder why with tre different MySQL administrator istances I have 3
different QueryCache Hitrate on the same database, in the same time :(
I'm trying with:
- MySQL administrator v.1.2.12 (Ubuntu 8.10): the query hitcache is
always at 100% (average 100)
- MySQL administrator v.1.2.5rc
Hi,
I have two questions regarding the query cache:
1. What is the difference between query_cache_limit and query_cache_size?
mysql show variables like '%query_cache%';
have_query_cache | YES |
query_cache_limit| 1048576 |
query_cache_min_res_unit | 4096
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 results
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 in the
cache
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 query_cache_size
PROTECTED] wrote:
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
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 results in a bigger resultset it will never get
into the cache even if its room
, 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
Hey, Guys
Is there a way to know what queries are in the query cache?
thanks
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 archives
or the
bin-logs.
How might I efficiently trouble shooting this, where might I begin? I
can't figure out how to replicate it, it seems to be quite sporadic.
What would corrupt query results, temporarily fixed with a mysqld
restart?
If it's the query cache, there are two relatively simple things you
We are experiencing a certain anomaly here on our db server. The
problem had occurred about 3 weeks ago.
We ran diagnostics on the hardware over a 48+hour period with no
failures or indications of problems with hardware. ( at least the
memory.) We rebooted the server, and had not experienced
What's your question?
Max Thayer wrote:
We are experiencing a certain anomaly here on our db server. The
problem had occurred about 3 weeks ago.
We ran diagnostics on the hardware over a 48+hour period with no
failures or indications of problems with hardware. ( at least the
memory.) We
What's your question?
Heh, yah that might be important...
Has anyone experienced this? Does it look like anything in the my.cnf
could be altered to alleviate or assist me in diagnosing the problem? I
do not get an indication of any problems in the log files or the
bin-logs.
How might I
Hi all,
I'm benchmarking performance improvement with MySQL Query Cache turned
on but I'm facing some problem with queries inside stored procedures
when they contains variable parameters
I just created this stored procedure to identify the problem
CREATE PROCEDURE `proc_test_qcache
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
problems).
We run in 2 scenarios -
1. Machines with lots of databases and few users (ie. internal testing
machines) and
2. Machines with only one database and many users (i.e. customer
production machines).
My questions...
Are HANDLER queries cached in the query cache?
If so, is it worth using
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
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 made unless I do a flush
made unless I do a flush
tables. This is even true if I log out and log back in. So, I am
guessing that it has to do with caching. Any idea why this is happening?
It's almost certainly not the MySQL query cache, because updates invalidate the
cache. You can test by adding SQL_NO_CACHE
not the MySQL query cache, because updates
invalidate the cache. You can test by adding SQL_NO_CACHE to your
SELECT, thusly:
SELECT SQL_NO_CACHE
If this still doesn't return the results you expect, something else is
happening. Are the web services not committing their transactions?
That's
Not sure what is going on, but the version of MySQL you are using is
ancient. The current version of MySQL is 5.0.37. Even MySQL 4.1 (which
has been end-of-lifed) has a latest version of 4.1.22. If it is a bug
you are seeing, it likely has been fixed in a later version.
Cheers,
Jay
Hello Everybody,
I increased the query_cache_size on one of our
main servers from 100 MB to 250 MB, since I was seeing a very high rate lot
of Qcache Low Mem prunes. The server was fine for 15 minutes and the Low mem
prunes went down to almost zero, but then started
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
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
-xr-x 6 mysqlmysql 4096 13 Oct 2005 mysql-test
drwxr-xr-x 3 mysqlmysql 256 07 Oct 2005 share
drwxr-xr-x 5 mysqlmysql 4096 13 Oct 2005 sql-bench
drwxr-xr-x 2 mysqlmysql 256 05 Dec 10:23 tmp
There is no file for the Query Cache.
I am
for the Query Cache.
I am sure that since this is a memory structure, there must be a
command in MySql or an admin tool which can be used to expose the
Queries.
If anybody knows this really would be very useful.
Regards, Ben.
Mohsen Pahlevanzadeh wrote:
Ben Clewett wrote:
Hi Mohsen,
Thanks
-xr-x 6 mysqlmysql 4096 13 Oct 2005 mysql-test
drwxr-xr-x 3 mysqlmysql 256 07 Oct 2005 share
drwxr-xr-x 5 mysqlmysql 4096 13 Oct 2005 sql-bench
drwxr-xr-x 2 mysqlmysql 256 05 Dec 10:23 tmp
There is no file for the Query Cache.
I am
as the Query Cache is entirely a memory
structure, does it use a file?
You're talking about different things.
Mohsen thinks you want to see the the last queries that were run, which
are stored in the ~/.mysql_history file.
Ben wants to see what queries are stored in the query cache
(http
Dear MySql,
Can you please tell me if there is a tool to view the queries stored in
the Query Cache?
Regards,
Ben Clewett.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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
Hi
The query cache uses variable-length blocks and the Qcache_total_blocks and
Qcache_free_blocks may indicate query cache memory fragmentation. After
FLUSH QUERY CACHE, only a single free block remains. So the variables
query_cache_min_res_unit, query_cache_limit, query_prealloc_size
Hello
I don't understand why
query_cache_size / query_cache_min_res_unit != Qcache_total_blocks and
Qcache_free_memory / query_cache_min_res_unit != Qcache_free_blocks
Can anybody enlight me so that I know if I have to increase the
Query-Cache or not?
mysql SHOW status LIKE Qcache_
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
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
]
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, 2006-08-30 at 11:43 -0500, Mazur Worden, Kathy wrote:
Hi,
I just turned on the query
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]
@lists.mysql.com
Subject: Re: query cache question
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
: 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, 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
-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 look just fine to me.
Could you output the result of the following:
SELECT
: 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, 2006-08-30
Ah, I think I may have figured it out...
Are you using prepared statements? If so, doing that prevents the query
cache from caching the resultset entirely.
On Wed, 2006-08-30 at 14:17 -0500, Mazur Worden, Kathy wrote:
@@global.query_cache_type
ON
Variable_name Value
Qcache_free_blocks
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 think
: query cache about the federated engine
--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
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 engine in
the mysql5.1?
If the query cache cann't be used
--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
Hi friends, I need your help.
I want to configure the Query Cache, but it dosn't work.
I have installed MySQL 5.0.19 in Mandrake Linux. The server has 2GB
memory ram, 150 gb hard disk, exclusive for dbms.
I configure my system how say the home page. I follow step by step the
instructions. (http
up 13x, so you are caching a
lot more queries, but it's not doing all that much good. You're
getting diminishing returns as you increase memory. The query cache
works best when you have the same exact queries being run over and
over. You know your code, so you need to think how many
Hi list,
We are using mysql 4.0.24 on RHEL 3.0 on dell 2650 machine with 2 gb RAM.
We tried to fine tune query cache . please find below the analysis
PARAMETER old
modified
_
From: Anil [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 15, 2005 10:36 PM
To: 'mysql@lists.mysql.com'
Subject: QUERY CACHE TUNING QUESTION
Hi list,
We are using mysql 4.0.24 on RHEL 3.0 on dell 2650 machine with 2 gb RAM.
We tried to fine tune query cache . please
.
The number of queries being cached went up 13x, so you are caching a
lot more queries, but it's not doing all that much good. You're
getting diminishing returns as you increase memory. The query cache
works best when you have the same exact queries being run over and
over. You know your
Mysql's query cache has two option's [query_cache_limit] and [query_cache_size].
The documentation is not clear (for me) on their purpose and correct
usage tactics.
What does the [query_cache_size] sets, the maximum memory space a
single query can utilize ? Is it wise to set it to the same size
.
On 8/15/05, Maxim Vexler [EMAIL PROTECTED] wrote:
Mysql's query cache has two option's [query_cache_limit] and
[query_cache_size].
The documentation is not clear (for me) on their purpose and correct
usage tactics.
What does the [query_cache_size] sets, the maximum memory space
OK.
Lets take a mythical application. The app is spending about 50% of its
time inserting into table FOO. The other 50% of the time its spent
doing SELECT against the table.
The SELECTs can use an index which is already full loaded into the query
cache. Not only THAT but it doesn't need
into the
query cache.
Indexes aren't loaded into the query cache, they are loaded into the
key cache (key_buffer_size).
Now assuming that you have the query cache actually being used (the
cache of the actual statement), then normally the SELECT won't wait for
any locks. So someone can have
Harrison Fisk wrote:
aren't loaded into the query cache, they are loaded into the key cache
(key_buffer_size).
Yes... you busted me ! :). I meant to say key cache though.
Now assuming that you have the query cache actually being used (the
cache of the actual statement), then normally
Hi,
On May 8, 2005, at 1:47 PM, Kevin Burton wrote:
Harrison Fisk wrote:
aren't loaded into the query cache, they are loaded into the key
cache (key_buffer_size).
Yes... you busted me ! :). I meant to say key cache though.
Alright, I assumed a typo or such.
Not only THAT but it doesn't need
Harrison Fisk wrote:
There isn't really any way to use concurrent INSERT. It happens
automatically if possible. However there are a few things you can do
to help it along, such as OPTIMIZE after you DELETE large portions of
the table. Also it does have to enabled in LOAD DATA INFILE
Hi,
Im the administrador of a MySQL Server, it have lots of queries, and now
its getting high load of processor, I try to increase the size of MySQL
Query Cache, but if I put more than 128 Mb the cache its reseting all the
time and the performance is worst. The server have 1,2 Mb of RAM and I
Hello.
In my opinion, your status variables are not so bad-looking. About a
half of your queries are taken from the cache and the
Key_reads/Key_read_requests
ratio is less than 1%. Check that the system doesn't start swapping
with high value of Query Cache size. If you run lots of queries
to do with CSS and no one really knows the answer that we have seen)
As for a query cache edit your My.cnf and
query_cache_type 1 2 = Cache only if script says to(my suggested setting,
make your coders code for caching instead of catch all settings)
This does cause some grief if the data changed
Hi,
I was wondering if there is any query cache code/lib somewhere to
cache certains queries ?
I'm always doing the same queries, (and the result never change, so I
could spare the round-trip to the server), but caching each tine the
data for it is a bit of work.
Thanks, for your suggestions
Mister Jack wrote:
Hi,
I was wondering if there is any query cache code/lib somewhere to
cache certains queries ?
I'm always doing the same queries, (and the result never change, so I
could spare the round-trip to the server), but caching each tine the
data for it is a bit of work.
Thanks
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 MySQL 4.1
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 MySQL 4.1 (libmysqlclient14)
Create very simple table
: CREATE TABLE woepwoep (CNT int NOT NULL);
Insert single row
: INSERT INTO woepwoep SET CNT=10
Hi,
Is there a way to access if a Query is returning its record from QUERY_CACHE or
not?
E.g.
$sql=SELECT * FROM TABLE;
$result=db_query($sql);
print $result;
//If query NoT returned from mysql_query_cache()
//Would Output something like:
Array[status][cached]=0;
Array[status][count]=1;
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
]
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 status. Neither
]
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 status. Neither
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' is a query just like any
Hello,
I was wondering whether someone could tell me something about
my query-cache statistics (MySQL 4.0.22):
Qcache queries in cache 4479
Qcache inserts 37392
Qcache hits 56994
Qcache lowmem prunes 0
Qcache not cached 24
Qcache free memory 9448968
Qcache free blocks 502
Qcache total
Based on may observations, derived tables (subselect) are not cacheable:
select column1, column2 from (select SQL_CACHE * from MyTable) as b
The second part is not inserted to QueryCache nor is it retrieved if
already in
cache.
Also the file comments in sql_cache.cpp - Make derived tables
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
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 remains there indefinitely,
unless
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 indication
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
there
indefinitely, unless either (1) one of the tables used in the
initial query is modified, or (2) the server is re-started?
Yes. Why would you remove a result from the cache if it's still current?
Actually, there is another condition:
(3) you issue a RESET QUERY CACHE statement, which
Hello,
I just upgraded to MySQL 4.0.18. I have a question about the new
query-cache. The documentation says:
The FLUSH TABLES statement also flushes the query cache.
What does that mean exactly? Does it mean FLUSH TABLES, in effect, is equal
to RESET QUERY CACHE, in that it purges the cache
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 regarded as
Just to be sure that this question is not supressed here :)
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
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 regarded as identical while they are not:
SELECT
MySQL baby [EMAIL PROTECTED] wrote:
Anyone using TONS of Query Cache for a high-traffic site?
Our search server is really sweating.
I was about to jump through a LOT of software loops to program
query caching at the app level, when I realized that MySQL had
it built-in already. (We're
Anyone using TONS of Query Cache for a high-traffic site?
Our search server is really sweating.
I was about to jump through a LOT of software loops to program
query caching at the app level, when I realized that MySQL had
it built-in already. (We're using newest: 4.0.18)
Seems we've got plenty
, 2003 12:49 AM
Subject: Query Cache not being used...
Hi all.
I've set an option in the my.cnf file ( for a 4.0.14 server ):
[mysqld]
query_cache_type = 1
and restarted the server.
The query cache is supposed to be available. SHOW VARIABLES LIKE
'have_query_cache' returns 'YES
1 - 100 of 133 matches
Mail list logo