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

          Zeplin

            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 Integration