Announcement

Collapse
No announcement yet.

clearing records in action_history_record table

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • clearing records in action_history_record table

    Hi

    is it safe to delete records in "action_history_record​" ? currently im having about 100,000 leads and my action_history_record​ table alone has over 5 million records..

    im having a VPS with 4 cores and 8gb ram but the CPU load goes until 70 and the whole system stops working until i restart. MySQL usage goes up to 90% when there are only 5 users in the system

    so i deleted all of the unwanted leads from the system and im left with action_history_record​ table which has over 5 mil records.. maybe clearing that might help so want to know if its safe to empty it?

  • #2
    Hi,

    action_history_record is a table who log all action of user .. it's just like a "log who delete, update, create, read, entity record".
    for me, yes you can "truncate table action_history_record" in sql.
    and you can too check same for "scheduled_job_log..." (forget the name of table). These table log all scheduled job, failled, success, and so not really "important" in this situation

    Comment


    • #3
      Thank you

      Comment

      Working...
      X