Blog: MySQL University: Concurrency Control: How It Really Works

Views:
5992

One of the major advantages of InnoDB over MyISAM storage engine is its ability to use transactions. If you're unfamiliar with the term, I strongly encourage you to look it up. In short, when using transactions you can avoid situations when two users trying to modify same set of data interfere with each other. While this might not be a serious issue for your average blogging site, when it comes to more serious applications like banking or business logic, transactions are absolutely necessary.

This week's MySQL University session deals with some internal details of how transactions work in MySQL in general and in InnoDB in particular. A word of warning: this is not an introduction to transactions as such, so you'd better familiarise yourself with the basics.

The slides for presentation are already available at MySQL Uni's website [http://forge.mysql.com/wiki/Concurrency_Control:_How_It_Really_Works] so you can check out, if you're interested.

The session is held this Thursday, September 24th on 14:00 UTC. If for whatever reasons you aren't able to participate the session will also be archived as Flash movie.

For more information about MySQL University, go to my introductory post [/blog/mysql-university]