MySQL Performance Tuning

Displaying courses for Great Britain [Change]

Overview

The MySQL[tm] Performance Tuning course is designed for Database Administrators and others who wish to monitor and tune MySQL. This course will prepare each delegate with the skills needed to utilize tools for monitoring, evaluating and tuning.

Delegates will evaluate the architecture, learn to use the tools, configure the database for performance, tune application and SQL code, tune the server, examine the storage engines, assess the application architecture, and learn general tuning concepts.

Objectives

  • Develop a tuning strategy
  • Display knowledge of MySQL architecture
  • Display knowledge and ability to use diagnostic tools
  • Display knowledge and ability to use tuning tools
  • Write queries against the INFORMATION_SCHEMA database and be able to decipher the metadata obtained
  • Understand the relational database model and both the positive and negative implications on performance
  • Display, decipher and edit server configuration variables to improve performance of your applications
  • Display and analyze status variables to ensure that their applications are utilizing the settings in the most effective manner
  • Write queries that take advantage of the MySQL 5.0 performance enhancements dealing with queries and indexing
  • Decide which of the storage engines could be used in their specific application needs
  • Evaluate the application architecture for efficient design, structure, caching, number of connections and other factors affecting performance
  • Evaluate hardware and OS for effects on performance
  • Evaluate techniques for loading data into the database and effects on performance

Prerequisites

  • Students who wish to attend this course, should have attended the MySQL for DBAs course or have similar knowledge:
  • Have previously worked with a MySQL Server instance and database and have working knowledge of MySQL architecture
  • Can use MySQL tools to connect to the MySQL Server
  • Have knowledge of general SQL statement structure and basic SQL tuning principles
  • MySQL for Database Administrators (SQL-4502)

Training provider

Teaching mode: Classroom - Instructor Led
Duration: 4 days
Gooroo has partnered with the global leaders in IT training to give you access to quality training, personalised to you, targeted at increasing your job opportunities and salary.

Our pricing

We do not display pricing as Gooroo members qualify for special discounts not available elsewhere. You must enquire through Gooroo to get this benefit.

New courses are happening all the time

Our partner's expert training consultant will provide you with the times and all the details you need. Enquire today.

Top skills covered in this course

Database
Great Britain
This skill has an average salary of
£43,302
and is mentioned in
7.72%
of job ads in this area.
MySQL
Great Britain
This skill has an average salary of
£49,041
and is mentioned in
1.02%
of job ads in this area.
Server administrator
Great Britain
This skill has an average salary of
£42,527
and is mentioned in
0.08%
of job ads in this area.