J. S., Framestore CFC
B. M., London Internet Exchange
MySQL Performance & Tuning training course contents
Introduction to performance tuning
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 scheme,
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 and monitoring
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.
The MyISAM engine
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
The Merge engine concept, Advantages and disadvantages of the Merge engine, Locking with the Merge engine, Performance issues with the Merge engine,
Exercices: Merge engine performance versus MyISAM.
The InnoDB engine
Transactions, Crash recovery, Locking, Monitoring InnoDB, Caches and buffers, Configuring data files, Configuring the log files,
Exercises: InnoDB configuration and performance.
Other storage engines
Archive engine, Memory engine, Federated engine, Blackhole engine, CSV engine, Overview of clustering and performance, Mixing storage engines,
Exercises: Storage engine performance.
Dumping and loading data
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.
Why Choose Us
SNT trainers score an average of over 90% on the three main areas of:
- Ability to teach
- Technical knowledge
- Answering questions
We limit our maximum class size to 8 delegates; often we have less than this. This ensures optimal interactivity between delegates and instructor.
"Excellent course. The small class size was a great benefit…" M.B. IBM
We write our own courses; courseware does not just consist of slides and our slides are diagrams not bullet point text. A typical chapter provides clearly defined objectives with a chapter overview, slides with text underneath, a quiz at the end to check the learning of the students. Hands on exercises are at the end and are used to reinforce the theory.