High-Performance MySQL

 Tunning with MySQL database

Main Speaker

Learning Tracks

Course ID

42603

Date

27/11/2024

Time

Daily seminar
9:00-16:30

Location

Daniel Hotel, 60 Ramat Yam st. Herzliya

Overview

MySQL powers many of the world’s largest and fastest-growing organizations. Companies including Facebook, Google and Adobe rely on MySQL to save both time and money powering their high-volume websites, business-critical systems and packaged software.

In this seminar, you will learn practical, safe and efficient ways to optimize the MySQL database performance. Participants will gain tips and tricks and best practices to optimally architect the MySQL database, find bottlenecks and learn how to properly configure the database appropriately for achieving extreme performance results.

Who Should Attend

Experienced MySQL database administrators who are looking to design and optimize a database server for maximum performance and scalability.

Prerequisites

Course Contents

  • Speedy MySQL introduction
  • Performance Tuning Basics Terms
  • MySQL Thread Handling and Memory Usage
  • Basic Server Parameters – my.cnf file
  • InnoDB/Xtradb Storage Engine Tuning
  • Facebook MyRocks Engine
  • Schema Design Considerations and Performance – Indexes Data-Types and stored procedure
  • MySQL Queries Performance – the explain
  • The Performance Schema
  • Scaling horizontally and vertically – Sharding Replication and Partition
  • JSON and Document-store
  • MySQL Server Tuning
  • MySQL 8.0 New Features

The conference starts in

Days
Hours
Minutes
Seconds