Sign in Register
Go to solution
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Shaun 248 posts 475 karma points
    Jun 15, 2010 @ 15:28
    Shaun
    0

    Emptying the umbracoLog table

    API Questions

    Hi

    My umbraco database is getting massive, due to lots of stuff being written to the umbracoLog table.

    If I were to do a "delete from umbracoLog" would it have a negative impact on my site at all?

    Many thanks

    Shaun

    Copy Link
  • Richard Soeteman 4035 posts 12842 karma points MVP
    Jun 15, 2010 @ 15:38
    Richard Soeteman
    2

    Hi Shaun,

    Only negative would be that it takes a while and lots of Timeouts can occur. I would Use "Truncate Table umbracoLog"  which just clears the table.

    Cheers,

    Richard

    Copy Link
  • Shaun 248 posts 475 karma points
    Jun 15, 2010 @ 17:07
    Shaun
    0

    Thanks Richard, I tried your command and it worked fine!

    Copy Link
  • Aaron Powell 1708 posts 3046 karma points c-trib
    Jun 16, 2010 @ 00:45
    Aaron Powell
    0

    Don't flat-out delete the log table. The log table is where the audit trail comes from ;)

    Copy Link
  • Tizer 170 posts 201 karma points
    Jul 23, 2010 @ 04:27
    Tizer
    0

    Doh - ignore this - truncate means delete :)

    Is it ok to just delete old logs from umbracoLog - ones from previous years (no longer needed)?

     

    Copy Link
  • Thomas Höhler 1237 posts 1709 karma points MVP
    Jul 23, 2010 @ 08:38
    Thomas Höhler
    0

    You can use my ClientTools4Umbraco where you can filter the logs by name, date, etc. and then you can delete the selected logentries

    http://our.umbraco.org/projects/developer-tools/client-tools-for-umbraco

    Thomas

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft