2

I have a mysql server and I want to disable innodb support for it.

It's said that I can cut-off my memory usage up to 100MB.

I'm pretty sure but not 100% sure, that there is no innodb tables in the server.

Is there a easy way to be 100% sure that there is no innodb tables in the server so I can disable innodb support safely

4

In the information_schema database:

SELECT * FROM `TABLES` WHERE `ENGINE` LIKE 'InnoDB'

That'll tell you which database and tables.

2
select table_schema, table_name from
information_schema.tables where engine='innodb';

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.