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