disadvantages of losing the data on system shutdown.
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 10, 2005 1:43 PM
To: Bob O'Neill
Cc: mysql@lists.mysql.com
Subject: Re: Slow queries only the first time
On Mar 10, 2005, at 11:20 AM, Bob O&
On Mar 10, 2005, at 11:20 AM, Bob O'Neill wrote:
Hello. I am wondering why some of my queries are slow on the first
run, but
speedy on subsequent runs. They are not being query cached, as I have
query_cache_type set to DEMAND. Is it something as simple as pulling
the
data into RAM from disk,
Most likely it's the OS cache caching all those disk
segments in memory. Also in InnoDB, MySQL uses the
Buffer Pool Size to cache data pages in addition to
the OS cache.
If you're running ona Windows machine, you can easily
tell what's going on by opening up Performance Monitor
and watching Pages/
Hello. I am wondering why some of my queries are slow on the first run, but
speedy on subsequent runs. They are not being query cached, as I have
query_cache_type set to DEMAND. Is it something as simple as pulling the
data into RAM from disk, or is there something else going on? Here's a
simpl
