Difference between revisions of "InnoDB"

From wikieduonline
Jump to navigation Jump to search
(Created page with "{{Draft}} wikipedia:InnoDB == See also == * {{DBs}} Category:Databases")
 
(20 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:
 +
* 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 <ref>https://mariadb.com/kb/en/innodb-page-compression/</ref>
 +
 +
== Activities ==
 +
* Show [[MariaDB engines|database engine]]: <pre>show table status like '<table name>';</pre>
 +
 +
== Related commands ==
 +
* <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 ==
 +
# Read InnoDB Recovery Modes https://mariadb.com/kb/en/innodb-recovery-modes/
  
 
== See also ==
 
== See also ==
 +
* {{InnoDB}}
 +
* {{MariaDB}}
 
* {{DBs}}
 
* {{DBs}}
 
  
 
[[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: