List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:March 4 2009 8:49pm
Subject:Re: SQL_NO_CACHE
View as plain text  
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.
Thread
SQL_NO_CACHEMorten4 Mar
  • Re: SQL_NO_CACHEMicah Stevens4 Mar
  • Re: SQL_NO_CACHEPerrin Harkins4 Mar
  • Re: SQL_NO_CACHEThomas Spahni4 Mar
    • Re: SQL_NO_CACHEPerrin Harkins4 Mar
      • Re: SQL_NO_CACHEjocelyn fournier4 Mar
        • Re: SQL_NO_CACHEMorten Primdahl4 Mar
          • Re: SQL_NO_CACHEjocelyn fournier4 Mar
            • Re: SQL_NO_CACHEMicah4 Mar
          • Re: SQL_NO_CACHEJocelyn Fournier4 Mar
            • Re: SQL_NO_CACHEMorten Primdahl4 Mar
              • Re: SQL_NO_CACHEJohan De Meersman4 Mar