Speakers | |
---|---|
Sergey Petrunya | |
Schedule | |
Day | Sunday |
Room | H.1309 |
Capacity | 150 |
Start time | 10:30 |
End time | 10:55 |
Duration | 00:25 |
Info | |
Track | MySQL and Friends Devroom |
MariaDB 5.3's query optimizer: taking the dolphin to where he's never been before
A typical recent version of a MySQL-based product focuses on letting you run the same queries on more CPU cores, or having better replication. MariaDB 5.3 is very different: its focus is the new query optimizer features that let you run queries that were traditionally considered off-limits for MySQL.
MariaDB 5.3 is getting stable: 5.3.3 Release Candidate has been released in December, and one can expect another, almost? stable release in January or February.
This talk will show: - What kinds of traditionally no-no queries are now okay to run, - What optimizations are used to execute them, - How the new optimizations behave for typical kinds queries and popular
benchmark suites.
In conclusion, we will discuss relationship with other MySQL branches: which of these new optimizations will also be in MySQL 5.6, what are the differences between MySQL and MariaDB variants, and what one can expect to see in Percona server.
Concurrent events:
Next (up to 3) talks in the same room (H.1309):
When | Event | Track |
---|---|---|
11:00-11:25 | How to offload MySQL server with Sphinx | MySQL and Friends |
11:30-11:55 | Build simple and complex replication clusters with Tungsten Replicator | MySQL and Friends |
12:00-12:25 | Cluster internals | MySQL and Friends |