Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

2 Answers 2

up vote 4 down vote accepted

In the information_schema database:

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

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

 
discard

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.