Performance Cross-database SQL binding When managing hundreds of databases with the same this case, it is impractical to bind SQL for each database one by �→ one. TiDB v7.6.0 introduces cross-database SQL bindings that enable �→ matching bindings across all schema-equivalent databases. impact on application traffic. For more information, see documentation. 2.2.1.3 Reliability • Cross-database execution plan binding #48875 @qw4990 When running SaaS services on TiDB, it is common practice

backup and restore Y N N N N N N N PITR Y N N N N N N N Global memory control Y N N N N N N N Cross-cluster RawKV replication E N N N N N N N Green GC E E E E E E E N 2.4 MySQL Compatibility TiDB MySQL-compatible database, and JetBrains DataGrip is a powerful integrated development environment (IDE) for database and SQL. This tutorial walks you through the process of connecting to your TiDB cluster DataGrip IDE standalone tool. 269 • As the Database Tools and SQL plugin in JetBrains IDEs, such as IntelliJ, PhpStorm, and PyCharm. This tutorial mainly focuses on the standalone DataGrip IDE. The steps

and tools 7.5 7.1 6.5 6.1 5.4 5.3 5.2 5.1 5.0 4.0 Global mem- ory con- trol Y Y Y N N N N N N N Cross- cluster RawKV repli- ca- tion E E E N N N N N N N Green GC E E E E E E E E E N Resource con- 209 • Foreign key is an experimental feature supported starting from TiDB v6.6.0, which allows cross-table referencing of related data, and foreign key constraints to maintain data consistency. Warning: MySQL-compatible database, and JetBrains DataGrip is a powerful integrated development environment (IDE) for database and SQL. This tutorial walks you through the process of connecting to your TiDB cluster

of data. Cross-database SQL binding (introduced in v7 �→ .6.0) When managing hundreds this case, it is impractical to bind SQL for each database one by �→ one. TiDB v7.6.0 introduces cross-database SQL bindings that enable �→ matching bindings across all schema-equivalent databases. Y Y Y Y Y Y Y E E Non-prepared statement cache Y Y E N N N N N N SQL binding Y Y Y Y Y Y Y Y Y Cross-database binding Y N N N N N N N N Create bindings according to historical execution plans Y Y Y

of data. Cross-database SQL binding (introduced in v7 �→ .6.0) When managing hundreds this case, it is impractical to bind SQL for each database one by �→ one. TiDB v7.6.0 introduces cross-database SQL bindings that enable �→ matching bindings across all schema-equivalent databases. Y Y Y Y Y Y Y E E Non-prepared statement cache Y Y E N N N N N N SQL binding Y Y Y Y Y Y Y Y Y Cross-database binding Y N N N N N N N N Create bindings according to historical execution plans Y Y Y

Y Y Y Y Y Y Y Y Y Y Y 93 Advanced SQL features 8.4 8.3 8.2 8.1 7.5 7.1 6.5 6.1 5.4 5.3 5.2 5.1 Cross-database binding Y Y Y Y N N N N N N N N Create bindings according to historical execution plans Y Y N N N N N PITR Y Y Y Y Y Y Y N N N N N Global mem- ory con- trol Y Y Y Y Y Y Y N N N N N Cross- cluster RawKV repli- ca- tion E E E E E E E N N N N N 104 Management, ob- serv- abil- ity, and supported starting from TiDB v6.6.0, and generally available starting from v8.5.0. Foreign keys allow cross-table references of related data, while foreign key constraints ensure the consistency of related

Y Y Y Y Y E E Non-prepared statement cache Y Y Y E N N N N N N SQL binding Y Y Y Y Y Y Y Y Y Y Cross-database binding Y Y N N N N N N N N Create bindings according to historical execution plans Y Y 5 6.1 5.4 5.3 5.2 5.1 PITR Y Y Y Y Y N N N N N Global mem- ory con- trol Y Y Y Y Y N N N N N Cross- cluster RawKV repli- ca- tion E E E E E N N N N N Green GC E E E E E E E E E E Resource con- mode: • Foreign key is an experimental feature supported starting from TiDB v6.6.0, which allows cross-table referencing of related data, and foreign key constraints to maintain data consistency. Warning:

Y Y Y E E Non-prepared statement cache Y Y Y Y E N N N N N N SQL binding Y Y Y Y Y Y Y Y Y Y Y Cross-database binding Y Y Y N N N N N N N N Create bindings according to historical execution plans Y Y Y Y Y N N N N N PITR Y Y Y Y Y Y N N N N N Global mem- ory con- trol Y Y Y Y Y Y N N N N N Cross- cluster RawKV repli- ca- tion E E E E E E N N N N N Green GC E E E E E E E E E E E Resource con- mode: • Foreign key is an experimental feature supported starting from TiDB v6.6.0, which allows cross-table referencing of related data, and foreign key constraints to maintain data consistency. Warning:

Y Y Y Y Y Y Y Y Y Y Y 88 Advanced SQL features 8.4 8.3 8.2 8.1 7.5 7.1 6.5 6.1 5.4 5.3 5.2 5.1 Cross-database binding Y Y Y Y N N N N N N N N Create bindings according to historical execution plans Y Y N N N N N PITR Y Y Y Y Y Y Y N N N N N Global mem- ory con- trol Y Y Y Y Y Y Y N N N N N Cross- cluster RawKV repli- ca- tion E E E E E E E N N N N N 99 Management, ob- serv- abil- ity, and mode: • Foreign key is an experimental feature supported starting from TiDB v6.6.0, which allows cross-table referencing of related data, and foreign key constraints to maintain data consistency. Warning:

backup and restore Y Y N N N N N N N PITR Y Y N N N N N N N Global memory control Y Y N N N N N N N Cross-cluster RawKV replication E E N N N N N N N Green GC E E E E E E E E N Resource control Y N N N 229 • Foreign key is an experimental feature supported starting from TiDB v6.6.0, which allows cross-table referencing of related data, and foreign key constraints to maintain data consistency. Warning: MySQL-compatible database, and JetBrains DataGrip is a powerful integrated development environment (IDE) for database and SQL. This tutorial walks you through the process of connecting to your TiDB cluster