… this is first question I hear from customers who migrated from MyISAM to InnoDB – can I just copy .ibd files from one… source. (on destination you should have XtraDB with innodb_expand_import extension and with innodb_expand_import=1 setting) 4) run alter… in error.log like: InnoDB: import: extended import of test/img_out59 InnoDB: import: 3 indexes are detected. InnoDB: Progress in %: 1 2…
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
… but instantly break upon upgrading to Innodb. Features The MyISAM features which forbid moving to Innodb are typically Full Text Search and… 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…
Post: Data compression in InnoDB for text and blob fields
May 30, 2012 By 2 Comments
… variable-length fields than REDUNDANT. Using InnoDB’s new Barracuda file format (available since InnoDB plugin 1.1 or MySQL 5.5…!): SET GLOBAL innodb_file_format=BARRACUDA; One caveat: you must be running with innodb_file_per_table=1 as the InnoDB system tablespace… format tables you will need to create them new and migrate data, or affect existing tables with an ALTER TABLE statement…
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… also can’t be solved by simple singe counter for Innodb tables as different transactions may see different number of rows…. This can be faster or slower both for MyISAM and Innodb depending on various conditions. In real applications there are much…
Post: Migrating to XtraDB Cluster Webinar follow up questions
June 6, 2012 By 3 Comments
…: The SST does not work with rsync when the option innodb_data_home_dir is set to a different path then…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
… about loss of data, you are most likely using the InnoDB storage engine, since MyISAM is not transactional and do not…, monitoring, alerting, backups, migration to production and post migration monitoring. Of course, it is the safest way to migrate an HA solution to… way, especially for the most complex solutions. Proof of concept Migration to Production MySQL replication 4 hours 12 hours Master-Master…
Post: Power of MySQL Storage Engines
March 5, 2007 By 3 Comments
… of architecture implementation details of how it would compare to Innodb storage engine – old timer in this space. Does it add… the fixes. While Innodb was only transactional storage engine there surely was less pressure – if you’re migrating from Oracle to MySQL… consider to delay migration but if you’re already with MySQL and requiring transactions you’re stuck with Innodb if you you…
Post: Percona Live MySQL Conference and Expo 2013: The talks I want to see
February 12, 2013 By 4 Comments
… feature sets. Internals of new InnoDB features in MySQL 5.6 - (Vadim Tkachenko, Percona) – Tuning Innodb is a huge part of my… hear real-life case studies for these kinds of architectures. InnoDB Compression: Present and Future - (Nizameddin Ordulu, Justin Tolmer, Facebook) — The… PXC/Galera and give some helpful instruction about what some migration strategies might look like. Using MySQL Performance Schema to debug…
Comment: Countless storage engines
May 4, 2007 By 6 Comments
… as replacement for Innodb in many users mind. Visiting customers I often hear the question of when they should migrate to Falcon… databases. 3) Solid – this one is actually better positioned as “Innodb Replacement” as it has much more close architecture and applications… has clustering by primary key and unlike Innodb has key compression (one of major Innodb problems in my opinion). The problems with…
Comment: Heikki Tuuri to answer your in depth Innodb questions
October 3, 2007 By 51 Comments
… many table. For migrating from 4.1 to 5.1 you can also try starting MySQL 5.1/innodb on 4.1 tablespace. I’ve done migration of 1.3TB from 4.0… slave and make sure it is uptodate with master, perform migration on slave, wait until slave will catch up again, test…
