Future Design Hurdles to Tackle in the MySQL Server

Like all software, the MySQL server has evolved over time. The architecture of the MySQL server is distinct from many other relational database systems, both in its well-known pluggable storage engine layer and also for less-known things like its connection-based memory allocators.

In this talk, MySQL Fellow, Monty Widenius will talk about the architectural and design challenges currently facing the MySQL server developers, including a bit of history behind why the architecture of MySQL looks the way it does. Then Monty will talk about the future architecture of the MySQL server and the plans he and others have to solve the design issues of the present day.

The session is recommended for those interested in both the internal workings of MySQL and those who look to extend the MySQL server in the future. A light discussion of the MySQL internals will be followed by a discussion of the future architectural concepts that Monty has. Jay Pipes will be on hand to act as a translator of Monty-speak and provide comedic relief.

Topics covered include:

• Memory and connection handling

• Thread resource contention issues

• Storage engine interface issues

• Optimizer changes

• Other stuff…