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, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze, Andrew Nicols, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

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