MySQL Forums
Forum List  »  InnoDB

Re: SET GLOBAL innodb_file_format=Barracuda not working
Posted by: Marko Mäkelä
Date: September 28, 2015 01:57AM

Like others have already pointed out, SET GLOBAL is not persistent across restarts. The settings will always be read from the configuration files or from the command-line parameters.

When it comes to this particular option, WL#7703 changed the default to innodb_file_format=Barracuda in MySQL 5.7.7, and WL#7704 removed the option in what would become the next major MySQL version. Furthermore, WL#8703 in MySQL 5.7.9 will change ROW_FORMAT=DYNAMIC to be the default.

With best regards,

Marko Mäkelä
InnoDB Group, MySQL server, Oracle Corporation

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: SET GLOBAL innodb_file_format=Barracuda not working
1829
September 28, 2015 01:57AM


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.