Closed (fixed)
Project:
Activity Log
Version:
6.x-2.0-beta1
Component:
Code
Priority:
Normal
Category:
Support request
Assigned:
Unassigned
Reporter:
Created:
2 Aug 2013 at 14:55 UTC
Updated:
21 Aug 2013 at 08:01 UTC
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
Comment #1
icecreamyou commentedPHPMyAdmin runs a fast heuristic to calculate the number of rows but you can get the exact number with a
SELECT COUNT(*) FROM table_namequery.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.
Comment #2
francis55 commentedReduced 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