MySQL Innovation Day Abstracts

Do not forget to register for the free Webcast of MySQL Innovation Day.

Abstracts

Better Availability with InnoDB Online Operations
Calvin Sun, Sr. Development Manager for InnoDB, Oracle Many top Web properties rely on MySQL as a critical piece of infrastructure to serve millions of users. Therefore, database availability has become increasingly important. One way to enhance availability is to allow users full access to the database during DDL operations. The online DDL operations in recent MySQL releases offer users the flexibility to perform schema changes while allowing users full access to the database, that is, with minimal delay for operations on the table, and without rebuilding the entire table. Those enhancements provide better responsiveness and availability in busy production environments. In this session, you will learn those InnoDB improvements on online DDL operations, such as add index, drop foreign key, rename column, etc.

MySQL Replication HA: Global Transaction IDs for Failover & Self Healing
Lars Thalmann, Director of MySQL Replication, Backup and Connector Development, Oracle Luis Soares, Sr. Software Engineer, MySQL Replication, Oracle This session will introduce the newest replication features that enable complex, highly available and dependable infrastructure setups backed by the latest MySQL 5.6 Development Milestone Release (DMR).
The attendee will learn how the new features, including global transaction identifiers and crash-safe slaves, together with a comprehensive set of tools, make the day-to-day management of MySQL replication a lot easier and self-healing. Moreover, the attendee will learn how they enable and support rapidly evolving, business critical application requirements.

Overview of New Optimizer Features in MySQL 5.6
Manyi Lu, Sr. Engineering Manager, MySQL Optimizer, Oracle Many optimizer features have been added into MySQL 5.6 DMR. This session will give you an introduction to these great features. Multi range read, index condition pushdown and batched key access will provide huge performance improvements on large data volumes. Structured explain, explain for update/delete/insert, and optimizer tracing will help users to analyze and speed up queries. Last but not the least, this session will cover subquery optimizations in MySQL 5.6.

MySQL 5.6 Performance Schema
Chris Powers, Principal MySQL Software Developer, Oracle The MySQL Performance Schema monitors Oracle’s MySQL Server execution at a low level. This versatile and tightly integrated component collects performance and session data from various subsystems within the server during runtime.

MySQL 5.6 DMR greatly enhances the Performance Schema. Learn about the new features for performance monitoring and tuning, including statement execution statistics, network I/O performance, table and index I/O performance, table locks, file I/O performance, client connection history, and expanded configuration options.

MySQL Replication High Performance: Multi-Threaded Slaves and Group Commit
Lars Thalmann, Director of MySQL Replication, Backup and Connector Development, Oracle Luis Soares, Sr. Software Engineer, MySQL Replication, Oracle This session introduces MySQL replication scalability and performance breakthroughs in MySQL 5.6 DMR release. In particular, it highlights features such as Multithreaded slave and binary log group commits as well as a number of other enhancements for row based replication. The attendee will learn how the features work and how to make the most out of them to ultimately boost their applications throughput thus keeping up with the demands of emerging web, mobile and cloud services.

The Power of MySQL EXPLAIN
Oystein Grovlen, Sr. MySQL Staff Engineer, Oracle MySQL’s EXPLAIN command has for a long time been a very useful tool in understanding how MySQL will execute a query. MySQL 5.6 DMR offers several new additions that both gives more detailed information about query plans, and makes it easier to understand the plans. This presentation will give an overview of the new EXPLAIN features including structured presentation of the query plan in JSON format, and EXPLAIN for INSERT/UPDATE/DELETE statements. We will give several examples of how these new extensions makes it easier to understand MySQL’s query plans.

InnoDB: a New Era for Read-Only Workloads
Calvin Sun, Sr. Development Manager for InnoDB, Oracle MySQL powers 9 of the 10 top Web sites worldwide, as well as thousands of corporate web-based applications. Successful web properties need to be able to quickly adapt a growing and expanding customer workload. As the most widely used storage engine for Web applications, InnoDB offers exceptional performance and scalability. In addition to the general performance improvements in MySQL 5.5, there have been some significant breakthroughs in InnoDB scalability for read-only workloads. Those techniques are no longer only related to protected regions and their related mutexes, RW locks, or atomic variables. In this session, we will present the type of scalability improvement normally found in high-performance computing, and the special optimizations for read-only transactions.