lab_code: dba_307_lab_ff1
title_en: "TiDB SQL Tuning Lab 2: Partitioned Tables"
title_zh: "TiDB SQL 调优实验 2: 分区表"
title_ja: "TiDB SQL チューニング演習 2: パーティションテーブル"
title_ko: "TiDB SQL 튜닝 실습 2: 파티션 테이블"
description_en:
  " In this hands-on lab, you will create and manage Range partitioning,
  Range COLUMNS partitioning, List partitioning and List COLUMNS partitioning tables.
  You will learn about the differences between Hash partitioning and Key partitioning
  tables. Finally, you will compare the performance between partitioned and non-partitioned
  table."
description_zh:
  在这个实验中，您将创建和管理 Range 分区、Range COLUMNS 分区、List 分区和 List COLUMNS 分区表。您将了解
  Hash 分区和 Key 分区表之间的区别。最后，您将比较分区表和非分区表之间的性能。
description_ja:
  このハンズオン演習では、Range パーティショニング、Range COLUMNS パーティショニング、List パーティショニング、List
  COLUMNS パーティショニングテーブルを作成および管理します。Hash パーティショニングテーブルと Key パーティショニングテーブルの違いについて学びます。最後に、パーティション化されたテーブルと非パーティション化されたテーブルのパフォーマンスを比較します。
description_ko:
  이 실습에서는 Range 파티셔닝, Range COLUMNS 파티셔닝, List 파티셔닝, List COLUMNS 파티셔닝
  테이블을 만들고 관리합니다. Hash 파티셔닝 테이블과 Key 파티셔닝 테이블의 차이점에 대해 배우게 됩니다. 마지막으로, 파티셔닝된 테이블과
  비파티셔닝된 테이블의 성능을 비교합니다.
splash_image_en: https://lab-static.pingcap.com/quick-demo/307-02.png
splash_image_zh: https://lab-static.pingcap.com/quick-demo/307-02.png
splash_image_ja: https://lab-static.pingcap.com/quick-demo/307-02.png
splash_image_ko: https://lab-static.pingcap.com/quick-demo/307-02.png
external_materials_en:
  - name: "Partitioned Tables Deck Template"
    url: https://docs.google.com/presentation/d/1hKVp6bylsMnfn0ihUVIzl-gDPdk23rfI/edit?slide=id.p1#slide=id.p1
    employee_only: true
external_materials_ja:
  - name: "パーティションテーブルデッキテンプレート"
    url: https://docs.google.com/presentation/d/1S0T9OAzWddEfLgstONhnqppjxY7ePUuN/edit?slide=id.p1#slide=id.p1
    employee_only: true
external_materials_zh:
  - name: "分区表演示文稿模板"
    url: https://docs.google.com/presentation/d/1hKVp6bylsMnfn0ihUVIzl-gDPdk23rfI/edit?slide=id.p1#slide=id.p1
    employee_only: true
external_materials_ko:
  - name: "파티션 테이블 템플릿"
    url: https://docs.google.com/presentation/d/1hKVp6bylsMnfn0ihUVIzl-gDPdk23rfI/edit?slide=id.p1#slide=id.p1
    employee_only: true
lab_level: Intermediate
category_en:
  - Application Migration
  - SQL Tuning
category_zh:
  - 应用迁移
  - SQL 调优
category_ja:
  - アプリケーション移行
  - SQL チューニング
category_ko:
  - 애플리케이션 마이그레이션
  - SQL 튜닝
authors:
  - Fei Dong (CEG)
  - Tony Huang (CEG)
delivery_type: Instructor-Led
tidb_environments:
  - TiDB Self-Managed
tidb_versions:
  - 7.5.4
target_audience:
  - Architect
  - Developer
  - DevOps
regions:
  aws:
    - oregon
    - tokyo
    - singapore
    - frankfurt
credits: 1
credit_redeemable: true
employee_only: false
estimated_duration_minutes: 90

requirements:
  - type: CloudStack

topology:
  - role: monitor
    node_count: 1
    ssh_user: ec2-user
    web_ssh: true
  - role: pd
    node_count: 1
  - role: kv
    node_count: 3
  - role: db
    node_count: 2

bootstrap:
  - name: "prepare monitor"
    type: "ShellScript"
    target:
      - monitor1
    script: ./scripts/prepare-monitor.sh
  - name: "prepare tidb"
    type: "ShellScript"
    target:
      - monitor1
    shell: |
      set -e
      /home/ec2-user/create-cluster-vinput.sh ${TIDB_VERSION} ${REGION_NAME} ./solution-topology-seven-nodes.yaml

features:
  enable_content_explain: false