Introduction

In this course, you will learn TiDB’s performance optimization principles, SQL optimization, performance monitoring, tuning tools and performance optimization best practice cases.

This course is available through private training. To purchase private training for you or your team, speak to you PingCAP representative or contact sales.

Contact Sales

Summary

  • Audience: Database administrators
  • Level: Advanced
  • Duration: 3 days
  • Prerequisites: TiDB system management basics, or equivalent work experience
  • TiDB Version: v5.x

Course Outline

  • TiDB Cluster Introduction
  • TiDB Server Introduction
  • TiKV Introduction
  • Placement Driver Introduction
  • SQL Execution Process
  • TiDB Database Table Schema Design
  • TiDB Database Indexes
  • TiDB Database System Tables
  • TiDB HTAP Overview
  • TiFlash
  • Distributed Transactions Fundamentals
  • Percolator Transaction Model
  • TiDB Transactions
  • Introduction to TiDB Optimizer
  • Understand Execution Plan
  • Statistics Management
  • Index-Based Optimization
  • TiDB SQL Tuning
  • Problem SQL Vs. Slow SQL
  • Optimizing DML Statements
  • Tune SQL Statements Based on Execution Plans
  • Query Optimization Case Studies
  • TiDB Server Performance Related Parameters
  • PD Performance Related Parameters
  • TiKV Performance Related Parameters
  • OS Optimization
  • Common Monitoring Metrics for TiDB Clusters
  • Performance Monitoring

Purchase private training for you or your team?  Contact Sales

Module 1: Deep Dive into TiDB Architecture

  • TiDB Cluster Introduction
  • TiDB Server Introduction
  • TiKV Introduction
  • Placement Driver Introduction
  • SQL Execution Process

Module 2: TiDB Database Schema

  • TiDB Database Table Schema Design
  • TiDB Database Indexes
  • TiDB Database System Tables

Module 3: TiDB HTAP

  • TiDB HTAP Overview
  • TiFlash

Module 4: TiDB Database Transactions

  • Distributed Transactions Fundamentals
  • Percolator Transaction Model
  • TiDB Transactions

Module 5: TiDB Database Query Optimization

  • Introduction to TiDB Optimizer
  • Understand Execution Plan
  • Statistics Management
  • Index-Based Optimization
  • TiDB SQL Tuning
  • Problem SQL Vs. Slow SQL
  • Optimizing DML Statements
  • Tune SQL Statements Based on Execution Plans
  • Query Optimization Case Studies

Module 6: TiDB Database System Optimization

  • TiDB Server Performance Related Parameters
  • PD Performance Related Parameters
  • TiKV Performance Related Parameters
  • OS Optimization
  • Common Monitoring Metrics for TiDB Clusters
  • Performance Monitoring
TiDB Cloud logo-black

TiDB Cloud

Get the massive scale and resiliency of TiDB databases in a fully managed cloud service

TiDB logo-black

TiDB

TiDB is effortlessly scalable, open, and trusted to meet the real-time needs of the digital enterprise