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
Who Should Attend
This course intended for Database Administrators, Developer and System Administrator
Course Curriculum
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
Course Modules
Exam & Certification
This course is not associated with any Certification.