MariaDB Performance and Tuning

This MariaDB Performance & Tuning course does not cover clustering (other than at overview level), replication or non-standard storage engines such as PBXT.

• Tuning Overview
• Resolving Performance Issues
• Recommended Approach to Tuning
• Items to Evaluate
• Where to look
• Planning a Monitoring Routine
• Building a New Database for Performance
• Tuning an Existing Database
• Setting Suitable Goals

• Administration Tools
• The Information Schema
• Performance-related SHOW Commands
• Benchmarking Tools
• The MariaDB Performance Schema
• Exercises: Obtaining Performance Information

• Normalisation
• De-normalisation
• Data Types
• Character Sets
• Choosing Storage Engines
• Exercises: Effects of Design on Performance

• Overview of Statement Tuning
• Identifying Problem Queries
• The Optimizer
• Explain
• Explain Extended
• Exercises: Identifying Problem Queries and Using Explain

• Index Overview
• Types of Index
• Index Tuning
• Indexes and Joins
• Exercises: Indexes and Performance

• Server Configuration Variables
• Server Status Variables
• Table Cache
• Multi-Threading
• Query Cache
• Exercises: Setting and Interpreting Server Variables and Caching

• Types of Locking
• Locking and Storage Engines
• Effects of Locking on Performance
• Exercises: Locking and Performance

• Advantages and Disadvantages of MyISAM
• How MyISAM Caches Data
• MyISAM Formats
• MyISAM Indexes
• MyISAM Locking
• The Key Cache
• Tuning MyISAM
• Exercises: Monitoring and Tuning the MyISAM Engine

• The Merge Engine Concept
• Advantages and Disadvantages of The Merge Engine
• Locking with the Merge Engine
• Performance Issues with the Merge Engine
• Exercises: Merge Engine Performance Versus MyISAM

• Transactions
• Crash Recovery
• Locking
• Monitoring InnoDB
• Caches and Buffers
• Configuring Data Files
• Configuring the Log Files
• Exercises: InnoDB Configuration and Performance

• Archive Engine
• Memory Engine
• Federated Engine
• Blackhole Engine
• CSV Engine
• Aria Engine
• Overview of Clustering and Performance
• Mixing Storage Engines
• Exercises: Storage Engine Performance

• SQL statements versus delimited data
• Parameters affecting dump performance
• Parameters affecting load performance
• Exercises: Dump and load performance

• Partitioned tables concepts
• Range partitioning
• Hash partitioning
• Key partitioning
• List partitioning
• Composite partitioning or subpartitioning
• Partition Pruning
• Exercises: Partitioned Table Performance

• MariaDB for Developers