Note
`default_storage_engine` is available starting with OceanBase Database V3.2.4 BP2.
Description
default_storage_engine specifies the default storage engine of an OBServer node.
Applicability
This variable applies only to OceanBase Database in MySQL mode.
Privilege requirements
Query variables
Global level
systenants and all user tenants can execute theSHOW VARIABLESstatement or query theinformation_schema.GLOBAL_VARIABLESview (MySQL mode) to view the value of a Global system variable.Session level
systenants and all user tenants can execute theSHOW VARIABLESstatement or query theinformation_schema.SESSION_VARIABLESview (MySQL mode) to view the value of a Session system variable.
Modify variables
Global level
systenants can directly modify the value of a Global system variable.MySQL user tenants can modify the value of a Global system variable only if they have the
SUPERorALTER SYSTEMprivilege.
Session level
systenants 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';