Home Video: How Facebook Makes MySQL Scale

Video: How Facebook Makes MySQL Scale

A few people from Facebook’s database teams (yes, plural) recently gave a MySQL Tech Talk at Facebook headquarters about how Facebook uses MySQL to process 13 million queries per second. Former Facebook CTO and Quora founded Adam D’Angelo has said that Facebook is “stuck” with PHP and MySQL for legacy reasons, but it sure sounds the Facebook team is making the best of it. Video and notes after the jump.

Watch live streaming video from facebookevents at livestream.com

The main thing Facebook is focusing on is consistency over average response time. “It’s OK if a query is slow as long as it is always slow,” Mark Callahan says. “t’s inconsistency that causes “confusion and unhappy users.”

One of the database performance team members says that the group focuses on edge cases – finding the worst performing queries and then finding ways to fix them.

To find variances in performance Facebook uses Poor Man’s Profiler and number of homegrown tools.

Todd Hoff has a post at High Scalability with some good notes.

I found this particularly interesting following this Hacker News discussion on whether PHP and MySQL are still practical for building web applications.

Image Credit: Massimo Barbieri

About ReadWrite’s Editorial Process

The ReadWrite Editorial policy involves closely monitoring the tech industry for major developments, new product launches, AI breakthroughs, video game releases and other newsworthy events. Editors assign relevant stories to staff writers or freelance contributors with expertise in each particular topic area. Before publication, articles go through a rigorous round of editing for accuracy, clarity, and to ensure adherence to ReadWrite's style guidelines.

Get the biggest tech headlines of the day delivered to your inbox

    By signing up, you agree to our Terms and Privacy Policy. Unsubscribe anytime.

    Tech News

    Explore the latest in tech with our Tech News. We cut through the noise for concise, relevant updates, keeping you informed about the rapidly evolving tech landscape with curated content that separates signal from noise.

    In-Depth Tech Stories

    Explore tech impact in In-Depth Stories. Narrative data journalism offers comprehensive analyses, revealing stories behind data. Understand industry trends for a deeper perspective on tech's intricate relationships with society.

    Expert Reviews

    Empower decisions with Expert Reviews, merging industry expertise and insightful analysis. Delve into tech intricacies, get the best deals, and stay ahead with our trustworthy guide to navigating the ever-changing tech market.