MySQL is the most trusted and widely used open source database platform in use today.
10 out of the top 10 most popular and highly-trafficked websites in the world rely on MySQL. MySQL 8.0 builds on this momentum by delivering across the board improvements designed to enable innovative DBAs and developers to create and deploy the next generation of web, embedded, mobile and Cloud/SaaS/PaaS/DBaaS applications on the latest generation of development frameworks and hardware platforms.
Overview
Through a blend of hands-on labs and interactive lectures, you will learn how to do performance tuning; test and configure your server; examine performance metrics using a range of database system metrics, command line and graphical tools; design a circuit for optimal performance; identify and optimize slow queries and troubleshoot common performance issues.
Skills Covered
After completing this course, you will be able to:
- How to troubleshoot common performance issues
- Checking the MySQL Server
- Configuring MySQL Server Parameters
- Explore performance metrics using a range of database system metrics, command line utilities, and graphical tools.
- Build database and queries for optimal performance.
- Diagnose and fix replication delays
Prerequisites
- MySQL for Database Administrators
- 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
Target Audience
This course intended for Database Administrators, Developer and System Administrator
Course Contents
1. Introduction
2. Performance Tuning Concepts
3. Performance tuning
4. Performance tuning scheme
5. General server settings.
6. Tuning tables, files and logs
7. Tuning InnoDB.
8. Schema Optimization
9. Monitoring requests.
10. Query Optimization
11. Optimization of blocking operations
12. Setting up replication
13. Conclusion
Dates & Locations
June 22, 2026 - June 25, 2026
June 22, 2026 - June 25, 2026
August 10, 2026 - August 13, 2026
August 10, 2026 - August 13, 2026
October 12, 2026 - October 15, 2026
October 12, 2026 - October 15, 2026
December 7, 2026 - December 10, 2026
December 7, 2026 - December 10, 2026
Exam & Certification
This course is not associated with any Certification.
Training & Certification Guide
Frequently Asked Questions
Speak to a Training Consultant
All courses are HRD Claimable.
Get in touch with our team via the form or WhatsApp us on +6011-5119 6631
