latin1_general_ci 多种语言的 (西欧)，不区分大小写 latin1_general_cs 多种语言的 (ISO 西欧)，区分大小写 latin1_german1_ci 德国 DIN-1 (字典序)，不区分大小写 latin1_german2_ci 德国 DIN-2，不区分大小写 latin1_spanish_ci 现代西班牙语，不区分大小写 latin1_swedish_ci 瑞典语/芬兰语，不区分大小写 AND ... 判断值满足范围 BINARY 将一个字符串转换为一个二进制字符串 & 位与 ~ 位非 [`\ `] (https://dev.mysql.com/doc/refman/5.7/en/bit- functions.html#operator_bitwise-or) 位或 ^ 按位异或 CASE case 操作符 DIV 整数除 / 除法 = 相等比较 <=> 详情参见 这里. 操作符 名 功能 描述 AND , && 逻辑 与 NOT , ! 逻辑 非 [`\ \ , OR`](https://dev.mysql.com/doc/refman/5.7/en/logical- operators.html#operator_or) 逻 辑 或 XOR 逻辑 亦或 逻辑操作符 操作符 - 114 - 本文档使用 书栈(BookStack.CN) 构建

version="1.0" encoding="UTF-8" ?> EN" "http://mybatis.org/dtd/mybatis-3-config.dtd"> EN" "http:// �→ mybatis.org/dtd/mybatis-3-mapper.dtd"> correctly. EN" "http:// �→ mybatis.org/dtd/mybatis-3-mapper.dtd"> 130

vari- able is depre- cated. Its value will be fixed to the default value ON, that is, global index is en- abled by de- fault. You only need to add the key- word GLOBAL to the corre- spond- ing column when able is depre- cated. Its value will be fixed to the default value ON, that is, list parti- tioning is en- abled by de- fault. 55 Variable name Change type Description tidb_ �→ enable �→ _ �→ table �→ _ is depre- cated. Its value will be fixed to the default value ON, that is, table parti- tioning is en- abled by de- fault. tidb_ �→ analyze �→ _ �→ partition �→ _ �→ concurrency �→ Modified Changes the

vari- able is depre- cated. Its value will be fixed to the default value ON, that is, global index is en- abled by de- fault. You only need to add the key- word GLOBAL to the corre- spond- ing column when able is depre- cated. Its value will be fixed to the default value ON, that is, list parti- tioning is en- abled by de- fault. 50 Variable name Change type Description tidb_ �→ enable �→ _ �→ table �→ _ is depre- cated. Its value will be fixed to the default value ON, that is, table parti- tioning is en- abled by de- fault. tidb_ �→ analyze �→ _ �→ partition �→ _ �→ concurrency �→ Modified Changes the

Changes the default value from OFF to ON. This means that Dis- tributed eXecu- tion Frame- work (DXF) is en- abled by de- fault, which fully utilizes the re- sources of the TiDB cluster and greatly im- proves of ADD �→ INDEX �→ and IMPORT �→ �→ INTO �→ tasks. If you want to up- grade a cluster with the DXF en- abled to v8.1.0 or later, disable the DXF (by setting tidb_ �→ enable �→ _ �→ dist �→ _ �→ task �→ version="1.0" encoding="UTF-8" ?> EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">

0 码力 | 6479 页 | 108.61 MB | 10 月前

3

version="1.0" encoding="UTF-8" ?> EN" "http://mybatis.org/dtd/mybatis-3-config.dtd"> EN" "http:// �→ mybatis.org/dtd/mybatis-3-mapper.dtd"> correctly. EN" "http:// �→ mybatis.org/dtd/mybatis-3-mapper.dtd">

version="1.0" encoding="UTF-8" ?> EN" "http://mybatis.org/dtd/mybatis-3-config.dtd"> EN" "http:// �→ mybatis.org/dtd/mybatis-3-mapper.dtd"> correctly. EN" "http:// �→ mybatis.org/dtd/mybatis-3-mapper.dtd">

V2. Set the value to 2 to enable it and 1 to disable it. The default value is 1. When TiDB DDL V2 is en- abled, DDL state- ments will be exe- cuted using TiDB DDL V2. The ex- ecution speed of DDL state- version="1.0" encoding="UTF-8" ?> EN" "http://mybatis.org/dtd/mybatis-3-config.dtd"> EN" "http:// �→ mybatis.org/dtd/mybatis-3-mapper.dtd">

supports LDAP authentication, which is compatible with MySQL 8.0. 0 码力 | 5716 页 | 104.74 MB | 1 年前

3

multiple SQL statements for internal execution. The split statements compromise transaction atomicity and iso- lation but greatly improve the cluster stability. TiDB has supported non-transactional DELETE statements forward compatibility, when txn-total-size-limit is configured as a non-default value, TiDB will still en- sure that transactions can use the memory set by txn-total-size-limit. If you are using TiDB v6.5 after further tests, mean- ing that the sup- port of Outer Join for the Join Re- order algo- rithm is en- abled by de- fault. 45 Variable name Change type Description tidb_cost_model_version �→ Modified