Is a mixture of both MyISAM and InnoDB table types on the same MariaDB 10.3 database 'bad'?

spaceman

• April 10, 2022 23:01

Hi All, I notice that some of our MariaDB 10.3 database have a mixture of MyISAM and InnoDB table types on them. Is it inherently "bad" to have both types of table on the same database? Or doesn't/shouldn't it make any difference? If it is ill-advised, then I guess we'll look into converting all tables to InnoDB, as this seems to be the preferred? Thx for your thoughts.

• 

  cPRex Jurassic Moderator

  • April 11, 2022 18:22

  Hey there! From a MySQL standpoint, there's no reason you can't have both working in the same database just fine. It could potentially cause confusion down the road with administration, but the server doesn't mind at all.

  0
• 

  spaceman

  • April 11, 2022 23:21

  Thanks for that cPRex. It still "feels weird" to have both, though! I'm a big "less is more" fan :-)

  0

Please sign in to leave a comment.