[TYPO3-english] sys_log table is getting too large

Sebastiaan de Jonge szebi.eger at gmail.com
Wed Jan 19 12:39:13 CET 2011


Hello Farooq,

What do you consider as *many* users? You could trim down the size by check
throwing away some older entries (or back them up, and only keep stuff until
it reaches a certain age).

It's also wise to check the errors inside the log, as this may also cause
the log table to grow faster than normal.

Hope this helps.

Sebastiaan

On Wed, Jan 19, 2011 at 12:32 PM, <mohammad.farooq at steria.co.in> wrote:

>
> Hello List,
>
> I have a site running on TYPO3, its database size excluding table "sys_log"
> is ~200MB, while table "sys_log" which holds back-end content edit history
> is more than 3GB and is getting increased, because there are too many
> back-end users with workspaces attached.
>
> Will you please suggest me, what to do to tame its size, and how about
> emptying this table or so.
>
>
> Thanks,
> Farooq
>
>
> Think before you print - Steria is committed to supporting a sustainable
> world
>
>
>
> This email originates from Steria*. It, and any attachments, may contain
> confidential information and may be subject to copyright or other
> intellectual property rights. It is only for the use of the addressee(s).
> You may not copy, forward, disclose, save or otherwise use it in any way if
> you are not the addressee(s) or responsible for delivery.
> If you receive this email by mistake, please advise the sender and cancel
> it immediately.
> Steria may monitor the content of emails within its network to ensure
> compliance with its policies and procedures.
> Any email is susceptible to alteration and its integrity cannot be assured.
> Steria shall not be liable if the message is altered, modified, falsified,
> or edited.
> _____________________________________________________
> * Steria Limited, number 4077975;
> Steria Recruitment Limited, number 1437998.
> Registered in England and Wales; registered office Three Cherry Trees Lane,
> Hemel Hempstead, Hertfordshire HP2 7AH
> _______________________________________________
> TYPO3-english mailing list
> TYPO3-english at lists.typo3.org
> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english
>



-- 
Kind regards,
Sebastiaan de Jonge

Freelance TYPO3 Developer - Certified TYPO3 Integrator
w: http://sebastiaandejonge.com


More information about the TYPO3-english mailing list