Uploaded image for project: 'Enterprise 3.x'
  1. Enterprise 3.x
  2. ETHREEOH-2046

Activity feed causing high load on db for user activity for sites with high # of members

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 3.1 SP1
    • Fix Version/s: Pending
    • Component/s: Share
    • Security Level: external (External user)
    • Labels:
      None
    • Environment:
      3 systems with equal system config: 2 x 2.66 GHz processors, 3 GB RAM .... share / repository / database ...
      Share + Repo is: Java 1.6.0_10, Tomcat 6.0 (alfresco+tomcat bundle).
      Mysql: 5.0.45

      Description

      Currently on share.alfresco.com we have the 'community' site which has 24k + members. The activity feed for user join/leave etc. Causes high load on db due to (seemingly) multiple insert activity. This makes the feed for this use case effectively unusable, as we get joins every 5 minutes or so.

      Workaround (from Jan) is that I've removed the ftl files for the user activities (plus the generic one so it doesn't fall through) ... this effectively disables this type of feed. Instead we simply get an error message stating missing file - which is fine for now.

      We also see this similar activity due to other activity types, but user join is the most common and the biggest problem.

        Activity

        Hide
        ken Ken Barber (Inactive) added a comment -
        To add - this also causes problems for documentLibrary activity when something from marketing modifies a document, of course this occurs less frequently.
        Show
        ken Ken Barber (Inactive) added a comment - To add - this also causes problems for documentLibrary activity when something from marketing modifies a document, of course this occurs less frequently.
        Hide
        srigby Steve Rigby added a comment -
        BRB reviewed
        Show
        srigby Steve Rigby added a comment - BRB reviewed

          People

          • Assignee:
            closedbugs Closed Bugs
            Reporter:
            ken Ken Barber (Inactive)
          • Votes:
            1 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Time Tracking

              Estimated:
              Original Estimate - 2 weeks
              2w
              Remaining:
              Remaining Estimate - 2 weeks
              2w
              Logged:
              Time Spent - Not Specified
              Not Specified