MySQL Optimization

About Me

Outline

Starting Questions

What you Need to Know

MySQL at Yahoo!

Why Optimize?

MySQL’s Defaults

Scaling MySQL

Using Less Hardware

Goals

Database Design

Database Design

Database Design

Database Design

Database Design

Database Design

Database Design

Database Design

Database Design

Database Design

Full-Text Search

Application Design

Application Design

Application Design

Application Design

Application Design

Application Design

Break!

Writing Fast Queries

Writing Fast Queries

Writing Fast Queries

Writing Fast Queries

Writing Fast Queries

Writing Fast Queries

Writing Fast Queries

Writing Fast Queries

Writing Fast Queries

Insert Speed

Query Cache

MySQL Server Tuning

MySQL Server Tuning

MySQL Server Tuning

MySQL Server Tuning

MySQL Server Tuning

On-the-Fly Tuning

MySQL Server Tuning

MySQL Server Tuning

MySQL Server Tuning

InnoDB Performance

MySQL Server Tuning

MySQL Server Tuning

Upgrade Testing

Operating System Tuning

Operating System Tuning

Operating System Tuning

Hardware Tuning

Hardware Tuning

Network & Replication

Network & Replication

Stupid Query Tricks

Stupid Query Tricks

Stupid Query Tricks

Final Advice

For More Info…

Questions and Answers