RE: MySQL 4.1.11 innodb cache can't be flushed after restart ?

[Charles Q. Shen]

The OS used are Mandriva and Fedora. 

Can you explain more?

Thanks.

Charles  

> -----Original Message-----
> From: Philippe Poelvoorde [mailto:pooly7@stripped] 
> 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 <qs2005@stripped>:
> > 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/mysql?unsub=1
>