MariaDB - covert MyISAM engine to InnoDB

General eFa discussion
Post Reply
ajmind
Posts: 53
Joined: 28 Mar 2017 15:26

MariaDB - covert MyISAM engine to InnoDB

Post by ajmind »

Due to some difficulties with my current used eFa box I had to recover corrupt databases.
(What has happend is not clear to me as my VM was always properly shutdown (?), but it was claimed in the log that some logs were in the future...)

That said Iam now looking closer into this part of eFa and have found advise to not use any MyISAM based tables and to covert them into InnoDB tables.

Code: Select all

SELECT table_name, table_schema, engine FROM information_schema.tables WHERE engine = 'MyISAM' AND table_schema <> 'mysql' ;
The result is:

Code: Select all

  
+------------+--------------+--------+
| table_name | table_schema | engine |
+------------+--------------+--------+
| tokens     | efa          | MyISAM |
+------------+--------------+--------+
So my question is simple: Should I do this, convert this table? As I am not an expert on this topic I am seeking herwith advise.

BR Andreas
User avatar
pdwalker
Posts: 1553
Joined: 18 Mar 2015 09:16

Re: MariaDB - covert MyISAM engine to InnoDB

Post by pdwalker »

Feel free to convert it to InnoDB. It will do no harm.
Post Reply