TYPO free

home

fighting for TYPO free code

Table Cleaner extension released

15 Mar 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 and a lot of content is added and removed. This means that some tables will 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 a scheduler task for 'truncating' ever growing tables and a task for actually removing deleted records from tables.

In the scheduler you will find two new tasks:

  • Table Cleaner (tablecleaner)
  • Table Truncater (tabletruncater)

Table Cleaner

In the 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.

If you wish to set different retentions for different tables, you can create multiple scheduler tasks and then specify a different retention time for each task.

Table Truncater

In the table truncater task, you can select one or more tables for truncating. You can specify a number of days after which to remove the records from the table. The default is 31 days. It does not actually truncate the tables unless of course you set the days value to 0. 

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