How to purge database


#1

Hello, I don’t really know why my Piwik database is so big (more than 50mb).
How can-I delete a part of it in order to keep it light?
Maybe my use of Piwik is not adapted. Can you tell me more?
Thank you.


#2

See Troubleshooting - Analytics Platform - Matomo


#3

Thank you, I already did it but my database is still 48mb large…


#4

After processing / archiving all your reports you could delete all piwik_archive_numeric_* and piwik_archive_blob_* tables. They will be recreated when running the archiving process again and should then be smaller in size.

You could also try to optimize all your Piwik tables manually. Use the MySQL OPTIMIZE TABLE function. See MySQL :: MySQL 5.5 Reference Manual :: 13.7.2.4 OPTIMIZE TABLE Syntax and 301 Moved Permanently.


#5

This is the answer I was looking for. Thank you n0v1.