From: Andrew Moore Date: October 4 2011 1:19pm Subject: Re: A tidbit for those of us who want to play with InnoDB compression List-Archive: http://lists.mysql.com/mysql/225915 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=000e0cd25b3ee8f8b004ae78f16b --000e0cd25b3ee8f8b004ae78f16b Content-Type: text/plain; charset=ISO-8859-1 Nice one Johan, thanks for the info. On Tue, Oct 4, 2011 at 2:17 PM, Johan De Meersman wrote: > As noted in the title, I'm messing about a bit with InnoDB compressed > tables. As such, I found a rather glaring hole in the Internet: how the hell > do you turn compression off again? :-D > > After messing about a lot and googling until my fingers hurt, I happened > upon this bug report: http://bugs.mysql.com/bug.php?id=56628 > > So, you turn compression on a table off by: > > set session innodb_strict_mode=off; > alter table YOURTABLEHERE engine=InnoDB row_format=compact > key_block_size=0; > > Of course, if you're running 5.1.55+ or 5.5.9+, you'll not need to tinker > with your innodb_strict_mode ; but it's still a glaring hole in the > documentation. > > -- > Bier met grenadyn > Is als mosterd by den wyn > Sy die't drinkt, is eene kwezel > Hy die't drinkt, is ras een ezel > --000e0cd25b3ee8f8b004ae78f16b--