Difference between revisions of "InnoDB"

From wikieduonline
Jump to navigation Jump to search
Line 16: Line 16:
  
 
== 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>[[mariabackup]]</code>

Revision as of 06:21, 9 June 2024

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';

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

  1. Read InnoDB Recovery Modes https://mariadb.com/kb/en/innodb-recovery-modes/

See also

  • https://mariadb.com/kb/en/innodb-page-compression/
  • Advertising: