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
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 neve
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
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 th
On Wed, Jun 9, 2010 at 8:04 PM, Kyong Kim 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 practice to hunt t
On Tue, Jun 8, 2010 at 10:57 PM, Machiel Richards 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:
>
>
>
>
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
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
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
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
(whic
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 ?
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 :
; > 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 :
>> >
at I run them. But
> > then they never seem 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 som
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 DISTIN
"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 headin
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 (De
query.
>
>
> >
> > On 9/17/08, Bard Aase <[EMAIL 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
rd 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 d
e <[EMAIL 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,
> >>>
>
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:
>>>
&g
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_li
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
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_un
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 Ge
Hey, Guys
Is there a way to know what queries are in the query cache?
thanks
r 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 si
> 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 effi
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 reboot
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 anym
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 quer
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_
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
their own 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 wor
y 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
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_CAC
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
ta
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
Kishor
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 ge
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 sou
onfuses 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 que
-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
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 for
-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
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
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
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
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
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
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
>
> Variabl
: 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&#x
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_prun
It bring great effect in performance if federated engine can't use the cache.
If mysql intend to support it in the future?
- Original Message -
From: "Michael Loftis" <[EMAIL PROTECTED]>
To: "wangxu" <[EMAIL PROTECTED]>;
Sent: Thursday, August 03,
--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 th
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 use
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.
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
.
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
_
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 cach
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
value.
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_cac
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
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
manual
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'
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 normall
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
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 ne
something
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 da
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 qu
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
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
>da
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 sugges
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
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
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 meth
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"]
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 cachabl
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 abs
e that a cached query remains 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
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
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, th
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
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
"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
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
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
ursday, September 25, 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 availa
1 - 100 of 133 matches
Mail list logo
