4 ms·
MySQL is, by default, ACID. There are storage engines that aren't, but they are rare and not default choices.
by willvarfar 5y ago
MySQL is, by default, ACID. There are storage engines that aren't, but they are rare and not default choices.
- EdwardDiego 5y agoMyISAM used to be the default for a long while. I made a bit of extra money when younger tidying up MySQL DBs that were in inconsistent states thanks to MyISAM not enforcing FKs.
- hu3 5y agoInnoDB has been the default for over a decade.
- doctor_eval 5y agoBut the dominance of MySQL and LAMP happened long before InnoDB.
- EdwardDiego 5y agoYep, it is now. My favourite bit was when InnoDB became the default, a lot of people configured MySQL after upgrading to keep defaulting MyISAM "for performance" that they really didn't need.