What will be the best storage engine for table with 74 million records, currently stored as MyISAM table size 7.6G.
Operations are mostly select and update. DDL operations (ALTER ADD COLUMN) are occasionally performed.
Joins and alter operations on MyISAM tables are extremely slow.
Will InnoDB with large innodb_buffer_pool_size be optimal for this scenario or shall I go with In-memory tables?