Nice one Johan, thanks for the info. On Tue, Oct 4, 2011 at 2:17 PM, Johan De Meersman <vegiv...@tuxera.be>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 >