configure the optimal parameters of the operating system · · 622 5.2.7 Manually configure the SSH mutual trust and sudo without password · 628 5.2.8 Install the numactl tool · · · · · · · · · · · · · · · · · mode includes these modes: ONLY_FULL_GROUP_BY, �→ STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO �→ ,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION. • MySQL’s default SQL mode: MySQL 8.0 includes these modes: ONLY_FULL_GROUP_BY �→ ,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO �→ ,NO_ENGINE_SUBSTITUTION. • Default value of lower_case_table_names: •

configure the optimal parameters of the operating system · · 720 5.2.7 Manually configure the SSH mutual trust and sudo without password · 727 5.2.8 Install the numactl tool · · · · · · · · · · · · · · · · · default value from OFF to ON. For tables with no statis- tics (pseudo- statistics) or empty tables (zero statis- tics), the op- timizer prefers inter- val scans over full table scans. 58 Variable name mode includes these modes: ONLY_FULL_GROUP_BY,STRICT_ �→ TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ �→ ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION. • MySQL’s default SQL mode:

configure the optimal parameters of the operating system · · 715 5.2.7 Manually configure the SSH mutual trust and sudo without password · 722 5.2.8 Install the numactl tool · · · · · · · · · · · · · · · · · default value from OFF to ON. For tables with no statis- tics (pseudo- statistics) or empty tables (zero statis- tics), the op- timizer prefers inter- val scans over full table scans. 53 Variable name mode includes these modes: ONLY_FULL_GROUP_BY,STRICT_ �→ TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ �→ ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION. • MySQL’s default SQL mode:

configure the optimal parameters of the operating system · · 105 4.2.6 Manually configure the SSH mutual trust and sudo without password · 111 4.2.7 Install the numactl tool · · · · · · · · · · · · · · · · · TiDB includes these modes: ONLY_FULL_GROUP_BY, �→ STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO �→ ,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION. – The default SQL mode in MySQL 8.0 includes these modes: ONLY_FULL_GROUP_BY �→ ,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO �→ ,NO_ENGINE_SUBSTITUTION. 67 • Default value of lower_case_table_names:

configure the optimal parameters of the operating system · · 634 5.2.7 Manually configure the SSH mutual trust and sudo without password · 640 5.2.8 Install the numactl tool · · · · · · · · · · · · · · · · · of the configuration item txn-entry-size- �→ limit by default. When this variable is set to a non-zero value, TiDB limits the size of a row record in transactions to the value of this variable. This improvement item txn- �→ entry �→ - �→ size �→ - �→ limit �→ by de- fault. When this vari- able is set to a non- zero value, txn- �→ entry �→ - �→ size �→ - �→ limit �→ is also set to the same value. 52 Variable name

configure the optimal parameters of the operating system · · 634 5.2.7 Manually configure the SSH mutual trust and sudo without password · 641 5.2.8 Install the numactl tool · · · · · · · · · · · · · · · · · entirely composed of TopN and the modified row count in the corresponding table statistics is non-zero #47400 @terry1purcell • The TopN operator supports disk spill #47733 @xzhangxian1008 • TiDB node mode includes these modes: ONLY_FULL_GROUP_BY,STRICT_ �→ TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ �→ ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION. • MySQL’s default SQL mode:

configure the optimal parameters of the operating system · · 631 5.2.7 Manually configure the SSH mutual trust and sudo without password · 638 5.2.8 Install the numactl tool · · · · · · · · · · · · · · · · · mode includes these modes: ONLY_FULL_GROUP_BY,STRICT_ �→ TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ �→ ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION. • MySQL’s default SQL mode: 8.0 includes these modes: ONLY_FULL �→ _GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE, �→ ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION. • Default value of lower_case_table_names: • The

configure the optimal parameters of the operating system · · 631 5.2.7 Manually configure the SSH mutual trust and sudo without password · 638 5.2.8 Install the numactl tool · · · · · · · · · · · · · · · · · mode includes these modes: ONLY_FULL_GROUP_BY,STRICT_ �→ TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ �→ ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION. • MySQL’s default SQL mode: 8.0 includes these modes: ONLY_FULL �→ _GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE, �→ ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION. • Default value of lower_case_table_names: • The

configure the optimal parameters of the operating system · · 650 5.2.7 Manually configure the SSH mutual trust and sudo without password · 656 5.2.8 Install the numactl tool · · · · · · · · · · · · · · · · · @lance6716 • Fix the issue that TiDB Lightning fails to correctly parse date values containing 0 when NO_ZERO_IN_DATE is not included in sql_mode #50757 @GMHDBJD 2.2.6 Contributors We would like to thank the mode includes these modes: ONLY_FULL_GROUP_BY,STRICT_ �→ TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ �→ ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION. • MySQL’s default SQL mode:

configure the optimal parameters of the operating system · · 622 5.2.7 Manually configure the SSH mutual trust and sudo without password · 628 5.2.8 Install the numactl tool · · · · · · · · · · · · · · · · · mode includes these modes: ONLY_FULL_GROUP_BY,STRICT_ �→ TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ �→ ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION. • MySQL’s default SQL mode: 8.0 includes these modes: ONLY_FULL �→ _GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE, �→ ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION. • Default value of lower_case_table_names: • The