- TiDB Cluster Introduction
- TiDB Server Introduction
- TiKV Introduction
- Placement Driver Introduction
- SQL Execution Process
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.
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 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
A fully-managed cloud DBaaS for predictable workloads
TiDB Serverless
A fully-managed cloud DBaaS for auto-scaling workloads