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