MySQL Performance Tuning Bootcamp (5 days)

The MySQL Database Administrators and Performance Tuning Boot Camp training course provides students with an 11 hour-per-day immersion into the world of MySQL database administration. The program is an accelerated course that provides those individuals who want to learn how to administer MySQL servers along with the know-how to ensure that their servers perform optimally through performance monitoring and tuning. Students will learn from MySQL-Certified experts through a combination of lab exercises, lectures, and presentations.

This is an intense immersion learning experience - live, breathe, eat, drink, MySQL 5.x administration and advanced performance tuning for one week!

Your registration includes:

• Five days (11-hour immersion) of MySQL-Certified topnotch instruction,
• MySQL Courseware for both MySQL Database Administration and MySQL Performance Tuning,

What you will Learn

• Describe the MySQL Architecture, general operational characteristics and resources utilized for running it.
• Perform the most common Database Administration (DBA) tasks utilizing the various
• programs contained within the MySQL application
• Use the INFORMATION_SCHEMA database to access metadata
• Install and Upgrade MySQL 5.x for the most common operating systems
• Perform the MySQL start and shutdown operations
• Configure MySQL server options at runtime
• Activate and manage numerous server logs
• Evaluate data types and character sets for performance issues
• Understand data locking concepts and the different levels of locking in MySQL
• Utilize the partitioning capabilities available
• Differentiate between the multiple storage engines available in MySQL
• Create, Maintain and Manage MySQL tables
• Perform backup and restore operations utilizing multiple MySQL tools
• Manage user maintenance and access to a MySQL Server
• Maintain integrity of a MySQL installation utilizing security protocols
• Manage stored routines and utilize triggers for administration tasks
• Manage, apply and understand the reason for using views
• Utilize MySQL monitoring tools to improve server performance
• Scale MySQL operations up
• 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

Who should Attend

• DBAs

Prerequisites

• Having attended the MySQL 5.0 for Beginners course or some experience with Relational Databases and SQL.

Format

• Instructor led, with hands-on lab exercises
• Each student will be provided with their own computer
• Each day starts at 7:30am and ends at 7:30pm
• Breakast is served from 7:00am

Applies to MySQL Version:

5.0, 5.1

Duration

5 Days, 7:30am to 7:30pm.

How to Register and Locations

See Upcoming Sessions.

Upcoming Sessions