Register now for a free Percona webinar about migrating your MyISAM databases to InnoDB. Save the date: Dec 1, 2010 at 9:00… such webinar. With the change in default storage engine from MyISAM to InnoDB in the upcoming MySQL 5.5 release, we expect… wanting to learn more about the benefits of switching to InnoDB, as well as topics such as: What kind of contraindications…
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 53 Comments
… when you’re running MyISAM but instantly break upon upgrading to Innodb. Features The MyISAM features which forbid moving to Innodb are typically Full… 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: 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: What to do with MySQL Full Text Search while migrating to Innodb ?
September 10, 2009 By 12 Comments
… rather typical for systems to start as MyISAM but as system growths to move to Innodb. The reason of the move could… during migration is Full Text Search indexes which are not supported for Innodb tables. So what can you do ? Leave Tables as MyISAM… the evils. Use “Shadow” MyISAM Table You can keep main data in Innodb but build a “shadow” MyISAM table which is used for…
Post: Moving from MyISAM to Innodb or XtraDB. Basics
November 22, 2010 By 2 Comments
… 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… for MyISAM and Innodb – it is possible to have some rows which can be stored in MyISAM but would not fit to Innodb, though… data in MyISAM. The 3 most important values to check are innodb_flush_log_at_trx_commit, innodb_buffer_pool_size and innodb_log…
Post: Doing Re-run of Migrating MyISAM to Innodb Webinar
December 1, 2010 By 9 Comments
… exactly what happened to me). As result we have scheduled Migrating MyISAM to Innodb webinar to run again on Tuesday, December 7 at…
Post: Impossible - possible, moving InnoDB tables between servers
June 8, 2009 By 9 Comments
… most from early days when I started to use InnoDB instead of 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…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
… of data, you are most likely using the InnoDB storage engine, since MyISAM is not transactional and do not sync data to… with MMM manager” Don’t use any special MyISAM feature All Can change MyISAM Full text to Sphinx All 4. What is…, monitoring, alerting, backups, migration to production and post migration monitoring. Of course, it is the safest way to migrate an HA solution to…
Post: Power of MySQL Storage Engines
March 5, 2007 By 3 Comments
… figuring out between MyISAM and Innodb and if they do they use some generic (and very wrong) ideas such as “MyISAM is always… the fixes. While Innodb was only transactional storage engine there surely was less pressure – if you’re migrating from Oracle to MySQL you of course may consider to delay migration but if you’re already…
Comment: Rendundant Array of Inexpensive Servers
August 21, 2008 By 15 Comments
…, a year apart…). #2 is planned outages (install bigger disk, migrate to a new host, attach to SAN, etc). #3 is… in 1 week, 2 years ago, running MyISAM). We’ve since switched to InnoDB and haven’t seen any non-human-driven…. Apart from the datafile corruption a couple of years ago (MyISAM under very heavy load), we haven’t seen any failures…
