mysql-5.6
mysql-5.6 copied to clipboard
Feature Request: Create Index in Parallel
inplace_populate_sk scans tables, if a table is too large, this consumes too much time.
The table can be divided into multiple parts, one thread per-part, to speed up the scaning. Now RocksDB has ApproximateKeyAnchors, it can be used in the partition phase to sampling keys for partition bounds.
I'm not familiar with MyRocks to implement this feature.
I noticed InnoDB has option innodb_ddl_threads for this purpose, it is straight forward to implement this feature in myrocks.
Is there any progress?
This feature has been in our TODO list and may have some updates in H2.