Database ACID property

ACID properties
============
Atomicity :: The atomicity aspect of the ACID model mainly involves InnoDB transactions. Related MySQL features include:
   i) Autocommit setting.
   ii) COMMIT statement.
   iii) ROLLBACK statement.

Consistency :: The consistency aspect of the ACID model mainly involves internal InnoDB processing to protect data from crashes. Related MySQL features include:
   i) InnoDB doublewrite buffer.
   ii) InnoDB crash recovery.

Isolation :: The isolation aspect of the ACID model mainly involves InnoDB transactions, in particular the isolation level that applies to each transaction.
   i) Autocommit setting.
   ii) SET ISOLATION LEVEL statement.
   iii) The low-level details of InnoDB locking.

Durability :: The durability aspect of the ACID model involves MySQL software features interacting with your particular hardware configuration. Because of the many possibilities depending on the capabilities of your CPU, network, and storage devices, this aspect is the most complicated to provide concrete guidelines for.  
   i) Configuration option innodb_flush_log_at_trx_commit.
   ii) Configuration option sync_binlog.
   iii) Configuration option innodb_file_per_table.
   iv) Write buffer in a storage device, such as a disk drive, SSD, or RAID array.