MySQL Performance and Tuning

Duration: 
3 days
Codes: 
STA-MYSDBAPT

Overview

Not available. Please contact.

Audience

Who will the Course Benefit? Who will the Course Benefit?

Anyone who wishes to monitor and tune MySQL performance for MySQL 5.6, 5.7 and 8 databases.

Skills Gained

The delegate will learn and acquire skills as follows:

  • 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
  • Performance tuning tools
  • Using load generation, stress testing and benchmarking tools
  • 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 InnoDB storage engine
  • Tuning other standard storage engines
  • Comparing and tuning dump and load performance
  • Evaluating the use of partitioning for performance

Evaluating the use of partitioning for performance Course Objectives Course Objectives

To provide the skills necessary to monitor and tune MySQL performance.

Prerequisites

Not available. Please contact.

Course Outline

The delegate will learn and acquire skills as follows:

  • 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
  • Performance tuning tools
  • Using load generation, stress testing and benchmarking tools
  • 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 InnoDB storage engine
  • Tuning other standard storage engines
  • Comparing and tuning dump and load performance
  • Evaluating the use of partitioning for performance

Evaluating the use of partitioning for performance Course Objectives Course Objectives

To provide the skills necessary to monitor and tune MySQL performance.

Related Courses

 

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

Upcoming Dates

  • GREEN This class is Guaranteed To Run.
  • SPVC - Self-Paced Virtual Class.
  • Click a Date to Enroll.
Course Location Days Cost Date
London London3 2250 £2250 2019-09-18
London London3 2250 £2250 2019-09-18
London London3 2250 £2250 2019-12-09
London London3 2250 £2250 2019-12-09