Hi everyone. I'm using MySQL 4.0.16 with W2K/SP4 on a 512KB RAM/1.2GHz
Athlon machine (my dev workstation).
I'm having a strange problem: when I execute a query via the MySQL Control
Center, it takes 10 seconds to return. About three seconds into the query,
I issue a mysqladmin processlist and see
There is caching but it is at OS level: on first query, data are
fetched from disk; other queries read directly from file system cache.
Hope this helps
Joseph Bueno
[EMAIL PROTECTED] wrote:
Hi everyone. I'm using MySQL 4.0.16 with W2K/SP4 on a 512KB RAM/1.2GHz
Athlon machine (my dev workstation).
: [EMAIL PROTECTED]
|
| Subject: Re: inconsistent query times for same query
[EMAIL PROTECTED] wrote:
Thanks Joseph.
I just to another look at the query and it actually takes 65 seconds on the
first run, not 10 seconds, so this is important for me to understand.
So my next questions are:
Is there any way to tune the OS file system cache?
This is very OS system dependent