Comments - How to change Innodb fileformat to Barracuda

6 years, 4 months ago timo veith

Hello MariaDB Users,

please allow me the following question.

It seems that I can do this at runtime. SET GLOBAL innodb_file_format = "Barracuda"; SET GLOBAL innodb_file_format_max = "Barracuda"; SET GLOBAL innodb_file_per_table = "ON"; SET GLOBAL innodb_strict_mode = "ON";

and

ALTER TABLE <table_name> row_format=compressed;

What are the implications? Can I really do this at runtime? Are there any pitfalls that I must be aware of?

Thank you and regards Timo

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.