Home
Percona
Experts in MySQL, InnoDB, and LAMP Performance
  • Services
      • Support
          • MySQL Support
          • MongoDB Support
          • MariaDB Support
          • PostgreSQL Support
          • DBaaS Support
          • High Availability Support
          • Flexible Pricing
          • Support Tiers
          • Technical Account Managers
      • Managed Services
          • Percona Managed Database Services
          • Percona Advanced Managed Database Service
      • Consulting
          • Percona Cloud Cover
          • Percona Open Source Advance
          • Percona and Microsoft Azure Partnership
      • Policies
      • Training
  • Products
      • MySQL Database Software
          • Percona Distribution for MySQL
          • Percona Server for MySQL
          • Percona XtraDB Cluster
          • Percona XtraBackup
      • MongoDB Database Software
          • Percona Distribution for MongoDB
          • Percona Server for MongoDB
          • Percona Backup for MongoDB
      • PostgreSQL Database Software
      • Percona Monitoring and Management
      • Percona Kubernetes Operators
      • Open Source Database Tools
          • Percona Toolkit
          • Percona DBaaS Command Line Tool
  • Solutions
      • Eliminate Vendor Lock-In
      • Embrace the Cloud
      • Optimize Database Performance
      • Reduce Costs and Complexity
  • Resources
      • Calculators
      • 2020 Survey Results
      • Solution Briefs
      • White Papers
      • Webinars
      • Case Studies
      • Datasheets
      • Ebooks
      • Videos
      • Technical Presentations
      • Product Documentation
  • About
      • About Percona
      • Contact Us
      • Customers
      • Careers
          • Percona Lifestyle
      • In The News
      • Percona Live
      • Events
  • Blog
  • Community
      • Forums
      • Community Blog
      • PMM Community Contributions

MySQL Indexing: Best Practices

  • Home
  • Resources
  • Videos

Subscribe to the
Percona Newsletter

Subscribe Now!
Buy Support Now!

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.
 

Slides

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 2020
DBdeployer, 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
Services
  • Support
  • Managed Services
  • Consulting
  • Training
Products
  • MySQL Software
  • MongoDB Software
  • PostgreSQL Distribution
  • Kubernetes
  • Monitoring & Management
Resources
  • Solution Briefs
  • White Papers
  • Webinars
  • Case Studies
  • Datasheets
  • Documentation
More
  • Blog
  • Community Blog
  • Technical Forum Help
About
  • Customers
  • Newsroom
  • About
  • Careers

Contact Us
  • Sales & General Inquiries
  • (888) 316-9775 (USA)
  • (208) 473-2904 (USA)
  • +44 203 608 6727 (UK)
  • 0-808-169-6490 (UK)
  • 0-800-724-4569 (GER)

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners. Proudly running Percona Server for MySQL

Terms of Use | Privacy | Copyright | Legal

Copyright © 2006-2021 Percona LLC.