Query Optimization with MySQL 5.7 and MariaDB 10: even newer tricks

Performance Optimization
3 November 9:00am - 12:00pm @ Orchard 2

Duration: 
3 hours tutorial
Last year I presented some of the changes in the MySQL 5.6 Optimizer that made the latest version of MySQL faster for those developers that knew how to take advantage of them, and also reviewed some of the more traditional and basic techniques on how to improve the performance of your applications (http://www.percona.com/live/london-2013/sessions/query-optimization-mysql-56-old-and-new-tricks). This year, now that MariaDB 10 has been released, and MySQL 5.7 is around the corner, I will open my tutorial to mention all the great features that Oracle, MariaDB Corporation, and Percona Server Engineers have been doing for the last months to make the MySQL ecosystem even faster and easier to use for DBAs and programmers. The topics include: new 5.7 cost-based optimizer, virtual columns, query rewriter plugin api, new join methods, subquery optimization, sql mode changes, full text search and GIS improvements. Everything with 3rd party real-world examples and practical results instead of laboratory, impossible-to-apply samples. This tutorial is aimed to Developers and DBAs in charge of MySQL applications, and who want to take full advantage -or just learn- about the latest query optimizer features in the newest MySQL server versions and tools. If you didn't attend to my last year's tutorial, do not worry as there will be no dependency on it. If you did attend, come back again for new great content, as there will be no overlap with that previous tutorial. Agenda: 1. Introduction 2. Break (VM installation) 3. General Optimizer Improvements 4. Computed/Virtual Columns 5. Query Rewrite Plugins 6. SQL Mode Changes 7. Join Optimization 8. Subquery Optimization 9. Fulltext search 10. GIS Improvements 11. Break 12. Query Profiling 13. Results and Conclusions 14. Q&A IMPORTANT: If you plan to attend this tutorial, predownload the virtual machine as explained here: http://dbahire.com/pluk14


Speakers

Sr Database Administrator, Wikimedia Foundation
Biography: 
Jaime works as the senior database administrator for the non-profit organization Wikimedia Foundation, host of Wikipedia and other similar open knowledge projects. His main topics of interest are MySQL query optimization and architectures for high availability. He is a former MySQL A.B./Sun Microsystems/Oracle/Percona instructor and consultant, and has also worked as an independent MySQL consultant at DBAhire.com.

Slides