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?
Post: Quick tip: how to convert tables to InnoDB
July 30, 2008 By 4 Comments
… this quick tip. Suppose you have 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…
Post: What to do with MySQL Full Text Search while migrating to Innodb ?
September 10, 2009 By 12 Comments
… systems to start as MyISAM but as system growths to move to Innodb. The reason …Innodb tables. So what can you do ? Leave Tables as MyISAM The beauty of MySQL storage engines is you do not have to convert…to be performed very quickly and it takes a lot of time to implement any significant changes to…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… over every option in the file. But again, you learn quickly if something strange is here. This whole time I’ve… minimum of the two is used to determine when an in-memory temporary table will be converted to an on-disk table, which… status, which might be an indication that it’s time to convert MyISAM tables to InnoDB. (But then again, it might not be.) Or maybe…
Post: Using MyISAM in production
June 17, 2006 By 35 Comments
… of rows in tens of thousands tables) Innodb was better choice mainly because of thouse …application. As load increases you might convert certain tables to MyISAM and other storage engines for performance …anyway. Tables which contain data which is quick to regenerate Generally tables which you can …
Post: What exactly is read_rnd_buffer_size
July 24, 2007 By 4 Comments
…can be converted to fixed size (basically everything but BLOB/TEXT) MySQL can use read_rnd_buffer to … it is unlikely to help as MySQL will stop fetching rows by pointers quickly For me … presentation. We should do benchmarks sometime to see how it really impacts performance both for MyISAM and Innodb…
Comment: Pitfalls of converting to InnoDB
February 26, 2007 By 16 Comments
Here is a quick shell script to convert all tables in a database to InnoDB. No dependancies other than a command line prompt on a… type=innodb” test; done Replace “test” with the target database. This pattern is also great for optimizing or analyzing your MyISAM tables…
Post: Living with backups
November 6, 2008 By 28 Comments
…to wait much longer until disk operations are scheduled and executed which converts…for MyISAM tables which have dedicated buffers only to store… stops responding to the incoming queries quick enough. What…to be divisible by 4096 in order to read it right. Even though it’s always the case for InnoDB…
