Need some help ? Call us:+32 2 503 40 40
Back

MySQL Performance Tuning - Live Virtual Classes

This course provides experienced MySQL DBAs with knowledge of how and why server settings affect performance, and when and how to tune them. It teaches students how to monitor their MySQL server and identify areas that impact performance, such as slow queries and replication lag, and how to diagnose and fix these issues.

Learn To:
•    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.
Benefits To You
MySQL is the world's most popular open source database, and the leading database for web applications. Many of the largest web properties rely on MySQL to cope with huge numbers of concurrent transactions, 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 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.
A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.

Cloud Database Administrators, Application Developers, Database Administrators, System Administrator, Database Designers, Developer, Technical Administrator, Web Administrator

You might also be interested in:

New

Oracle Database 12c R2: Clusterware Administration - Live Virtual Classes

This Oracle Database 12c: Clusterware Administration training will explore general cluster
concepts and Oracle Clusterware architecture. Work with expert Oracle University
instructors through interactive instruction and hands-on exercises to reinforce your
learning.In this course, you will be introduced to Oracle Database Exadata Cloud Service.

New

Oracle Database 12c R2: Data Guard Administration - Live Virtual Classes

This Oracle Database 12c: Data Guard Administration Ed 1 training teaches you how to
use Oracle Data Guard. Learn how it protects your Oracle database against planned and
unplanned downtimes. In this course, you will be introduced to Oracle Database Exadata
Cloud Service.

New

Oracle Database 12c R2: Program with PL/SQL - Live Virtual Classes

This Database Program with PL/SQL training shows you how to develop stored
procedures, functions, packages and database triggers. You’ll learn to manage PL/SQL
program units and dependencies, while using of some of the Oracle-supplied packages