This table is never trimmed down. I just noticed that I have 200,000 rows in this table dating back to Mar 2005. Which explains why updates to it are starting to show up in my slow query log. Surely this table can be trimmed on cron.

Comments

deekayen’s picture

deekayen commented

When should entries be dropped off the end?

dalin’s picture

dalin
he/him
Primary language English
Location 🇨🇦, 🇲🇽, 🌍
commented

How about the last 6months or a year. That should be more than enough auditing trail for anyone.

deekayen’s picture

deekayen commented

What do you think about using the dblog_row_limit value from admin/settings/logging/dblog

dalin’s picture

dalin
he/him
Primary language English
Location 🇨🇦, 🇲🇽, 🌍
commented

The dblog module isn't a required module, so it would mean that the default value would be used if that variable has not already been initialized which sounds like a reasonable course of action.

mgifford’s picture

mgifford
he/him
Primary language English
commented
Issue summary: View changes

If this is still an issue, please re-open and upgrade version to D7. Drupal 6 is no longer being maintained.

mgifford’s picture

mgifford
he/him
Primary language English
commented
Status: Active » Closed (won't fix)