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 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'; | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
== Activities == | == Activities == | ||
| Line 44: | Line 30: | ||
== See also == | == See also == | ||
* {{InnoDB}} | * {{InnoDB}} | ||
| − | |||
* {{MariaDB}} | * {{MariaDB}} | ||
| − | + | * {{DBs}} | |
[[Category:Databases]] | [[Category:Databases]] | ||
Advertising:
