Aktualne promocje

20/01/2017
29/09/2020
31/10/2020

Barcampy, konferencje, wydarzenia

29/11/2016 - 18:00
08/11/2016 - 08:30
04/11/2016 (Caly dzien)

Performance Tuning MariaDB & MySQL

Kod szkolenia: 
MDB-PT
Opis szkolenia: 

This instructor-led class is for those who wants to be able to obtain the highest performance from their MariaDB & MySQL databases. 

Learn how to optimize queries, find bottlenecks, utilize caches, and more. Get the latest tips and tricks for squeezing every last drop of performance out of your MariaDB or MySQL server!

Cel szkolenia: 

Learn how to:

  • Choose the best storage engine to suit your dataset and traffic
  • Configure MariaDB or MySQL for best connection concurrency vs memory footprint
  • Design your schema, normalize it, and know when to de-normalize!
  • Tune your SQL queries with inside knowledge of the MariaDB Optimizer
  • Design your application to handle scaling out with Replication, and other technologies
Grupa docelowa: 

This course is for those who wants to be able to obtain the highest performance from their MariaDB & MySQL databases. Learn how to optimize queries, find bottlenecks, utilize caches, and more. Get the latest tips and tricks for squeezing every last drop of performance out of your MariaDB or MySQL server.

Wymagania wobec słuchaczy: 

Basic DBA knowledge is required. It is recommended that students attend the “Administering MariaDB & MySQL” training course prior to registering for the Performance Tuning course.

Cena netto PLN: 
6724
Cena brutto PLN: 
8270.52
Cena EURO: 
1500
Czas trwania: 
5 dni
Uwagi: 

Cena w PLN jest kosztem orientacyjnym.

Koszt szkolenia w Euro przeliczany jest wg kursu sprzedaży w NBP z dnia wystawienia faktury.
Kurs Euro przyjęty do powyższej kalkulacji 1Euro=4,4829 PLN - Tabela nr 099/C/NBP/2016 z dnia 2016-05-23.

Przyjmujemy wpłaty w PLN lub EURO.

Oferujemy  szkolenia w naszych ośrodkach w Warszawie, Wrocławiu i Krakowie, jak i w lokalizacjach wskazanych przez klienta.W celu ustalenia szczegółów prosimy o kontakt na osec@osec.pl

Konspekt: 

Course Highlights
You’ll learn many things in this course related to tuning MariaDB and MySQL databases for better performance. In particular, you’ll learn how to:

  • Architecture of MariaDB and MySQL;
  • How to Assess the Performance of a Server;
  • Methods of Tuning Databases;
  • Select Appropriate Storage Engines for your Needs and Getting More out of
  • Them;
  • Resolving Common Problems; and
  • Utilizing Replication and other Methods of Load Balancing.

Course Outline
Below is the outline of this course. Based on student needs, though, this may change for each teaching of the course.

  • Architecture
  • Collecting Information
  • Schema Tuning
  • Query Tuning
  • Server Configuration
  • MyISAM
  • InnoDB
  • Common Bottlenecks
  • MySQL Replication
  • Maintenance Impact

Logowanie

O osec.pl

Nasz serwis działa dzieki następującym projektom:

Drupal CMS - http://www.drupal.org
Apache HTTPD - http://www.apache.org
PHP - http://www.php.net
MySQL - http://www.mysql.com

ipv6 ready