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

Missing documentation of deletelogs->delete_logs_unused_actions_schedule_lowest_interval #15484

Closed
toredash opened this issue Jan 29, 2020 · 3 comments
Closed

Missing documentation of deletelogs->delete_logs_unused_actions_schedule_lowest_interval #15484

toredash opened this issue Jan 29, 2020 · 3 comments
Labels
c: Documentation For issues related to in-app product help messages, or to the Matomo knowledge base. not-in-changelog For issues or pull requests that should not be included in our release changelog on matomo.org.

Comments

@toredash
Copy link
Contributor

toredash commented Jan 29, 2020 •
edited

Hi,

I'm unable to find any documentation on this config option:
delete_logs_unused_actions_schedule_lowest_interval

Feature was introduced in #13822

I've checked the forums and global.ini.php for help but there is no docs on its usage:

matomo/config/global.ini.php

Lines 910 to 921 in 162513d

[Deletelogs]
; delete_logs_enable - enable (1) or disable (0) delete log feature. Make sure that all archives for the given period have been processed (setup a cronjob!),
; otherwise you may lose tracking data.
; delete_logs_schedule_lowest_interval - lowest possible interval between two table deletes (in days, 1|7|30). Default: 7.
; delete_logs_older_than - delete data older than XX (days). Default: 180
delete_logs_enable = 0
delete_logs_schedule_lowest_interval = 7
delete_logs_older_than = 180
delete_logs_max_rows_per_query = 100000
enable_auto_database_size_estimate = 1
enable_database_size_estimate = 1
delete_logs_unused_actions_schedule_lowest_interval = 30

Reading from the code, I get that it is related to how often one should purge data in table log_action.

I've made a PR to add some docs to this, #15492, but also to add a user-definable value for how many rows to analyze in one iterations. Our log_action table contains >100M rows, so pruning data takes a while.
@tsteur tsteur added the c: Documentation For issues related to in-app product help messages, or to the Matomo knowledge base. label Jan 29, 2020
@tsteur
Copy link
Member

tsteur commented Jan 29, 2020

It's basically how much time is in between matomo tries to delete unused actions again

@toredash
Copy link
Contributor Author

Created a new PR for 4-x.dev branch. Original post updated.

Good to get a verification on the intended usage for the variable.

@toredash toredash mentioned this issue Jan 31, 2020
Merged
@toredash
Copy link
Contributor Author

toredash commented Feb 5, 2020

closed by #15492

@toredash toredash closed this as completed Feb 5, 2020
@mattab mattab added the not-in-changelog For issues or pull requests that should not be included in our release changelog on matomo.org. label Feb 10, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
c: Documentation For issues related to in-app product help messages, or to the Matomo knowledge base. not-in-changelog For issues or pull requests that should not be included in our release changelog on matomo.org.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@tsteur @toredash @mattab