Difference between revisions of "InnoDB"

From wikieduonline
Jump to navigation Jump to search
Tags: Mobile web edit, Mobile edit
(13 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
{{Draft}}
 
{{Draft}}
[[wikipedia:InnoDB]]
+
[[wikipedia:InnoDB]] is a storage engine for the database management system [[MySQL]] and [[MariaDB]]. Is the default engine since [[MariaDB 10.2]] (2016).
  
  
 
InnoDB supports:
 
InnoDB supports:
* Both SQL and XA transactions
+
* Both SQL and XA [[transactions]]
 
* [[Tablespaces]]
 
* [[Tablespaces]]
 
* [[Foreign keys]]
 
* [[Foreign keys]]
Line 10: Line 10:
 
* Spatial operations, following the OpenGIS standard
 
* Spatial operations, following the OpenGIS standard
 
* Virtual columns, in [[MariaDB]]
 
* Virtual columns, in [[MariaDB]]
 +
* Page compression <ref>https://mariadb.com/kb/en/innodb-page-compression/</ref>
  
 
== Activities ==
 
== Activities ==
* Show database engine: <pre>show table status like '<table name>';</pre>
+
* Show [[MariaDB engines|database engine]]: <pre>show table status like '<table name>';</pre>
 
 
  
 
== 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]]</code>
 +
* <code>[[SHOW PROCESSLIST;]]</code>
 +
* <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 ==
 
== Activities ==
# Read https://mariadb.com/kb/en/repair-table/
+
# Read InnoDB Recovery Modes https://mariadb.com/kb/en/innodb-recovery-modes/
  
 
== See also ==
 
== See also ==
 +
* {{InnoDB}}
 +
* {{MariaDB}}
 
* {{DBs}}
 
* {{DBs}}
* [[primary keys]]
 
 
  
 
[[Category:Databases]]
 
[[Category:Databases]]

Revision as of 18:18, 4 June 2022

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 (2016).


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: