How do I purge Piwik logs?
You can configure Piwik to automatically delete your older logs from the database. Deleting old logs has many advantages: 1) free significant database space, 2) which will bring slightly better performance, 3) It can be recommended for Privacy reasons to keep detailed logs for 6 months or so. To configure Log delete in Piwik, login as the Super User, click on Settings > Privacy > Delete old visitor logs from database. You can then configure to Delete logs older than N days, and execute the log purging every day, every week or every month. Important: When you enable automatic log deletion, you must ensure that all previous daily reports have been processed, so that no data is lost. See this FAQ for more information.