Advanced MySQL Performance Optimization

Advanced MySQL Performance OptimizationShort Description
Defining Performance
+ Simple world but many meanings
+ Main objective:
- Users (direct or indirect) should be satisfied
+ Most typical performance metrics
- Throughput
- latency/response time
- Scalability
- Combined metrics

Website: www.mysqlperformanceblog.com | Filesize: 799kb
No of Page(s): 138

Content
…
Throughput
+ Metric: Transactions per time (second/min/hour)
- Only some transactions from the mix can be counted
+ Example: TPC-C
+ When to use
- Interactive multi user applications
+ Problems:
- “starvation” - some users can be waiting too long
- single user may rather need his request served fast

Response Time/Latency
+ Metric: Time (milliseconds, seconds, minutes)
- derived: average/min/max response time
- derived 90 percentile response time
+ Example: sql-bench, SetQuery
+ When to use
- Batch jobs
- together with throughput in interactive applications
+ Problems:
- Counts wall clock time, does not take into account what else is happening
…

Get the file Download here

AddThis Social Bookmark Button
Related Books:
  • Fixing MySQL after upgrading to Mac OS X 10.2
  • MySQL PHP Tutorial
  • Beginning MySQL Tutorial
  • Introduction to MySQL
  • XL Fortran Optimization and Programming Guide
  • Chapter 3. MySQL Tutorial
  • MySQL 5.0 Triggers MySQL 5.0 New Features Series Part 2
  • Tutorial for MySQL An Introduction to Java Programming

    • Filed Under SQL, Database, Programming 

    Related Searches:



    Comments

    Leave a Reply