Rules . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 200 4.2.3 DistSQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 200 Definition How it works . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 434 7.10 DistSQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 435 7.10 encryption can’t work with JPA? . . . . 498 8.5 DistSQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 498 8.5.1 DistSQL How to set custom JDBC connection properties

Rules . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 194 4.2.3 DistSQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 194 Definition How it works . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 407 7.10 DistSQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 408 7.10 encryption can’t work with JPA? . . . . 459 8.5 DistSQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 459 8.5.1 DistSQL How to set custom JDBC connection properties

4 Cluster mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 3.3 DistSQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 3.3.1 Rules . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 167 5.2.3 DistSQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 167 Syntax . . 362 7.8.18 [DistSQL] How to set custom JDBC connection properties or connection pool properties when adding a data source using DistSQL? . . . . . . . . . . . . . . . 362 7.8.19 [DistSQL] How to solve

Data Source . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 164 9.2.3 DistSQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 165 Definition . . . . . . . . . . . . . . . . 551 13.5 DistSQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 552 13.5.1 DistSQL How to set custom JDBC connection properties source using DistSQL? . . . . . . . . . . . . . . . . . 552 13.5.2 DistSQL How to solve Storage unit [xxx] is still used by [Sin- gleRule]. exception when dropping a data source using DistSQL? . . . .

4 Cluster mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 3.3 DistSQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 3.3.1 Properties . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 160 5.2.3 DistSQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 162 Syntax . . 350 7.8.18 [DistSQL] How to set custom JDBC connection properties or connection pool properties when adding a data source using DistSQL? . . . . . . . . . . . . . . . 350 7.8.19 [DistSQL] How to solve

4 Cluster mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 3.3 DistSQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 3.3.1 166 Distributed Transaction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 167 DistSQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 169 5.2.4 Configuration can’t work with JPA? . 308 7.7.17 17. [DistSQL] How to set custom JDBC connection properties or connection pool properties when adding a data source using DistSQL? . . . . . . . . . . . . . . . 308 7

Clients Syncer Data location Job TiSpark DistSQL API TiKV TiDB TSO/Data location Worker Worker Spark Cluster TiDB Cluster TiDB ... ... ... DistSQL API PD PD PD Cluster TiKV TiKV TiDB

maxi- mum value from 256 to 4294967295 �→ . 46 Variable name Change type Description tidb_analyze_distsql_scan_concurrency �→ Newly added Sets the concur- rency of the scan opera- tion when execut- ing response time of the corresponding TiKV address and the Region logs in PD and KV at that time. • 7.1.5 distsql.go reports inconsistent index. The data index seems to be inconsistent. Run the admin check table memory problems caused by high concurrency. The corresponding system variables include: • tidb_distsql_scan_concurrency • tidb_index_serial_scan_concurrency • tidb_executor_concurrency • The concurrency

response time of the corresponding TiKV address and the Region logs in PD and KV at that time. • 7.1.5 distsql.go reports inconsistent index. The data index seems to be inconsistent. Run the admin check table memory problems caused by high concurrency. The corresponding system variables include: • tidb_distsql_scan_concurrency • tidb_index_serial_scan_concurrency • tidb_executor_concurrency • The concurrency pd_client_cmd_handle_cmds_duration_seconds{type="wait"} + req_per_copr * ( tidb_distsql_handle_query_duration_seconds{sql_type="general"} ) tidb_distsql_handle_query_duration_seconds{sql_type="general"} <= send �→ request

response time of the corresponding TiKV address and the Region logs in PD and KV at that time. • 7.1.5 distsql.go reports inconsistent index. The data index seems to be inconsistent. Run the admin check table memory problems caused by high concurrency. The corresponding system variables include: • tidb_distsql_scan_concurrency • tidb_index_serial_scan_concurrency • tidb_executor_concurrency • The concurrency pd_client_cmd_handle_cmds_duration_seconds{type="wait"} + req_per_copr * ( tidb_distsql_handle_query_duration_seconds{sql_type="general"} ) tidb_distsql_handle_query_duration_seconds{sql_type="general"} <= send �→ request