[EE6] Deleting large system logs can produce insufficient memory errors #2112
Description
In recent months, I've hit memory errors when deleting large system logs using the EE control panel, and have seen similar reports on Slack. A couple of example screenshots from Slack discussion follow.
It should be possible to clear system logs of any size using the EE control panel without hitting such errors.
A related issue is that users express surprise at the size of system logs when they come to clear them — often tens or hundreds of thousands of records. EE could do a much better job of reporting at a glance the size of these logs — both number of records and total size in each case. Adding this information to the overview page for system logs would help to bring it to users' attention on an ongoing basis, and help them to manage logs more sensibly.
A specific example: when access throttling is turned on, displaying the access throttling logs shows only situations where the throttling limit has been violated, but the total number of records stored at any time for this feature can be significantly larger. The actual size of this log is only shown by EE when an attempt is made to clear it. This information should be visible at a glance from the system logs overview at any time.