MySQL Optimization
Speaker Info (Who am I?)
Outline
Outline continued…
Outline continued…
Starting Questions
What you Need to Know
Recent History of MySQL
Recent History of MySQL
Recent History of MySQL…
Typical MySQL Use
Atypical MySQL Use
Atypical MySQL Use
MySQL at Yahoo!
Why Optimize?
MySQL’s Defaults
Scaling MySQL
Using Less Hardware
Real-World Numbers
Real-World Learning
Goals
Questions so Far?
Database Design
Database Design
Database Design
Database Design
Database Design
Database Design
Database Design
Database Design
Database Design
Database Design
Questions so Far?
Application Design
Application Design
Application Design
Application Design
Application Design
Application Design
Questions so Far?
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
Questions so Far?
MySQL Server Tuning
MySQL Server Tuning
MySQL Server Tuning
MySQL Server Tuning
MySQL Server Tuning
MySQL Server Tuning
MySQL Server Tuning
MySQL Server Tuning
MySQL Server Tuning
MySQL Server Tuning
Questions so Far?
Operating System Tuning
Operating System Tuning
Operating System Tuning
Hardware Tuning
Hardware Tuning
Questions so Far?
Network & Replication
Network & Replication
Network & Replication
Network & Replication
Network & Replication
Network & Replication
Questions so Far?
Final Advice
Where to Learn More
Where to Learn More
Where to Learn More
Shameless Book Plug
Questions and Answers