MySQL: How To Show All Tables Running INNODB Engine

Article By: daniel Dhar


img

mysql innodb myisam engine

mysql server

This short tutorial will show you how to show all database tables running INNODB engine on a mysql server.

Login into MySQL

mysql> use mysql;
mysql> SELECT table_schema, table_name, engine FROM INFORMATION_SCHEMA.TABLES WHERE engine = 'innodb';
Results:
+--------------+-----------------------+--------+
| table_schema | table_name            | engine |
+--------------+-----------------------+--------+
| pdns         | domains               | InnoDB |
| pdns         | records               | InnoDB |
| pdns         | supermasters          | InnoDB |
| pdns         | zone_templ            | InnoDB |
| pdns         | zone_templ_records    | InnoDB |
| pdns         | zones                 | InnoDB |
| vmails       | vacation              | InnoDB |
| vmails       | vacation_notification | InnoDB |
+--------------+-----------------------+--------+
8 rows in set (0.00 sec)

In my next MySQL post I'll look at how the INNODB storage engine by default puts all the tables into a single file called ibdata1 and how you can change the default to have a single file per table in the same way that the MyISAM storage engine does. For more information on Server Commands or any other topics of interest search the CLC Community Learning Center.




Tags: , , , , , , ,


Welcome to the healthcare-only HIPAA - GDPR compliant cloud. Exclusively hosted on a HPC environment!

Learn more or start today by choosing your secure HIPAA - GDPR compliant server's Operating System bellow and pick the package that's best for you.

BIPmd makes it simple to launch in the cloud and scale up as you grow – whether you’re running one virtual machine, thousand or more.



Windows VPS options and add ons
Linux VPS options and add ons

>

Looking for a custom solution?

Our technicians can provide you with the best custom-made solutionss on the market, no matter whether you're a small business or large enterprise.

Get in touch

Leave a Reply



Feedbacks