Thank you. I know how to migrate tables using ALTER TABLE - my question has
more to do with *whether* I should migrate. For smaller databases (10mb in
size) is it really beneficial? Details in my original post quoted below.
> -----Original Message-----
> From: mfatene@stripped [mailto:mfatene@stripped]
> Sent: Tuesday, June 14, 2005 7:00 PM
> To: Stembridge, Michael
> Cc: mysql@stripped
> Subject: Re: Considering migration from MyISAM to InnoDB
> see the my.cnf examples in the install dir, and look at innodb* variables.
> you can migrate each table just using :
> alter table toto engine=innodb;
> Selon "Stembridge, Michael" <MStembridge@stripped>:
> > I currently use MyISAM on an internal web application server; our data
> > up 10mb at this time, though this is likely to grow substantially in the
> > coming year. The database sees moderate heavy read and moderate write
> > from 50 users.
> > We're upgrading our sever from Red Hat 7.3 to SuSE Linux Enterprise 9.0
> > and have considered migrating to InnoDB as part of our upgrade. I
> > the performance increases I've seen documented here
> > http://www.innodb.com/bench.php, though I'm not sure our environment
> > for InnoDB. Thoughts?