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! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.13: up 6 days, processed 184,858,313 queries (347/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
