Duración

4 días - 24 horas

Descripción

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 impactperformance, such as slow queries and replication lag, and how to diagnose and fix these issues.

Objetivos

  1.   Identify and fix replication lag
  2.   Understand performance tuning concepts
  3.   List factors that affect performance
  4.   Use a range of performance tuning tools
  5.   Configure and use the Performance Schema
  6.   Tune the MySQL server instance
  7.   Design a schema for optimal performance
  8.   Understand how MySQL optimizes queries
  9.   Identify and fix slow queries
  10.   Diagnose and resolve common performance issues

Contenidos del curso

Introducing 

  • Course goals
  • MySQL products and professional services
  • MySQL Cloud Service
  • Supported platforms
  • MySQL resources on the web
  • MySQL courses and certification options

Performance Tuning Tools

  • MySQL Monitoring Tools
  • Oracle DB monitoring tools
  • Community monitoring tool
  • Linux tools
  • Benchmarking tools

Performance Schema

  • What is Performance Schema?
  • Schema overview
  • Configuration
  • The Instance and Connection Tables
  • Querying event data
  • The sys schema
  • MySQL Workbench performance tools

General Server Tuning

  • How MySQL uses memory
  • Calculating maximum MySQL memory usage
  • Managing connections
  • Tuning threads

Tuning Tables, Files, and Logs

  • Sizing the table cache
  • Managing tables and files
  • Tuning the binary logs

Tuning InnoDB

  • What is InnoDB?
  • How does InnoDB work?
  • Tuning InnoDB buffer pool and log files
  • Measuring InnoDB performance

Optimizing Your Schema

  • Schema design considerations
  • Indexes
  • InnoDB table compression
  • Partitioning tables

Monitoring Queries

  • Identifying candidate queries for optimization
  • Server logs
  • Statement status variables
  • Performance Schema and sys
  • Graphical tools

Query Optimization

  • How the optimizer works
  • Understanding the query plan
  • Optimizing queries

Optimizing Locking Operations

  • How MySQL locking works
  • InnoDB lock types
  • Metadata locks
  • Viewing lock information with SQL statements
  • Investigating locks by querying system databases

Tuning Replication

  • Replication overview
  • Understanding replication lag
  • Diagnosing replication lag
  • Resolving replication lag

Conclusion

  • Course Goals Recap
  • MySQL Training at Oracle University
  • MySQL Websites
  • Your Evaluation
  • Q&A Session

Conclusion

  • Course Overview
  • Training and Certification Website
  • Course Evaluation
  • Thank You!
  • Q&A Session


Información extra

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 anytime. 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.

Audience

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

Related Training

Required Prerequisites

  • DBA experience
  • Familiarity with the mysql command-line client and tools
  • Knowledge of Linux
  • MySQL for Database Administrators Ed 4

Suggested Prerequisites

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

Información general

Área formativa

Oracle MySQL

Fabricante

Oracle

Metodología

Presencial

Certificación

Garantía juvenil

 

¿TIENES DUDAS? PREGÚNTANOS

He leído y acepto la del sitio y las condiciones de tratamiento de mis datos de carácter personal

 

 

Fecha Hora Ubicación Precio
No hay convocatoria programada. Por favor, consúltanos sobre próximas fechas y precio para esta formación.

¿Necesitas Ayuda?

Consúltanos si necesitas información de nuestros cursos o masters.

 

Contacta con Core Networks