Feature #25343
closedScheduler task to delete old rows from database tables
100%
Description
Often customer databases are filled up with lots of syslog entries. Those entries are useful but in most cases having the logs for the X past weeks/months would be sufficient.
Provide a scheduler task to remove older entries regularly.
(issue imported from #M17970)
Updated by Francois Suter over 13 years ago
Several tasks have been opened to clear various tables (cache, etc.). Why not trying to make it more general. I wrote an extension called "cachecleaner" which is designed to clean up arbitrary tables. It works as part of the CLI lowlevel cleaner for now, but could be adapted into a Scheduler task (I've been meaning to do that for a long time, actually).
http://typo3.org/extensions/repository/view/cachecleaner/current/
Updated by Mr. Hudson over 13 years ago
Patch set 1 of change Id7c58d28e4f6e82a708513a3ce9761baf36c06cd has been pushed to the review server.
It is available at http://review.typo3.org/1376
Updated by Christian Kuhn over 13 years ago
Pushed a patch for EXT:scheduler implementing the garbage collection as a scheduler task. The task deletes all database entries in sys_log table older than n days, which can be set by an additinonal field.
Updated by Mr. Hudson over 13 years ago
Patch set 2 of change Id7c58d28e4f6e82a708513a3ce9761baf36c06cd has been pushed to the review server.
It is available at http://review.typo3.org/1376
Updated by Mr. Hudson over 13 years ago
Patch set 3 of change Id7c58d28e4f6e82a708513a3ce9761baf36c06cd has been pushed to the review server.
It is available at http://review.typo3.org/1376
Updated by Christian Kuhn over 13 years ago
- Subject changed from Create scheduler task for removing old syslog entries to Scheduler task to garbage database tables
Updated by Christian Kuhn over 13 years ago
- Subject changed from Scheduler task to garbage database tables to Scheduler task to delete old rows from database tables
Updated by Mr. Hudson over 13 years ago
Patch set 4 of change Id7c58d28e4f6e82a708513a3ce9761baf36c06cd has been pushed to the review server.
It is available at http://review.typo3.org/1376
Updated by Christian Kuhn over 13 years ago
Patch set 4 is a revised version that handles more than just the sys_log table:
To prevent administrators from committing hazard to the database, tables that can be cleaned up must be registered in an own 'option' array (which extensions can add entries to). There a specific table and a time stamp field must be defined, the table will then be selectable in the task as additional field.
Per task only one table can be selected, there is no multi-select-option to simplify the logic a bit if configured tables 'vanish' from configuration if extensions are un-installed or configured otherwise (the according task will then throw an exception).
For the core tables: Currently only sys_log is configured as default table to be chosen. The following tables are candidates to be added to the configuration: sys_history, be_sessions, fe_sessions, fe_session_data. All of them already have some weird internal garbage collection implemented in the core, so that they are already garbage collected during fe/be calls sometimes. This could be cleaned up in an additional patch, which should add a registry handling to the garbage collection task that logs its last execution and only calls the currently built in core garbage collection if our new task did not run for a long time. Since there is no handling for this currently, I've not added those tables to the task, yet.
Updated by Mr. Hudson over 13 years ago
Patch set 5 of change Id7c58d28e4f6e82a708513a3ce9761baf36c06cd has been pushed to the review server.
It is available at http://review.typo3.org/1376
Updated by Mr. Hudson over 13 years ago
Patch set 6 of change Id7c58d28e4f6e82a708513a3ce9761baf36c06cd has been pushed to the review server.
It is available at http://review.typo3.org/1376
Updated by Mr. Hudson over 13 years ago
Patch set 7 of change Id7c58d28e4f6e82a708513a3ce9761baf36c06cd has been pushed to the review server.
It is available at http://review.typo3.org/1376
Updated by Mr. Hudson over 13 years ago
Patch set 8 of change Id7c58d28e4f6e82a708513a3ce9761baf36c06cd has been pushed to the review server.
It is available at http://review.typo3.org/1376
Updated by Mr. Hudson over 13 years ago
Patch set 9 of change Id7c58d28e4f6e82a708513a3ce9761baf36c06cd has been pushed to the review server.
It is available at http://review.typo3.org/1376
Updated by Christian Kuhn over 13 years ago
- Status changed from New to Resolved
- % Done changed from 0 to 100
Applied in changeset d8bdda72d4b68483ca4b8502f519419c2043235c.
Updated by Steffen Gebert over 13 years ago
- Target version changed from 4.6.0-beta1 to 1281
Updated by Steffen Gebert over 13 years ago
- TYPO3 Version changed from 4.5 to 4.6
Updated by Xavier Perseguers over 12 years ago
- Status changed from Resolved to Closed