[TYPO3] Limit changes history
Staffan Ericsson
staffan at zytor.com
Wed Nov 15 14:57:03 CET 2006
David Rennert skrev:
> Hi,
>
> I'm using typo 3.8.1.
>
> My sys_history is growing fast. It's now ~20MB and soon my webhosters
> will charge me extra for exceeding the 50MB quota for a MySql DB.
>
> As a temporary solution I truncate this table from time to time.
>
> Is there a way of limiting the number of history changes so this table
> will not over populate? I prefer not to use a cron job.
>
>
> Thanks,
> David.
>From an earlier post:
We say TYPO3 has the history of record changes unlimited but since I
hadn't read TSCONFIG completely I just found out it's not true.
history.maxAgeDays: "The number of days elements are in the history at
most. Takes precedence over keepEntries. Default is 7 days. Range 0-200.
Zero turns the magAgeDays of."
AND
history.keepEntries: "Max entries in the sys_history for this table.
Range 0-200. Zero turns the history of.
AND
History log: By default 20 states of history data is preserved in TYPO3
and after a week it expires.
So undo's are not unlimited so we are doing false advertising?
*** OR ***
Am I reading docs wrong and I have to set the following for unlimited
TCEMAIN {
#instead of default you can put also table.tablename (ie.
table.tt_conent)
default {
history.keepEntries = 0
history.maxAgeDays = 0
}
}
References:
http://typo3.org/documentation/document-library/references/doc_core_tsconfig/current/view/1/3/#id2798076
Thanks for any of your thoughts! Cheers.
More information about the TYPO3-english
mailing list