MySQL Indexing: Best Practices for MySQL 5.6

Apr 30, 2014

Percona MySQL Webinar

Peter Zaitsev, CEO

Watch webinar recording: http://www.percona.com/resources/mysql-webinars/mysql-indexing-best-prac...

Proper indexing is a key ingredient of database performance, and MySQL is no exception. Peter Zaitsev shares new indexing techniques based on MySQL 5.6 optimizer improvements, including:

  • 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
  • How to be able to distinguish which indexes may be unnecessary