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

          caused a regression

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-49723 Deprecate guess_antolope_row_size function

          • Minor - Minor loss of function where workaround is possible
          • Closed
          has a non-specific relationship to

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-47387 Some course restores throw an error/moodle/dmlwriteexception

          • Critical - Crashes server, loss of data, severe memory leak
          • Closed

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-46235 default InnoDB database tables in MySQL cannot handle more than 10 text columns (varchar also affected)

          • Major - Major loss of function, incorrect output
          • Closed

            Activity

              People

              Assignee:
              skodak Petr Skoda
              Reporter:
              damyon Damyon Wiese
              Integrator:
              Dan Poltawski Dan Poltawski
              Tester:
              Dan Poltawski Dan Poltawski
              Participants:
              Component watchers:
              Andrew Lyons, Dongsheng Cai, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze, Andrew Lyons, Dongsheng Cai, Huong Nguyen, 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