MySQL Performance Tuning
About this Training
Identify and fix replication lag
Understand performance tuning concepts
List factors that affect performance
Use a range of performance tuning tools
Configure and use the Performance Schema
Tune the MySQL server instance
Design a schema for optimal performance
Understand how MySQL optimizes queries
Identify and fix slow queries
Diagnose and resolve common performance issues
What you will learn
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.
Duration: 4 Days 
Prerequisite
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.
Application Developers
Cloud Database Administrators
Database Administrators
Database Designers
Developer
System Administrator
Technical Administrator
Audience
Content
Introduction
Course goals
MySQL products and professional services
MySQL Cloud Service
Supported platforms
MySQL resources on the web
MySQL courses and certification options
Performance Tuning Concepts
Terminology
Benchmarking
Troubleshooting performance issues
Tuning steps
Deploying and maintaining MySQL
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
Atendimento Personalizado
Para saber mais sobre os treinamentos, certificações e soluções de TI da SoftSell, entre em contato com a gente.
É só escolher o seu canal preferido e aguardar breve resposta em horário comercial:
ENDEREÇO
Rua Emiliano Perneta, 680 – 9º Andar
Centro – Curitiba – Paraná – 80420-080