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

2006-04-07 Thread Philippe Poelvoorde
2006/4/7, Charles Q. Shen <[EMAIL PROTECTED]>: > The OS used are Mandriva and Fedora. > > Can you explain more? > I'll make it quick, there is plenty of doc on a web that will explain this better than I can. Once you read few things from your hard drive (let's say the index file for your table), i

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

2006-04-07 Thread Charles Q. Shen
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

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

2006-04-06 Thread Philippe Poelvoorde
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 tes