Difference between revisions of "InnoDB"
Jump to navigation
Jump to search
↑ https://mariadb.com/kb/en/innodb-page-compression/
Tags: Mobile web edit, Mobile edit |
|||
| (8 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
{{Draft}} | {{Draft}} | ||
| − | [[wikipedia:InnoDB]] is a storage engine for the database management system MySQL and [[MariaDB]]. Is the default engine since [[MariaDB 10.2]] | + | [[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 17: | Line 17: | ||
== 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>[[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 29: | Line 43: | ||
== See also == | == See also == | ||
| + | * {{InnoDB}} | ||
| + | * {{MariaDB engines}} | ||
* {{MariaDB}} | * {{MariaDB}} | ||
| − | |||
| − | |||
[[Category:Databases]] | [[Category:Databases]] | ||
Latest revision as of 12:08, 19 February 2023
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:
- 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 [1]
Activities[edit]
- Show database engine:
show table status like '<table name>';
Related commands[edit]
mariadbcheck, can checked InnoDB tables with CHECK TABLE, but not repaired them with REPAIR TABLEmariabackupshow table statusSHOW PROCESSLIST;show table status where name = "YOUR_TABLE_NAME"(Includes engine type)
SELECT TABLE_NAME,
ENGINE
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'dbname';
Errors[edit]
/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[edit]
- Read InnoDB Recovery Modes https://mariadb.com/kb/en/innodb-recovery-modes/
See also[edit]
- InnoDB, InnoDB purge worker
- MariaDB engines: MyISAM, Aria, InnoDB, XtraDB,
show engines; - MariaDB:
mariadbcheck,mariabackup,mysqldump, MyRocks,show (MariaDB)MariaDB Changelog,50-server.cnf, MariaDB engines, .ibd, .myd, .myi,/var/log/mysql/error.log, MariaDB files:.frm,.ibd,/etc/mysql/mariadb.conf.d/50-server.cnf, replication, MariaDB slow queries,show databases;, Aria, MyISAM, MariaDB SkySQL, binary log, 3306
Advertising:
