Difference between revisions of "InnoDB"

Revision as of 13:04, 10 May 2020

This article is a Draft. Help us to complete it.

InnoDB supports:

mariadbcheck, can checked InnoDB tables with CHECK TABLE, but not repaired them with REPAIR TABLE
show table status where name = "YOUR_TABLE_NAME" (Includes engine type)

SELECT TABLE_NAME,
      ENGINE
FROM   information_schema.TABLES
WHERE  TABLE_SCHEMA = 'dbname';

@@ Line 18: / Line 18: @@
 * <code>[[mariadbcheck]]</code>, can checked InnoDB tables with CHECK TABLE, but not repaired them with REPAIR TABLE
 * <code>[[show table]] status where name = "YOUR_TABLE_NAME"</code> (Includes [[engine]] type)
+ SELECT TABLE_NAME,
+       ENGINE
+ FROM   information_schema.TABLES
+ WHERE  TABLE_SCHEMA = 'dbname';
 == Activities ==