5 ms·
MySQL: Wait a sec, what do I use for this table, InnoDB or MyISAM? What are the tradeoffs again? Oh, right, do I want ACID transactions or fulltext search? Man,
by rayrrr 7y ago
MySQL: Wait a sec, what do I use for this table, InnoDB or MyISAM? What are the tradeoffs again? Oh, right, do I want ACID transactions or fulltext search? Man, this tradeoff sucks.
PostgreSQL: Wait a sec, which schema (namespace) should I put this table in? Man, it's nice to have namespaces within a DB.
- Thaxll 7y agoNo one has been using MyISAM for the last 10 years.
- rayrrr 7y agoFunnily enough, I have not been using MySQL for the last 10 years either, because I switched to Postgres and never went back.
- evanelias 7y agoFair, but why comment on MySQL's supposed deficiencies if your knowledge of it is so out-of-date?
- Thaxll 7y agoBut vanilla PG didn't get good master / slave feature until "recently" so you were running without replicas in the last 10 years? https://www.postgresql.org/about/news/1235/ https://www.postgresql.org/about/news/1235/
- bjt 7y agoYour link is from 9 years ago.
- nevertoolate 7y agoThis happens when someone asks a versus question on a Sunday.
- Thaxll 7y agoThe release from 9 years ago was not even close to what MySQL was offering at the time.
- AdrianB1 7y agoUnfortunately this is not true, I found it used in the most unexpected places, even new developments as old as 2-3 years.
- miahi 7y agoThat's mostly because it's the default in some versions and the developers don't know/care that MyISAM is dangerous (as it's not transactional and it will transparently ignore any kind of foreign key statement).
- deleted 7y ago[deleted]
- mike22 7y agoWe specifically had to switch to MyISAM for some things when upgrading from 5.5 to 5.7, in 2017. We were hitting InnoDB’s 4k row limit in many cases (without clobs). Fortunately the tables in question are filled once, updated a couples times right after, and from then on only read, so lack of ACID is ok just for that. (All the real transactional tables are InnoDB.)
- NightlyDev 7y agoInnoDB got fulltext search support nearly 7 years ago if I remember correctly...
- johannes1234321 7y agoInnoDB has Fulltext search for about 10 years now. Also in other regards InnoDB has all MyISAM funcionality for a while and is faster in by far most realistic scenarios.
- evanelias 7y agoMyISAM is considered deprecated at this point. It isn't crash-safe and basically should not be used at all, let alone for a new project. InnoDB has supported fulltext indexes since 5.6 (GA release back in feb 2013). However, to be fair, fulltext indexes in InnoDB are not widely used and have a mixed reputation at best. Large MySQL-based companies tend to lean on external search services e.g. Solr. I'm not familiar enough with pg's fulltext to compare. I would expect the functionality is superior to InnoDB's, but I am genuinely curious whether large pg-based companies rely on it solely vs using an external search index service.