Proper indexing is a key ingredient of database performance and MySQL is no exception. In this session we will talk about how MySQL uses indexes for query execution, how to come up with an optimal index strategy, how to decide when you need to add an index, and how to discover indexes which are not needed.
Presented by Peter Zaitsev at Percona Webinars - August 15th, 2012.
Related Videos: Percona MySQL Webinars, Best Practices, Operations, Performance Optimization, Query Tuning and Optimization, Search and Indexing
Boosting MySQL Performance - Jose Luis Martinez - Percona Live ONLINE 2020DBdeployer, the Community Edition - Giuseppe Maxia - Percona Live ONLINE 2020
Sharding: DIY or Out of the Box Solution? - Art van Scheppingen - Percona Live ONLINE 2020
The State of ProxySQL, 2020 Edition
Advanced Optimization and Troubleshooting MySQL Using PMM2 - Peter Zaitsev - Percona Live ONLINE 2020
Databases on Kubernetes - Rick Vasquez - PLO October 2020
Disaster Recovery and High Availability: The Concepts, The Mistakes, and How To Properly Plan For Failure