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

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.