Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

share|improve this question
up vote 4 down vote accepted

In the information_schema database:


That'll tell you which database and tables.

share|improve this answer
select table_schema, table_name from
information_schema.tables where engine='innodb';
share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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