Opleiding: My SQL Performance Tuning

Introduction
• MySQL Overview
• MySQL Products and Tools
• MySQL Services and Support
• MySQL Web Pages
• MySQL Courses
• MySQL Certification
• MySQL Documentation

Performance Tuning Basics
• Thinking About Performance
• Areas to Tune
• Performance Tuning Terminology
• Benchmark Planning
• Benchmark Errors
• Tuning Steps
• General Tuning Session
• Deploying MySQL and Benchmarking

Performance Tuning Tools
• MySQL Monitoring Tools
• Open Source Community Monitoring Tools
• Benchmark Tools
• Stress Tools

MySQL Server Tuning
• Major Components of the MySQL Server
• MySQL Thread Handling
• MySQL Memory Usage
• Simultaneous Connections in MySQL
• Reusing Threads
• Effects of Thread Caching
• Reusing Tables
• Setting table_open_cache

MySQL Query Cache
• MySQL Query Cache
• When to Use the MySQL Query Cache
• When NOT to Use the MySQL Query Cache
• MySQL Query Cache Settings
• MySQL Query Cache Status Variables
• Improve Query Cache Results

InnoDB
• InnoDB Storage Engine
• InnoDB Storage Engine Uses
• Using the InnoDB Storage Engine
• InnoDB Log Files and Buffers
• Committing Transactions
• InnoDB Table Design
• SHOW ENGINE INNODB STATUS
• InnoDB Monitors and Settings

MyISAM
• MyISAM Storage Engine Uses
• MyISAM Table Design
• Optimizing MyISAM
• MyISAM Table Locks
• MyISAM Settings
• MyISAM Key Cache
• MyISAM Full-Text Search

Other MySQL Storage Engines and Issues
• Large Objects
• MEMORY Storage Engine Uses
• MEMORY Storage Engine Performance
• Multiple Storage Engine Advantages
• Single Storage Engine Advantages

Schema Design and Performance
• Schema Design Considerations
• Normalization and Performance
• Schema Design
• Data Types
• Indexes
• Partitioning

MySQL Query Performance
• General SQL Tuning Best Practices
• EXPLAIN
• MySQL Optimizer
• Finding Problematic Queries
• Improve Query Executions
• Locate and Correct Problematic Queries

Performance Tuning Extras
• Configuring Hardware
• Considering Operating Systems
• Operating Systems Configurations
• Logging
• Backup and Recovery

Conclusion
• Course Overview
• Training and Certification Website
• Course Evaluation
• Thank You!
• Q&A Session