Details
-
Bug
-
Status: Open
-
Minor
-
Resolution: Unresolved
-
3.4.5, 3.5.2
-
None
-
MySQL
-
MOODLE_34_STABLE, MOODLE_35_STABLE
Description
While I understand the logic of checking for Barracuda and large prefixes during the installation, I'm not so convinced about checking for innodb_file_per_table during installation.
For smaller installs, being set either way is not particularly problematic, since if not enabled, tables may be dropped and the space not immediately reclaimed by the filesystem, the space is still usable by MySQL.
The problem comes in for us with larger installations when using AWS and Azure, namely that replication of databases on these environments works much better on having one large tablespace that all tables are part of, and performance is improved as well in our experience.
I'd argue that this is also a decision that systems administrators should be making rather than applications; it should be transparent to the application whether it's on or off, and trying to impose logic for one set of users in the application to the detriment of others may not be ideal.
For now we've simply resorted to manually removing that test during installation but it really shouldn't be application-level.
Attachments
Issue Links
- has a non-specific relationship to
-
MDLSITE-5169 Dump/load conversion to utf8mb4 does not work
-
- Open
-
-
MDL-58729 Full unicode support conversion impractically slow
-
- Closed
-
-
MDL-59561 Upgrade to 3.3 fails because of very long index in mdl_question_categories on MariaDB in utf8mb4_general_ci
-
- Closed
-
-
MDL-60862 Invalid Record Message
-
- Closed
-
- will be (partly) resolved by
-
MDL-58931 AWS Aurora MySQL support for Moodle
-
- Closed
-