[ic] Time for new hardware?

Grant emailgrant at gmail.com
Thu Oct 6 15:42:31 UTC 2016


> 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



More information about the interchange-users mailing list