Feature/Enhancement Description Scalability and Performance Instance-level providing better �→ control over memory usage and enhancing database stability. Global indexes for partitioned some of the �→ application modification work required for data migration. 42 Parallel

Feature/Enhancement Description Scalability and Performance Instance-level providing better �→ control over memory usage and enhancing database stability. Global indexes for partitioned some of the �→ application modification work required for data migration. 37 Parallel

Global Sort (experimental, introduced in v7.4.0) �→ TiDB v7.1.0 introduced the https://docs.pingcap.com/tidb/v7.5/tidb-resource-control#manage �→ -background-tasks" target="_blank">Resource for background �→ tasks (experimental, introduced in v7.4.0) In v7.1.0, the Resource Control feature

Feature/Enhancement Description Scalability and Performance Cross-database SQL binding bindings that enable �→ matching bindings across all schema-equivalent databases. Achieve up to 10 times cases, this improvement accelerates restore process by about up to 10 �→ times. Achieve up to 10 �→ times faster for creating tables in batch

Compare / Contrast / Combine Ed Huang, CTO @ PingCAP h@pingcap.com TiDB Community Slack Channel https://pingcap.com/tidbslack/ Compare Why Aurora? ● Amazon Aurora is popular ● Amazon Aurora is designed SSD tidb-server x3 All tests are done in AWS TiDB environment: TiKV configuration modifications: https://gist.github.com/c4pt0r/b0c39f9da9360af2fb2c41ace274b30e Benchmark environment type remarks usage 3016.63 60,332.61 Sysbench - Read-Write (TPS & QPS) Benchmark - TPC-C TPCC configuration file https://gist.github.com/c4pt0r/ca9ecdecc45de5d60d334aa80d031243 1000 warehouse tpmC result: Terminals TiDB

Feature/Enhancement Description Scalability and Performance Global indexes for partitioned �→ application modification work that might be required for data �→ migration. Default time for certain SQL queries and improves the overall �→ database performance. Ignoring unnecessary

Feature/Enhancement Description Scalability and Performance Acceleration of cluster the end-to-end restore speed improving by approximately 1.5 to 3 �→ times. 37 �→ Achieve up to 10 times faster for creating tables, ranging from tens to �→ hundreds of thousands, is a common challenge. 0 码力 | 6479 页 | 108.61 MB | 9 月前

3

Feature/Enhancement Description Reliability and Availability �→ TiProxy supports multiple load balancing policies overall resource usage, improves cluster performance, and increases �→ throughput. The concurrency of parallel HashAgg using < �→ code>tidb_executor_concurrency. 37 Improve

Companies”[2] [0] https://github.com/pingcap/docs/blob/master/sql/mysql-compatibility.md [1] https://blog.pythian.com/tag/myrocks/ [2] https://www.pingcap.com/success-stories/https://www.pingcap.com/success-stories/ TiDB Overview - Architecture Image Credit: https://github.com/pingcap/docs/blob/master/architecture.md © The Pythian Group Inc., 2019 �8 TiKV Image Credit: https://github.com/tikv/tikv © The Pythian Group + Ad Hoc OLAP Image Credit: https://www.slideshare.net/morgo/tidb-introduction © The Pythian Group Inc., 2019 �10 TiDB: SQL Parser and Coprocesor. Image Credit: https://www.slideshare.net/morgo/tidb-introduction

Feature/Enhancement Description Scalability and Performance Acceleration of cluster �→ the end-to-end restore speed improving by approximately 1.5 to 3 �→ times. �→ Achieve up to 10 times faster for creating tables, ranging from tens to �→ hundreds of thousands, is a common challenge. 0 码力 | 6321 页 | 107.46 MB | 1 年前

3