OceanBase logo

OceanBase

A unified distributed database ready for your transactional, analytical, and AI workloads.

DEPLOY YOUR WAY

OceanBase Cloud

The best way to deploy and scale OceanBase

OceanBase Enterprise

Run and manage OceanBase on your infra

TRY OPEN SOURCE

OceanBase Community Edition

The free, open-source distributed database

OceanBase seekdb

Open source AI native search database

Customer Stories

Real-world success stories from enterprises across diverse industries.

View All
BY USE CASES

Mission-Critical Transactions

Global & Multicloud Application

Elastic Scaling for Peak Traffic

Real-time Analytics

Active Geo-redundancy

Database Consolidation

Resources

Comprehensive knowledge hub for OceanBase.

Blog

Live Demos

Training & Certification

Documentation

Official technical guides, tutorials, API references, and manuals for all OceanBase products.

View All
PRODUCTS

OceanBase Cloud

OceanBase Database

Tools

Connectors and Middleware

QUICK START

OceanBase Cloud

OceanBase Database

BEST PRACTICES

Practical guides for utilizing OceanBase more effectively and conveniently

Company

Learn more about OceanBase – our company, partnerships, and trust and security initiatives.

About OceanBase

Partner

Trust Center

Contact Us

International - English
中国站 - 简体中文
日本 - 日本語
Sign In
Start on Cloud

A unified distributed database ready for your transactional, analytical, and AI workloads.

DEPLOY YOUR WAY

OceanBase Cloud

The best way to deploy and scale OceanBase

OceanBase Enterprise

Run and manage OceanBase on your infra

TRY OPEN SOURCE

OceanBase Community Edition

The free, open-source distributed database

OceanBase seekdb

Open source AI native search database

Customer Stories

Real-world success stories from enterprises across diverse industries.

View All
BY USE CASES

Mission-Critical Transactions

Global & Multicloud Application

Elastic Scaling for Peak Traffic

Real-time Analytics

Active Geo-redundancy

Database Consolidation

Comprehensive knowledge hub for OceanBase.

Blog

Live Demos

Training & Certification

Documentation

Official technical guides, tutorials, API references, and manuals for all OceanBase products.

View All
PRODUCTS
OceanBase CloudOceanBase Database
ToolsConnectors and Middleware
QUICK START
OceanBase CloudOceanBase Database
BEST PRACTICES

Practical guides for utilizing OceanBase more effectively and conveniently

Learn more about OceanBase – our company, partnerships, and trust and security initiatives.

About OceanBase

Partner

Trust Center

Contact Us

Start on Cloud
编组
All Products
    • Databases
    • iconOceanBase Database
    • iconOceanBase Cloud
    • iconOceanBase Tugraph
    • iconInteractive Tutorials
    • iconOceanBase Best Practices
    • Tools
    • iconOceanBase Cloud Platform
    • iconOceanBase Migration Service
    • iconOceanBase Developer Center
    • iconOceanBase Migration Assessment
    • iconOceanBase Admin Tool
    • iconOceanBase Loader and Dumper
    • iconOceanBase Deployer
    • iconKubernetes operator for OceanBase
    • iconOceanBase Diagnostic Tool
    • iconOceanBase Binlog Service
    • Connectors and Middleware
    • iconOceanBase Database Proxy
    • iconEmbedded SQL in C for OceanBase
    • iconOceanBase Call Interface
    • iconOceanBase Connector/C
    • iconOceanBase Connector/J
    • iconOceanBase Connector/ODBC
    • iconOceanBase Connector/NET
icon

OceanBase Database

