Subscribe to the
Percona Newsletter

Subscribe Now!
  Thursday, October 19, 2017    Matthew Boehm

What You Need to Get the Most Out of Indexes – Part 2

Proper indexing is key to database performance. Finely tune your query writing and database performance with tips from the experts. MySQL offers a few different types of indexes and uses them in a variety of ways.

In this session you’ll learn:
1) How to use composite indexes
2) Other index usages besides lookup
3) How to find unoptimized queries
4) What is there beyond EXPLAIN?

To see part 1 of What You Need to Get the Most Out of Indexes please visit this page here.


About the Author

Matthew Boehm

Matthew joined Percona in the fall of 2012 as a MySQL consultant. His areas of knowledge include the traditional Linux/Apache/MySQL/PHP stack, memcached, MySQL Cluster, massive sharding topologies, PHP development and a bit of MySQL-C-API development. Previously, Matthew was a DBA for the 5th largest MySQL installation at eBay/PayPal and also hails from managed hosting environments. During his off-hours, Matthew is a nationally ranked, competitive West Coast Swing dancer and travels to competitions around the US. He enjoys working out, camping, biking and playing MMOs with his son.