Service Virtualization

Expand all | Collapse all

DB Housekeeping

Jump to Best Answer
  • 1.  DB Housekeeping

    Posted 01-28-2020 11:45 AM
    Hi All,

    DevTest External DB gets piled up as soon as we start the broker. Can anyone suggest which of the following tables can be truncated ?

    12K ACL_AUDIT_LOG.frm
    16M ACL_AUDIT_LOG.ibd
    12K ACL_RESOURCE_GROUPS.frm
    112K ACL_RESOURCE_GROUPS.ibd
    12K ACL_RESOURCE_GROUPS_RESOURCES.frm
    112K ACL_RESOURCE_GROUPS_RESOURCES.ibd
    12K ACL_RESOURCE_GROUPS_ROLES.frm
    112K ACL_RESOURCE_GROUPS_ROLES.ibd
    12K HST_CYCLE_MESSAGE.frm
    2.9G HST_CYCLE_MESSAGE.ibd
    3.2G HST_EVENT_INFO.ibd
    17G HST_METRIC_VALUE.ibd
    12G HST_PROPERTY_INFO.ibd
    12K HST_STEP_MESSAGE.frm
    15M HST_STEP_MESSAGE.ibd
    3.9G HST_STEP_RUN.ibd
    12K HST_SUITE_MESSAGE.frm
    144K HST_SUITE_MESSAGE.ibd
    20K LISA_AGENT.frm
    464K LISA_AGENT.ibd
    12K LISA_AGENT_VERSION.frm
    96K LISA_AGENT_VERSION.ibd
    12K LISA_FRAME_CATEGORY.frm
    112K LISA_FRAME_CATEGORY.ibd
    12K LISA_FRAME_FLAGS.frm
    160K LISA_FRAME_FLAGS.ibd
    12K LISA_FRAME_TAGS.frm
    112K LISA_FRAME_TAGS.ibd
    43G LISA_TRANSACTION_INFO.ibd
    12K LISA_TRANSACTION_USAGE.frm
    62G LISA_TRANSACTION_USAGE.ibd
    4.0K V_HST_STEP_MESSAGE.frm
    4.0K V_LISA_AGENT.frm
    4.0K V_LISA_FRAME_CATEGORY.frm

    Regards,
    Akshay M


  • 2.  RE: DB Housekeeping
    Best Answer

    Posted 01-29-2020 07:07 AM
    Hi Akshay
               There are specific settings that control how long the data reside in these tables and on what frequency these need to be cleaned up automatically. As a first step, could you please review this page https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/continuous-testing/devtest-solutions/10-5/administering/database-administration/database-maintenance.html

    There are specific sections for different components.  Please check and confirm if these settings are intact. If the settings are fine, then we can move on to what could be dont about data that outlives the configuration.

    regards
    Sankar


    ------------------------------
    Sankar Natarajan
    Service Virtualization Product Engineering Team
    Broadcom
    ------------------------------