Hello All,
We have upgraded to Totara 2.7 (from 2.6) MySQL version is 5.6.19 The Message says "if this test fails, it indicates a potential problem
Advanced Totara features require InnoDB Barracuda storage format"
I am wondering what the impact is and what could be a resolution to an error in the Other Checks section of the Site Admin - Server - Environment page might be.
A screen shot is included above.
Any Ideas?
Thank you,
Peter
Hi Peter,
Further information here: https://tracker.moodle.org/browse/MDL-46235
Basically tables with more than 10 text columns may not work correctly. This mainly affects ReportBuilder caching and Appraisals at this point which both make use of dynamic table creation but could also affect some third-party plugins, or features that may be added in the future.
A fix was provided back in 2.5.20 & 2.6.12 as T-12640 in October last year (so is also included in all versions of 2.7) - see the Changelog notes for those versions, especially
"Database servers need to be configured to use the new Barracuda database format and one file per table setting. Existing database tables are not fixed during upgrade, use admin/cli/mysql_compressed_rows.php to fix existing installations."
So running "php admin/cli/mysql_compressed_rows.php" on the command line from the root directory of your totara installation should switch your existing database to use the Barracuda format.
If you do not use Reportbuilder Caching or Appraisals the impact should be minimal, but it would still be best to run the script anyway in case future enhancements require Barracuda support.
Thank you Ciaran!
Is there any chance I may have data loss on the upgraded site?
Hi Peter,
There are no potential data-loss issues with the switch to the Barracuda format that we are aware of. But it is always wise to take a backup before performing any upgrade.
