Q

ACID-compliant MySQL

A MySQL expert talks about the significance of ACID-compliant transactions and names two MySQL databases that use them.

What are ACID-compliant transactions? Does MySQL support them?

ACID stands for Atomicity, Consistency, Isolation and Durability. In a database server with many simultaneous connections,...

problems might arise if some process changes data between the time an application has searched for it and tries to act on it. ACID-compliant transactions ensure that processes cannot interfere with each other, and that data remains in a complete state.

MySQL offers ACID-compliant transactions with the InnoDB engine, and the upcoming Falcon engine. See http://dev.mysql.com/books/mysqlpress/mysql-tutorial/ch10.html

This was last published in April 2007

Dig Deeper on Open source databases

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

SearchServerVirtualization

SearchCloudComputing

SearchEnterpriseDesktop

Close