Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Plugin DatabaseCleaner #3916

Closed
anonymous-matomo-user opened this issue Apr 26, 2013 · 3 comments
Closed

Plugin DatabaseCleaner #3916

anonymous-matomo-user opened this issue Apr 26, 2013 · 3 comments
Labels
Enhancement For new feature suggestions that enhance Matomo's capabilities or add a new report, new API etc. worksforme The issue cannot be reproduced and things work as intended.

Comments

@anonymous-matomo-user
Copy link

Plugin DatabaseCleaner

If you want to delete an obsolete website from your Piwik-installation or you want to drop already processed log_* entries from your database - but you also want to archive those data for later usage - this plugin does the job ;-)

Features

  • extract "old" and already processed raw-log entries (stored in the log_*-tables) to the filesystem
  • archive and delete a selected WebSite
  • create mysqldump-scripts
  • easy GUI frontend to execute the maintenance tasks
  • backup parts of your piwik database online without the need of phpmyadmin et. al.

Download

Latest version is available from online repository:
http://plugin.suenkel.org/plugin/detail/DatabaseCleaner

Screenshots

[[Image(http://plugin.suenkel.org/pic/w/2013/04/dbcIndex-300x147.png)]]
[[Image(http://plugin.suenkel.org/pic/w/2013/04/dbcWebsite-300x141.png)]]
[[Image(http://plugin.suenkel.org/pic/w/2013/04/dbcCleanup-300x162.png)]]
[[Image(http://plugin.suenkel.org/pic/g/2013/04/dbcFiles-300x153.png)]]
[[Image(http://plugin.suenkel.org/pic/g/2013/04/dbcPreferences-300x131.png)]]
Keywords: mysql, third-party-plugin
@anonymous-matomo-user
Copy link
Author

there is a new version available

  • upgrade to Piwik 1.12.0
  • automatically adjusting runtime settings (exec time/memory usage) with profiling
  • minor bugfixes

http://plugin.suenkel.org/plugin/detail/DatabaseCleaner

@anonymous-matomo-user
Copy link
Author

there is a new version available for Piwik Version 2

http://plugin.suenkel.org/plugin/detail?name=DBCleaner

@mattab
Copy link
Member

mattab commented Feb 6, 2014

Maybe you have some ideas to improve our existing Db cleanup tools ?

In general we are thinking of ways to handle past datas, but I don't think dumping to disk is preferred solution. Maybe dumping to "archive tables" instead? this way the data could be still used by mysql. Anyway, that's interesting to think of ways to make Piwik more reliable and easier to manage database.

This was referenced Apr 23, 2022
Open
Open
This issue was closed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
Enhancement For new feature suggestions that enhance Matomo's capabilities or add a new report, new API etc. worksforme The issue cannot be reproduced and things work as intended.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@mattab @anonymous-matomo-user