MySQL Performance & Tuning

StayAhead Training Ltd

Course

In London

£ 1,195 VAT inc.

The best Other Database courses

See all

See all

Description

  • Type

    Course

  • Location

    London

  • Duration

    3 Days

Suitable for: Anyone who wishes to monitor and tune MySQL performance.

Facilities

Location

Start date

London
See map
6 Long Lane, Barbican, EC1A 9HF

Start date

On request

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Emagister S.L. (data controller) will process your data to carry out promotional activities (via email and/or phone), publish reviews, or manage incidents. You can learn about your rights and manage your preferences in the privacy policy.

Reviews

Course programme

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

See related categories

MySQL Performance & Tuning

£ 1,195 VAT inc.

The best Other Database courses

See all

See all