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. Attendee takeaways: - Queries to profile top tables/schemas - Toolset to assist in the profiling of your schema - Introduction to Percona Server index_statistics tool
Technical Account Manager, Percona
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 (http://okcmysql.org) and loves to expose people to the power of Open Source software.