Bulk delete entries in Child Report to control wp_mainwp_stream_meta and wp_mainwp_stream

[markus998 (Markus)]

Hello,

I am referring to this article and want to add something to it:

Huge Database Issue With wp_mainwp_stream_and meta wp_mainwp_stream

The two database tables below on all the satellite sites are getting extremely loaded up and we are getting complaints from customers because they’re hosting company is shutting them down because the database is too big. How can these be cleared remotely or stop the massive increase? wp_mainwp_stream_meta wp_mainwp_stream

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

[bojan (Bojan Katusic)]

Hey @markus998

@markus998

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

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

@markus998

Shouldn’t it be possible in wp-admin to bulk delete selected log entries

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

[markus998 (Markus)]

@bojan

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

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

@bojan

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

Good to know