In the activity_log_events table I have more than a million rows
(how many exactly: I don't know. In phpmyadmin, every time I refresh the page, I get a different value, varying between 1.7 million and 700,000)
In /admin/settings/activity_log i have reduced the Number of days to store an activity record from 365 to 90.
Will that reduce the size of the table? I have run the cron of the module, for the moment it doesn't seem to have reduced, although it's hard to tell as I don't know the exact number. For the moment I see no change.
I am using Drupal Commons.

Comments

icecreamyou’s picture

Status: Active » Fixed

PHPMyAdmin runs a fast heuristic to calculate the number of rows but you can get the exact number with a SELECT COUNT(*) FROM table_name query.

Reducing the number of days to store a record will bring down the row count if you have more than that many days of records stored.

francis55’s picture

Reduced as you suggested from 365 days of retention to 3, now I'm down from 1,000,000 to 36 rows
I now think the activity is due to mass-importing nodes.
I'll increase the number again to get history in coming days

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.