On Mon, Jun 09, 2003 at 12:30:23PM +0200, Iago Sineiro wrote:
> 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 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)