Didn't get any info for forum search or from adding to general help. So adding here.
Ourgrade_grades, grade_grades_history, and grade_items_history tables are huge
In site administration->server->cleanup, I set grade history lifetime to 180 days/6 months whereas it had been set to no limit.
I ran cron several times.
Nothing happened to the size of the tables. I ran analyze/optimize/repair on our MySQL and nothing happened to the size of the tables.
I searched the code base for the table names and gradehistorylifetimeand didn't find any useful delete SQL commands/functions. So do I have to manually delete entries in the grade_grades_history and grade_items_history tables?
How does this work?
I also went to site administration->plugins->logging and changed standard log history to 6 months thinking that would help here. It didn't.
Again the tables are the same size.
Is there a SQL Query to do this manually? Tool?