… exactly what happened to me). As result we have scheduled Migrating MyISAM to Innodb webinar to run again on Tuesday, December 7 at…
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: 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… 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: 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: Recordings for webinars are now online
December 9, 2010 By 6 Comments
We’ve just published the recordings for our webinars; Migrating MyISAM to InnoDB and Introduction to Percona Server, XtraDB and Xtrabackup. To…
Post: Webinar: Introduction to Percona Server, XtraDB and Xtrabackup
November 26, 2010 By 2 Comments
…’ve had such a large number of signups to our Migrating MyISAM to InnoDB webinar, that we decided to hold one more before…
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…
