Caricamento...
  1. Database, Big Data, Machine Learning
MIEOS04

MYSQL Performance Tuning

Prezzo

€ 1,790.00
(Iva esclusa)

Scheda tecnica

Scarica

Giorni

4 gg

Al termine di questo corso gli studenti sarano in grado di:

  • Develop a tuning strategy
  • Display knowledge of MySQL architecture
  • Display knowledge and ability to use diagnostic tools
  • Display knowledge and ability to use tuning tools
  • Write queries against the INFORMATION_SCHEMA database and be able to decipher the metadata obtained
  • Understand the relational database model and both the positive and negative implications on performance
  • Display, decipher and edit server configuration variables to improve performance of your applications
  • Display and analyze status variables to ensure that their applications are utilizing the settings in the most effective manner
  • Write queries that take advantage of the MySQL 5.0 performance enhancements dealing with queries and indexing
  • Decide which of the storage engines could be used in their specific application needs
  • Evaluate the application architecture for efficient design, structure, caching, number of connections and other factors affecting performance
  • Evaluate hardware and OS for effects on performance
  • Evaluate techniques for loading data into the database and effects on performance


     

    Database Administrators and System Administrators che attualmente mantengono MySQL server (s), sviluppatori di database e programmatori che attualmente progettano e/o interagiscono con il database MySQL


    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


    Sede Data P