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: 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/[EMAIL PROTECTED]