Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Missing indexes for ASN_SUBMISSION

Description

Hi there,

While looking at the Assignments tool in 12.4 (with NYU's post-conversion data set), I noticed that loading the tool was very slow.  It's taking several minutes to load the list of assignments for a site.

The stack trace shows my request thread sitting in AssignmentRepositoryImpl.countAssignmentSubmissions, which should be a fairly simple query.  Running it directly against the DB like this:

Shows the same sort of slowness. The EXPLAIN shows it's doing a full table scan; are there some indexes missing here?:

Activity

Show:

Mark Golbeck September 23, 2024 at 8:20 PM

per comment can we close this JIRA?

Thomas Kelsey May 3, 2021 at 9:19 PM

, it looks like this issue has been resolved/incorporated from the comments above? Can it be resolved?

Earle Nietzel December 17, 2018 at 7:56 PM
Edited

Here is the documentation from MySQL which is why these index's are not required:

https://dev.mysql.com/doc/refman/5.6/en/innodb-foreign-key-constraints.html

Mark Triggs December 17, 2018 at 7:40 PM

Hi , ,

Just confirming that the modified index worked fine.  Additionally, we needed this one too:

Without this, we found viewing submissions for an assignment was doing full table scans.

Mark Triggs December 6, 2018 at 10:13 PM

Hi ,

Yep, I'll be in a position to test this over the next week.  Right now we've been testing with 's suggested index and that's been fine, so I'll try dropping that additional column from the index and see if things still look good.  Will report back!

Details

Priority

Affects versions

Components

Assignee

Reporter

Labels

Environment

Oracle

Created November 11, 2018 at 10:11 PM
Updated September 23, 2024 at 8:20 PM