List:General Discussion« Previous MessageNext Message »
From:Charles Q. Shen Date:April 7 2006 7:19am
Subject:RE: MySQL 4.1.11 innodb cache can't be flushed after restart ?
View as plain text  
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
> 

Thread
MySQL 4.1.11 innodb cache can't be flushed after restart ?Charles Q. Shen7 Apr
  • Re: MySQL 4.1.11 innodb cache can't be flushed after restart ?Philippe Poelvoorde7 Apr
    • RE: MySQL 4.1.11 innodb cache can't be flushed after restart ?Charles Q. Shen7 Apr
      • Re: MySQL 4.1.11 innodb cache can't be flushed after restart ?Philippe Poelvoorde7 Apr
    • RE: MySQL cache problem - innodb_buffer_pool_size and FS cacheCharles Q. Shen15 Apr
      • Re: MySQL cache problem - innodb_buffer_pool_size and FS cacheDan Nelson15 Apr
        • RE: MySQL cache problem - innodb_buffer_pool_size and FS cacheCharles Q. Shen15 Apr
          • Re: MySQL cache problem - innodb_buffer_pool_size and FS cacheDan Nelson16 Apr
            • Should we petition GoDaddy?Nicolas Verhaeghe16 Apr
              • RE: Should we petition GoDaddy?David T. Ashley16 Apr
              • Re: Should we petition GoDaddy?James Eaton17 Apr
                • Re: Should we petition GoDaddy?David Logan17 Apr
              • Re: Should we petition GoDaddy?Dotan Cohen17 Apr