Ocean West Posted February 27, 2015 Share Posted February 27, 2015 Looking for step by step guide to convert my database to InnoDB.And should this be done in 3x or wait till after I upgrade to 4? Link to comment Share on other sites More sharing options...
sobrenome Posted February 27, 2015 Share Posted February 27, 2015 After many headaches for altering the tables, this was the best way for me:It hasn't been mentioned yet, so I'll write it for posterity: If you're migrating between DB servers (or have another reason you'd dump and reload your dta), you can just modify the output from mysqldump: mysqldump --no-data DBNAME | sed 's/ENGINE=MyISAM/ENGINE=InnoDB/' > my_schema.sql; mysqldump --no-create-info DBNAME > my_data.sql; Then load it again: mysql DBNAME < my_schema.sql && mysql DBNAME < my_data.sql (Also, in my limited experience, this can be a much faster process than altering the tables ‘live’. It probably depends on the type of data and indexes.)http://stackoverflow.com/questions/3856435/how-to-convert-all-tables-from-myisam-into-innodb Link to comment Share on other sites More sharing options...
Gabriel Torres Posted February 28, 2015 Share Posted February 28, 2015 One thing you have to have in mind before moving is that InnoDB/ExtraDB uses more server resources than MyISAM, namely more CPU load and more RAM. You have to make sure you have enough available RAM in particular.That said, InnoDB/ExtraDB is a must for performance reasons.After migration, you will also need to make several fine-tunings to your my.cnf file. Link to comment Share on other sites More sharing options...
RevengeFNF Posted February 28, 2015 Share Posted February 28, 2015 Another thing, if you do not have Sphinx installed or do not feel conformable installing and setup it, you should wait for IPS4 to convertet your tables to innodb. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.