Slideshare uses cookies to improve functionality and performance, and to provide you with relevant advertising. If you continue browsing the site, you agree to the use of cookies on this website. See our User Agreement and Privacy Policy.

Slideshare uses cookies to improve functionality and performance, and to provide you with relevant advertising. If you continue browsing the site, you agree to the use of cookies on this website. See our Privacy Policy and User Agreement for details.

Peter Zaitsev - Practical MySQL Performance Optimization

2.
About Presentation
Define “Performance”
Provide Practical Approach to getting
Performance you need
Talk about Tools you can use
2
www.percona.com

3.
Focus on Thought Process
Right Approach to the problems is a key
It is hard to Google “how to approach things”
Easy to find a lot of specific advice once you know what you
want to do
MySQL Performance Blog has a lot of specific information
High Performance MySQL Book
3
www.percona.com

4.
Speaking about Performance
We
mean
we
want
system
which is
4
•Responsive
•Efficient
•Scalable
www.percona.com

5.
Good Enough
System
needs • Responsiveness
to be • Efficiency
Good
• Scalability
Enough
in
5
www.percona.com

6.
Focus on Application
Database
Performance • It does only as it
Does not
impacts an Application
Matter
Database is
a Tool we
use
6
• … and problem are
we deal with
www.percona.com

7.
Things to Note
Not all Application Performance
Problems come from MySQL
Not all Application Performance
Problems which come from MySQL
• … are resolved on MySQL level
7
www.percona.com

8.
Putting it in Practice
Look at Complete System
• Start with Architecture
Do not focus on tuning
database alone
8
www.percona.com

24.
Process Support
Discover New Queries in the Application
Mark them as “Needing Attention” or “Reviewed”
Tag queries with information about application or
user facing function
Discuss it with the team and record changes
using Comments
24
www.percona.com