MySQL™: The World’s Most Popular Open Source Database 177 Storage Engine: MyISAM • Developed by MySQL AB (replaced original ISAM) • Static, dynamic and compressed (read-only) row formats but no transactions • Text and compressed indexes • Data and indexes in separate files • Fast read/write performance but low r/w concurrency • Extremely good concurrency in the select and insert at end case (logs) • External check and repair program (myisamchk) • Especially useful for websites & logging Copyright 2003 MySQL AB
MySQL Page 176 Page 178