query containing a correlated subquery and CTE #55551 @guo-shaoge • Fix the issue that disabling lite-init-stats might cause statistics to fail to load synchronously #54532 @hawkingrei 87 • Fix the issue `migrations`(`timestamp`, `name`) VALUES (?, ?) �→ -- PARAMETERS: [1693814724825,"Init1693814724825"] Migration Init1693814724825 has been executed successfully. query: COMMIT Migration files are generated initialization script init.sql and save it, you can execute the following statement to initialize the database. 375 mysql -u root \ -h {host} \ -P {port} \ -p {password} \ < init.sql To view all tables

query containing a correlated subquery and CTE #55551 @guo-shaoge • Fix the issue that disabling lite-init-stats might cause statistics to fail to load synchronously #54532 @hawkingrei 82 • Fix the issue `migrations`(`timestamp`, `name`) VALUES (?, ?) �→ -- PARAMETERS: [1693814724825,"Init1693814724825"] Migration Init1693814724825 has been executed successfully. query: COMMIT Migration files are generated initialization script init.sql and save it, you can execute the following statement to initialize the database. 370 mysql -u root \ -h {host} \ -P {port} \ -p {password} \ < init.sql To view all tables

with many tables or partitions, this process can take a long time. When the configuration item force-init-stats is set to ON, TiDB does not provide services until the initial statistics are loaded. In this `migrations`(`timestamp`, `name`) VALUES (?, ?) �→ -- PARAMETERS: [1693814724825,"Init1693814724825"] Migration Init1693814724825 has been executed successfully. query: COMMIT Migration files are generated initialization script init.sql and save it, you can execute the following statement to initialize the database. 348 mysql -u root \ -h {host} \ -P {port} \ -p {password} \ < init.sql To view all tables

Configuration file Configuration parame- ter Change type Description TiDB concurrently �→ - �→ init �→ - �→ stats �→ Newly added Controls whether to initialize statistics concur- rently during TiDB `migrations`(`timestamp`, `name`) VALUES (?, ?) �→ -- PARAMETERS: [1693814724825,"Init1693814724825"] Migration Init1693814724825 has been executed successfully. query: COMMIT Migration files are generated initialization script init.sql and save it, you can execute the following statement to initialize the database. 345 mysql -u root \ -h {host} \ -P {port} \ -p {password} \ < init.sql To view all tables

reduces the impact on the overall service when TiDB nodes restart. You can set the parameter lite-init-stats to true to enable this feature. During TiDB startup, SQL statements executed before the initial issues. To avoid such issues, TiDB v7.1.0 introduces the �→ configuration parameter [`force-init-stats`](#force-init-stats-new-in �→ -v657-and-v710). With this option, you can control whether TiDB �→ provides author- ity file for Start- TLS connec- tions in LDAP SASL authen- tica- tion. authentication_ldap_sasl_init_pool_size �→ Newly added Specifies the initial connec- tions in the connec- tion pool to the LDAP

`migrations`(`timestamp`, `name`) VALUES (?, ?) �→ -- PARAMETERS: [1693814724825,"Init1693814724825"] Migration Init1693814724825 has been executed successfully. query: COMMIT Migration files are generated initialization script init.sql and save it, you can execute the following statement to initialize the database. 345 mysql -u root \ -h {host} \ -P {port} \ -p {password} \ < init.sql To view all tables After that, you will see a page similar to the following: Figure 63: playground gitpod workspace init This scenario in the page uses TiUP to build a TiDB Playground. You can check the progress on the

Configuration file Configuration parame- ter Change type Description TiDB concurrently �→ - �→ init �→ - �→ stats �→ Newly added Controls whether to initialize statistics concur- rently during TiDB `migrations`(`timestamp`, `name`) VALUES (?, ?) �→ -- PARAMETERS: [1693814724825,"Init1693814724825"] Migration Init1693814724825 has been executed successfully. query: COMMIT Migration files are generated database initialization script init.sql and save it, you can execute the following statement to initialize the database. mysql -u root \ -h {host} \ -P {port} \ -p {password} \ < init.sql To view all tables

embedding multi-value indexes and OR operators in AND predicates #51778 @time-and-fate • When force-init-stats is set to true, TiDB waits for statistics initialization to finish before providing services #43527 @hi-rustin • Fix the issue that TiDB does not listen to the corresponding port when force- �→ init-stats is configured #51473 @hawkingrei • Fix the issue that in determinate mode (tidb_opt_objective='determinate' contain predicates, statistics might not be loaded #48257 @time-and-fate • Fix the issue that the init-stats process might cause TiDB to panic and the 80 load stats process to quit #51581 @hawkingrei

`migrations`(`timestamp`, `name`) VALUES (?, ?) �→ -- PARAMETERS: [1693814724825,"Init1693814724825"] Migration Init1693814724825 has been executed successfully. query: COMMIT Migration files are generated database initialization script init.sql and save it, you can execute the following statement to initialize the database. mysql -u root \ -h {host} \ -P {port} \ -p {password} \ < init.sql To view all tables After that, you will see a page similar to the following: Figure 63: playground gitpod workspace init This scenario in the page uses TiUP to build a TiDB Playground. You can check the progress on the

`migrations`(`timestamp`, `name`) VALUES (?, ?) �→ -- PARAMETERS: [1693814724825,"Init1693814724825"] 233 Migration Init1693814724825 has been executed successfully. query: COMMIT Migration files are database initialization script init.sql and save it, you can execute the following statement to initialize the database. mysql -u root \ -h {host} \ -P {port} \ -p {password} \ < init.sql To view all tables After that, you will see a page similar to the following: 558 Figure 63: playground gitpod workspace init This scenario in the page uses TiUP to build a TiDB Playground. You can check the progress on the