@ PingCAP h@pingcap.com TiDB Community Slack Channel https://pingcap.com/tidbslack/ Compare Why Aurora? ● Amazon Aurora is popular ● Amazon Aurora is designed for OLTP workload ● Amazon Aurora is need to involve data warehouse! ○ Example: a dashboard for each tenant in SaaS applications Why Aurora is fast ● Fewer I/O, fewer write amplification ● Smaller network packets ● Eventual consistency TiDB: $0.59 ○ Aurora: $3.38 (without storage cost) Cost comparsion with similar hardware Why? VS Why? A Query Execution Plan Example: TiDB(root@127.0.0.1:test) > explain select count(*) from t1

3868 15.3.9 What is the maximum number of statements in a transaction? · · · · · · · 3868 15.3.10 Why does the auto-increment ID of the later inserted data is smaller than that of the earlier inserted 3.14 Does TiDB release space immediately after deleting data? · · · · · · · · · · · 3869 15.3.15 Why does the query speed get slow after data is deleted? · · · · · · · · · · · · 3869 15.3.16 What should 15.3.20 Can I use optimizer hints to override the optimizer behavior? · · · · · · · · 3871 15.3.21 Why the Information schema is changed error is reported? · · · · · · · 3871 15.3.22 What are the causes

3139 13.2.5 What is the maximum number of statements in a transaction? · · · · · · · 3139 13.2.6 Why does the auto-increment ID of the later inserted data is smaller than that of the earlier inserted 11 Does TiDB support the REPLACE INTO syntax? · · · · · · · · · · · · · · · · · · · · 3140 13.2.12 Why does the query speed get slow after data is deleted? · · · · · · · · · · · · 3141 13.2.13 What should Can I use hints to override the optimizer behavior? · · · · · · · · · · · · · · · · · 3142 13.2.18 Why the Information schema is changed error is reported? · · · · · · · 3142 13.2.19 What are the causes

4400 15.3.9 What is the maximum number of statements in a transaction? · · · · · · · 4400 15.3.10 Why does the auto-increment ID of the later inserted data is smaller than that of the earlier inserted 3.14 Does TiDB release space immediately after deleting data? · · · · · · · · · · · 4401 15.3.15 Why does the query speed get slow after data is deleted? · · · · · · · · · · · · 4401 15.3.16 What should v5.4.0 and later versions, when backup tasks are performed on the cluster under a heavy workload, why does the speed of backup tasks become slow? · · · · · · · · · · · · · · · · · · · · · · · · · · · ·

7 When I use TiCDC to replicate messages to Kafka, Kafka returns the Message was too large error. Why? · · · · · · · · · · · · · · · · · · · · · · · · · · · · 1195 7.6.8 How can I find out whether a DDL 1197 7.7.1 How do I choose start-ts when creating a task in TiCDC? · · · · · · · · · 1197 7.7.2 Why can’t some tables be replicated when I create a task in TiCDC? · 1198 7.7.3 How do I view the state · · 1205 7.7.10 Does TiCDC support outputting data changes in the Canal protocol? · 1205 7.7.11 Why does the latency from TiCDC to Kafka become higher and higher?1206 7.7.12 When TiCDC replicates data

4637 15.3.9 What is the maximum number of statements in a transaction? · · · · · · · 4638 15.3.10 Why does the auto-increment ID of the later inserted data is smaller than that of the earlier inserted 14 Does TiDB release space immediately after deleting data? · · · · · · · · · · · 4639 21 15.3.15 Why does the query speed get slow after data is deleted? · · · · · · · · · · · · 4639 15.3.16 What should v5.4.0 and later versions, when backup tasks are performed on the cluster under a heavy workload, why does the speed of backup tasks become slow? · · · · · · · · · · · · · · · · · · · · · · · · · · · ·

4880 15.3.9 What is the maximum number of statements in a transaction? · · · · · · · 4880 15.3.10 Why does the auto-increment ID of the later inserted data is smaller than that of the earlier inserted 3.14 Does TiDB release space immediately after deleting data? · · · · · · · · · · · 4882 15.3.15 Why does the query speed get slow after data is deleted? · · · · · · · · · · · · 4882 15.3.16 What should v5.4.0 and later versions, when backup tasks are performed on the cluster under a heavy workload, why does the speed of backup tasks become slow? · · · · · · · · · · · · · · · · · · · · · · · · · · · ·

4808 15.3.9 What is the maximum number of statements in a transaction? · · · · · · · 4808 15.3.10 Why does the auto-increment ID of the later inserted data is smaller than that of the earlier inserted 3.14 Does TiDB release space immediately after deleting data? · · · · · · · · · · · 4809 15.3.15 Why does the query speed get slow after data is deleted? · · · · · · · · · · · · 4809 15.3.16 What should v5.4.0 and later versions, when backup tasks are performed on the cluster under a heavy workload, why does the speed of backup tasks become slow? · · · · · · · · · · · · · · · · · · · · · · · · · · · ·

5151 15.3.9 What is the maximum number of statements in a transaction? · · · · · · · 5151 15.3.10 Why does the auto-increment ID of the later inserted data is smaller than that of the earlier inserted 3.14 Does TiDB release space immediately after deleting data? · · · · · · · · · · · 5153 15.3.15 Why does the query speed get slow after data is deleted? · · · · · · · · · · · · 5153 22 15.3.16 What v5.4.0 and later versions, when backup tasks are performed on the cluster under a heavy workload, why does the speed of backup tasks become slow? · · · · · · · · · · · · · · · · · · · · · · · · · · · ·

5180 15.3.9 What is the maximum number of statements in a transaction? · · · · · · · 5180 15.3.10 Why does the auto-increment ID of the later inserted data is smaller than that of the earlier inserted 3.14 Does TiDB release space immediately after deleting data? · · · · · · · · · · · 5182 15.3.15 Why does the query speed get slow after data is deleted? · · · · · · · · · · · · 5182 22 15.3.16 What v5.4.0 and later versions, when backup tasks are performed on the cluster under a heavy workload, why does the speed of backup tasks become slow? · · · · · · · · · · · · · · · · · · · · · · · · · · · ·