Following a Query Back and Forth in the MySQL Server

Mikael Ronstrom, father of MySQL Cluster, explains the architecture of NDB (MySQL Cluster).

Jan Kneschke, creator of MySQL Proxy, gives an overview of the architecture and usage of MySQL Proxy.

Reggie Burnett, father of the MySQL Connector/NET API, explains how to build MySQL on Windows.

MySQL memory handling and memory handling in Falcon

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

MySQL Sandbox is a tool that can install a side instance of MySQL in a few seconds, efficiently, precisely, and without influencing existing installations. Testing new versions can be tedious and error prone. Using MySQL Sandbox, the process of testing single servers or replication systems can be greatly simplified.

Random Query Generator is a new QA tool that generates pseudo-random queries targeted to exercise a specific part of the server being tested. It then executes those queries to check for crashes or assertions or to compare the results returned from two different servers (two versions, two different storage engines, optimizer flags, etc.). It is also able to execute queries against a replication master, constantly checking that the slave is OK and has not diverged.

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

Run-through of PHP and Database support in NetBeans

OpenSolaris Web Stack (http://opensolaris.org/os/project/webstack) is an OpenSolaris project and community building an integrated stack of popular open source web tier infrastructure technologies such as Apache HTTP server, MySQL, memcached, PHP and Ruby On Rails optimized for Solaris platform. This session introduces OpenSolaris Web Stack, its status and future development including addition of newer technologies such as lighttpd, Varnish etc., as well as the ease of use features for developers and deployers. We will also be discussing an experimental web stack IPS package repository and it could be leveraged to build and make available popular end user applications such as Drupal.

Building MySQL client applications