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 <federico_raz@yahoo.it>:
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 <rohanmc@gmail.com> ha scritto:
Oggetto: [Maria-discuss] question regarding innodb compression A: maria-discuss@lists.launchpad.net 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 : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp