Bug #108171 innodb_ddl_threads not effective Submitted: 17 Aug 2022 18:06Modified: 18 Aug 2022 11:38 Reporter: xincheng xie Email Updates: Status: Unsupported Impact on me: None Category: MySQL ServerSeverity: S2 (Serious) Version: 8.0.27OS: Linux Assigned to: CPU Architecture: x86...
SQL SET innodb_ddl_threads = 8; SQL SET innodb_parallel_read_threads = 8; SQL SET innodb_ddl_buffer_size = 1048576000; SQL alter table booking add index idx_2(flight_id, seat, passenger_id); Query OK, 0 rows affected (3 min 9.1862 sec) Wow ! This is a nice improvement ! This ...