time.
"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.=2
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 hav
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" ??
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 su
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 SEL
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 ORDE
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 t
