EncartaLabs

MariaDB Performance & Tuning

( Duration: 3 Days )

This MariaDB Performance & Tuning training course is designed for Database Administrators, Application Developers and Technical Consultants who need to monitor and tune the performance of MariaDB servers and databases. This course provides practical experience in monitoring and tuning MariaDB servers and databases.

By attending MariaDB Performance & Tuning workshop, delegates will learn:

  • To provide the skills necessary to monitor and tune MariaDB database performance.

  • Working knowledge of MariaDB Database Administration or MySQL Database Administration.
  • Basic knowledge of Linux/UNIX is recommended but is not essential.

The MariaDB Performance & Tuning class is ideal for:

  • Anyone who wishes to monitor and tune MariaDB performance.

COURSE AGENDA

1

Introduction

2

Introduction to Performance Tuning

  • Tuning Overview
  • Tuning Levels
  • 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
3

Mariadb Performance Tuning Tools

  • Administration Tools
  • The Information Schema
  • Performance-related SHOW Commands
  • Benchmarking Tools
  • The MariaDB Performance Schema
  • MonYog
4

Schema Design

  • Normalisation
  • De-normalisation
  • Naming Conventions
  • Load Generation,Stress Testing and Benchmarking Tools
  • Selecting Data Types
  • Data Types
  • Character Sets
  • Choosing Storage Engines
5

Statement Tuning

  • Overview of Statement Tuning
  • Identifying Problem Queries
  • The Optimizer
  • Explain
  • Explain Extended
6

Indexes

  • Index Overview
  • Index Size
  • Types of Index
  • Index Tuning
  • Indexes and Joins
7

Server Configuration & Monitoring

  • Server Configuration Variables
  • Server Status Variables
  • Table Cache
  • Multi-Threading
  • Connection Issues
  • Query Cache
8

Locking

  • Types of Locking
  • Locking and Storage Engines
  • Effects of Locking on Performance
9

The Innodb Engine

  • Transactions
  • Crash Recovery
  • Locking
  • Monitoring InnoDB
  • Caches and Buffers
  • Configuring Data Files
  • Configuring the Log Files
10

Other Storage Engines

  • MyISAM Engine
  • Merge Engine
  • Archive Engine
  • Memory Engine
  • Blackhole Engine
  • CSV Engine
  • The Spider Engine
  • The ColumnStore Engine
  • The MyRocks Engine
  • Mixing Storage Engines
11

Overview of Clustering & Performance

  • Advantages Performance Advantages of Clustering
  • Performance Issues and Clustering
  • The NDBCluster Engine
  • The Galera Cluster
  • The Percona XtraDB Cluster
  • MySQL InnoDB Cluster
  • The Federated Engine
  • The FederatedX Engine
  • Overview of Other High Availability Techniques
  • NOSQL and Mencached Overview
12

Dumping & Loading Data

  • SQL statements versus delimited data
  • Parameters affecting dump performance
  • Parameters affecting load performance
13

Partitioned Tables

  • Partitioned tables concepts
  • Range partitioning
  • Hash partitioning
  • Key partitioning
  • List partitioning
  • Composite partitioning or subpartitioning
  • Partition Pruning

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 4,000 Modules on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top