clearing records in action_history_record table
Collapse
X
-
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 situationLeave a comment:
-
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?Tags: None
Leave a comment: