Szkolenia Oracle

Cel szkolenia szkolenie zdalne - dlearning

kod: O-ELS-MySQL-PT | wersja: Ed 4

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.

Plan szkolenia Rozwiń listę

    1. Introduction
    2. Performance Tuning Concepts
    3. Performance Tuning Tools
    4. Performance Schema
    5. General Server Tuning
    6. Tuning Tables
    7. Files, and Logs
    8. Tuning InnoDB
    9. Optimizing Your Schema
    10. Monitoring Queries
    11. Query Optimization
    12. Optimizing Locking Operations
    13. Tuning Replication
    14. Conclusion

 

Pobierz konspekt szkolenia w formacie PDF

Dodatkowe informacje

Wymagania wstępne

Suggested Prerequisite

  • Familiarity with the Performance Schema
  • Experience of MySQL Enterprise Monitor

Required Prerequisite

  • MySQL for Database Administrators Ed 4
  • DBA experience
  • Knowledge of Linux
  • Familiarity with the mysql command-line client and tools
Poziom trudności
Czas trwania 4 dni
Certyfikat

Uczestnicy szkoleń otrzymają zaświadczenia o ukończeniu kursu sygnowane przez firmę Oracle.

Prowadzący

Autoryzowany wykładowca Oracle.

Pozostałe szkolenia Oracle | MySQL

Szkolenia powiązane tematycznie

Bazy danych

MySQL

Formularz kontaktowy

Prosimy o wypełnienie poniższego formularza, jeśli chcą Państwo uzyskać więcej informacji o powyższym szkoleniu.






* pola oznaczone (*) są wymagane

Informacje o przetwarzaniu danych przez Compendium – Centrum Edukacyjne Spółka z o.o.

CENA SZKOLENIA OD 7200 PLN NETTO

Najbliższe szkolenia Oracle

Harmonogram szkoleń Oracle