MySQL Forums
Forum List  »  InnoDB

Re: SET GLOBAL innodb_file_format=Barracuda not working
Posted by: Stephen Bloomer
Date: September 24, 2015 06:19PM

For those that follow, this is how I fixed.

Find the My.ini and add the line innodb_file_format=Barracuda

Then run
SET GLOBAL innodb_file_per_table=1;
SET GLOBAL innodb_file_format=Barracuda;

Then run to give you a list of all tables you need to change
SELECT table_schema, table_name, row_format
FROM information_schema.tables
WHERE engine='innodb'
AND row_format NOT IN ('Redundant', 'Compact');

Then run
ALTER TABLE "table_name" ROW_FORMAT=Compressed;
for every table that is not compressed.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: SET GLOBAL innodb_file_format=Barracuda not working
2512
September 24, 2015 06:19PM


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.