Difference between revisions of "InnoDB"

From wikieduonline
Jump to navigation Jump to search
 
(8 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]] is a storage engine for the database management system [[MySQL]] and [[MariaDB]]. Is the default engine since [[MariaDB 10.2]] (2016).
  
Line 13: Line 12:
  
 
== Activities ==
 
== Activities ==
* Show [[MariaDB engines|database engine]]: <pre>show table status like '<table name>';</pre>
+
* Show [[MariaDB engines|database engine]]: <code>[[show table status like]] '<table name>';</code>
  
 
== Related commands ==
 
== Related commands ==
 +
* [[mysqldump --single-transaction]]
 
* <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>[[mariabackup]]</code>
 
* <code>[[show table status]]</code>
 
* <code>[[show table status]]</code>
 +
* <code>[[SHOW PROCESSLIST;]]</code>
 
* <code>[[show table]] status where name = "YOUR_TABLE_NAME"</code> (Includes [[engine]] type)
 
* <code>[[show table]] status where name = "YOUR_TABLE_NAME"</code> (Includes [[engine]] type)
  
Line 24: Line 26:
 
  FROM  information_schema.TABLES
 
  FROM  information_schema.TABLES
 
  WHERE  TABLE_SCHEMA = 'dbname';
 
  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 ==
 
== Activities ==
Line 30: Line 44:
 
== See also ==
 
== See also ==
 
* {{InnoDB}}
 
* {{InnoDB}}
 +
* {{MariaDB engines}}
 
* {{MariaDB}}
 
* {{MariaDB}}
* {{DBs}}
+
 
  
 
[[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: