I set up 3.5.1 in my server and collect data for almost 60k+ sites.
I also set
delete_logs_older_than to 35 days because we need monthly unique visitors.
But the database is still very big. It also effect query and backup.
So I need slim the database.
I fount that the biggest table is relationship table
log_link_visit_action. There are almost 750+ million records in this table. (35 days data)
Because the monthly unique visitors is only need monthly data of
log_visit, so can I just keep the 35 values for
log_visit table and setup another value (like 5 days) for others?