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.
Thanks again, Michael > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Tuesday, June 14, 2005 7:00 PM > To: Stembridge, Michael > Cc: mysql@lists.mysql.com > 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; > > Mathias > > > Selon "Stembridge, Michael" <[EMAIL PROTECTED]>: > > > I currently use MyISAM on an internal web application server; our data > takes > > 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 > usage > > from 50 users. > > > > We're upgrading our sever from Red Hat 7.3 to SuSE Linux Enterprise 9.0 > soon > > and have considered migrating to InnoDB as part of our upgrade. I > like > > the performance increases I've seen documented here > > http://www.innodb.com/bench.php, though I'm not sure our environment > calls > > for InnoDB. Thoughts? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
