'How to monitor OPTIMIZE process?
Adding a materialized column
ALTER TABLE actions ADD COLUMN `total` UInt64 MATERIALIZED price1 + price2
Requires running OPTIMIZE on table
OPTIMIZE TABLE actions FINAL
OPTIMIZE is a slow process, how can I monitor this process?
Solution 1:[1]
select * from system.merges where table = 'actions'
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | freemanoid |