===== moodle =====

==== mysql ====


<code>
set global innodb_file_format = `BARRACUDA`;
set global innodb_large_prefix = `ON`;


USE moodle37;
SET @@global.innodb_large_prefix = 1;
SET SESSION sql_mode=STRICT_ALL_TABLES;
SET GLOBAL innodb_file_per_table=1;
SET GLOBAL innodb_file_format=Barracuda;
ALTER TABLE mdl_badge ROW_FORMAT=Compressed;
ALTER TABLE mdl_data ROW_FORMAT=Compressed;
ALTER TABLE mdl_data_fields ROW_FORMAT=Compressed;
ALTER TABLE mdl_enrol_lti_lti2_consumer ROW_FORMAT=Compressed;
ALTER TABLE mdl_enrol_paypal ROW_FORMAT=Compressed;
ALTER TABLE mdl_lti ROW_FORMAT=Compressed;
ALTER TABLE mdl_oauth2_issuer ROW_FORMAT=Compressed;
ALTER TABLE mdl_user ROW_FORMAT=Compressed;
ALTER TABLE mdl_user_info_field ROW_FORMAT=Compressed;

</code>

Run above in `mysql` console, or change cnf file: https://github.com/dcai/vagrant-dev/blob/master/ansible/templates/mysql/innodb.cnf