… unable to join at the time of event (which is frankly exactly what happened to me). As result we have scheduled Migrating MyISAM to Innodb webinar to run again on Tuesday, December 7 at 9AM Pacific (Same Time). Here is direct link if you would like to…
Post: Moving from MyISAM to Innodb or XtraDB. Basics
November 22, 2010 By 2 Comments
… free webinar on migrating MyISAM to Innodb or some other reason but recently I see a lot of questions about migration from MyISAM to Innodb. Webinar will cover the process in a lot more details though I would like to go over…
Post: Webinar: MyISAM to InnoDB migration
November 8, 2010 By 4 Comments
Register now for a free Percona webinar about migrating your MyISAM databases to InnoDB. Save the date: Dec 1, 2010 at 9:00 AM… engine from MyISAM to InnoDB in the upcoming MySQL 5.5 release, we expect that a lot of users will be wanting to learn more about the benefits of switching to InnoDB, as well as topics such as…
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 53 Comments
… you when you’re running MyISAM but instantly break upon upgrading to Innodb. Features The MyISAM features which forbid moving to Innodb are typically Full Text… use MyISAM (or Archive) for logging. Innodb Needs Tuning As a final note about MyISAM to Innodb migration I should mention about Innodb tuning. Innodb needs tuning. Really. MyISAM…
Post: Webinar: Introduction to Percona Server, XtraDB and Xtrabackup
November 26, 2010 By 2 Comments
… signups to our Migrating MyISAM to InnoDB webinar, that we decided to hold one more before the year is out: December, 8th 9AM PST: Introduction to Percona… the main aspects that change, and where you can expect to get the most benefit. This will be a technical talk…
Post: What to do with MySQL Full Text Search while migrating to Innodb ?
September 10, 2009 By 12 Comments
It is rather typical for systems to start as MyISAM but as system growths to move to Innodb. The reason of the move could be just desire for better data consistency guaranty or being bitten repairing multiple GB MyISAM… helpful if migration has to be performed very quickly and it takes a lot of time to implement any significant changes to schema or…
Post: COUNT(*) for Innodb Tables
December 1, 2006 By 29 Comments
I guess note number one about MyISAM to Innodb migration is warning what Innodb is very slow in COUNT(*) queries. The part which I … for MyISAM (MEMORY and some others) tables because they would simply read number of rows in the table from stored value. Innodb… both for MyISAM and Innodb tables by performing index rage scan. This can be faster or slower both for MyISAM and Innodb depending on…
Post: Impossible - possible, moving InnoDB tables between servers
June 8, 2009 By 9 Comments
… MyISAM. Since that I figured out how to survive without it, but this is first question I hear from customers who migrated from MyISAM to InnoDB – can I just copy .ibd files from one server to another and answer “use mysqldump…
Post: Recordings for webinars are now online
December 9, 2010 By 6 Comments
… published the recordings for our webinars; Migrating MyISAM to InnoDB and Introduction to Percona Server, XtraDB and Xtrabackup. To listen, click on (Watch: Recorded Webinar… next year. If you have any suggestions, feel free to leave a comment.
Post: Power of MySQL Storage Engines
March 5, 2007 By 3 Comments
…MyISAM and Innodb and if they do they use some generic (and very wrong) ideas such as “MyISAM…to customer winning. When Falcon looses to Innodb in certain cases it makes Jim to try harder, if Heikki sees Innodb… you’re migrating from Oracle to MySQL you of course may consider to delay migration but if…
