Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-26192

Updates to sakai_digest table can fill binlogs and bring down the database

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: CLOSED
    • Priority: Major
    • Resolution: Won't Fix
    • Affects Version/s: 2.9.3, 10.0
    • Fix Version/s: None
    • Component/s: Other
    • Labels:
      None

      Description

      The sakai_digest table stores all the emails for each user in 1 xml field. It updates this xml field each time. We had a situation where the binlogs were over 40gb. After analyzing the logs and user activity, we found that several course sites had over 10 instructors and the Assignments were set to send a digest email one time per day. On this particular day the students were submitting their assignments and each time they submitted, the submission announcement with the submission text was added to the ever growing xml field and written to the binlog each time.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                bbiltimier Brooke Biltimier
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Git Source Code