MySQL and InnoDB Performance for the Rest of Us

MySQL and InnoDB Performance for the Rest of Us

Dive into a comprehensive exploration of MySQL and InnoDB performance optimization in this 34-minute conference talk from SREcon21. Gain valuable insights into storage engines, performance tuning, and index design. Learn how to effectively use clustered indexes and primary keys, improve access types, and overcome index limitations. Discover the intricacies of covering indexes and understand the query parser's role in optimization. Walk away with practical knowledge to enhance your database performance and confidently tackle SQL-related challenges.