From: Johan De Meersman Date: May 22 2012 1:30pm Subject: Re: Reducing ibdata1 file size List-Archive: http://lists.mysql.com/mysql/227504 Message-Id: <2824e8f4-d303-4546-ab1c-ba51c39cd6b8@zimbra> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit ----- Original Message ----- > From: "Jan Steinman" > > That's been the common wisdom for a long time. > > However, this just popped up on my RSS reader. I haven't even looked > at it, let alone tried it. In brief: convert all your tables to myisam, delete ibdatafile during a restart, convert tables back to compressed innodb. My first thought is mentioned, but "will be adressed in next post": you lose your relations. I gotta run now, but I wonder what other incompatibilities between the engines one might run into. For simple databases this would probably work, though. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel