List:General Discussion« Previous MessageNext Message »
From:Stefan Hinz Date:September 23 2009 7:53am
Subject:MySQL University session on Sep 24: Concurrency Control: How It Really
View as plain text  
Concurrency Control: How It Really Works

This Thursday (September 24th, 14:00 UTC (yes, 1 h later than usually)),
Heikki Tuuri, the father of InnoDB, will give a session on Concurrency
Control: How It Really Works. He'll describe how InnoDB manages
concurrency control, so that the system protects data integrity.
Beginning with the basics of transaction management, Heikki will include
a discussion of the ACID (atomicity, consistency, isolation, and
durability) properties, and explain various transaction modes, locking,
deadlocks, and more advanced topics such as the impact of next-key (gap)
locking, referential integrity, XA (distributed transaction management)
support, and more. While the discussion will focus on the InnoDB
implementation, many of the concepts presented apply to other database
systems and storage engines.

For MySQL University sessions, point your browser to this page:

You need a browser with a working Flash plugin. You may register for a
Dimdim account, but you don't have to. (Dimdim is the conferencing
system we're using for MySQL University sessions. It provides integrated
voice streaming, chat, whiteboard, session recording, and more.)

MySQL University is a free educational online program for
engineers/developers. MySQL University sessions are open to anyone, not
just Sun employees. Sessions are recorded (slides and audio), so if you
can't attend the live session you can look at the recording anytime
after the session.

Here's the schedule for the upcoming weeks:

* October 1: InnoDB Internals: InnoDB File Formats and Source Code
Structure (Calvin Sun)
* October 8: Building MySQL Releases on Unix (Jörg Brühe)
* October 15: The Spider Storage Engine (Giuseppe Maxia)
* November 12:  Gearman for MySQL (Giuseppe Maxia)

The schedule is not engraved in stone at this point. Please visit for the
up-to-date list. On that page, you can also find the starting time for
many time zones.


Sun Microsystems GmbH        Stefan Hinz
Sonnenallee 1                Manager Documentation, Database Group
85551 Kirchheim-Heimstetten  Phone: +49-30-82702940
Germany                      Fax:   +49-30-82702941      mailto: stefan.hinz@stripped

Amtsgericht Muenchen: HRB161028
Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer
Vorsitzender des Aufsichtsrates: Martin Haering

MySQL University session on Sep 24: Concurrency Control: How It ReallyWorksStefan Hinz23 Sep