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

Missing Env check for InnoDB table format Barracuda

    XMLWordPrintable

    Details

    • Database:
      MySQL
    • Testing Instructions:
      Hide
      1. Set-up a moodle instance to use MySQL as database.
      2. Run the CLI script on the terminal to list tables that need fixing:

        php admin/cli/mysql_compressed_rows.php -l

        By default, I've run the conversion script and it found 6 tables to be fixed.
        If it doesn't return anything, change the Row Format to Compact of a table (mdl_enrol_paypal) for example.

      3. In your moodle instance using MySQL, go to: Site Administration > Server > Environment.
      4. Look on Other checks section and make sure you get the message:

        Your database has tables using Antelope as file format. You are recommended to convert the tables to Barracuda file format. See the documentation Administration via command line for details of a tool for converting InnoDB tables to Barracuda.

      5. Return to the terminal, run the command:

        php admin/cli/mysql_compressed_rows.php -f

      6. Reload the environment check page, and make sure the warning is no longer displayed.
      Show
      Set-up a moodle instance to use MySQL as database. Run the CLI script on the terminal to list tables that need fixing: php admin/cli/mysql_compressed_rows.php -l By default, I've run the conversion script and it found 6 tables to be fixed. If it doesn't return anything, change the Row Format to Compact of a table (mdl_enrol_paypal) for example. In your moodle instance using MySQL, go to: Site Administration > Server > Environment. Look on Other checks section and make sure you get the message: Your database has tables using Antelope as file format. You are recommended to convert the tables to Barracuda file format. See the documentation Administration via command line for details of a tool for converting InnoDB tables to Barracuda. Return to the terminal, run the command: php admin/cli/mysql_compressed_rows.php -f Reload the environment check page, and make sure the warning is no longer displayed.
    • Affected Branches:
      MOODLE_28_STABLE
    • Fixed Branches:
      MOODLE_27_STABLE, MOODLE_28_STABLE
    • Pull from Repository:
    • Pull Master Branch:
      MDL-46963-master
    • Sprint:
      Team '; drop tables Sprint 5, Team '; drop tables Sprint 6
    • Issue size:
      Small

      Description

      See MDL-46235 for details, but the default InnoDB table format (Antelope) has bugs and should be changed to Barracuda to avoid random moodle bugs. We added a cli script to do the conversions, but we need to add an environment check to force admins to alter their default table formats. Otherwise newly created tables will be created with the wrong format even after they have run the cli script (after a DB reboot).

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              lameze Simey Lameze
              Reporter:
              damyon Damyon Wiese
              Peer reviewer:
              Mark Nelson
              Integrator:
              David Monllaó
              Tester:
              Rajesh Taneja
              Participants:
              Component watchers:
              Andrew Nicols, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze, Jake Dallimore, Jun Pataleta
              Votes:
              0 Vote for this issue
              Watchers:
              10 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Fix Release Date:
                11/May/15