| Latest revision |
Your text |
| Line 1: |
Line 1: |
| − | [[wikipedia:InnoDB]] is a storage engine for the database management system [[MySQL]] and [[MariaDB]]. Is the default engine since [[MariaDB 10.2]] (2016). | + | {{Draft}} |
| | + | [[wikipedia:InnoDB]] |
| | | | |
| | | | |
| | InnoDB supports: | | InnoDB supports: |
| − | * Both SQL and XA [[transactions]] | + | * Both SQL and XA transactions |
| | * [[Tablespaces]] | | * [[Tablespaces]] |
| | * [[Foreign keys]] | | * [[Foreign keys]] |
| Line 9: |
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 ==
| |
| − | * 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 == |
| − | * {{InnoDB}} | + | * {{DBs}} |
| − | * {{MariaDB engines}} | + | * [[primary keys]] |
| − | * {{MariaDB}}
| |
| | | | |
| | | | |
| | [[Category:Databases]] | | [[Category:Databases]] |
