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