I’m sorry to ask this as it might be obvious for an experienced user but how and where do I run the following the code to purge my
logs? It is not mentioned on the FAQ page. Thank you!
DELETE piwik_log_visit, piwik_log_link_visit_action FROM piwik_log_visit INNER JOIN piwik_log_link_visit_action WHERE piwik_log_visit.idvisit = piwik_log_link_visit_action.idvisit AND visit_server_date <= CURRENT_DATE() - 30