Skip to content

Instantly share code, notes, and snippets.

@lchanmann
Created August 4, 2016 22:39
Show Gist options
  • Save lchanmann/36901d7962de87f10cc4ee275987e1e8 to your computer and use it in GitHub Desktop.
Save lchanmann/36901d7962de87f10cc4ee275987e1e8 to your computer and use it in GitHub Desktop.
No InnoDB in mysql
+ — — — — — — + — — — — -+ — — — — — — — — — — — — — — — — — — — — — — — — — — — — — — — — + — — — — — — — + — — — + — — — — — — +
| Engine | Support | Comment | Transactions | XA | Savepoints |
+ — — — — — — + — — — — -+ — — — — — — — — — — — — — — — — — — — — — — — — — — — — — — — — + — — — — — — — + — — — + — — — — — — +
| MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |
| BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) | NO | NO | NO |
| CSV | YES | CSV storage engine | NO | NO | NO |
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |
| FEDERATED | NO | Federated MySQL storage engine | NULL | NULL | NULL |
| ARCHIVE | YES | Archive storage engine | NO | NO | NO |
| MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance | NO | NO | NO |
+ — — — — — — + — — — — -+ — — — — — — — — — — — — — — — — — — — — — — — — — — — — — — — — + — — — — — — — + — — — + — — — — — — +
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment