T1609

Ladda ner som PDF

MariaDB Performance Tuning

Gain a deep understanding of advanced MariaDB features and enhancements for delivering the highest database performance. Learn the latest optimization tips and techniques—such as optimizing queries, identifying bottlenecks, utilizing caches, and more.

Audience

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

Prior knowledge

  • Advanced MariaDB or MySQL Skills
  • Significant Amount of Experience with MariaDB or MySQL

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:

  • Learn how to analyze queries and review slow query logs to determine typical hinderances to performance
  • Tune queries with inside knowledge of the MariaDB Optimizer
  • Choose the right storage engine and column types for your dataset and traffic
  • Design and normalize your schema, and know when to de-normalize
  • Configure MariaDB for the best connection concurrency vs. memory footprint
  • Design applications to scale out with replication and other technologies

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
  • MariaDB Replication
  • Maintenance Impact

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:

  • Learn how to analyze queries and review slow query logs to determine typical hinderances to performance
  • Tune queries with inside knowledge of the MariaDB Optimizer
  • Choose the right storage engine and column types for your dataset and traffic
  • Design and normalize your schema, and know when to de-normalize
  • Configure MariaDB for the best connection concurrency vs. memory footprint
  • Design applications to scale out with replication and other technologies

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
  • MariaDB Replication
  • Maintenance Impact
Kurs-ID: T1609
Längd: 4 dagar
Pris exkl moms: 31 450 kr
Kan betalas med:
TRAINING CARD

Lämna dina kontaktuppgifter om du önskar en företagsintern utbildning.

Tipsa