diff options
author | Tore <tore.lonoy@gmail.com> | 2020-02-04 23:10:33 +0300 |
---|---|---|
committer | GitHub <noreply@github.com> | 2020-02-04 23:10:33 +0300 |
commit | c71f6e21820975e6ee9aee22398512772f4c4ceb (patch) | |
tree | 42f791be938a7271622b48b44540e8017ef457c6 /config | |
parent | 1c87257325477edc2a59d1d60ab1839e9a3866de (diff) |
fix: enable user-defined value for insertIntoTempIterationStep (#15492)
Diffstat (limited to 'config')
-rwxr-xr-x | config/global.ini.php | 7 |
1 files changed, 6 insertions, 1 deletions
diff --git a/config/global.ini.php b/config/global.ini.php index 38538c7c4d..138bfbedbc 100755 --- a/config/global.ini.php +++ b/config/global.ini.php @@ -910,12 +910,17 @@ enable_sql_profiler = 0 [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_schedule_lowest_interval - lowest possible interval between two table deletes, for tables named log_* (in days, 1|7|30). Default: 7. ; delete_logs_older_than - delete data older than XX (days). Default: 180 +; delete_logs_unused_actions_schedule_lowest_interval - lowest possible interval between two table deletes, for table log_action (in days, 1|7|30). Default: 30. +; delete_logs_max_rows_per_query and delete_logs_unused_actions_max_rows_per_query can be increased for large sites to speed up delete processes +; +; The higher value one assign to *_schedule_lowest_interval, the longer the data pruning/deletion will take. This is caused by the fact there is more data to evaluate and process every month, than every week. delete_logs_enable = 0 delete_logs_schedule_lowest_interval = 7 delete_logs_older_than = 180 delete_logs_max_rows_per_query = 100000 +delete_logs_unused_actions_max_rows_per_query = 100000 enable_auto_database_size_estimate = 1 enable_database_size_estimate = 1 delete_logs_unused_actions_schedule_lowest_interval = 30 |