MySQL Database Performance For Developers

Let's face it, when it comes to databases, developers and DBAs don't often see eye-to-eye. This talk will help bridge the gap using a common goal, "Database Performance".

If you're a developer, you've probably used a query that was performing poorly. Many times the solution is seeking help from a DBA. The DBA performs some magic behind a curtain, and all the sudden the query is running fast. Wouldn't it be nice to take a peek behind the curtain to see the magic being performed? During this talk, we'll discuss several aspects of the database that can affect performance. This includes schema design, indexes, and queries. We'll also look at some real life examples of slow performance and performance solutions.

Jeremy Glick is a MySQL Database Engineer at ZipRecruiter (https://www.ziprecruiter.com). Before that, he worked as a consultant for various technology companies with systems ranging from dozens to hundreds of database servers. Jeremy is also the organizer of the Chicago MySQL Meetup (https://www.meetup.com/mysql-5/). He holds multiple MySQL certifications and is a RedHat RHCE.