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
  • giacomosilligiacomosilli New New
    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?

  • x00x00 MVP MVP

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

    grep is your friend.

    giacomosilli
  • giacomosilligiacomosilli New New
    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?

  • x00x00 MVP MVP

    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?


  • giacomosilligiacomosilli New New
    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.