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: 410

Filed under:
|
|
|

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

Related posts about mysql

Related posts about Performance