Troubleshooting MySQL Performance with Sveta Smirnova

Level

Troubleshooting MySQL Performance with Sveta Smirnova

Aikona
Logo Aikona

Need more information? Get more details on the site of the provider.

Starting dates and places

This product does not have fixed starting dates and/or places.

Description

Special Notices

Please note, this special seminar will take place on 28th February 2013 at:

Oracle University
One South Place
London
EC2M 2RB

Overview

This class focuses on performance problems in MySQL applications. In this class you will learn why issues happen in the first place and how to react to and solve situations such as Query runs slow, Query execution time increases during life of the application, MySQL server uses more and more system resources, Slave cannot catch up the master, and more. Special attention will be paid to tools, both included with the MySQL server and working separately. While there are a lot of resources about High Performance best practices, they don't foc…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: .

Special Notices

Please note, this special seminar will take place on 28th February 2013 at:

Oracle University
One South Place
London
EC2M 2RB

Overview

This class focuses on performance problems in MySQL applications. In this class you will learn why issues happen in the first place and how to react to and solve situations such as Query runs slow, Query execution time increases during life of the application, MySQL server uses more and more system resources, Slave cannot catch up the master, and more. Special attention will be paid to tools, both included with the MySQL server and working separately. While there are a lot of resources about High Performance best practices, they don't focus on troubleshooting techniques. If you hit a problem you need to run through all this information looking for a tool or technique which can help you in this specific case. This seminar brings all the key troubleshooting techniques together for you in one place.

Speaker Bio

Sveta Smirnova is a Principal Support Engineer for MySQL. She has been working in the Bugs Analysis MySQL Support Group since 2006. Sveta enjoys working on tricky support issues and MySQL software bugs on a daily basis. Before starting at MySQL in 2006, she worked as a web developer on several closed CRM systems. Sveta is an active participant in the open source community. Her main interests in recent years are solving DBA problems and finding ways to semi-automate the related processes. Sveta is the author of the book 'MySQL Troubleshooting'

Audience

  • Database Administrators
  • Developer

Prerequisites

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

Delegates will learn how to

  • Understand why a query can run slow
  • Understand the effect of concurrency
  • See how MySQL server interacts with the operating system

Course Outline.

  • How to test safely
  • Reproducible problems with single query
  • Reproducible problems with multiple threads running at the same time, e.g. concurrency issues
  • Effect of MySQL options
  • What you need to know about the storage engine you use
  • Effect of operating system resources
  • Replication
There are no reviews yet.

    Share your review

    Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

    There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.