Most people use the default storage engine, without really thinking about it, bu... | Hacker News

Hacker News new | past | comments | ask | show | jobs | submit

login

debacle on Oct 2, 2013 | parent | context | favorite | on: MySQL is to SQL like MongoDB to NoSQL

Most people use the default storage engine, without really thinking about it, but almost every project I've worked with recommends innodb - not sure why.

VLM on Oct 2, 2013 [–]

There's no surprise it became the default storage engine instead of myisam around early ver 5.5 or so, it is superior to myisam in many ways.

Personally I like the row level locks and the way it can enforce foreign keys, which myisam can't do.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact