SET GLOBAL innodb_file_format=Barracuda not working
Hi all. I have had several MySQL servers for about 10 years, but as the are so reliable I have not had to do much with them, so I am not experienced. The server is a Windows 2012 R2 running MySQL 5.6.19 which is a backend server for a Moodle site with IIS running on another server.
For an upcoming version we need to change the innodb_file_format from Antelope to Barracuda. Following instructions I ran the commands and all looked good, but our Moodle still reported that we were running Antelope. Today I ran show variables like "%innodb_file%"; again and it reported
innodb_file_format Antelope
innodb_file_format_max Barracuda
This is a list of all commands I ran
USE dbname;
SET SESSION sql_mode=STRICT_ALL_TABLES;
SET GLOBAL innodb_file_per_table=1;
SET GLOBAL innodb_file_format=Barracuda;
ALTER TABLE mdl_data ROW_FORMAT=Compressed;
ALTER TABLE mdl_data_fields ROW_FORMAT=Compressed;
ALTER TABLE mdl_enrol_paypal ROW_FORMAT=Compressed;
ALTER TABLE mdl_lti ROW_FORMAT=Compressed;
ALTER TABLE mdl_user ROW_FORMAT=Compressed;
ALTER TABLE mdl_user_info_field ROW_FORMAT=Compressed;
I have since ran SET GLOBAL innodb_file_format=Barracuda; several times. When I do it appears to run without issues and then I run show variables like "%innodb_file%"; and it reported
innodb_file_format Barracuda
innodb_file_format_max Barracuda
So I quit this and restart the server and run show variables like "%innodb_file%"; and it again reports innodb_file_format Antelope. The innodb_file_format_max shows Barracuda.
Can someone please assist with identifying what I am doing wrong to get it all to Barracuda ?
Thanks in advance.
Subject
Views
Written By
Posted
SET GLOBAL innodb_file_format=Barracuda not working
9989
September 22, 2015 10:50PM
2367
September 22, 2015 11:43PM
2125
September 23, 2015 12:02AM
2513
September 24, 2015 06:19PM
1829
September 28, 2015 01:57AM
1632
October 03, 2015 05:01PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.