MariaDB - covert MyISAM engine to InnoDB
Posted: 12 Sep 2022 13:22
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.
The result is:
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
(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' ;Code: Select all
+------------+--------------+--------+
| table_name | table_schema | engine |
+------------+--------------+--------+
| tokens | efa | MyISAM |
+------------+--------------+--------+
BR Andreas