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

Slow query in /admin/index.php

    XMLWordPrintable

    Details

    • Database:
      MySQL
    • Testing Instructions:
      Hide

      1/ Access /admin/index.php on a Moodle instance running on MySQL
      2/ manually convert some table to MyISAM engine
      3/ Access /admin/index.php again and verify warning is displayed

      optionally: Check the slow query log for the "SHOW TABLE STATUS" query

      Show
      1/ Access /admin/index.php on a Moodle instance running on MySQL 2/ manually convert some table to MyISAM engine 3/ Access /admin/index.php again and verify warning is displayed optionally: Check the slow query log for the "SHOW TABLE STATUS" query
    • Affected Branches:
      MOODLE_22_STABLE
    • Fixed Branches:
      MOODLE_24_STABLE
    • Pull from Repository:
    • Pull Master Branch:
      w28_MDL-34010_m24_mysqldiag

      Description

      After upgrading to Moodle 2, we're seeing a slow query in our MySQL slow query log every time we access /admin/index.php:

      SHOW TABLE STATUS WHERE Name LIKE BINARY 'mdl_%';

        Attachments

          Activity

            People

            • Assignee:
              skodak Petr Skoda
              Reporter:
              maherne Michael Aherne
              Integrator:
              Dan Poltawski
              Tester:
              Ankit Agarwal
              Participants:
              Component watchers:
              Andrew Nicols, Mathew May, Michael Hawkins, Shamim Rezaie, Simey Lameze, Jake Dallimore, Jun Pataleta
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Fix Release Date:
                3/Dec/12