Hi Trevor, MySQL itself doesn't cache any of the data (.MYD) file. The operating system uses any free RAM to cache that file data. This is why I don't think it's that important to have such a huge key_buffer, because some of that memory would probably be better used for caching the data file. Index data can be read from disk a lot faster than rows can -- and the OS will also cache the index data even when MySQL's key_buffer does.
Hope that helps. Matt ----- Original Message ----- From: "trevor%tribenetwork.com" Sent: Monday, January 12, 2004 5:20 PM Subject: Loading the .myd into memory > Mysqlians, > > > > Greetings. Besides the query cache is their a buffer which > holds the data portion of MyISAM tables. All the buffers seem to hold key > information or query processing information. > > > > Thanks, > > > > Trevor -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]