MySQL Performance & Tuning

Level:
Costs:
Total time:
Provider rating: 10 Perpetual Solutions has an average rating of 10 (out of 1 reviews)
Logo Perpetual Solutions

Tip: Receive more information about the programme, starting dates & price. Or request a proposal from multiple providers for in-house training.

Overview

Your experience of this course?

Did you attend the course MySQL Performance & Tuning at Perpetual Solutions? Help other people by submitting your review at Springest!

Springest will donate £1.- to the Edukans Foundation as a thank you for each review

 
Schedule:
Daytime
Run time:
3 Days
Location type:
Open

completion, maximum participants, and starting dateplaces are unknown for this course.

Prerequisites:

Delegates must have a working knowledge of MySQL Database Administration.

Course Description:

This MySQL Performance & Tuning course is designed for Database Administrators who wish to monitor and tune the performance of MySQL servers and databases. The course provides practical experience in monitoring and tuning MySQL servers and databases.

The delegate will practise:

  • Developing a monitoring and tuning plan
  • Using monitoring and diagnostic tools
  • Using the Information Schema and Show commands to collect data for tuning
  • Understanding normalization and de-normalization and their effect on performance
  • Using server configuration and status variables
  • Understanding the output from the E…

Read the complete description

Description

Prerequisites:

Delegates must have a working knowledge of MySQL Database Administration.

Course Description:

This MySQL Performance & Tuning course is designed for Database Administrators who wish to monitor and tune the performance of MySQL servers and databases. The course provides practical experience in monitoring and tuning MySQL servers and databases.

The delegate will practise:

  • Developing a monitoring and tuning plan
  • Using monitoring and diagnostic tools
  • Using the Information Schema and Show commands to collect data for tuning
  • Understanding normalization and de-normalization and their effect on performance
  • Using server configuration and status variables
  • Understanding the output from the Explain command
  • Identifying and improving problem queries
  • Making efficient use of indexes
  • Monitoring and sizing memory caches
  • Monitoring locks
  • Tuning the MyISAM storage engine
  • Tuning the InnoDB storage engine
  • Tuning other standard storage engines
  • Comparing and tuning dump and load performance
  • Evaluating the use of partitioning for performance

Please note that this MySQL Performance & Tuning course does not cover clustering (other than at overview level), replication or non-standard storage engines such as Falcon and PBXT.

This course includes the following modules:

Introduction to Performance Tuning

  • 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

MySQL Tools

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

Schema Design

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

Statement Tuning

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

Indexes

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

Server Configuration and Monitoring

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

Locking

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

The Mysiam Engine

  • 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

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

The Innodb Engine

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

Other Storage Engines

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

Dumping and Loading Data

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

Partitioned Tables

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

For online live training advice please visit our Learning Advice Centre on our website. Be sure to follow us on Twitter to receive special course offers, news and updates!

Reviews

There are no reviews yet. Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

In-company offer

Ask for a quote on a customised training course.
Maximum 3 relevant providers will directly respond.

More courses within this subject:

Compare 32,279 training courses in subjects like SQL & MySQL

Sign up to create your own Learning Lists.

Not for humans