Join performance on MyISAM and InnoDB tables
Posted
by
j0nes
on Server Fault
See other posts from Server Fault
or by j0nes
Published on 2011-01-14T08:38:29Z
Indexed on
2011/01/14
8:54 UTC
Read the original article
Hit count: 439
I am thinking about converting some tables from MyISAM to InnoDB in my mysql server. The tables will certainly benefit from the change because a lot of write requests come to these tables, while there are also quite a lot of read request at the same time.
However, they are often joined together with some tables that almost don't get any writes. Is there a performance penalty when joining together MyISAM and InnoDB tables or should everything work fine?
Second question: During backups at night, I am copying data from the InnoDB tables to MyISAM tables for archiving purposes. In these backups, a lot of write-requests happen, however there is almost no read from these archive tables. Would these tables also benefit from using InnoDB or is this just a waste of space and RAM?
© Server Fault or respective owner