Home
Topics
Enterprise Linux applications and databases
Open source databases
ACID-compliant MySQL

ACID-compliant MySQL

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

Requires Free Membership to View

Login

By submitting you agree to receive email communications from
TechTarget and its partners. Privacy Policy Terms of Use.

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

More News and Tutorials

Articles

This was first published in April 2007

Join the conversationComment

Share

Comments

Results

Contribute to the conversation

All fields are required. Comments will appear at the bottom of the article.

Back to top

More from Related TechTarget Sites

Data Center
Server Virtualization
Cloud computing
Enterprise Desktop

Data Center
- Data center modernization starts with cloud, SDN and virtualization
  
  Some of the technologies driving data center modernization include cloud computing, flash storage, virtualization and software-defined networking.
- Data center technologies evolve to meet tomorrow's computing demands
  
  VMware's upcoming public cloud and AMD's 64-bit ARM servers are technologies for the data center that exemplify the changes in the IT industry.
- New data center cooling strategies to improve efficiency, lower costs
  
  Stagnant strategies for data center cooling will keep energy bills climbing ever higher, but a more modern approach can bring them back down to earth.
Server Virtualization
- How to achieve optimal resource allocation and why that matters
  
  Optimal resource allocation is a tricky tightrope act for even experienced IT pros, but you can ease the process by asking yourself a few questions.
- Virtualization widens schism between server and networking teams
  
  Virtual networking has revived tensions between server and networking teams within data centers, but it's a dynamic both sides must embrace.
- Strike a common-sense balance when deciding what to automate
  
  Consider the many factors that determine the potential return on investment when deciding when and what to automate.
Cloud computing
- Interest in private clouds grows as market matures
  
  Growing interest in private clouds reflects an improved understanding of cloud computing among IT pros, experts say.
- Building a cloud ecosystem with open source software
  
  The open source community fosters innovation in the name of cloud. OW2's Cédric Thomas talks of 'coopitition' and the open source cloud revolution.
- Sequestration stymies federal government cloud ambitions
  
  The federal government is under mandates to consolidate data centers and deliver IT as a Service, but sequestration makes this easier said than done.
Enterprise Desktop
- New Office 2013 features can help IT pros as much as end users
  
  New features in Microsoft Office 2013 make desktop management more efficient. See what Office Web Apps Server, Office Telemetry and more can do.
- How to remove a Windows.old folder
  
  Deleting a Windows.old folder seems simple, but it isn't. Our expert explains why Windows Desk Cleanup won't work.
- Finding a prescription for desktop security management at Sharp HealthCare
  
  Desktop security policy must cover the use of mobile devices and the cloud. Sharp HealthCare uses a mix of software for desktop security management.

All Rights Reserved,Copyright 2003 - 2013, TechTarget