clearing records in action_history_record table

Collapse
X
 
  • Time
  • Show
Clear All
new posts

  • livewire
    replied
    Thank you

    Leave a comment:


  • item
    replied
    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

    Leave a comment:


  • livewire
    started a topic clearing records in action_history_record table

    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?
Working...