Details
MySQL is the world's most popular open source database, and the leading database for web applications. The majority of the largest web properties rely on MySQL to cope with huge numbers of transactions simultaneously, while maintaining
the integrity of their data. As users continue to demand better performance and more functionality from web applications, you need to make sure that your database can keep up. The MySQL 8.0 Performance Tuning course will teach you how to use the vast array
of configuration options, monitoring tools, and techniques employed by MySQL database professionals to keep your applications fast, efficient, and safe.
After attending this course you will understand performance tuning concepts; be able to benchmark and tune your server; investigate performance metrics with a range of system databases, command-line, and graphical tools; design your schema for optimal performance; identify and optimize slow queries, and troubleshoot common performance problems.
Objectives:
- Troubleshoot common performance problems
- Benchmark your MySQL server
- Tune MySQL server settings
- Investigate performance metrics with a range of system databases, command-line utilities, and graphical tools
- Design your databases and queries for optimal performance
- Diagnose and fix replication lag
Outline
Topics
- Introduction
- Performance Tuning Concepts
- Performance Tuning Tools
- Performance Schema
- General Server Tuning
- Tuning Tables, Files, and Logs
- Tuning InnoDB
- Optimizing Your Schema
- Monitoring Queries
- Query Optimization
- Optimizing Locking Operations
- Tuning Replication
- Conclusion
Reviews
Be the first to write a review about this course.
Write a Review
DBQuest, Inc. is an Oracle Training Provider and an Approved Training Partner of Lithan. We are one of the Authorized Training Center of Oracle University here in the Philippines with over 10 years of delivering high quality Education. Recently, we partners with Lithan, an eduCLaaS Digital Skills Accelator in Singapore to deliver International Degree Programs and Certification Skills Programs.
AWARDS AND RECOGNITIONS
- Top Oracle Approved Education Center (OAEC) for FY 2017
- Top Oracle University Reseller for FY 2017
- Top Oracle Approved Education Center (OAEC) FY 2016
- Top University Reseller for FY 2015
