Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
From: Paul DuBois (paulmysql.com)
Date: Fri Dec 21 2007 - 09:38:27 CST
At 9:01 AM -0500 12/21/07, Duhaime Johanne wrote:
>We are doing some performance tests and would like to disable the cache.
>We did set the query_cache_size=0 but it did not have any effect as well
>as a "select no_cache". The process is a select on MyISAM table. We are
>using a Mysql 5.0.27.
>We are wondering if Mysql uses a file to cache or something like this.
>The first request take several seconds but the second is instantaneous.
>Even if we stop Mysql it does the second one very fast. It is quite odd.
You might be seeing the effect of filesystem caching even when the
MySQL query cache is disabled.
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql