Add multiple indexes in one pass table scan
Closed this issue · 2 comments
rockeet commented
MyRocks inplace_populate_sk()
scan table one pass for each index, this waste CPUs, but this waste is not a hot spot because MyRocks MergeTree is very slow -- thus MergeTree is the hot spot.
MyTopling has auto_sort_sst
, which is very fast, especially for building indexes, thus the wasted table scans are hot spot.
So creating multiple indexes shoule be realized by just one pass table scan, at least for non-unique index.
rockeet commented
rockeet commented
This feature had been submited to MyRocks earlier: facebook/mysql-5.6#1376