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:
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]:
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), it's
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