SQL - V4.2.0

    Download PDF

    OceanBase logo

    The Unified Distributed Database for the AI Era.

    Follow Us
    Products
    OceanBase CloudOceanBase EnterpriseOceanBase Community EditionOceanBase seekdb
    Resources
    DocsBlogLive DemosTraining & Certification
    Company
    About OceanBaseTrust CenterLegalPartnerContact Us
    Follow Us

    © OceanBase 2026. All rights reserved

    Cloud Service AgreementPrivacy PolicySecurity
    Contact Us
    Document Feedback
    1. Documentation Center
    2. OceanBase Database
    3. SQL
    4. V4.2.0
    iconOceanBase Database
    SQL - V 4.2.0
    SQL
    KV
    • V 4.4.2
    • V 4.3.5
    • V 4.3.3
    • V 4.3.1
    • V 4.3.0
    • V 4.2.5
    • V 4.2.2
    • V 4.2.1
    • V 4.2.0
    • V 4.1.0
    • V 4.0.0
    • V 3.1.4 and earlier

    Structure of the OBServer node working directory

    Last Updated:2024-05-27 05:42:37  Updated
    share
    What is on this page
    Directory of configuration files
    Directory of log files
    Data file directory

    folded

    share

    A typical OBServer node working directory contains the following eight directories: audit/, bin/, etc/, etc2/, etc3/, log/, run/, and store/. However, not all of them are required for the installation of an OBServer node. Before you start an OBServer node, make sure that the etc/, log/, run/, and store/ directories exist. In addition, the store/ directory must contain the clog/, ilog/, slog/, and sstable/ directories. The etc2/ and etc3/ directories are created by an OBServer node to store the backup configuration files. The audit/ directory is created by an OBServer node to store the audit logs. The bin/ directory stores the observer binary files for future use.

    ├─audit
    ├─bin
    ├─etc
    ├─etc2
    ├─etc3
    ├─log
    ├─run
    ├─store
           ├─clog
           ├─ilog
           ├─slog
           ├─sstable
    

    Directory of configuration files

    The configuration files are stored in the etc/, etc2/, and etc3/ directories. These three directories have the same files. The difference lies in that the etc/ directory must be manually created before you start an OBServer node, whereas the other two are created by an OBServer node to store copies of configuration files in the etc/ directory. You can specify whether to create the etc2/ and etc3/ directories by setting the config_additional_dir parameter. A configuration change not only writes data into the observer.config.bin file in the etc/ directory but also creates additional configuration files in the etc2/ and etc3/ directories. OBServer does not read configuration files in the etc2/ and etc3/ directories. Configuration files in these two directories are used for backup only. OBServer automatically creates the two directories if it has the permission. Otherwise, an error is returned in the log.

    The configuration files store the incremental information of the cluster- and tenant-level parameters. You can log on to the database and execute an ALTER SYSTEM statement to modify a cluster parameter, or specify a cluster parameter by using a command-line tool. The value of a parameter that is specified by using a command-line tool overwrites the existing one. If you use a command-line tool, you can specify the following options to modify OBServer parameters:

    -z,--zone ZONE           The name of the zone in which the node exists.
    -p,--mysql_port PORT      The MySQL port number for the SQL service protocol.
    -P,--rpc_port PORT        The RPC port number for the communication within a cluster.
    -n,--appname APPNAME      The name of the OceanBase cluster.
    -c,--cluster_id ID        The ID of the OceanBase cluster.
    -d,--data_dir DIR         The directory where data such as the SSTable is stored.
    -i,--devname DEV          The name of the NIC bound to the service process.
    -r,--rs_list RS_LIST      The RootService list.
    -l,--log_level LOG_LEVEL  The system log level.
    -o,--optstr OPTSTR        The additional parameters specified in the format of "parameter name = new value,parameter name = new value".
    

    Directory of log files

    The log/ directory stores the following operational log files: observer logs, RootService logs, and election logs. The size of a single log file is 256 MB.

    When the enable_syslog_recycle parameter is set to true and the max_syslog_file_count parameter is set to an integer greater than 0, log files are automatically recycled. The enable_syslog_recycle parameter specifies whether to enable automatic log recycling. The max_syslog_file_count parameter specifies the maximum number of logs of each type.

    Data file directory

    The data files are stored in the store/ directory, which contains the clog/, ilog/, slog/, and sstable/ directories. The slog/ directory stores transaction logs for static data writes. The clog/ directory stores transaction logs for dynamic data writes. The ilog/ directory stores the log directories. The sstable/ directory stores the baseline data and contains a block_file, which is created after the OBServer node starts. The size of the file is determined by specifying the datafile_size or datafile_disk_percentage parameter.

    Note

    • datafile_size specifies the size of a data file.

    • datafile_disk_percentage specifies the percentage of occupied space of the disk where the data_dir directory resides. The disk of the data_dir directory will be initialized by OceanBase Database to store data.

    For more information about the two parameters, see the System parameters chapter of OceanBase Database Reference Guide.

    Previous topic

    Security audit
    Last

    Next topic

    Configuration files
    Next
    What is on this page
    Directory of configuration files
    Directory of log files
    Data file directory