Re: Migrating my mindset from MyISAM to InnoDB

2010-09-29 Thread Hank
> 2.  Don't stare at the screen.  Start it, script the process & have it email > your phone when it's done.  Do something else in the mean time. I don't literally stare at the screen -- of course I script it and do other things.. but when I have a resource limited environment, it sure would be ni

Re: Migrating my mindset from MyISAM to InnoDB

2010-09-29 Thread Dan Nelson
In the last episode (Sep 28), Gavin Towey said: > Also note, 5.5 isn't production ready. 5.1 is the current GA release. 5.5 is really really close, though (5.5.6 is marked as Release Candidate), Better to switch now while you're already doing a migration, and then install 5.5.x updates as they ha

RE: Migrating my mindset from MyISAM to InnoDB

2010-09-28 Thread Gavin Towey
Also note, 5.5 isn't production ready. 5.1 is the current GA release. -Original Message- From: Hank [mailto:hes...@gmail.com] Sent: Tuesday, September 28, 2010 3:29 PM To: mysql@lists.mysql.com Subject: Migrating my mindset from MyISAM to InnoDB Primarily due to many positive

RE: Migrating my mindset from MyISAM to InnoDB

2010-09-28 Thread Gavin Towey
Hank [mailto:hes...@gmail.com] Sent: Tuesday, September 28, 2010 3:29 PM To: mysql@lists.mysql.com Subject: Migrating my mindset from MyISAM to InnoDB Primarily due to many positive posts I've seen about MySQL 5.5 and advances in InnoDB, I'm seriously considering converting all my MyISAM data

Migrating my mindset from MyISAM to InnoDB

2010-09-28 Thread Hank
Primarily due to many positive posts I've seen about MySQL 5.5 and advances in InnoDB, I'm seriously considering converting all my MyISAM databases to InnoDB.   I don't need many of the InnoDB features, but if I'm going to upgrade from 4.1.14 to 5.5, I might as well bit the bullet since that seems