At 12:07 PM 2/24/2004, Keith C. Ivey wrote:
Sounds like it's your operating system's caching of the disk reads.
Yikes... that would explain it.
um... anyone know how to disable disk caching on Linux 2.6 kernel?
-bill
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
T
On 24 Feb 2004 at 12:00, Bill Marrs wrote:
> Actually, I just noticed that even after I restart mysql, the speed
> stays. That doesn't make any sense, maybe there is some other unknown
> factor influencing this.
Sounds like it's your operating system's caching of the disk reads.
--
Keith C. Iv
At 11:35 AM 2/24/2004, Mike Johnson wrote:
It sounds like query caching is working against you.
There are a variety of ways to get around it. While it'll be a PITA, you
may want to have you script call `RESET QUERY CACHE` at the begining, and
then include `SQL_NO_CACHE` in your SELECT statement(
Are you logging slow queries? Have you run an explain plan for the
queries in question?
>> Original Message <<
On 2/24/04, 10:29:33 AM, Bill Marrs <[EMAIL PROTECTED]> wrote regarding
disabling optimizations to identify slow queries:
> I've found a performance i
From: Bill Marrs [mailto:[EMAIL PROTECTED]
> I've found a performance issue with a series of mysql queries
> that I make to generate a web page. But, when I go to
> investigate it, reloading the page a few times, I find the
> performance of the pages within a couple tries becomes very
> fast.
