Re: SQL_NO_CACHE

[Johan De Meersman]

On Wed, Mar 4, 2009 at 8:42 PM, Morten Primdahl <my.lists@stripped> 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.