Difference between revisions of "InnoDB"

From wikieduonline
Jump to navigation Jump to search
(* Page compression <ref>https://mariadb.com/kb/en/innodb-page-compression/</ref>)
Tags: Mobile web edit, Mobile edit
Tags: Mobile web edit, Mobile edit
Line 30: Line 30:
  
 
== See also ==
 
== See also ==
 +
* {{MariaDB}}
 
* {{DBs}}
 
* {{DBs}}
 
* [[primary keys]]
 
* [[primary keys]]

Revision as of 11:43, 25 August 2020

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

wikipedia:InnoDB is a storage engine for the database management system MySQL and MariaDB. Is the default engine since MariaDB 10.2


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
  • Page compression [1]

Activities

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


Related commands

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

Activities

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

See also

  • https://mariadb.com/kb/en/innodb-page-compression/
  • Advertising: