Percona Live: Data Performance Conference 2016 Logo

April 18-21, 2016

Santa Clara, California

Schema Review 101: How and What You Should Be Looking at . . .

Schema Review 101: How and What You Should Be Looking at . . .

 19 April 11:30 AM - 12:20 PM @ Room 204
Experience level: 
Beginner
Duration: 
50 minutes conference
Tracks:
MySQL 101
Operations and Management
Topics:
MySQL

Description

The goal of this talk is to review the key features that would be part of a schema review, including things such as largest tables, index issues and table activity. Since learning how to profile your data is important when looking at capacity planning, architecture, and application design, I'll also highlight methods/queries to find big tables, information_schema tables to review, and tools to find low hanging fruit. Attendee takeaways: - Queries to profile top tables/schemas - Toolset to assist in the profiling of your schema - Introduction to Percona Server index_statistics tool

Speakers

Michael Benshoof's picture

Michael Benshoof

Technical Account Manager, Percona

Biography:

Mike is a Technical Account Manager with Percona and specializes in performance tuning and architecture/application design leveraging open source systems. His background is in the web development space, but he has several years of experience as a MySQL DBA and consultant as well. Mike founded and continues to lead the Oklahoma City MySQL User Group (h​ttp://okcmysql.org) ​and loves to expose people to the power of Open Source software.

Share this talk


Slides