I am leading a project which has us (among other things) migrating around 4T of data from Mysql 4.0.18 to 5.x.. we are currently targeting 5.0.27 which seems to be holding up fairly well, although we still having some issues in a couple of places.
Having put our migration suite through it's many paces (5 distinct target hosts, multiple databases on each) we have found a few issues which we have generally been able to address by refactoring our code, reducing the load of any given query or upgrading to the latest publicly available patch. It has been suggested by our systems staff that InnoDB table type is inherently unstable under MySql 5.x.and MyIsam presents the only stable route. Who else out there is dealing with very large amounts of data under high load and InnoDB who would care to share some heart-warming stories about how well InnoDB is working out under those circumstances? Horror stories are also invited... please embellish with version numbers and any interesting platform notes you might have. Our particular albatross is that we are trying to do this on a combination of of PPC and Intel Macs under OSX 10.4.4 Any input, comments or sympathy cards accepted. -- - michael dykman - [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
