View Tuple Mover Operation Run-time Intervals
Jim_Knicely
- Select Field - Administrator
Vertica’s Tuple Mover manages WOS and ROS data storage. To do that it performs two operations:
- Moveout: Moves data from WOS to ROS.
- Mergeout: Combines small ROS containers into larger ones and purges deleted data.
The Tuple Mover operations are controlled by a set of configurable parameters. To quickly view the relevant parameter’s current values, you can call the LIST_SERVICES function.
Example:
dbadmin=> \a
Output format is unaligned.
dbadmin=> select list_services('TM');
list_services
Service: 'AnalyzeRowCount' is enabled , interval 86400 second(s)
Service: 'LGELaggingCheck' is enabled , interval 300 second(s)
Service: 'ManageEpochs' is enabled , interval 180 second(s)
Service: 'PartitionTables' is disabled , interval 3000 second(s)
Service: 'RebalanceCluster' is enabled , interval 300 second(s)
Service: 'TM Moveout' is enabled , interval 300 second(s)
Service: 'TM Mergeout' is enabled , sub-services:
Service: 'TM Mergeout(00)' is enabled , interval 600 second(s)
Service: 'TM Mergeout(01)' is enabled , interval 600 second(s)
(1 row)
From the output above, we see that the Moveout operation occurs every 300 seconds and Mergeout operation occurs every 600 seconds.
Helpful Links:
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/Glossary/TupleMover.htm
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/AdministratorsGuide/ConfiguringTheDB/TupleMoverParameters.htm
Have fun!
0