Layer 7 API Management

Expand all | Collapse all

How to stop removing record in service_metrics table.

Jump to Best Answer
  • 1.  How to stop removing record in service_metrics table.

    Posted 05-20-2019 09:48 AM

    Hi,

    for our customer who request to show number of hits I need to collect data grouping by APIkey and month. Now I can see only data for last year, but i need to show data for last few years, all data at the best. I found settings in:

     

    /opt/SecureSpan/Gateway/node/default/etc/conf/system.properties

     

    #com.l7tech.service.metrics.enabled=true
    #com.l7tech.service.metrics.maxFineAge=3600000
    #com.l7tech.service.metrics.maxHourlyAge=604800000
    #com.l7tech.service.metrics.maxDailyAge=31536000000

     

    and I (even remove #) cut the time of values that might remove some rows from service_metrics table, but after runnig 

    /opt/SecureSpan/ApiPortal/portal.sh

    nothing changed.

    Can you help me how to setup Gateway (9.3 CR4) and Portal 3.5 so, that I will enable to list all hits for gateway lifetime? I understand, if deleted records wasnt able to restore, but at least I need to stop removing any historical data even for years.

     

    Many thanks,

    Dusan



  • 2.  Re: How to stop removing record in service_metrics table.
    Best Answer

    Posted 05-20-2019 07:35 PM

    Dear Dusan,

    By default, the gateway should not just remove the metrics data, but merge them to lower resolution.

    It's better to open a support ticket to check the data in gateway and portal.

     

    Regards,

    Mark



  • 3.  Re: How to stop removing record in service_metrics table.

    Posted 05-21-2019 04:27 AM

    Dear Mark,

     

    Thank you for your explanantion, it's sounds sensible and I understand.

     

    Regards,

    Dusan