Can database performance improvements be achieved with zero code changes and no production downtime? See the results of how creating better indexes with no development changes halved a clients daily hosting costs saving them over $500 per day.
Attendees will learn how to apply one simple technique to their existing MySQL production environment. this presentation will demonstrate how queries were improved by over 500% even with a highly indexed schema.
This presentation is part of the http://www.generalassemb.ly/ Events & Classes and will have a $30 entrance fee. You need to pay at http://savingmoneywithbetterindexes.eventbrite.com/ to attend this event at General Assembly
Ronald Bradford is a MySQL Expert based in New York where he provides professional consulting for startups to Fortune 500 companies. He is a published author, Oracle ACE Director for MySQL and is the all time top individual contributor of MySQL blog content. Visit http://NYMySQLExpert.com for more information.
As always, Ronald is bringing lots of details to the table - even in this talk with a relatively narrow topic, I learned something I didn't know before and was able to get detailed and thorough answers to my follow-up questions.
March 23, 2011
I'm pretty green when it comes to MySQL and databases in general. So I picked up a lot. I don't think the technique discussed, using covering indices, will help at my job though. Our tables are all pretty simple and we don't do many complex queries. And we use an ORB so we are typically selecting entire rows.
March 23, 2011
Join or login to comment.