The INFORMATION_SCHEMA ENGINES Table The host name part of the granted role. YES  or  NO , depending on whether the role is a default role. 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: The name of the storage engine. The server’s level of support for the storage engine, as shown in the following table. 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 . A brief description of the storage engine. Whether the storage engine supports transactions. Whether the storage engine supports XA transactions. 4787 • XA • TRANSACTIONS • COMMENT • SUPPORT • ENGINE • IS_DEFAULT • IS_MANDATORY 26.3.13 The INFORMATION_SCHEMA ENGINES Table Value Meaning YES The engine is supported and is active DEFAULT Like  YES , plus this is the default engine NO The engine is not supported DISABLED The engine is supported but has been disabled