innodb_vs_myisam
This is an old revision of the document!
InnoDB vs MyISAM
| InnoDB | MyISAM |
|---|---|
| Default Engine in mysql 5.5.5 and above | MyISAM Engine in mysql versions below 5.5.5 |
| Row-level locking - less issues with backups | Full Table-level locking - lots of backup issues |
| Crash Recovery | NO crash recovery |
| No full text search in versions < 5.5 | Full text search in all versions |
MyISAM
MyISAM offers NO data integrity. It does NOT play well with unclean shutdowns and cancelled operations which can in turn cause data corruption. To attempt to resolve you would need to run a full repair or rebuild on indexes and tables.
Sources:
innodb_vs_myisam.1498482716.txt.gz · Last modified: 2024/05/23 07:26 (external edit)