MySql Performance Tuning

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
• Course Evaluation
• Thank You!
• QA Session

Questo corso è progettato Database Administrators and System Administrators che attualmente mantengono MySQL server, sviluppatori di database e programmatori che attualmente progettano e/o interagiscono con il database MySQL

• Esperienza nella manutenzione e utilizzo di un’istanza del server MySQL
• Familiarità con gli strumenti della riga di comando e gli script di Linux
• Conoscenza di un linguaggio di programmazione, come Java o PHP

Al termine del corso i partecipanti saranno in grado di:

• Program with Connectors
• Write console and web applications
• Optimize query performance
• Write stored routines and triggers
• Store, access, and analyze geospatial data
• Use X DevAPI to access JSON data in document store