Sample Header Ad - 728x90

Is Mysql ACID Compliant?

9 votes
3 answers
10614 views
Is Mysql not an ACID compliant according to Postgresql? In some blogs I see Mysql is not ACID compliant. How true is that? Let't not consider the replication here, lets consider a standalone and how efficient is Mysql ACID? In my understanding for Mysql-ACID. > A - Atomicity (Set of transactions should all be committed if one > fails it has to rollback. Yes means all are committed , no means even > one failed it has to Rollback). > > I.E. Features that supports in Mysql are. > > - start Transaction; ..... commit ; > - auto_commit=1; > > C - Consistency. > > ( PK,FK,UK,NOT-NULL). It adheres to Relations and constraints for > Databases. Instance a parent key can be deleted only when its child > key is removed. > > I - Isolation. Isolation between users and their state of commit. > > Read Repeatable Read Uncommitted Read Committed Serialized > > D - Durability. At the event of DB crash innodb recovers the DB by > applying committed transaction from iblog file and discards > not-committed transaction. Click here for the source of this question. - Is it because the blog is created @2001? **UPDATE Jun-30-2017:** As per "Evan Carroll" response and I have personally tested the blog experiment on 5.7.18-enterprise. The results obtained from the experiment seems to be **Mysql is Not an ACID Compliant.**
Asked by Mannoj (1581 rep)
Jun 29, 2017, 07:03 AM
Last activity: Nov 7, 2021, 02:17 PM