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

Slow query on BULLHORN_ALERTS EVENT and REF columns

    XMLWordPrintable

    Details

    • 20 status:
      Resolved
    • 19 status:
      Please Merge
    • Test Plan:
      Hide

      1. Use bullhorns
      2. Add an announcement
      3. Confirm that a bullhorn is presented
      4. Delete the announcement
      5. Confirm that the bullhorn no longer exists.

      Show
      1. Use bullhorns 2. Add an announcement 3. Confirm that a bullhorn is presented 4. Delete the announcement 5. Confirm that the bullhorn no longer exists.

      Description

      Observed from MySQL slow query logs:

      1. Time: 191111 16:23:38
      2. User@Host: sakai[sakai] @ [localhost] Id: 2137635
      3. Query_time: 13.419679 Lock_time: 0.000042 Rows_sent: 0 Rows_examined: 1033879
        SET timestamp=1573489418;
        delete from BULLHORN_ALERTS where EVENT='annc.new' and REF='/announcement/msg/siteid/main/3ef02fab-e8c8-436f-a8f4-f1e74fe87802';

        Gliffy Diagrams

          Zeplin

            Attachments

              Issue Links

                Activity

                  People

                  • Assignee:
                    ottenhoff Sam Ottenhoff
                    Reporter:
                    ottenhoff Sam Ottenhoff
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    2 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved:

                      Git Integration