Hardware and performance

tcm_grade_items_history table is HUGE!

 
Picture of Scott Bingham
tcm_grade_items_history table is HUGE!
 

Using phpMyAdmin, i noticed my tcm_grade_items_history table is HUGE at 949.9 MB and is by far the largest table I have. 


Have I missed an important setting somewhere?  Is this table supposed to be this large?


Help me tame the beast, please!

 
Average of ratings: -
Picture of Chris Fryer
Re: tcm_grade_items_history table is HUGE!
Particularly helpful Moodlers

Hi Scott

There are some admin settings relating to the retention of Grade Histories on the "cleanup" page.

Navigate to /admin/settings.php?section=cleanup

Chris

 
Average of ratings: -
Picture of Scott Bingham
Re: tcm_grade_items_history table is HUGE!
 

Thanks, Chris. 


I adjusted the settings. Any idea when the database will be "cleaned up?"

 
Average of ratings: -
Picture of Ken Task
Re: tcm_grade_items_history table is HUGE!
Particularly helpful Moodlers

Depending upon version of Moodle ... there are Scheduled Task that one could run individually.  Site Admin search for 'task'.

Also, how often are you running cron?  Run the cron and watch for info related to target of 'cleaning up'.   Could run cron from the web but must give a password now ... search for 'cron'.

'spirit of sharing', Ken


 
Average of ratings: -
Picture of Chris Fryer
Re: tcm_grade_items_history table is HUGE!
Particularly helpful Moodlers

Also, you probably won't get the space back until you optimize the table.

https://dev.mysql.com/doc/refman/5.7/en/optimize-table.html

 
Average of ratings: -