How to Change Innodb storage Format for Moodle/Totara

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

How to Change Innodb storage Format for Moodle/Totara

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:-
How to Change Innodb storage Format for Moodle/Totara

2. To show database Information.

php admin/cli/mysql_compressed_rows.php -i

How to Change Innodb storage Format for Moodle/Totara

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:-
How to Change Innodb storage Format for Moodle/Totara

Leave a Reply

Your email address will not be published. Required fields are marked *