Uploaded image for project: 'Data Management'
  1. Data Management
  2. DM-6573

Determine what is occurring during mmap and mlock call that speeds up queries.

    Details

    • Type: Story
    • Status: To Do
    • Resolution: Unresolved
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Templates:
    • Team:
      Data Access and Database

      Description

      Calling mmap and mlock causes queries to run significantly faster, including solo queries, which is unexpected. Further, the mlock call must complete before the query is passed to mysql and only one mlock call can be be running at a time or the speed benefit vanishes. This is not the expected behavior and it would be good to know exactly what is happening. At this point, this has only been tested on the in2p3 cluster.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                jgates John Gates
                Reporter:
                jgates John Gates
                Watchers:
                Fritz Mueller, Gabriele Comoretto, John Gates
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:

                  Summary Panel