MyISAM in the way the table data is cached. MyISAM caches only the keys, and simply hopes the OS will do a good job caching the data. InnoDB does not put any faith in the OS and takes the matter of caching the data into its own hands.
- 5.2. Interesting Aspects of Specific Configuration Variables
- from Understanding MySQL Internals
- Publisher: O'Reilly Media, Inc.
- Released: April 2007
Difference between MyISAM and InnoDB
Share this highlighthttp://www.safaribooksonline.com/a/understanding-mysql-internals/6302483/