MySQL “innodb_large_prefix” and “Barracuda” innodb_file_format now supported

Our MySQL database servers now support the innodb_large_prefix option and the “Barracuda” innodb_file_format option.

Users should not notice any difference, but this should improve compatibility with a small number of scripts that require these options (notably recent versions of Moodle).

For technical users, MySQL looked like this before the change:

mysql> show variables
    -> where Variable_name in
    -> ("innodb_large_prefix", "innodb_file_format");
+---------------------+----------+
| Variable_name       | Value    |
+---------------------+----------+
| innodb_file_format  | Antelope |
| innodb_large_prefix | OFF      |
+---------------------+----------+

And like this after the change:

mysql> show variables
    -> where Variable_name in
    -> ("innodb_large_prefix", "innodb_file_format");
+---------------------+-----------+
| Variable_name       | Value     |
+---------------------+-----------+
| innodb_file_format  | Barracuda |
| innodb_large_prefix | ON        |
+---------------------+-----------+