Buy Percona ServicesBuy 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.

Matthew Boehm
Architect
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.

Visit Percona Store


General Inquiries

For general inquiries, please send us your question and someone will contact you.