Buy Percona ServicesBuy Now!
  Friday, May 31, 2013
   Bill Karwin

MySQL Query Patterns, Optimized


Join Bill Karwin, Percona’s Principal MySQL Instructor, as he classifies several common types of queries with which developers struggle, based on years of answering questions online. Bill will test several SQL solutions for each type of query objective, and show how you can use MySQL 5.6 built-in methods to analyze them for optimal query efficiency.  The discussion will cover optimizer reports, query profiling, and session status to measure performance.  The query classes include:

·         Exclusion Join

·         Random Selection

·         Greatest-Per-Group

·         Dynamic Pivot, and

·         Relational Division

Bill Karwin
Senior Knowledge Manager
Visit Percona Store

General Inquiries

For general inquiries, please send us your question and someone will contact you.