4 días - 24 horas


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.


  • 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

Contenidos del curso

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

Información general

Área formativa

Cursos ELS Oracle MySQL




Presencial | Learning virtual class


Propia del fabricante



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



    Fecha y precios de nuestros cursos

    Fecha Horario de impartición Ubicación Precio por alumno Previsto en fecha
    10 Jun 2024
    De 9.00 a 15.00 horas
    Formación en Aula Virtual

    ¿Necesitas Ayuda?

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


    Contacta con Core Networks

    Oracle - Core NetworksOracle - Core Networks