MySQL Performance & Tuning
Overview
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.
Objectives
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.
Training Partners
We work with the following best of breed training partners using our bulk buying power to bring you a wider range of dates, locations and prices.
Modules
Prerequisites
Delegates must have a working knowledge of MySQL Database Administration.
Additional Learning
The courses below may help you meet the knowledge level required to take this course. If you are unsure please ask a training advisor .
-
MySQL Database Administration Fundamentals
This course provides the skills necessary to administer, monitor and support MySQL databases and servers.
Scheduled Dates
Please select from the dates below to make an enquiry or booking.
Pricing
Different pricing structures are available including special offers. These include early bird, late availability, multi-place, corporate volume and self-funding rates. Please arrange a discussion with a training advisor to discover your most cost effective option.