Editing InnoDB

Jump to navigation Jump to search

Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.

The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.

Latest revision Your text
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 12: Line 13:
  
 
== Activities ==
 
== Activities ==
* Show [[MariaDB engines|database engine]]: <code>[[show table status like]] '<table name>';</code>
+
* Show [[MariaDB engines|database engine]]: <pre>show table status like '<table name>';</pre>
  
 
== 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 26: Line 24:
 
  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 44: Line 30:
 
== See also ==
 
== See also ==
 
* {{InnoDB}}
 
* {{InnoDB}}
* {{MariaDB engines}}
 
 
* {{MariaDB}}
 
* {{MariaDB}}
 
+
* {{DBs}}
  
 
[[Category:Databases]]
 
[[Category:Databases]]

Please note that all contributions to wikieduonline may be edited, altered, or removed by other contributors. If you do not want your writing to be edited mercilessly, then do not submit it here.
You are also promising us that you wrote this yourself, or copied it from a public domain or similar free resource (see Wikieduonline:Copyrights for details). Do not submit copyrighted work without permission!

Cancel Editing help (opens in new window)

Advertising: