Steps to Change Innodb storage Format for Moodle/Totara
Description: You may face this problem in Totara:
Advanced Totara features require innodb Barracuda storage format
Reason: The error usually occurs because of Mysql 5.6 and below using file format “Antelope”. This format cannot handle more than 10 text columns. So it is recommended to change it to barracuda file format.
Solution: You can’t change it simply from Moodle/Totara administrator settings but still there is a workaround for it through Command line. You can follow these steps to convert Antelope file system to Barracuda –
Open the Terminal and go to the Moodle root folder.
$cd /path_to/moodle
In my case the moodle path is
/var/www/html/moodle
Use the below mentioned command with the provided switches .
php admin/cli/mysql_compressed_rows.php
Like : -l (list the tables having problem)
-i (to show database Information)
-f (to fix issue for all tables in database)
Usage of command and switches:-
1.To list problematic tables. It shows all the tables which have problem:
php admin/cli/mysql_compressed_rows.php -l
Output is:-
2. To show database Information.
php admin/cli/mysql_compressed_rows.php -i
It shows the database information status whether it is connectable or not.
3. For attempt to fix all the tables
php admin/cli/mysql_compressed_rows.php -f
Output is:-
