Performance and Tuning Queries in MySql Database

Performance and Tuning Queries in MySql Database

  • Codice
    DT0032
  • Prezzo
    1.790,00 €
  • Durata
    4 gg

Descrizione

Il corso di Performance and Tuning consentirà di apprendere le nozioni principali per monitorare le Queries e gli Access Path, conoscere in modo approfondito l'ottimizzatore per migliorare le prestazioni degli Statement SQL.

Target

Database Administrator e sviluppatori

Prerequisiti

Conoscenza di base del database MySql

Programma Corso

Introduction

  • MySQL Overview, Products, Services and Enterprise Services
  • Supported Operating Services
  • MySQL Certification Program
  • Training Curriculum Paths
  • MySQL Website
  • Installing MySQL
  • Installing the world Database MySQL Architecture
  • MySQL Architecture Overview (High Level)
  • Client/Server Architecture
  • Storage Engine Concept
  • Data Directory
  • Data Storage
  • Locks MySQL Performance Tools
  • Overview
  • Benchmarking Tools
  • Administration Tools
  • Specific SHOW commands

Schema Design

  • Data Modeling
  • Normalization
  • Denormalization
  • Data Types
  • Partitioning Indexing
  • Indexes
  • MySQL Index Types
  • Index Optimizations Statement Tuning
  • General SQL Tuning
  • EXPLAIN
  • MySQL Optimizer
  • Finding Problematic Queries
  • Caching and MySQL
  • Choose an Architecture Caching
  • Caching Benefits
  • Non-MySQL Caches
  • Query Cache
  • MEMORY/MyISAM

Tables as Cache MySQL Server Configuration

  • Server Connection Parameters
  • Table Cache and Multi-threading Issues
  • Individual Thread Parameters
  • General Monitoring
  • Table Handlers MyISAM
  • Where to use
  • Row Storage Format
  • Indexing
  • Locking
  • Key Cache
  • MyISAM Tuning
  • Other optimization tools for MyISAM
  • MERGE Storage Engine InnoDB
  • Transactions
  • Internal Buffers
  • Indexes
  • Crash Recovery
  • Best Practices
  • Tuning
  • Comparing InnoDB and MyISAM Alternate Storage Engines
  • MEMORY, FEDERATED, ARCHIVE, CSV, BLACKHOLE

Falcon

  • Performance Issues with Mutliple Storage Engines
  • Creating a Custom Storage Engine
  • MySQL Cluster Conclusion
  • Course Overview
  • Training and Certification Website