MySQL, MyISAM or InnoDB?

Forum Moderators: open

Message Too Old, No Replies

MySQL, MyISAM or InnoDB?

csdude55

7:33 am on Nov 27, 2020 (gmt 0)

As I'm considering the upgrade from 5.5 to 8.0, I'm reading that 8.0 is significantly improved for InnoDB.

It's my understanding, though, that InnoDB is best for tables with a lot of writes, while MyISAM outperforms on tables with a lot more read activity than writes. Is that correct?

Most (if not all) of my tables have a huge amount more reads than writes, so I'm thinking that I should stick with MyISAM... unless MySQL 8.0 has improved InnoDB to the point that it would be faster than MyISAM now?

Dimitri

9:51 am on Nov 27, 2020 (gmt 0)

Today, the good practice is to use InnoDB, and this is why MySQL is using it, by default (if you do not mention an engine, it's InnoDB which is selected).

However, as you said, MyISAM will always be faster, when it comes to reading operations.

Personally, for my usage, I have 90% reads, so I prefer to stick with MyISAM. I also use with fixed size rows, as much as possible.

These are not a recommendations, I am just sharing a personal opinion.