Difference between revisions of "InnoDB"

From wikieduonline
Jump to navigation Jump to search
Tags: Mobile web edit, Mobile edit
Tags: Mobile web edit, Mobile edit
Line 17: Line 17:
 
== Related commands ==
 
== Related commands ==
 
* <code>[[mariadbcheck]]</code>, can checked InnoDB tables with CHECK TABLE, but not repaired them with REPAIR TABLE
 
* <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)
  
 
== Activities ==
 
== Activities ==

Revision as of 13:02, 10 May 2020

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

wikipedia:InnoDB


InnoDB supports:

  • Both SQL and XA transactions
  • Tablespaces
  • Foreign keys
  • Full text search indexes, since MySQL 5.6 (February 2013) and MariaDB 10.0)
  • Spatial operations, following the OpenGIS standard
  • Virtual columns, in MariaDB

Activities

  • Show database engine:
    show table status like '<table name>';


Related commands

  • 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)

Activities

  1. Read InnoDB Recovery Modes https://mariadb.com/kb/en/innodb-recovery-modes/

See also

Advertising: