お問い合わせ 今すぐ始める

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 Dedicated

TiDB Dedicated

TiDB Cloudのエンタープライズ版。
専用VPC上に構築された専有DBaaSでAWSとGoogle Cloudで利用可能。

TiDB Dedicated

TiDB Serverless

TiDB Cloudのライト版。
TiDBの機能をフルマネージド環境で使用でき無料かつお客様の裁量で利用開始。