MySQL Performance & Tuning

Focus on Training

Course

In London-City

£ 1,295 + VAT

The best .Net and C# courses

See all

See all

Description

  • Type

    Course

  • Location

    London-city

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. Learning Objectives To provide the skills necessary to monitor and tune MySQL performance. The delegates will practise: Developing a monitoring and tuning planUsing monitoring and diagnostic toolsUsing the Information Schema and Show commands to collect data for tuningUnderstanding normalization and de-normalization and their effect on performanceUsing server configuration and status variablesUnderstanding the output from the Explain commandIdentifying and improving problem queriesMaking efficient use of indexesMonitoring and sizing memory cachesMonitoring locksTuning the MyISAM storage engineTuning the InnoDB storage engineTuning other standard storage enginesComparing and tuning dump and load performanceEvaluating the use of partitioning for performance

Facilities

Location

Start date

London-City ((select))
EC3V 9LJ

Start date

On request

About this course

Delegates must have a working knowledge of MySQL Database Administration. 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.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Database training
  • Database
  • MySQL
  • Server
  • Monitoring

Course programme

Course Contents - DAY 1Course Introduction

  • Administration and Course Materials
  • Course Structure and Agenda
  • Delegate and Trainer Introductions
Session 1: 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
Session 2: MYSQL TOOLS
  • Administration Tools
  • The Information Schema
  • Performance-related SHOW Commands
  • Benchmarking Tools
  • The MySQL Performance Schema
  • Exercises: Obtaining Performance Information
Session 3: SCHEMA DESIGN
  • Normalisation
  • De-normalisation
  • Data Types
  • Character Sets
  • Choosing Storage Engines
  • Exercises: Effects of Design on Performance
Session 4: STATEMENT TUNING
  • Overview of Statement Tuning
  • Identifying Problem Queries
  • The Optimizer
  • Explain
  • Explain Extended
  • Exercises: Identifying Problem Queries and Using Explain
Session 5: INDEXES
  • Index Overview
  • Types of Index
  • Index Tuning
  • Indexes and Joins
  • Exercises: Indexes and Performance
Course Contents - DAY 2Session 6: SERVER CONFIGURATION AND MONITORING
  • Server Configuration Variables
  • Server Status Variables
  • Table Cache
  • Multi-Threading
  • Query Cache
  • Exercises: Setting and Interpreting Server Variables and Caching
Session 7: LOCKING
  • Types of Locking
  • Locking and Storage Engines
  • Effects of Locking on Performance
  • Exercises: Locking and Performance
Session 8: THE MYISAM 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
Session 9: THE MERGE 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
Course Contents - DAY 3Session 10: THE INNODB ENGINE
  • Transactions
  • Crash Recovery
  • Locking
  • Monitoring InnoDB
  • Caches and Buffers
  • Configuring Data Files
  • Configuring the Log Files
  • Exercises: InnoDB Configuration and Performance
Session 11: 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
Session 12: Dumping and Loading Data
  • SQL statements versus delimited data
  • Parameters affecting dump performance
  • Parameters affecting load performance
  • Exercises: Dump and load performance
Session 13: PARTITIONED TABLES
  • Partitioned tables concepts
  • Range partitioning
  • Hash partitioning
  • Key partitioning
  • List partitioning
  • Composite partitioning or subpartitioning
  • Partition Pruning
  • Exercises: Partitioned Table Performance

See related categories

MySQL Performance & Tuning

£ 1,295 + VAT

The best .Net and C# courses

See all

See all