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, contact sales to build out a custom training plan.

Contact Sales

Summary

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

Course Outline

  • SQL Tuning Principles
  • Implicit Data Type Conversion Case Study
  • Deep Paging Case Study
  • Aggregate Operation Case Study
  • Multi-Table Join Case Study
  • TiDB Hardware Configuration Recommendations
  • TiDB Operating System Configuration Recommendations
  • TiDB Quick Environment Check
  • SQL Query Time-Out Case Study
  • Write Performance Jitter Case Study
  • Disk Capacity Impacts PD Scheduling Performance Case Study

Build out a custom training plan?  Contact Sales

Module 1: Query Optimization Case Studies

  • SQL Tuning Principles
  • Implicit Data Type Conversion Case Study
  • Deep Paging Case Study
  • Aggregate Operation Case Study
  • Multi-Table Join Case Study
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