We've recently upgraded to 2.7.2+ from 2.6.X+ and have started experiencing occasional database connectivity issues. In investigating I found that the new Standard log store has 'never delete logs' by default (guess I missed that one) and as a result that table has over 35,045,968 rows (at time of this writing).
Knowing that mdl_log used to cause some issues for other users when it would hit 7-9 million lines I wanted to investigate pruning it, but by setting a log limit. I set it to 35 days but then I discovered that the earliest entry is September 19 (when we did the upgrade)- only 31 days ago.
Is the new log format really logging that much more info (mdl_log has 56,000 entries for 35 days)- and what are the performance implications?