Presentation Index

• Questions for You
• What this Talk is About
• What this Talk is NOT About
• What you should already know
• Factors Affecting Performance Tuning
• Writing Fast Queries: Indexes
• Writing Fast Queries: Don't
• Writing Fast Queries: Do
• Application Tuning Ideas
• More Application Tuning Ideas
• Non-Transactional Table Types
• Transactional Table Types
• Server Tuning: Goals
• Server Tuning: General Recommendations
• my.cnf Options: General/MyISAM
• my.cnf Options: Delayed Queries
• my.cnf Options: BDB Tables
• my.cnf Options: InnoDB Tables
• my.cnf Options: Gemini Tables
• Server Tuning: Hardware
• Load Balancing with Replication
• Monitoring Performance: Watching Queries
• Monitoring Performance: Watching Numbers
• Monitoring Performance: Watching More Numbers
• Monitoring Performance: Other Stuff
• Benchmarking: Why not?
• Benchmarking: Automation Tools
• Benchmarking: Suggestions
• What Else?
• Questions