Users running a non-download version of Vanilla (pulled from github), on branch release/2019.016 or master from the last 2 weeks should upgrade to release/2019.017 or latest master for security reasons. Downloaded official open sources releases are not affected.
Please upgrade here. These earlier versions are no longer being updated and have security issues.

Activity Table weight

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

Comments

  • R_JR_J Cheerleader & Troubleshooter Munich Moderator


    hgtonight
  • edited January 2017

    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"

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

  • LincLinc Director of Development Detroit Vanilla Staff

    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.

    R_Jhgtonight
  • Nice to know, when it will be released? :)

  • Thank you, do it work better then this plugin?

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

    grep is your friend.

    giacomosilli
  • edited February 2017

    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?

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

    grep is your friend.

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

  • R_JR_J Cheerleader & Troubleshooter Munich Moderator

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


  • edited February 2017

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

  • R_JR_J Cheerleader & Troubleshooter Munich Moderator

    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?


    giacomosillimatamataLinchgtonight
  • Thank you, the problem seems to be solved

Sign In or Register to comment.