June 18, 2013

Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL

May 1, 2013 By 10 Comments

… prevent them from moving forward. If you are thinking of migrating your workload to Percona XtraDB Cluster, make sure to go… PXC, wsrep_replicate_myisam allows you to do so. However, if you can, you should consider moving to InnoDB altogether. There are very few reasons to stay with MyISAM nowadays i.e. if you…

Filed Under: Insight for DBAs, MySQL, Percona Software, XtraDB Cluster Tagged With: , , , ,

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…

Filed Under: Events and Announcements, MySQL Tagged With:

Post: Should you move from MyISAM to Innodb ?

January 12, 2009 By 59 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…

Filed Under: Insight for DBAs Tagged With: , ,

Post: COUNT(*) for Innodb Tables

December 1, 2006 By 32 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…

Filed Under: Insight for Developers Tagged With: ,

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

… to using MyISAM are far outweighed by the potential disadvantages and the strengths of InnoDB. However, up until MySQL 5.6, MyISAM was… would be a migration to InnoDB, but due to their use of MyISAM FTS, the idea of a complete or partial migration was, for… the MyISAM default. After all, the (naive?) hope here is that when I run an FTS query against both MyISAM and InnoDB I…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

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…

Filed Under: Insight for Developers Tagged With: ,

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…

Filed Under: Events and Announcements, MySQL Tagged With: , ,

Post: Concatenating MyISAM files

November 19, 2012 By 5 Comments

Recently, I found myself involved in the migration of a large read-only InnoDB database to MyISAM (eventually packed). The only issue was… small… I calculated that with something like insert into MyISAM_table… select * from Innodb_table… would take about 10 days. The bottleneck…

Filed Under: MySQL

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…

Filed Under: Events and Announcements, MySQL Tagged With: , , ,

Post: Migrating several single standalone MySQL server to one Percona XtraDB Cluster... MariaDB to the rescue !

December 18, 2012 By 3 Comments

…there was one major issue, the tables where MyISAM and this is not really recommended with …be the dedicated slave convert the table in InnoDB configure and start the replication finally perform …server. It worked like a charm and the migration of production to Percona XtraDB Cluster became very …

Filed Under: MySQL
« Older Posts