Quick question… does the pt-online-schema-change tool work at tables using the MyISAM storage engine? Would it work to convert a table from MyISAM to InnoDB?
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
March 29, 2012 By 28 Comments
… article! It is just what I needed to convert a 330GB MyISAM database to InnoDB with reasonable effort. I have tested your Perl…
Post: Quick tip: how to convert tables to InnoDB
July 30, 2008 By 4 Comments
… a bazillion tables to convert from MyISAM to InnoDB, but they are mixed in with other tables that are already InnoDB, or are another storage engine that you don’t want to touch. mk-find –engine MyISAM –exec “ALTER TABLE %D.%N ENGINE=INNODB” –print Here’s a bonus tip, while…
Post: InnoDB in self-compiled MySQL 5.1
September 13, 2007 By 9 Comments
… of InnoDB from previous version: mysql testdatabase < dump.sql I bet you will not notice all your tables now is MyISAM. Why… | YES | CSV storage engine | NO | NO | NO | | MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO | | MEMORY | YES | Hash based… want to see is BIG Warning or even Error that InnoDB table can’t be created instead of calm converting to MyISAM
Post: Moving from MyISAM to Innodb or XtraDB. Basics
November 22, 2010 By 2 Comments
… are some feature differences between MyISAM and Innodb though well it is typically easily spotted by converting tables to Innodb on restored backup. Full… stored in MyISAM but would not fit to Innodb, though this is an exception. Space Innodb Tables tend to be larger. Again converting schema…
Post: Using CHAR keys for joins, how much is the overhead ?
June 18, 2007 By 18 Comments
… about Innodb ? Innodb executed the same query in 2.9 seconds which was a bit disappointing for me as I expected MyISAM to… more. The next test I decided to do is to convert Innodb table to latin1 character set. I was expected this to… can range from few percent to couple of times for Innodb tables MyISAM Tables may suffer significantly if key compression is not…
Post: Recovering Innodb table Corruption
July 4, 2008 By 19 Comments
… Innodb tablespace got corrupted. In such cases Innodb will typically print something like this: InnoDB: Database page corruption on disk or a failed InnoDB: file read of page 7. InnoDB… MyISAM table so all you have to do is to drop old table and convert new table back to Innodb after restarting without innodb…
Post: Pitfalls of converting to InnoDB
February 25, 2007 By 16 Comments
We often recommend to our clients to convert their current database from MyISAM tables to InnoDB. The transfer by itself in most cases… the idea. Also there is script we are using for converting databases with many tables, maybe it will be useful for… “Converting table $t” mysql -u$DBUSER -p$DBPWD -e “alter table $t type=InnoDB” $DBNAME; done There is the standard script mysql_convert…
Post: MyISAM Scalability and Innodb, Falcon Benchmarks
October 12, 2007 By 10 Comments
… was converting table t1 into InnoDB, and results: Threads Queries/sec 1 296 2 341 4 544 8 493 16 498 InnoDB both… when single query executed being 1/3rd of MyISAM and 1/6th of Innodb. On other hand it scales quite nicely as…. Here is comparison of MyISAM Innodb and Falcon results in the graphical form: I’ve created bug, for MyISAM key cache contention issue…
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… do ? Leave Tables as MyISAM The beauty of MySQL storage engines is you do not have to convert all tables at once… the evils. Use “Shadow” MyISAM Table You can keep main data in Innodb but build a “shadow” MyISAM table which is used for…
