The standard table handler for MySQL is not ACID compliant because it doesn't support consistency, isolation, or durability. However, the default table handler supports atomicity using table locks. MySQL includes components such as the InnoDB storage engine that adhere closely to the ACID model, WHY? MySQL has nine storage engine, but only two of those really matter to most users: MyIsam and InnoDB. MyIsam was the original engine, built for speed, but it lacked transactions; InnoDB has transactions and is speedier than MyIsam, which is why it’s the default storage engine InnoDB supports Row-level Locking It's designed for maximum performance when processing high volume of data It support foreign keys hence we call MySQL with InnoDB is RDBMS It stores its tables and indexes in a tablespace It supports transaction. You can commit and rollback with InnoDB On the contrary MYISAM supports Table-level Locking and designed for need of speed It does ...