From: Arthur Meeks Meeks
Date: September 12 2009 7:50pm
Subject: InnoDB doubles size when converting from myisam
List-Archive: http://lists.mysql.com/innodb/7
Message-Id: <23a09a180909121250r686847ebp2e7278d808b9e835@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=0016e6dbeaa6937abb047366be24

--0016e6dbeaa6937abb047366be24
Content-Type: text/plain; charset=ISO-8859-1

Hello,

I have a database with about 1000 tables and 150GB. I have done a simple
"for f in $(cat tables); do mysql -uuser -ppassword database_name -e "alter
table $f engine=InnoDB;" ; done

I took about 3 hours and everything went fine, but I just realised that the
same database in another server in myisam is about 150GB and in the server
where I converted it to innodb it's about 350GB.

Is that normal?

Thanks in advance
A

--0016e6dbeaa6937abb047366be24--