Re: InnoDB doubles size when converting from MyIsam

2009-09-12 Thread Arthur Meeks Meeks
2009/9/13 Dan Nelson > In the last episode (Sep 12), Arthur Meeks Meeks said: > > 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 hou

Re: InnoDB doubles size when converting from MyIsam

2009-09-12 Thread Dan Nelson
In the last episode (Sep 12), Arthur Meeks Meeks said: > 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

InnoDB doubles size when converting from MyIsam

2009-09-12 Thread Arthur Meeks Meeks
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 i