MySQL Performance Tuning

• DevOps
• Application Developers
• Architecture Designers

• Linux Basic Knowledge
• ANSI SQL Basic Knowledge
• RDBMS Basic Understanding

History And Introduction

• Overview
• Real Examples and Use Cases Of Customers Using MySQL Database

Architecture Overview 

• Sever
• Client

Storage Engines

• Engines Types
• Engines Characteristics
• Using Storage Engines For Different Tasks To Achieve Better Performance

Database Management 

• System Variables
• Altering Database Variables at Session / Global Level

Identifying Slow Queries

• The Slow-Query-Log
• The Process List
• InnoDB_TRX
• Using Show Warnings
• Performance Schema
• PT Query Digest (Percona)

Optimizing Queries

• MySQL Performance Tuning Methods
• Explaining The EXPLAIN
• MySQL Indexes
• MySQL Optimizer Hints
• Working with MySQL Caching Solutions

MySQL Parameter File Best Practices – my.cnf 

• InnoDB Memory Buffers
• Log file size And log buffer
• Memory Consumption
• Memory Limitations

Table Maintenance

• Analyze Table
• Check Table
• Checksum Table
• Optimize Table
• Repair Table
• Moving Tables Between Schemas / Servers / Tablespaces
• Implementing Partitions

Locking in MySQL

• The Locking Mechanism Overview
• InnoDB ACID And Isolation Levels Locks
• Table Level Locking
• Row Level Locking
• Internal / External Locking
• Dead Locks
• Locks Monitoring

Monitoring Database Activity 

• Information Schema
• Performance Schema and Workbench
• Monitoring Solutions Overview

Planning For Schema Change

• Alter Table Considerations
• PT Online Schema Change (Percona)

Various Logs In MySQL (Error Monitoring)

• Error Log
• Query Log
• Slow Query Log
• Binary Log
• Relay Log
• General Query Log

Using MySQL Built-In Tools 

• MySQLAdmin
• MySQLBinlog
• MySQLDump
• MySQLImport