InnoDB vs MyISAM

from the Artful MySQL Tips List

MyISAM is typically faster for table scans. If the table needs to be updated more than occasionally, the price for this table scan performance advantage will often be more than offset by concurrency and locking issues. Load Data Infile is much slower with InnoDB, so if huge loads are required, MyISAM may be a better choice at least for a staging table. Last updated 5 Jun 2024