Tel: UK 0845 757 3888 | Ireland: 01 284 6796
MySQL Performance Tuning
Course type Essentials (What does this mean?)
| Course title | MySQL Performance Tuning |
|---|---|
| Delivery method |  Classroom |
| RRP | £1860 exc. VAT |
| Days/Duration | 4 |
| Code | SQL4402 |
Secure online payment
- view dates / book course
- course description
- blogs
Course dates
| Location | May | Jun | Jul | Aug | view later dates |
|---|---|---|---|---|---|
| Location | Sep | Oct | Nov | Dec | view earlier dates |
London
Tabernacle Street, EC2 |- |- |- |- 
Location Sep Oct Nov Dec view earlier dates Tabernacle Street, EC2 |- |- |19 |- Tabernacle Street, EC2 location information and directions
19 Nov 5 or more places available £1,860 exc VAT MySQL Performance Tuning training in Tabernacle Street, EC2
Special Notices
Please note: Courses in London are subject to a 10% surcharge
Overview
The MySQL[tm] Performance Tuning course is designed for Database Administrators and others who wish to monitor and tune MySQL. This course will prepare each student with the skills needed to utilize tools for monitoring, evaluating and tuning. Students will evaluate the architecture, learn to use the tools, configure the database for performance, tune application and SQL code, tune the server, examine the storage engines, assess the application architecture, and learn general tuning concepts.
Prerequisites
- Students who wish to attend this course, should have attended the MySQL for DBAs course or have similar knowledge:
- Have previously worked with a MySQL Server instance and database and have working knowledge of MySQL architecture
- Can use MySQL tools to connect to the MySQL Server
- Have knowledge of general SQL statement structure and basic SQL tuning principles
- MySQL for Database Administrators (SQL-4502)
Delegates will learn how to
- Develop a tuning strategy
- Display knowledge of MySQL architecture
- Display knowledge and ability to use diagnostic tools
- Display knowledge and ability to use tuning tools
- Write queries against the INFORMATION_SCHEMA database and be able to decipher the metadata obtained
- Understand the relational database model and both the positive and negative implications on performance
- Display, decipher and edit server configuration variables to improve performance of your applications
- Display and analyze status variables to ensure that their applications are utilizing the settings in the most effective manner
- Write queries that take advantage of the MySQL 5.0 performance enhancements dealing with queries and indexing
- Decide which of the storage engines could be used in their specific application needs
- Evaluate the application architecture for efficient design, structure, caching, number of connections and other factors affecting performance
- Evaluate hardware and OS for effects on performance
- Evaluate techniques for loading data into the database and effects on performance
Related blogs
Did you have a satisfactory course?
Posted by Phil Stirpe on 25 May 2012
I have written and delivered training courses for many years and in all that time there has always been some form of evaluation at the end of the course. Although there are several questions on the current QA evaluation form, the most important is Overall Satisfaction.
vSphere 5 CLI reference poster
Posted by Bryan O'Connor on 24 May 2012
The vCAP-DCA 5 is coming, and having a look at the blue print, there will be command line and as such the reference poster will be a good resource for revision
Connection Options for the vMA (VMware Management Assistant)
Posted by Bryan O'Connor on 23 May 2012
This article covers the various conn-options for the vMA
Let’s have a Fling
Posted by Bryan O'Connor on 22 May 2012
Not the type you thought, but an offering from VMware
Windows 7 Native Boot Adding the VHD to Bare Metal
Posted by Andrew Mallett on 21 May 2012
I have written before on the native boot feature of Windows 7 where it can boot to a VHD, Virtual Hard Drive. In this blog though we look at adding in a VHD to a completely clean disk with no OS ....
