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

Admin cli tool for converting innodb tables to Barracuda (backport of MDL-46235)

    XMLWordPrintable

    Details

    • Testing Instructions:
      Hide

      1/ execute unit tests in all database, mysql without innodb_file_format=Barracuda and innodb_file_per_table=1 is supposed to fail with descriptive error message

      2/ execute unit tests in various MySQLs and MariaDBs you may try to tweak following settings in my.cnf:

      • innodb_file_format
      • innodb_file_per_table

      3/ ideally test both InnoDB and XtraDB via $CFG->dboptions = array('dbengine' => 'xxx');

      4/ install moodle without the patch on MySQL and try all options of the new CLI tool at admin/cli/mysql_compressed_rows.php (ideally with and without the SUPER privilege) - the script should modify the tables if DB is configured properly or if db user has SUPER priv, error message should be printed if db cannot be fixed automatically

      Show
      1/ execute unit tests in all database, mysql without innodb_file_format=Barracuda and innodb_file_per_table=1 is supposed to fail with descriptive error message 2/ execute unit tests in various MySQLs and MariaDBs you may try to tweak following settings in my.cnf: innodb_file_format innodb_file_per_table 3/ ideally test both InnoDB and XtraDB via $CFG->dboptions = array('dbengine' => 'xxx'); 4/ install moodle without the patch on MySQL and try all options of the new CLI tool at admin/cli/mysql_compressed_rows.php (ideally with and without the SUPER privilege) - the script should modify the tables if DB is configured properly or if db user has SUPER priv, error message should be printed if db cannot be fixed automatically
    • Affected Branches:
      MOODLE_26_STABLE, MOODLE_27_STABLE
    • Fixed Branches:
      MOODLE_26_STABLE, MOODLE_27_STABLE
    • Pull from Repository:
      git@github.com:skodak/moodle.git

      Description

      See MDL-46235.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              skodak Petr Skoda
              Reporter:
              damyon Damyon Wiese
              Integrator:
              Dan Poltawski
              Tester:
              Dan Poltawski
              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:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Fix Release Date:
                10/Nov/14