Visão Geral

Este Curso MariaDB Performance & Tuning foi desenvolvido para administradores de banco de dados que desejam monitorar e ajustar o desempenho de servidores e bancos de dados MariaDB. O curso MariaDB Performance and Tuning oferece experiência prática em monitoramento e ajuste de servidores e bancos de dados MariaDB.

Este curso MariaDB Performance and Tuning beneficiará quem deseja monitorar e ajustar o desempenho do MariaDB.

Pre-Requisitos

• Os participantes, devem ter conhecimento prático de MariaDB ou MySQL Database Administration.

Materiais

Conteúdo Programatico

INTRODUCTION TO PERFORMANCE TUNING

1.  Tuning Overview
2.  Resolving Performance Issues
3.  Recommended Approach to Tuning
4.  Items to Evaluate
5.  Where to look
6.  Planning a Monitoring Routine
7.  Building a New Database for Performance
8.  Tuning an Existing Database
9.  Setting Suitable Goals

MARIADB TOOLS

1.  Administration Tools
2.  The Information Schema
3.  Performance-related SHOW Commands
4.  Benchmarking Tools
5.  The MariaDB Performance Schema
6.  Exercises: Obtaining Performance Information

SCHEMA DESIGN

1.  Normalisation
2.  De-normalisation
3.  Data Types
4.  Character Sets
5.  Choosing Storage Engines
6.  Exercises: Effects of Design on Performance

STATEMENT TUNING

1.  Overview of Statement Tuning
2.  Identifying Problem Queries
3.  The Optimizer
4.  Explain
5.  Explain Extended
6.  Exercises: Identifying Problem Queries and Using Explain

INDEXES

1.  Index Overview
2.  Types of Index
3.  Index Tuning
4.  Indexes and Joins
5.  Exercises: Indexes and Performance

SERVER CONFIGURATION AND MONITORING

1.  Server Configuration Variables
2.  Server Status Variables
3.  Table Cache
4.  Multi-Threading
5.  Query Cache
6.  Exercises: Setting and Interpreting Server Variables and Caching

LOCKING

1.  Types of Locking
2.  Locking and Storage Engines
3.  Effects of Locking on Performance
4.  Exercises: Locking and Performance

THE MYISAM ENGINE

1.  Advantages and Disadvantages of MyISAM
2.  How MyISAM Caches Data
3.  MyISAM Formats
4.  MyISAM Indexes
5.  MyISAM Locking
6.  The Key Cache
7.  Tuning MyISAM
8.  Exercises: Monitoring and Tuning the MyISAM Engine

THE MERGE ENGINE

1.  The Merge Engine Concept
2.  Advantages and Disadvantages of The Merge Engine
3.  Locking with the Merge Engine
4.  Performance Issues with the Merge Engine
5.  Exercises: Merge Engine Performance Versus MyISAM

THE INNODB ENGINE

1.  Transactions
2.  Crash Recovery
3.  Locking
4.  Monitoring InnoDB
5.  Caches and Buffers
6.  Configuring Data Files
7.  Configuring the Log Files
8.  Exercises: InnoDB Configuration and Performance

OTHER STORAGE ENGINES

1.  Archive Engine
2.  Memory Engine
3.  Federated Engine
4.  Blackhole Engine
5.  CSV Engine
6.  Aria Engine
7.  Overview of Clustering and Performance
8.  Mixing Storage Engines
9.  Exercises: Storage Engine Performance

DUMPING & LOADING DATA

1.  SQL statements versus delimited data
2.  Parameters affecting dump performance
3.  Parameters affecting load performance
4.  Exercises: Dump and load performance

PARTITIONED TABLES

1.  Partitioned tables concepts
2.  Range partitioning
3.  Hash partitioning
4.  Key partitioning
5.  List partitioning
6.  Composite partitioning or subpartitioning
7.  Partition Pruning
8.  Exercises: Partitioned Table Performance