The OS used are Mandriva and Fedora. Can you explain more?
Thanks. Charles > -----Original Message----- > From: Philippe Poelvoorde [mailto:[EMAIL PROTECTED] > Sent: Friday, April 07, 2006 2:43 AM > To: MySQL General > Subject: Re: MySQL 4.1.11 innodb cache can't be flushed after > restart ? > > 2006/4/7, Charles Q. Shen <[EMAIL PROTECTED]>: > > Hi all, > > > > I am running MySQL 4.1.11 with an innoDB table holding > about 17GB of > > records. I took a few hundreds of randomly selected records > from the > > table and measured the average access time: > > > > 1st test: average access time is 600ms 2nd test: average > access time > > is 30ms 3rd test: average access time is 15ms Stop and > restart MySQL > > 4th test: average access time is 15ms > > > > Note that I stopped and restarted mysql between the 3rd and > 4th test > > but the average access time does not change. > > What OS do you use ? It's quiet likely you hit the FS cache, > not the MySQL one. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]