Convert InnoDB Tables to MyISAM

I have been trying to optimize my 256 MB slice from slicehost. One of the strategies is to not use the InnoDB SQL engine for your tables and instead use MyISAM. If you need transactions or foreign key support you should not do this.

I came across this snippet: SELECT CONCAT('ALTER TABLE ',table_schema,'.',table_name,' engine=MyISAM;') FROM information_schema.tables WHERE engine = 'InnoDB';

It seems to have worked. Maybe I'll provide an article or tutorial in the future on benchmarking your slice.

If you made it this far, you should follow me on Twitter.

-JP

comments powered by Disqus