The ARCHIVE Storage Engine, added in MySQL 4.1, is ideally suited for storing large amounts of data (without indexes) in a very small footprint, and selects using table scans. See http://dev.mysql.com/doc/mysql/en/archive-storage-engine.html for details.