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]]: < | + | * Show [[MariaDB engines|database engine]]: <pre>show table status like '<table name>';</pre> |
== 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>[[show table status]]</code> | * <code>[[show table status]]</code> | ||
* <code>[[SHOW PROCESSLIST;]]</code> | * <code>[[SHOW PROCESSLIST;]]</code> | ||
| Line 28: | Line 27: | ||
== Errors == | == Errors == | ||
| − | |||
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: 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: Could not set the file size of './ibtmp1'. Probably out of disk space | ||
| Line 44: | Line 42: | ||
== See also == | == See also == | ||
* {{InnoDB}} | * {{InnoDB}} | ||
| − | |||
* {{MariaDB}} | * {{MariaDB}} | ||
| − | + | * {{DBs}} | |
[[Category:Databases]] | [[Category:Databases]] | ||
Advertising:
