0
votes

We noticed that in our MySQL RDS the following message appeared in the event log:

DB Instance contains MyISAM tables that have not been migrated to InnoDB. These tables can impact your ability to perform point-in-time restores. Consider converting these tables to InnoDB.

Being that, we checked all the schemas and found no table in MyISAM.

How to convert a table that we didn't find?

What could be happening?

Is there any way to check if there is a hidden table?

Thanks in advance, everyone.

1

1 Answers

1
votes

You can use this to detect, if there are any MyISAM tables

SELECT
    table_schema AS DATABSE_NAME,
    table_name
FROM
    information_schema.tables 
WHERE
     engine = 'MyISAM'
     and table_type = 'BASE TABLE'
     and table_schema not in ('information_schema', 'sys',
                               'performance_schema','mysql')
ORDER BY 
   table_schema, table_name;