[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