engines

The engines view provides information about storage engines. It is used to check whether a storage engine is supported or check the default engine. This view is read-only. All users have the read permission on this view.

**Table 1** information_schema.engines columns
Name	Type	Description
ENGINE	varchar(64)	Engine name. Return values: Ustore and Astore.
SUPPORT	varchar(8)	Level of the storage engine supported by the server. Return values: YES and YES.
COMMENT	varchar(80)	Brief description of the engine. Return values: In-place update store and Append update store.
TRANSACTIONS	varchar(3)	Specifies whether the engine supports transactions. Return values: YES and YES.
XA	varchar(3)	Specifies whether the engine supports XA transactions. Return values: YES and YES.
SAVEPOINTS	varchar(3)	Specifies whether the engine supports savepoints. Return values: YES and YES.