Difference between revisions of "InnoDB"

From wikieduonline
Jump to navigation Jump to search
 
(27 intermediate revisions by 3 users not shown)
Line 1: Line 1:
{{Draft}}
+
[[wikipedia:InnoDB]] is a storage engine for the database management system [[MySQL]] and [[MariaDB]]. Is the default engine since [[MariaDB 10.2]] (2016).
[[wikipedia:InnoDB]]
 
  
  
 
InnoDB supports:
 
InnoDB supports:
* Both SQL and XA transactions
+
* Both SQL and XA [[transactions]]
 
* [[Tablespaces]]
 
* [[Tablespaces]]
 
* [[Foreign keys]]
 
* [[Foreign keys]]
Line 10: Line 9:
 
* 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 ==
 +
* Show [[MariaDB engines|database engine]]: <code>[[show table status like]] '<table name>';</code>
 +
 +
== Related commands ==
 +
* [[mysqldump --single-transaction]]
 +
* <code>[[mariadbcheck]]</code>, can checked InnoDB tables with CHECK TABLE, but not repaired them with REPAIR TABLE
 +
* <code>[[mariabackup]]</code>
 +
* <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';
 +
 +
== Errors ==
 +
[[/var/log/mysql/error.log (MariaDB)]]
 +
2022-12-15 19:18:32 0 [ERROR] InnoDB: preallocating 12582912 bytes for file ./ibtmp1 failed with error 28
 +
2022-12-15 19:18:32 0 [ERROR] InnoDB: Could not set the file size of './ibtmp1'. Probably out of disk space
 +
2022-12-15 19:18:32 0 [ERROR] InnoDB: Unable to create the shared innodb_temporary
 +
2022-12-15 19:18:32 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
 +
2022-12-15 19:18:37 0 [ERROR] Plugin 'InnoDB' init function returned error.
 +
2022-12-15 19:18:37 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
 +
2022-12-15 19:18:37 0 [ERROR] Unknown/unsupported storage engine: InnoDB
 +
2022-12-15 19:18:37 0 [ERROR] Aborting
 +
2022-12-15 19:21:06 35 [ERROR] mysqld: Table './xxxxx/[[searchindex]]' [[is marked as crashed and should be repaired]]
 +
 +
== Activities ==
 +
# Read InnoDB Recovery Modes https://mariadb.com/kb/en/innodb-recovery-modes/
  
 
== See also ==
 
== See also ==
* {{DBs}}
+
* {{InnoDB}}
 +
* {{MariaDB engines}}
 +
* {{MariaDB}}
  
  
 
[[Category:Databases]]
 
[[Category:Databases]]

Latest revision as of 06:31, 9 June 2024

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[edit]

Advertising: