Zielgruppe
- Database administrators
- Developers
- System administrators
Voraussetzungen
Required Prerequisites:
- Experience maintaining a database server (preferably a MySQL server)
- Can use MySQL tools to connect to the MySQL Server
- Have knowledge of general SQL statement structure and basic SQL tuning principles
- Working knowledge of Linux operating systems
Suggested Prerequisites:
- MySQL for Database Administrators
- Experience with a MySQL Server instance and MySQL tools
- Experience writing SQL retrieve, insert, modify and delete
- An ability to locate and execute commands on Linux
Kursziele
- Understand the basics of performance tuning
- Use performance tuning tools
- Tune the MySQL Server instance to improve performance
- Improve performance of tables based on the storage engine being used
- Implement proper Schema Design to improve performance
- Improve the performance of MySQL Queries
- Describe additional items related to performance tuning
Produktbeschreibung
This MySQL Performance Tuning training teaches practical, safe & efficient ways to optimize performance for the MySQL Server. Become familiar with tools for monitoring, evaluating, tuning and more.
Learn To:
- Evaluate the architecture.
- Utilize the tools.
- Configure the database for performance.
- Tune application and SQL code.
- Tune the server.
- Examine storage engines and assess the application architecture.
Course subjects
Introduction
- MySQL Overview
- MySQL Products and Tools
- MySQL Services and Support
- MySQL Web Pages
- MySQL Courses
- MySQL Certification
- MySQL Documentation
Performance Tuning Basics
- Thinking About Performance
- Areas to Tune
- Performance Tuning Terminology
- Benchmark Planning
- Benchmark Errors
- Tuning Steps
- General Tuning Session
- Deploying MySQL and Benchmarking
Performance Tuning Tools
- MySQL Monitoring Tools
- Open Source Community Monitoring Tools
- Benchmark Tools
- Stress Tools
MySQL Server Tuning
- Major Components of the MySQL Server
- MySQL Thread Handling
- MySQL Memory Usage
- Simultaneous Connections in MySQL
- Reusing Threads
- Effects of Thread Caching
- Reusing Tables
- Setting table_open_cache
MySQL Query Cache
- MySQL Query Cache
- When to Use the MySQL Query Cache
- When NOT to Use the MySQL Query Cache
- MySQL Query Cache Settings
- MySQL Query Cache Status Variables
- Improve Query Cache Results
InnoDB
- InnoDB Storage Engine
- InnoDB Storage Engine Uses
- Using the InnoDB Storage Engine
- InnoDB Log Files and Buffers
- Committing Transactions
- InnoDB Table Design
- SHOW ENGINE INNODB STATUS
- InnoDB Monitors and Settings
MyISAM
- MyISAM Storage Engine Uses
- MyISAM Table Design
- Optimizing MyISAM
- MyISAM Table Locks
- MyISAM Settings
- MyISAM Key Cache
- MyISAM Full-Text Search
Other MySQL Storage Engines and Issues
- Large Objects
- MEMORY Storage Engine Uses
- MEMORY Storage Engine Performance
- Multiple Storage Engine Advantages
- Single Storage Engine Advantages
Schema Design and Performance
- Schema Design Considerations
- Normalization and Performance
- Schema Design
- Data Types
- Indexes
- Partitioning
MySQL Query Performance
- General SQL Tuning Best Practices
- EXPLAIN
- MySQL Optimizer
- Finding Problematic Queries
- Improve Query Executions
- Locate and Correct Problematic Queries
Performance Tuning Extras
- Configuring Hardware
- Considering Operating Systems
- Operating Systems Configurations
- Logging
- Backup and Recovery
Conclusion
- Course Overview
- Training and Certification Website
- Course Evaluation
- Thank You!
- Q&A Session