MySQL memory tables performance InnoDB MyISAM recent versions

MySQL maximum table size InnoDB vs MyISAM database size limits SQL database management MySQL table creation

MyISAM InnoDB MySQL storage engines transaction support table locking foreign key constraints