Re: Loading the .myd into memory

2004-01-12 Thread Matt W
g 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

Loading the .myd into memory

2004-01-12 Thread trevor%tribenetwork.com
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