Differences

This shows you the differences between two versions of the page.

--- innodb_vs_myisam [2017/06/26 13:29] – luke7858
+++ innodb_vs_myisam [2024/05/23 07:26] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
 === InnoDB vs MyISAM ===
 ^ InnoDB ^ MyISAM ^
-| Default Engine in mysql 5.5.5 and above   | MyISAM Engine in mysql versions below 5.5.5       |
+| Default Engine in mysql 5.5.5 and above   | Default 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.6 and greater | Full text search in all versions |
-| | |
+| .idb, .FRM,  | .MYD, .FRM|
 \\
 === InnoDB ===
-InnoDB is a high reliable high performance db.
+InnoDB is a highly reliable, high performance engine.
+\\
+ACID compliant (Atomicity, Consistency, Isolation, Durability) --> Transactions featuring commits, rollbacks, crash recovery. More information on ACID (https://dev.mysql.com/doc/refman/5.7/en/mysql-acid.html)
+\\
+Supports FOREIGN Key Constraints (https://dev.mysql.com/doc/refman/5.6/en/innodb-foreign-key-constraints.html)
 \\
-ACID compliant (Atomicity, Consistency, Isolation, Durability) --> Transactions featuring commits, rollbacks, crash recovery.
 \\
 === MyISAM ===
@@ Line 19: / Line 22: @@
 \\
 __Sources__:
+\\
 https://dev.mysql.com/doc/refman/5.7/en/innodb-introduction.html
 \\