Mailing List Archive

> I did notice that my tables are split about 50/50 between InnoDB and
> MyISAM and I'd like to make all of them InnoDB.
>
> - Grant


For anyone else putting off converting MyISAM tables to InnoDB, it
turns out the process is one of those delightfully simple ones:

ALTER TABLE table_name ENGINE=InnoDB;

Also the more of these conversions you make, the more you can push RAM
from key_buffer_size over to innodb_buffer_pool_size. More info here
but I didn't need any beyond the above:

http://dev.mysql.com/doc/refman/5.7/en/converting-tables-to-innodb.html

- Grant

_______________________________________________
interchange-users mailing list
interchange-users@icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users