Thanks. I will try it.
Iago Sineiro.
-Mensaje original-
De: Dan Nelson [mailto:[EMAIL PROTECTED]
Enviado el: lunes, 09 de junio de 2003 16:54
Para: Iago Sineiro
CC: MySql Mail List
Asunto: Re: How to empty the cache?
In the last episode (Jun 09), Iago Sineiro said:
> Sorry for
In the last episode (Jun 09), Iago Sineiro said:
> Sorry for the ambiguity. I'm testing the useful of adding indexes to
> one table for one type of query.
>
> When I execute the same query for the second time it executes faster
> beacuse it's using the cache (the key_cache or the query cache if it
key_cache (and also the query cache) without shutdown the mysql server?
Iago Sineiro.
-Mensaje original-
De: Nils Valentin [mailto:[EMAIL PROTECTED]
Enviado el: lunes, 09 de junio de 2003 12:48
Para: Iago Sineiro; MySql Mail List
Asunto: Re: How to empty the cache?
Hi Iago,
I am u
Hi Iago,
I am unsure if I understand your question correctly, MySQL has a t least 5
different chaches (to name only the most important ones).
key_cache
table_cache
thread_cache
hostname_cache
evt. disc cache (memory)
or do you mean buffer variables ?
sort_buffer
record_buffer
join_buffer_size
On Mon, Jun 09, 2003 at 12:30:23PM +0200, Iago Sineiro wrote:
> Hi.
>
> I'm doing some testings and I want to know how to empty the cache in mysql
> (versions 3.23 and 4.0) between the differents tests.
What cache? The query only exists in MySQL 4.0.
If you want an empty key buffer, I'd suggest
