Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-61381

Slow queries : Index 'mdl_sess_tim2_ix' on table 'mdl_sessions' and column 'timemodified'

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 3.4, 3.5.5
    • Fix Version/s: None
    • Component/s: General
    • Affected Branches:
      MOODLE_34_STABLE, MOODLE_35_STABLE

      Description

      Hello,

      We have some slow queries on one of our Moodle platform.

      The 'mdl_sessions' table has ~5000 rows, and each time it's updated, this leads to a slow query (we think because of the index mdl_sess_tim2_ix (timemodified)).

      Why is there an index on timecreated and timemodified for this table ?

      Can we remove them ?

      Thank you in advance for you answer.

      Kind regards,

      Olivier

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            Trolli Olivier Piton
            Participants:
            Component watchers:
            Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias, Sujith Haridasan
            Votes:
            3 Vote for this issue
            Watchers:
            6 Start watching this issue

              Dates

              Created:
              Updated: