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

Review various innodb removed parameters (mysql and mariadb)

    XMLWordPrintable

Details

    • Bug
    • Status: Open
    • Minor
    • Resolution: Unresolved
    • 3.9.6, 3.10.3, 3.11, 4.0
    • None
    • Database SQL/XMLDB
    • None
    • MOODLE_310_STABLE, MOODLE_311_STABLE, MOODLE_39_STABLE, MOODLE_400_STABLE

    Description

      With MySQL 8 and MariaDB 10.3.1/10.6.0 various parameters were removed:

      • innodb_file_format[_check|_max]: Only file format is Barracuda, so the parameters have been removed.
      • innodb_large_prefix: With the Barracuda format, the default is to have this parameter enabled, so it has been removed too.

      This issue is about to look for all the uses of them in core and only try to report or use them when available.

      Take a look to is_antelope_file_format_no_more_supported() because it already has some code detecting it.

      This affects specifically to various admin/cli/mysql_**** scripts.

      $ ag '(innodb_large_prefix|innodb_file_format)' -l
      admin/cli/mysql_collation.php
      admin/cli/mysql_compressed_rows.php
      lang/en/admin.php
      lib/dml/mysqli_native_moodle_database.php
      lib/ddl/tests/ddl_test.php
      lib/upgradelib.php
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              stronk7 Eloy Lafuente (stronk7)
              David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated: