This MySQL Performance Tuning training will teach you practical, safe and highly efficient ways to optimize performance for the MySQL Server. It will help you develop the skills needed to utilize tools for monitoring, evaluating and tuning. This is a five-day boot camp.
• Evaluate the architecture.
• Understand and use the tools.
• Configure the database for performance.
• Tune application and SQL code.
• Tune the server.
• Examine the storage engines.
• Assess the application architecture.
• Understand general tuning concepts.
• 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
• Database Administrators
• System Administrator