[MDL-68052] Implement cleanup of analytics_indicator_calc stores table - Moodle Tracker

XML

Word

Printable

Details

Type: New Feature
Status: Closed
Priority: Minor
Resolution: Fixed
Affects Version/s: 3.8.1
Fix Version/s: 3.11
Component/s: Analytics
Labels:
- ci
- release_notes
- triaged

Testing Instructions:
Hide

Set the new "analytics/calclifetime" admin setting (Analytics > Analytics settings) to 35 days (default).

Check the number of records in your analytics_indicator_calc table and make sure there are some that have a timecreated older than 35 days.

If you don't have records that are older than 35 days then update some of the records so that they are.

Run the cleanup task.

php admin/cli/scheduled_task.php --execute='\core\task\analytics_cleanup_task'

Verify it ends without error.

Check the analytics_indicator_calc table and make sure records older than 35 days have been removed.
Show
Set the new "analytics/calclifetime" admin setting (Analytics > Analytics settings) to 35 days (default). Check the number of records in your analytics_indicator_calc table and make sure there are some that have a timecreated older than 35 days. If you don't have records that are older than 35 days then update some of the records so that they are. Run the cleanup task. php admin/cli/scheduled_task.php --execute='\core\task\analytics_cleanup_task' Verify it ends without error. Check the analytics_indicator_calc table and make sure records older than 35 days have been removed.
Affected Branches:
MOODLE_38_STABLE
Fixed Branches:
MOODLE_311_STABLE
Pull from Repository:
git://github.com/danmarsden/moodle.git
Pull Master Branch:
~~MDL-68052~~
Pull Master Diff URL:
https://github.com/moodle/moodle/compare/master...danmarsden:MDL-68052

Description

Would it be possible to implement automated cleanup of the mdl_analytics_indicator_calc table? This would be useful prevent table from becoming too large. For example, in one Moodle site with a 65 GB database, the table is currently 25 GB in size.

Attachments

Options
- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

Attachments

Screen Shot 2020-11-30 at 11.10.13 am.png
762 kB
30/Nov/20 11:11 AM
Screen Shot 2020-11-30 at 11.10.36 am.png
379 kB
30/Nov/20 11:11 AM

Activity

People

Assignee:: Dan Marsden

Reporter:: Thomas College ITS

Peer reviewer:: Paul Holden

Integrator:: Adrian Greeve

Tester:: Mathew May

Participants:: Adrian Greeve, CiBoT, Dan Marsden, Jonathon Fowler, Mathew May, Mikael Kurula, Paul Holden, Sara Arjona (@sarjona), Thomas College ITS

Component watchers:: Amaia Anabitarte, Carlos Escobedo, Ferran Recio, Ilya Tregubov, Sara Arjona (@sarjona)

Votes:: 3 Vote for this issue

Watchers:: 8 Start watching this issue

Dates

Created:: 26/Feb/20 5:08 AM

Updated:: 07/May/21 5:54 PM

Resolved:: 04/Dec/20 9:25 AM

Fix Release Date:: 17/May/21

Time Tracking

Estimated:

Not Specified

Remaining:

Logged:

2h 30m