Joining InnoDB tables with MyISAM tables
What jumps out immediately at me is MyISAM. ASPECT #1 : The JOIN itself Whenever there are joins involving MyISAM and InnoDB, InnoDB tables will end up having table-level lock behavior instead of row-level locking because of MyISAM’s involvement in the query and MVCC cannot be applied to the MyISAM data. MVCC cannot even be …