Sign in Register
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

    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 4054 posts 12927 karma points MVP 2x
    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

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies