From: Johan De Meersman Date: March 4 2009 8:49pm Subject: Re: SQL_NO_CACHE List-Archive: http://lists.mysql.com/mysql/216598 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit On Wed, Mar 4, 2009 at 8:42 PM, Morten Primdahl wrote: > around while trying to figure out why the first query was slow and the > subsequent snappy. Given that you posted that a MySQL restart does not change anything, but a system restart does, I put my money on the filesystem cache having buffered your data/index file on the second access. -- Celsius is based on water temperature. Fahrenheit is based on alcohol temperature. Ergo, Fahrenheit is better than Celsius. QED.