In news:[EMAIL PROTECTED], "Daevid Vincent" <[EMAIL PROTECTED]> wrote:
> Because we're a huge enterprise product, with 3 databases of > 200 > tables each. > > We are migrating from MYISM to INNODB and keeping track of that value > isn't something we thought we'd need to do. Plus it seems like > something we _shouldn't_ have to do. That's WHY we use a database. Have you done any research regarding the effects of changes you are making? For example, how those two engines differ one from another, what the strenghts and weaknesses of either engine? I think not. If you did, you wouldn't be surprised by the easiest to spot difference in behaviour between MyISAM and InnoDB (and there are plenty more). RDBMS is not an Office spreadsheet, you cannot simply change software as from OpenOffice Calc to MS Excel and expect everything will work the same. The migration can be done with positive effects, but require knowledge of both products. Maciek -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]