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: 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: 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: 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: 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…
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: Using MyISAM in production
June 17, 2006 By 35 Comments
… application (storing billions of rows in tens of thousands tables) Innodb was better choice mainly because of thouse other behaviors … well… performance for small application. As load increases you might convert certain tables to MyISAM and other storage engines for performance reasons…. of…
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
