Limit Database Size

Is it possible to limit database size? Suppose I want to allot 25 MB for database size so that older entries will be deleted automatically to save server space or do I have to delete the database and create a new one every few months.

You will have to manually delete the database when needed.

You can safely delete all archives tables and your DB will shrink if you dont go back to see stats of previous months.

Also deleting (or better yet emptying) the logs tables (there’s 3 of them), will erase all stats.

By the way, the feature of asking Piwik to keep only X months of stats is already on the road map.

See our new page, which lists the various limits on historical data, number of websites, users, database size, when using Piwik: Data Limits Analytics