Activity Table weight

giacomosilli

Hello,

I have thousands of registered users on the forum, hundreds of active connections at the same time.
I would like to make a cleaning of Activity table, and maybe completely disable it, to lighten the forum / database.
Is there any plugin or some practice for this problem?

Thank you

R_J

Yes there is something like that: https://open.vanillaforums.com/addon/activitypurge-plugin

giacomosilli

Thank you but i wont work on vanilla2.3
Working on vanilla2.0.

On vanilla2.3, after enable it, i get "page not found" when i click on "settings"

giacomosilli

Seems to work in vanilla2.3 too now, thanks again.

Linc

In Vanilla 2.4, this will be baked into the product and won't require a plugin. We auto-prune activity older than 2 months, by default. It does it in batches of 10 every time a new activity is added so as to not cause high load.

giacomosilli

Nice to know, when it will be released?

x00

https://open.vanillaforums.com/discussion/comment/195196#Comment_195196

giacomosilli

Thank you, do it work better then this plugin?

x00

yes in the sense it is not relying on requests to execute.

giacomosilli

I'm testing it locally, seems to wont work.

    DELETE FROM GDN_Activity WHERE ActivityTypeID NOT IN ( SELECT ActivityTypeID FROM GDN_ActivityType WHERE Name = 'WallComment' ) AND TIMESTAMPDIFF(MONTH,DateInserted,NOW())>2;
/ * The connection to 127.0.0.1 was closed on 01/02/2017 16:39:54 * /
/ * Rows affected: 2,309,140 Lines found: 0 Warnings: 0 Duration of 1 query: 00:06:39 * /

Any tips?

x00

What do you mean "word work"? it clearly affected 2,309,140 rows.

matamata

All activities are still there, such as approval of new users, change the picture profile, membership and more

R_J

Are you the same or do you only have the same problem?

giacomosilli

Hello, i have the same problem, i have not solved it

R_J

Like x00 already said: more than 2 million rows have been deleted, that's what you have posted.

But you might not have understood what you have done: you have deleted
a) everything which is not a wall comment and(!)
b) is older than 2 months

Have you checked that those old activities aren't there any more, matamatagiacomosilli?

giacomosilli

Thank you, the problem seems to be solved