Hi..
I'm using cache queries with MySQL 4.0.13 during three days and I get
a little better speed.
Value of Query_cache_size = 20 Mb.
I have two questions.
1.- Is there any way to see which queries are being stored ??
2.- How can I delay qcache_lowmen_pruenes ?? In three day values
Paco Martinez Rodriguez wrote:
Hi..
I'm using cache queries with MySQL 4.0.13 during three days and I get
a little better speed.
Value of Query_cache_size = 20 Mb.
This is 20 Mega Bits. I suppose you meant to mean 20 MegaBytes (20MB),
or even 20 Mibibytes (20MiB).
I have two questions
.
Paco Martinez Rodriguez [EMAIL PROTECTED] wrote:
Hi..
I'm using cache queries with MySQL 4.0.13 during three days and I get
a little better speed.
Value of Query_cache_size =3D 20 Mb.
I have two questions.=20
1.- Is there any way to see which queries are being stored ??
2
Hi!
On Mar 28, Homam S.A. wrote:
It seems that MySQL freaks out whenever it seems
something that looks like a derive table and refuses
it to cache. Even a non-UNION query like:
SELECT * FROM
(SELECT * FROM X WHERE A = 5) AS DerivedTable
Won't be cached.
It's a bug. Could you submit a
I have a query of the form:
(SELECT A, B from X ORDER BY A LIMIT 1000)
UNION ALL
(SELECT A, B from Y ORDER BY A LIMIT 1000)
ORDER BY A
I thought may be each query needs to start with
SELECT, so I wrapped the above query in a
derived-table expression like:
SELECT * FROM (
(SELECT A, B from X
It seems that MySQL freaks out whenever it seems
something that looks like a derive table and refuses
it to cache. Even a non-UNION query like:
SELECT * FROM
(SELECT * FROM X WHERE A = 5) AS DerivedTable
Won't be cached.
I read a comment in the documentation that if you put
SQL_CACHE in the
Hello.
As said at:
http://dev.mysql.com/doc/mysql/en/query-cache-how.html
A query will not be cached, if it uses TEMPORARY tables.
Homam S.A. [EMAIL PROTECTED] wrote:
Why MySQL insists on ignoring the query cache whenever
I use the same query repeatedly to populate a temp
Why MySQL insists on ignoring the query cache whenever
I use the same query repeatedly to populate a temp
table?
So I have:
create temporary table MyTable
select SQL_CACHE * from SomeTable WHERE (A bunch of
criteria) limit 1000;
SomeTable is a read-only table.
If I issue the query without the