[精品]21PM_R1_14 30_Ronald Bradford_Improving Performance With Better Indexes.pdf

文档介绍：- Its all about Performance and Scalability
Improving Performance
with Better Indexes
Ronald Bradford

OTN APAC Tour
October 2011
QuickTime?and a
GIF pressor
are needed to see this picture.
- Its all about Performance and Scalability
OBJECTIVE
•Improve query performance,
therefore
•Increase server throughput,
therefore
•Reduce H/W to run your
application
- Its all about Performance and Scalability
ABOUT Author
Ronald BRADFORD
12 years with MySQL / 22 years with
RDBMS
Senior Consultant at MySQL Inc (06-08)
Consultant for Oracle Corporation (96-99)
7 years presenting MySQL content
Available NOW
All time top MySQL blogger for consulting
Published author

Oracle ACE Director
- Its all about Performance and Scalability
SOLUTIon

Extra: Using Index

- Its all about Performance and Scalability
SQL REVIEW
Six step
1. Capture process
2. Identify
3. Confirm
4. Analyze
5. Optimize
6. Verify
- Its all about Performance and Scalability
Capture
Not discussed
in detail this
General Query Log presentation
TCP/IP
Connectors
Application All Queries?
or
Proxy Sample Queries?
1. Capture
Plugin 2. Identify
3. Confirm
... 4. Analyze
5. Optimize
- Its all about Performance and Scalability 6. Verify
Capture
Example
Customer
Application Logging example
All queries for a given function
TCP/IP
Sample queries for a period of time
- Its all about Performance and Scalability