TYPO free

home

fighting for TYPO free code

Table cleaner extension 2.3.0 released

14 Nov 2013

When a record is deleted in TYPO3, most of the times it is not actually deleted. Many tables just set a value of 1 on the 'deleted' field. Some sites can get pretty big as a lot of content is added and removed. This means that some tables will slowly fill up with deleted records.

There are also tables that just keep on growing. Take sys_log for example. That logs system events from the time the system was first started to the present day. In some installations the sys_log also contains a lot of PHP error messages. I have seen sys_log tables of multiple GigaBytes in size.

This extension provides scheduler tasks for 'cleaning up' the ever growing tables. In the scheduler you will find three new tasks:

  • Remove deleted entries from the database older than N days
  • Remove (or mark as deleted) hidden entries from the database older than N days
  • Remove any entries from the database older than N days

In a table cleaner task, you can select one or more tables for cleaning. You can also specify a number of days after which to actually remove the deleted records from the table. The default is 31 days.

In a task, you can select one or more tables for cleaning. You can specify a number of days after which to remove the records from the table. The default is 31 days.

New in this version

For the cleaner task that removes hidden records older than N days, you can now optionally mark the hidden records as 'deleted' instead of removing them from the table. This will give editors and admins a certain 'grace period' if you will, in which editor can reclaim their lost (previously hidden) records from the recycler.

If you find any problems, please report them over at forge:

https://forge.typo3.org/projects/extension-tablecleaner/issues

add comment
Commenting is closed for this item