Table log_link_visit_action is too big


#1

Hi everyone!
I can’t update matomo DB to latest release due to great amount of query running time. I see that total size of my atomo DB is abt 12.2 GiB. Table log_link_visit_action is 7.3 GiB, and log_visit is abt 4.6 GiB

My installation Matomo worked for 10 months on site with everyday pageviews abt 130000.
All reccomendation for huge loaded servers I’ve implemented.

Now I need to find a way how to decrease table size. Is somebody can help me please?