← Back to team overview

maria-discuss team mailing list archive

R: question regarding innodb compression


I had a mix of Antelope/Barracuda for years. As far as I can tell, this never caused problems.


Mer 29/10/14, Rohan M C <rohanmc@xxxxxxxxx> ha scritto:

 Oggetto: [Maria-discuss] question regarding innodb compression
 A: maria-discuss@xxxxxxxxxxxxxxxxxxx
 Data: Mercoledì 29 ottobre 2014, 08:36
 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?
 -----Segue allegato-----
 Mailing list: https://launchpad.net/~maria-discuss
 Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
 Unsubscribe : https://launchpad.net/~maria-discuss
 More help   : https://help.launchpad.net/ListHelp

Follow ups