Percona Live: Open Source Database Performance Conference - Amsterdam 2016 Logo

October 3-5, 2016

Amsterdam, Netherlands

Improving Performance with Better Indexes

Improving Performance with Better Indexes

 4 October 11:20 AM - 12:10 PM @ Zürich 2
Experience level: 
Beginner
Duration: 
50 minutes conference
Tracks:
Scalability/Performance
MySQL
Topics:
MySQL
Optimization
Tools and Techniques

Description

Learn how to use one simple advanced technique to make better MySQL indexes and improve your queries by 500% or more. Even with a highly indexed schema significant improvements in performance can be achieved by creating better indexes. This presentation introduces the approach for correct identification and verification of problem SQL statements and then describes the means of identifying index choices for optimization. Then discussed is not only how to apply indexes to improve query performance, but how to apply better indexes and provide even greater performance gains. This presentation includes: - 6 steps to successful SQL review - Effective examples of capture SQL via application logging and TCP/IP analysis - All the commands necessary to identify why and how to create indexes - How the number of table rows and different storage engines can effect query performance - How to create an iterative verification process

Speakers

Ronald Bradford's picture

Ronald Bradford

Founder & CEO, EffectiveMySQL

Biography:

Ronald has over 25 years of professional RDBMS experience in MySQL, Oracle, and Ingres. His expertise covers MySQL, LAMP and cloud-based consulting in architecture, performance, scalability and business continuity. Ronald is a former employee of the MySQL Inc consulting team (06-08) and Oracle Corporation (96-99). He has currently published 4 books on MySQL, his most recent titles available from Oracle Press include Effective MySQL: Optimizing SQL Statements, Effective MySQL: Backup & Recovery and Effective MySQL: Replication Techniques in Depth.

Share this talk


Slides