inotify is a handy standard Linux kernel tool to track file access/writes under a live server.

Following a Query Back and Forth in the MySQL Server

Mikael "Monty" Widenius, father of MySQL, gives an overview of query execution and use of temp tables in the MySQL Server.

How to do a good code review

MySQL Error Handling and Reporting

Ann Harrison and Jim Starkey, creator of Falcon, explain the archtecture of the Falcon storage engine.

Timour Katchaounov explains the inner workings of the MySQL Optimizer.

Konstantin Osipov explains how locking works in MySQL.

Brian Aker explains the technology behind the MySQL storage handler interface.

Lars Thalmann, now leading the MySQL Replication team, explains the architecture of MySQL Replication.

my.sys library and algorithms explained

Sergey from the MySQL Optimizer team talks about recent developments in the MySQL Optimizer, including: What's new in MySQL 5.1 optimizer, Overview of known optimizer problems in MySQL 5.1, State of new optimizations in MySQL 6.0, Optimizer development beyond 6.0

MySQL Sandbox is a tool to install a side server or a replication system in seconds, in complete isolation, without need to remember complex sequence of commands.Administrators, developers, QA and support engineers need to install and test several versions of MySQL database server. Performing this task safely, without affecting existing instances on the same host is not easy. Using MySQL Sandbox, users can: Install a new server in less than 10 seconds, just by pointing to a binary tarball; Install an system of master + slaves in replication in less than 15 seconds; Install 10 independent servers in one minute with just one command; Optionally, install the above items with complex options, using one command, without need of editing configuration files. This presentation explain how to install a server or a replication system with MySQL Sandbox, covering the basics and some advanced  []

It is overview (not really very detailed) of insert/update/replace command execution: Important structures / files to understand command execution; Types of the commands; Every type execution in more detail

Interaction Between Optimizer and Storage Engine

How to Run MySQL With a Debugger

How MySQL Handles ORDER BY, GROUP BY, and DISTINCT

This session will give you an overview about how to perform backups of a MySQL Server using file system snapshots. Lenz will explain the general procedure, Caveats and Gotchas with this backup technique and how to work around some of them. The talk will also introduce two very popular methods for performing the actual snapshots: Linux LVM and using ZFS snapshots. Other utilities suitable for creating snapshot are covered as well.

Tomas Ulin, MySQL Server Director, explains the new MySQL release model which has just recently been announced.

This session will give you an overview about how to perform backups of a MySQL Server using file system snapshots. Lenz will explain the general procedure, Caveats and Gotchas with this backup technique and how to work around some of them. The talk will also introduce two very popular methods for performing the actual snapshots: Linux LVM and using ZFS snapshots. Other utilities suitable for creating snapshot are covered as well.