Testing this is difficult because it requires a great deal of time to set up the test, so I'm asking in case anyone has institutional experience on this.
We have the loglifetime setting set to Never (/admin/settings.php?section=logsettingstandard). We would like to change this setting. Our logstore_standard_log table has approximately 688,472,030 rows. The concern is that the first time it goes to prune this database, the query will lock up the whole site for days.
Does anyone have any experience with this and can offer any suggestions as to the best way to go about turning on the pruning functionality.