Difference between revisions of "InnoDB"

From wikieduonline
Jump to navigation Jump to search
Line 4: Line 4:
  
 
InnoDB supports:
 
InnoDB supports:
* Both SQL and XA transactions
+
* Both SQL and XA [[transactions]]
 
* [[Tablespaces]]
 
* [[Tablespaces]]
 
* [[Foreign keys]]
 
* [[Foreign keys]]

Revision as of 12:30, 5 May 2021

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:

Activities

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: