Bulk delete entries in Child Report to control wp_mainwp_stream_meta and wp_mainwp_stream

Support
1

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:

  1. Shouldn’t it be possible in wp-admin to bulk delete selected log entries
  2. 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
  3. Therefore it would need a better control on how to delete selectively those log entries
  4. 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

2

Hey @markus998

It will in fact delete all older entries, so this is an effective way of cleaning unneeded entries.

Using the Code Snippets add-on, you can even change this value in bulk: Code Snippets - MainWP WordPress Management

Please feel free to make a suggestion about this on our feedback site. That way, others can vote for it, letting us know which features our users want the most: https://voice.mainwp.com

3

True, I just checked the results a few days later and it really does delete them

Good to know

1 Like