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 posts I've

RE: Migrating my mindset from MyISAM to InnoDB

2010-09-28 Thread Gavin Towey
1. Generally reducing fragmentation in the data/index files will reduce the footprint of tables on disk, and can be more efficient to query. With innodb you need to be using the innodb-file-per-table option, and then you can use OPTIMIZE TABLE table; to rebuild it. You don't get detailed progr