MySQL Performance Tuning

MySQL Performance Tuning

In this class, you will learn practical, safe, highly efficient ways to optimize performance for the MySQL Server. This course will prepare you with the skills needed to utilize tools for monitoring, evaluating, and tuning. You 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.

Duration: 4 Days

Prerequisites

• Experience maintaining a database server (preferably a MySQL server)
• Can use MySQL tools to connect to the MySQL Server
• Have knowledge of general SQL statement structure and basic SQL tuning principles
• Working knowledge of Linux operating systems
• Experience with a MySQL Server instance and MySQL tools (suggested)
• Experience writing SQL retrieve, insert, modify and delete (suggested)
• An ability to locate and execute commands on Linux (suggested)
• MySQL for Database Administrators course (suggested)

Audience

• Database Administrators
• Developers
• System Administrators

Learning Objectives

• Understand the basics of performance tuning
• Use performance tuning tools
• Tune the MySQL Server instance to improve performance
• Improve performance of tables based on the storage engine being used
• Implement proper Schema Design to improve performance
• Improve the performance of MySQL Queries
• Describe additional items related to performance tuning

Topics

• Performance Tuning Basics
• Performance Tuning Tools
• MySQL Server Tuning
• MySQL Query Cache
• InnoDB
• MyISAM
• Other MySQL Storage Engines and Issues
• Schema Design and Performance
• MySQL Query Performance
• Performance Tuning Extras
• Troubleshooting Performance Issues
• Optimizing MySQL for Your Application Environment
• Hardware Optimization