MySQL Performance & Tuning
|
Summary
|
|
|||||||||||||
MySQL Performance & Tuning
This MySQL Performance & Tuning course is designed for Database Administrators who wish to monitor and tune the performance of MySQL servers and databases. The course provides practical experience in monitoring and tuning MySQL servers and databases.
The delegates will practise:
- Developing a monitoring and tuning plan
- Using monitoring and diagnostic tools
- Using the Information Schema and Show commands to collect data for tuning
- Understanding normalization and de-normalization and their effect on performance
- Using server configuration and status variables
- Understanding the output from the Explain command
- Identifying and improving problem queries
- Making efficient use of indexes
- Monitoring and sizing memory caches
- Monitoring locks
- Tuning the MyISAM storage engine
- Tuning the InnoDB storage engine
- Tuning other standard storage engines
- Comparing and tuning dump and load performance
- Evaluating the use of partitioning for performance
Anyone who wishes to monitor and tune MySQL performance.
To provide the skills necessary to monitor and tune MySQL performance.
There are currently no official certification examinations for MySQL Performance and Tuning.
Delegates must have a working knowledge of MySQL Database Administration.
This MySQL Performance & Tuning course does not cover clustering (other than at overview level), replication or non-standard storage engines such as Falcon and PBXT.
- MySQL Database Administration
- MySQL for Developers
- Perl Programming
- Apache Web Server
- PHP & MySQL for Web Development
NOTE: Course technical content is subject to change without notice.
- Administration and Course Materials
- Course Structure and Agenda
- Delegate and Trainer Introductions
- Tuning Overview
- Resolving Performance Issues
- Recommended Approach to Tuning
- Items to Evaluate
- Where to look
- Planning a Monitoring Routine
- Building a New Database for Performance
- Tuning an Existing Database
- Setting Suitable Goals
- Administration Tools
- The Information Schema
- Performance-related SHOW Commands
- Benchmarking Tools
- The MySQL Performance Schema
- Exercises: Obtaining Performance Information
- Normalisation
- De-normalisation
- Data Types
- Character Sets
- Choosing Storage Engines
- Exercises: Effects of Design on Performance
- Overview of Statement Tuning
- Identifying Problem Queries
- The Optimizer
- Explain
- Explain Extended
- Exercises: Identifying Problem Queries and Using Explain
- Index Overview
- Types of Index
- Index Tuning
- Indexes and Joins
- Exercises: Indexes and Performance
- Server Configuration Variables
- Server Status Variables
- Table Cache
- Multi-Threading
- Query Cache
- Exercises: Setting and Interpreting Server Variables and Caching
- Types of Locking
- Locking and Storage Engines
- Effects of Locking on Performance
- Exercises: Locking and Performance
- Advantages and Disadvantages of MyISAM
- How MyISAM Caches Data
- MyISAM Formats
- MyISAM Indexes
- MyISAM Locking
- The Key Cache
- Tuning MyISAM
- Exercises: Monitoring and Tuning the MyISAM Engine
- The Merge Engine Concept
- Advantages and Disadvantages of The Merge Engine
- Locking with the Merge Engine
- Performance Issues with the Merge Engine
- Exercises: Merge Engine Performance Versus MyISAM
- Transactions
- Crash Recovery
- Locking
- Monitoring InnoDB
- Caches and Buffers
- Configuring Data Files
- Configuring the Log Files
- Exercises: InnoDB Configuration and Performance
- Archive Engine
- Memory Engine
- Federated Engine
- Blackhole Engine
- CSV Engine
- Overview of Clustering and Performance
- Mixing Storage Engines
- Exercises: Storage Engine Performance
- SQL statements versus delimited data
- Parameters affecting dump performance
- Parameters affecting load performance
- Exercises: Dump and load performance
- Partitioned tables concepts
- Range partitioning
- Hash partitioning
- Key partitioning
- List partitioning
- Composite partitioning or subpartitioning
- Partition Pruning
- Exercises: Partitioned Table Performance
If you want to find out more about MySQL Performance & Tuning, you can make an information request below and the school will contact you with further information.
Expenses
StayAhead Training
StayAhead Training - SQL, Oracle, UNIX and Linux training courses delivered by IT experts
StayAhead Training are recognised as one of the top 50 IT Training organisations in the UK and the first choice provider of UNIX, Linux, MySQL and Oracle training courses for many of the UK's most prominent organisations.
StayAhead Training was established in 1992 and now have training centres in London, Birmingham, Manchester, Leeds, Edinburgh and Bristol. Because of this, StayAhead are able to offer a large range of scheduled, tailored and onsite training. Independent of where you are based, StayAhead can help you and your firm's IT requirements be reality.
Specialist IT training for professionals
StayAhead Training have a formidable reputation for quality and expertise within the UNIX, Oracle, Linux and MySQL arena.
UNIX training courses not only covers standard UNIX but includes a range of Solaris, AIX, HP-UX, Linux, SUSE, LPI & Red Hat Linux training. The Oracle training courses also have depth with courses available for DBAs, Developers and Designers. If certification is important to you then again we do not disappoint taking delegates to the level required to take the examinations in Solaris, Red Hat, SUSE, LPI, MySQL, Oracle Forms Developer and Oracle DBA. With the Oracle e-business suite growing in popularity a range of Oracle Financials courses are also available.
In-house Professional IT training for your organisation
In addition to the public schedule of courses provided, StayAhead offer all courses in-house at a client's site, or at a StayAhead location. All courses can be tailored to meet our clients' specific needs. For courses at the client's site StayAhead can provide all the necessary hardware and software.
StayAhead's focus on IT training
StayAhead understands the best approach for such technical IT training is always to be enthusiastic, business-like, informal yet professional. StayAhead's style of delivery is designed to foster the development of learning. Instructor led tutorials are followed by practical exercises. The style is experiential allowing delegates to take ownership and solve problems for themselves. Research shows that the pace of learning is greatly accelerated when delegates are shown HOW to solve their problems rather than just why they should.
Show all courses with
StayAhead Training
Request information - obligation free
Contact information for StayAhead Training
Phone no: +44 (0)20 7600 6116 
To request information from MySQL Performance & Tuning, please fill out the following details:
