clearing records in action_history_record table

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • livewire
    Senior Member
    • Nov 2016
    • 100

    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?
  • item
    Active Community Member
    • Mar 2017
    • 1476

    #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
    If you could give the project a star on GitHub. EspoCrm believe our work truly deserves more recognition. Thanks.​

    Comment

    • livewire
      Senior Member
      • Nov 2016
      • 100

      #3
      Thank you

      Comment

      Working...