Setting innodb_file_format Barracuda needs innodb_file_per_table. So, your (new created) Barracuda table is putted into one .ibd file. Any other your Antelope tables (in other .ibd files or ibdata1) don't be affected that operation.
I have mix of Antelope/Barracuda for years in our production environment too, without any problem of that. Regards, 2014-10-29 17:35 GMT+09:00 Federico Razzoli <[email protected]>: > I had a mix of Antelope/Barracuda for years. As far as I can tell, this > never caused problems. > > Regards > Federico > > > -------------------------------------------- > Mer 29/10/14, Rohan M C <[email protected]> ha scritto: > > Oggetto: [Maria-discuss] question regarding innodb compression > A: [email protected] > Data: Mercoledì 29 ottobre 2014, 08:36 > > Hi > all, > Due to space constraints we are considering the > innodb compression option for some of our larger tables. > We're not compressing all the tables, but only a select > few to begin with. Our current planned process for this is > to SET GLOBAL innodb_file_format=Barracuda; > create compressed table, transfer data, and switch > innodb_file_format back to Antelope. > My question is around having this mix of table > file formats in the same database. I've tried test > queries and they were fine, but is it ok to have a mix of > both Antelope and Barracuda file format tables in the db for > a production environment? > Thanks,Rohan > -----Segue allegato----- > > _______________________________________________ > Mailing list: https://launchpad.net/~maria-discuss > Post to : [email protected] > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp > > > _______________________________________________ > Mailing list: https://launchpad.net/~maria-discuss > Post to : [email protected] > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp >
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
