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

Review various innodb removed parameters (mysql and mariadb)

XMLWordPrintable

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

      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
      

            Unassigned Unassigned
            stronk7 Eloy Lafuente (stronk7)
            Votes:
            1 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.