Fundación Tripartita

MYSQL Performance Tuning SQL 4402

Contents

  • 1. Develop an adjustment strategy
  • 2. Demonstrate knowledge about the MySQL architecture
  • 3. Demonstrate knowledge and skills in the use of diagnostic tools
  • 4. Write queries against the INFORMATION_SCHEMA database and be able to decrypt the metadata obtained
  • 5. Understanding Database Model Relationships and the Positive and Negative Implications Affecting Performance
  • 6. Write queries that take advantage of MySQL 5.0 performance improvements in queries and indexes
  • 7. Evaluate & nbsp; application architecture to increase design efficiency, structure, caching, number of connections and other factors affecting performance
  • 8. Evaluate how your hardware and operating system affect performance
  • 9. Evaluate the data loading techniques in the database and how they affect performance
  •  

    Utilizamos cookies propias y de terceros para mejorar nuestros servicios, personalizar y analizar sus hábitos de navegación y mostrarle publicidad relacionada con sus preferencias. Si continúa navegando, consideramos que acepta su uso. Puede cambiar la configuración u obtener más información acerca de las cookies en el siguiente enlace:Política de Cookies.

    Aceptar Cookies