Hello,
I am referring to this article and want to add something to it:
I am testing the Child Report and notice the DB wp_mainwp_stream_meta and wp_mainwp_stream contain a lot of data. It seems this depends also on the installed plugins. Some plugins write a lot (or let’s say MainWP Child Report collects a lot of their activities).
This leads to large DB size. With InnoDB you can try to optimize it but it won’t make a difference in the actual size of the DB. The only chance is to export the table, drop it, import it again. Therefore it’s important to be able to control it before it gets too large in size.
This brings me to some of the topics:
- Shouldn’t it be possible in wp-admin to bulk delete selected log entries
- There is the option "Reset MainWP Child Reports Database " but that means also it will delete everything, so that means the next report would be empty
- Therefore it would need a better control on how to delete selectively those log entries
- If I change the setting “Keep records for” from 100 to 30 days, then this would probably not clean up older entries. I assume (correct me if I am wrong) this will only apply to newly added logs
Thanks for sharing your thoughts on this