How to Efficiently Use Indexes in MySQL

Overview:

If you want to access MySQL database the most efficient way you need to understand how MySQL works with indexes. The first step is to learn what is an index, how MySQL stores data in the indexes and how it can access the data.
We will review most typical use-cases when a client can benefit from an index. Each use-case we will illustrate with examples so you can quickly build high-performance applications.

Bio:
Aleksandr Kuzminsky is a MySQL SRE at Dropbox and founder of TwinDB - online backups for MySQL.
He used to work as a consultant and the data recovery expert at Percona.

Ovais is a MySQL architect, performance engineer, Chef consultant and an open source advocate. Ovais currently works at Lithium Technologies as a Lead MySQL DBA and Automation Engineer. He is also the co-Founder of TwinDB - online backups for MySQL. Previously, Ovais worked at Percona as a Senior MySQL Consultant and at a few other startups in various capacities.

Agenda:

6:30 - 7:00 -- Doors open/general socializing & food provided by Percona
7:00 - 7:15 -- Intro/announcements
7:15 - 8:00(ish) -- Main presentation
8:00 - 8:30 -- General discussion/Q&A/networking/etc.
8:30ish -- post-event socializing... aka beers someplace nearby

Sponsors:
Percona (http://www.percona.com/) is the oldest and largest independent MySQL support and consulting company, with a global 24×7 staff of over 40 people serving more than 1000 customers (http://www.percona.com/about-us/customers/) in 50+ countries since 2006. Our clients achieve breakthrough results with MySQL: cost savings, faster time to market, higher system uptime, and long-term scalability. With Percona, you can execute with confidence and clarity. Anyone can claim expertise, but we show our abilities by creating open-source (http://www.percona.com/software/) software for MySQL users, writing industry-leading books (http://www.percona.com/about-us/books/), and publishing original research on the widely read MySQL Performance Blog (http://www.mysqlperformanceblog.com/). We also organize the Percona Live (http://www.percona.com/live/) series of conferences to share what we know.

Lithium (http://www.lithium.com/) helps companies unlock the passion of their customers. Lithium software powers amazing Social Customer Experiences for more than 400 iconic brands including AT&T, BT, Best Buy, Indosat, Sephora, and Telstra. Lithium helps companies grow brand advocacy, drive sales, reduce costs and accelerate innovation to create social communities that redefine the customer experience.

Vendini (http://www.vendini.com/) makes the business of live events simple. Offering a full suite for the performing arts, live music, music festival and live event spaces, Vendini is helping thousands of venues increase revenue, collect valuable data and make running an event simple. In a world of endless single-use vendors, Vendini is the first company to offer one comprehensive solution for multiple aspects of live events including ticketing, marketing, fundraising, logistics and more. Vendini is based in San Francisco, CA, with offices in Boston, MA, New York, NY, Knoxville, TN and Vancouver, BC.

O'Reilly Media (http://oreilly.com/) spreads the knowledge of innovators through its books, online services, magazines, research, and conferences. Since 1978, O'Reilly has been a chronicler and catalyst of leading-edge development, homing in on the technology trends that really matter and galvanizing their adoption by amplifying "faint signals" from the alpha geeks who are creating the future. An active participant in the technology community, the company has a long history of advocacy, meme-making, and evangelism.