How can I get the status of a data re-balance?
Re-balancing data can take a long time. Is there a way to check on its progress?
I am running the operation from Vertica Admin Tools under Cluster Management.
I am running the operation from Vertica Admin Tools under Cluster Management.
0
Comments
You can check the progress status from the system tables rebalance_projection_status and rebalance_table_status.
/Sajan
If the script only includes drop projection statements, the rebalance tables may not have anything.
/Sajan
If its about Rebalancing, you can try these tables to get the status
To take a look at already rebalanced projections To take a look , if projections refresh for a particular projections has started check this table And to check the status of rebalance on your cluster Hope this helps
Rebalance generate extreme I/O activity , which can be view on Level of OS , you shoud see high change of the filesystem utilization during this process ,which you don't see on normal ongoing activity .
Sometime re-balance get stuck and wont show you in system table. Check On tuple mover operation, it will show you what phase it is operating, it is Recreating ros or not. Also I/o and CPU usage will increase .