Standards (FIPS) #47948 @tiancaiamao • Optimize the TiDB implementation when handling some type conversions and fix related issues #47945 #47864 #47829 #47816 @YangKeao @lcwangchao • When obtaining the tics E E E E E N N N N N N 77 Statistics 7.6 7.5 7.1 6.5 6.1 6.0 5.4 5.3 5.2 5.1 5.0 Randomly sam- ple about 10000 rows of data to quickly build statis- tics Deprecated Deprecated E E E E E E E E 18 or later. • Git. • A TiDB cluster. • An AWS user with administrator permissions. • AWS CLI • AWS SAM CLI If you don’t have a TiDB cluster, you can create one as follows: • (Recommended) Follow Creating

Variable name Change type Description tidb_build_sampling_stats_concurrency �→ Newly added Controls the sam- pling concur- rency of the ANALYZE �→ pro- cess. tidb_enable_async_merge_global_stats �→ Newly added N N N N Control the mem- ory quota for col- lect- ing statis- tics E E E E N N N N N N Randomly sam- ple about 10000 rows of data to quickly build statis- tics Deprecated E E E E E E E E E Lock statis- later. • Git. • A TiDB cluster. • An AWS user with administrator permissions. • AWS CLI 230 • AWS SAM CLI If you don’t have a TiDB cluster, you can create one as follows: • (Recommended) Follow Creating

later. • Git. • A TiDB cluster. • An AWS user with administrator permissions. • AWS CLI 249 • AWS SAM CLI If you don’t have a TiDB cluster, you can create one as follows: • (Recommended) Follow Creating and check the result 1. (Prerequisite) Install the AWS SAM CLI. 2. Build the bundle: npm run build 3. Invoke the sample Lambda function: sam local invoke --env-vars env.json -e events/event.json " deploy the AWS Lambda Function using either the SAM CLI or the AWS Lambda console. SAM CLI deployment (Recommended) 1. (Prerequisite) Install the AWS SAM CLI. 2. Build the bundle: npm run build 3. Update

ing statis- tics E E E N N N N N N 91 Statistics 7.1 6.5 6.1 6.0 5.4 5.3 5.2 5.1 5.0 Randomly sam- ple about 10000 rows of data to quickly build statis- tics E E E E E E E E E Lock statis- tics later. • Git. • A TiDB cluster. • An AWS user with administrator permissions. • AWS CLI 250 • AWS SAM CLI If you don’t have a TiDB cluster, you can create one as follows: • (Recommended) Follow Creating and check the result 1. (Prerequisite) Install the AWS SAM CLI. 2. Build the bundle: npm run build 3. Invoke the sample Lambda function: sam local invoke --env-vars env.json -e events/event.json "

N N Control the mem- ory quota for col- lect- ing statis- tics E E E E E N N N N N N N Randomly sam- ple about 10000 rows of data to quickly build statis- tics Deprecated Deprecated Deprecated E E E later. • Git. • A TiDB cluster. • An AWS user with administrator permissions. • AWS CLI 258 • AWS SAM CLI If you don’t have a TiDB cluster, you can create one as follows: • (Recommended) Follow Creating and check the result 1. (Prerequisite) Install the AWS SAM CLI. 2. Build the bundle: npm run build 3. Invoke the sample Lambda function: sam local invoke --env-vars env.json -e events/event.json "

E E N N N Control the mem- ory quota for col- lect- ing statis- tics E E E E N N N N N Randomly sam- ple about 10000 rows of data to quickly build statis- tics DeprecatedDeprecatedE E E E E E E Lock later. • Git. • A TiDB cluster. • An AWS user with administrator permissions. • AWS CLI 229 • AWS SAM CLI If you don’t have a TiDB cluster, you can create one as follows: • (Recommended) Follow Creating and check the result 1. (Prerequisite) Install the AWS SAM CLI. 2. Build the bundle: npm run build 3. Invoke the sample Lambda function: sam local invoke --env-vars env.json -e events/event.json "

E E E E E E E E N N N N 96 Statistics8.4 8.3 8.2 8.1 7.5 7.1 6.5 6.1 5.4 5.3 5.2 5.1 Randomly sam- ple about 10000 rows of data to quickly build statis- tics Deprecated Deprecated Deprecated Deprecated later. • Git. • A TiDB cluster. • An AWS user with administrator permissions. • AWS CLI 265 • AWS SAM CLI If you don’t have a TiDB cluster, you can create one as follows: • (Recommended) Follow Creating and check the result 1. (Prerequisite) Install the AWS SAM CLI. 2. Build the bundle: npm run build 3. Invoke the sample Lambda function: sam local invoke --env-vars env.json -e events/event.json "

E N N N Control the mem- ory quota for col- lect- ing statis- tics E E E E E N N N N N Randomly sam- ple about 10000 rows of data to quickly build statis- tics Deprecated Deprecated Deprecated E E E later. • Git. • A TiDB cluster. • An AWS user with administrator permissions. • AWS CLI 235 • AWS SAM CLI If you don’t have a TiDB cluster, you can create one as follows: • (Recommended) Follow Creating and check the result 1. (Prerequisite) Install the AWS SAM CLI. 2. Build the bundle: npm run build 3. Invoke the sample Lambda function: sam local invoke --env-vars env.json -e events/event.json "

N N N Control the mem- ory quota for col- lect- ing statis- tics E E E E E E N N N N N Randomly sam- ple about 10000 rows of data to quickly build statis- tics Deprecated Deprecated Deprecated Deprecated later. • Git. • A TiDB cluster. • An AWS user with administrator permissions. • AWS CLI 238 • AWS SAM CLI If you don’t have a TiDB cluster, you can create one as follows: • (Recommended) Follow Creating and check the result 1. (Prerequisite) Install the AWS SAM CLI. 2. Build the bundle: npm run build 3. Invoke the sample Lambda function: sam local invoke --env-vars env.json -e events/event.json "

E E E E E E E E N N N N 91 Statistics8.4 8.3 8.2 8.1 7.5 7.1 6.5 6.1 5.4 5.3 5.2 5.1 Randomly sam- ple about 10000 rows of data to quickly build statis- tics Deprecated Deprecated Deprecated Deprecated later. • Git. • A TiDB cluster. • An AWS user with administrator permissions. • AWS CLI 260 • AWS SAM CLI If you don’t have a TiDB cluster, you can create one as follows: • (Recommended) Follow Creating and check the result 1. (Prerequisite) Install the AWS SAM CLI. 2. Build the bundle: npm run build 3. Invoke the sample Lambda function: sam local invoke --env-vars env.json -e events/event.json "