content_image/837545.jpg
## 26.3.13 The INFORMATION_SCHEMA ENGINES Table 

The host name part of the granted role. 

• IS_DEFAULT 

YES  or NO , depending on whether the role is a default role. 

• IS_MANDATORY 

YES  or NO , depending on whether the role is mandatory. 

The ENGINES  table provides information about storage engines. This is particularly useful for checking whether a storage engine is supported, or to see what the default engine is. 

The ENGINES  table has these columns: 

• ENGINE 

The name of the storage engine. 

• SUPPORT 

The server’s level of support for the storage engine, as shown in the following table. 

<img src='content_image/837545.jpg'>

A value of NO  means that the server was compiled without support for the engine, so it cannot be enabled at runtime. 

A value of DISABLED  occurs either because the server was started with an option that disables the engine, or because not all options required to enable it were given. In the latter case, the error log should contain a reason indicating why the option is disabled. See Section 5.4.2, “The Error Log” . 

You might also see DISABLED  for a storage engine if the server was compiled to support it, but was started with a --skip- engine_name  option. For the NDB  storage engine, DISABLED  means the server was compiled with support for NDB Cluster, but was not started with the --ndbcluster  option. 

All MySQL servers support MyISAM  tables. It is not possible to disable MyISAM . 

• COMMENT 

A brief description of the storage engine. 

• TRANSACTIONS 

Whether the storage engine supports transactions. 

• XA 

Whether the storage engine supports XA transactions. 

