+1Hi there,
I have seen vertica 7.1 in my installation randomly in a node consuming all the space and then releasing it. I have managed to find a folder in teh data path that grows and then it shrinks again. the name of the folder is MgO_26239203.
Have you ever seen this?
I would appreciate any help on this
Vertica stores data in immutable ROS containers.
To keep performance in good shape you need to have low number of ROS containers.
Vertica regularly checks state of ROS containers and periodically merges multiple smaller ROS containers
into single larger ROS container. Those operations need to use space temporarily.
Similar things happen when you do PURGE, projection refresh or rebalance your cluster.
For those reasons Vertica recommends to have at least 50% of free space.
Also additional space will be needed when you do backups. Hard link backups will create links to all files.
This may consume extra space until the backup is removed.
So in general space fluctuations is expected and in most cases considered normal.
+1 K_Krutiy.
MgO_* folders are created temporarily for the TM mergeout process.
+1Thank you very much
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
