Note
This variable is available starting with V3.2.4 BP2.
Description
default_storage_engine specifies the default storage engine of an OBServer node.
Note
This variable is available only in MySQL-compatible mode.
Privilege requirements
Query variables
Global level
systenant and all user tenants can execute theSHOW VARIABLESstatement or query theinformation_schema.GLOBAL_VARIABLESview (MySQL-compatible mode) to view the value of a Global system variable.Session level
systenant and all user tenants can execute theSHOW VARIABLESstatement or query theinformation_schema.SESSION_VARIABLESview (MySQL-compatible mode) to view the value of a Session system variable.
Modify variables
Global level
systenant can directly modify the value of a Global system variable.MySQL user tenants must have the
SUPERorALTER SYSTEMprivilege to modify the value of a Global system variable.
Session level
systenant and all user tenants can directly modify the value of a Session system variable.
Attributes
| Attribute | Description |
|---|---|
| Type | Varchar |
| Default value | OceanBase |
| Value range | OceanBase |
| Scope |
|
| Modifiable | Yes. You can execute the SET statement to modify the value. |
Examples
Set the default storage engine of an OBServer node to OceanBase.
Global level
obclient> SET GLOBAL default_storage_engine ='OceanBase';Session level
obclient> SET default_storage_engine ='OceanBase';