Michael Benshoof, Technical Account Manager at Percona, brings his talk, Schema Review 101: How and What You Should Be Looking at.
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.
- Queries to profile top tables/schemas
- Toolset to assist in the profiling of your schema
- Introduction to Percona Server index_statistics tool