3 ms·
Great explanation. Would you recommend mixing InnoDB and MyISAM tables within a database based on read/write levels of certain tables? My general knowledge of
by truebosko 18y ago
Great explanation. Would you recommend mixing InnoDB and MyISAM tables within a database based on read/write levels of certain tables?
My general knowledge of databases says Yes, no problem but having much less experience, I figure it won't hurt to ask.
- jkmcf 18y agoFrom what I've read, NEVER mix InnoDB and MyISAM tables in the same database. Update: While they don't say never, they don't recommend it. Managing backups gets a lot harder. Also, you should never mix innodb and myisam tables within a transaction, which is probably what I was attaching never to. http://www.mysqlperformanceblog.com/2009/01/12/should-you-move-from-myisam-to-innodb/ http://www.mysqlperformanceblog.com/2009/01/12/should-you-mo...