List:General Discussion« Previous MessageNext Message »
From:Jeremy Zawodny Date:June 9 2003 10:39am
Subject:Re: How to empty the cache?
View as plain text  
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 stopping and starting
MySQL.  That won't affect the operating system's disk cache but it
will flush any caching MySQL has done.

Jeremy
-- 
Jeremy D. Zawodny     |  Perl, Web, MySQL, Linux Magazine, Yahoo!
<Jeremy@stripped>  |  http://jeremy.zawodny.com/

MySQL 4.0.13: up 6 days, processed 184,858,313 queries (347/sec. avg)
Thread
How to empty the cache?Iago Sineiro9 Jun
  • Re: How to empty the cache?Jeremy Zawodny9 Jun
  • Re: How to empty the cache?Nils Valentin9 Jun
    • RE: How to empty the cache?Iago Sineiro9 Jun
      • Re: How to empty the cache?Dan Nelson9 Jun
        • RE: How to empty the cache?Iago Sineiro9 Jun