Skip to main content

io_usage history is much shorter then network usage

  • March 13, 2014
  • 2 replies
  • 8 views
K_Krutiy
Forum|alt.badge.img
I am trying to analyze resource usage on my system

I am looking at

io_usage
network_usage
cpu_usage
etc


I was surprised to find out that io_usage history is much shorter then network usage

I can get only 299 records from io_usage.
With each record covers 1 minute my history for IO is only 299 minutes

From network_usage I can get 5365 records.
So I have as much as 20x longer history for NETWORK.


Is it possible to increase retention for io_usage to several days ?



    2 replies

    Abhishek_Rana
    Forum|alt.badge.img
    • Abhishek_Rana
    • Participating Frequently
    • March 13, 2014
    Hi,

    io_usage is not a data collector table, so information in it will keep on flushing . To get information for history of io_usage, you can refer to dc_io_info data collector table .

    Regards'

    Abhishek
    Prasanta_Pal
    Forum|alt.badge.img
    • Prasanta_Pal
    • Participating Frequently
    • March 15, 2014
    Check out this link about datacollector table and data retention policies

    https://my.vertica.com/docs/7.0.x/HTML/index.htm#Authoring/SQLReferenceManual/SystemTables/MONITOR/DATA_COLLECTOR.htm%3FTocPath%3DSQL%20Reference%20Manual|HP%20Vertica%20System%20Tables|V_MONITOR%20Schema|_____9

    and
    https://my.vertica.com/docs/7.0.x/HTML/index.htm#Attic/Troubleshooting/ConfiguringDataRetentionPolic...



    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement