Forum Discussion

cjunior_138458's avatar
cjunior_138458
Icon for Altostratus rankAltostratus
Jun 03, 2016

AVR - Collecting statistics

Hi, I'd planned to collect statistics for a month a certain traffic and apparently the AVR is synthesising that data.

 

I need that statistics to be daily plotted in the graph.

 

So, does Big-IP have data stored detailed or AVR process don't keep that data and it means that I don't have the detailed data anymore?

 

Is there any way to try this from mySQL database? I had no luck.

 

Thank you.

 

application delivery
LTM
  • MaCrek_56686's avatar
    MaCrek_56686
    Jun 17, 2016

    Did you try to show your data by tmsh commands ?

    examle:

    show /analytics report view-by country range now--now-30m

    Another devcentral question should answer your question about storage limitations: AVR historical data 
    By design, external data is a requirement for the granularity. Internal data collection is limited to allow for storage and performance limitations. For this reason, AVR aggregates data according to the following:

First 2 hours it keeps data aggregated every 5 minutes
After 8 hours it keeps data aggregated every 1 hours (60 minutes)
After 2 days it keeps data aggregated every 4 hours (240 minutes)
After 2 weeks it keeps data aggregated every 24 hours
After 2 months it keeps data aggregated every 1 week
After 1 year it keeps data aggregated every 4 weeks


Other internal limits are;
chart capacity is limited to 1 year
Captured transaction data is limited to 1000 records and although new records are being displayed in the gui, the old records must be cleared before the new records are stored.

Greetings!
Andreas
  • MaCrek_56686's avatar
    MaCrek_56686
    Icon for Altocumulus rankAltocumulus
    Jun 17, 2016

    Did you try to show your data by tmsh commands ?

    examle:

    show /analytics report view-by country range now--now-30m

    Another devcentral question should answer your question about storage limitations: AVR historical data 
    By design, external data is a requirement for the granularity. Internal data collection is limited to allow for storage and performance limitations. For this reason, AVR aggregates data according to the following:

First 2 hours it keeps data aggregated every 5 minutes
After 8 hours it keeps data aggregated every 1 hours (60 minutes)
After 2 days it keeps data aggregated every 4 hours (240 minutes)
After 2 weeks it keeps data aggregated every 24 hours
After 2 months it keeps data aggregated every 1 week
After 1 year it keeps data aggregated every 4 weeks


Other internal limits are;
chart capacity is limited to 1 year
Captured transaction data is limited to 1000 records and although new records are being displayed in the gui, the old records must be cleared before the new records are stored.

Greetings!
Andreas
    • cjunior's avatar
      cjunior
      Icon for Nacreous rankNacreous
      Jun 20, 2016
      Thank you for the informations. I realized this in a hard way. So, I made a query in AVR database and I retrieve detailed data for the last fifteen days and incomplete for the rest. Regards.