On Wed, Mar 4, 2009 at 8:42 PM, Morten Primdahl <my.li...@mac.com> 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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
