Process|V4.2.5| docs|Distributed Database

Process

Last Updated：2025-01-02 01:58:39 Updated

Different request links are available for different requests. A complete request link consists of multiple request procedures. In OceanBase Database, an internal processing procedure is defined as a span. A request link can be understood as a tree structure that contains parent span nodes and child span nodes. This type of information is recorded in trace logs. Parent and child nodes are associated based on parent_id and id. In trace logs, the information about executed SQL statements during each request procedure is tagged. Details about the current operation are recorded by using different tags. Spans and tags are recorded in trace logs to help O&M engineers understand the internal processing logic of the database and locate issues.

The following sections describe the three parts of an entire access link.

Client

Applications connect to OceanBase Database by using the OBClient or JDBC driver.

Spans related to the client are obclient and JDBC.

obclient: Applications access the database by using the OBClient.
JDBC: Applications access the database by using the JDBC driver.

Client-related tags are command_name and client_ip. The tags of the OBClient and JDBC driver are consistent.

command_name marks requests of different types such as TEXT requests, PREPARE requests, and EXECUTE requests.
client_ip specifies the IP address and port of the OBClient that sends the request.

ODP

This phase involves three levels of spans. The span level here corresponds to the level variable in the trace-related function of the DBMS_MONITOR package.

Level 1

The following two spans are defined: ob_proxy and ob_proxy_server_process_req.
- ob_proxy indicates the total time consumed by OceanBase Database Proxy (ODP) to process an SQL request. This period begins from the time when a database request is sent, to the time when data processing is finished, and finally to the time when a result is returned, excluding the frontend driver layer of OceanBase Database.
- ob_proxy_server_process_req indicates the time consumed by ODP to process an SQL request and the network overhead of the request.
Level 2

The following two spans are defined: ob_proxy_server_response_read and ob_proxy_cluster_resource_create.
- ob_proxy_server_response_read indicates the time consumed in reading the response.
- ob_proxy_cluster_resource_create indicates the time consumed by ODP to prepare cluster resources in the request forwarding phase.
Level 3

The following four spans are defined: ob_proxy_partition_location_lookup, ob_proxy_do_OBServer_open, ob_proxy_client_response_write, and ob_proxy_server_request_write.
- ob_proxy_partition_location_lookup indicates the time consumed by ODP to obtain the partition location for routing in the request forwarding phase.
- ob_proxy_do_observer_open indicates the time consumed by ODP to select an OBServer node or establish a connection in the request forwarding phase.
- ob_proxy_client_response_write indicates the time consumed by ODP to forward the response to the client after it receives the response from the OBServer node.
- ob_proxy_server_request_write indicates the time consumed by ODP to forward the client request to the OBServer node.

OBServer nodes

Spans

An OBServer node classifies the received requests into text SQL statements, preprocess statements, and stored procedures. The three types of requests contain transactions, internal SQL requests, and access requests stored in the database.

The following figure shows the access links for different request types and the relationship between parent and child span nodes. For example, the parent span of the mpquery_single_stmt span is com_query_entry, and the child span of the com_query_entry span is mpquery_single_stmt.

The spans are described as follows:

com_query_entry: the query procedure.
mpquery_single_stmt: the access path of a single statement.
sql_compile: specifies to compile an SQL statement.
pc_get_plan: specifies to obtain an execution plan.
hard_parse: specifies to perform hard parsing.
parse: specifies to perform soft parsing.
resolve: specifies to parse the semantics of a syntax tree and generate a statement.
rewrite: specifies to rewrite an SQL statement.
optimize: specifies to perform cost-based optimization and generate execution plan logs.
code_generate: specifies to generate a physical execution plan based on the execution plan logs.
pc_add_plan: specifies to add the generated execution plan to the plan cache.
sql_execute: specifies to execute a physical execution plan.
open: specifies to open an execution plan.
response_result: the plan execution process and results.
px_schedule: specifies to schedule tasks based on parallel execution (PX).
px_task: specifies to execute PX subtasks.
close: specifies to close an execution plan.
cmd_execute: specifies to execute a command.
cmd_open: specifies to enable the cmd plan.
ps_prepare: specifies to prepare the preprocess statement.
ps_execute: specifies to execute the preprocess statement.
ps_close: specifies to close the preprocess statement.
pl_entry: specifies to process a stored procedure.
pl_compile: specifies to compile stored procedure objects.
pc_get_pl_object: specifies to obtain the stored procedure object from the plan cache.
pc_add_pl_object: specifies to store the stored procedure object in the plan cache.
pl_execute: specifies to execute a stored procedure.
pl_spi_query: specifies to execute the SPI statement in the stored procedure.
pl_spi_prepare: the preprocessing phase of stored procedures.
pl_spi_execute: specifies to execute the SPI statement in the stored procedure.
inner_prepare: the preprocessing phase of internal SQL statements.
inner_execute: the execution phase of internal SQL statements.
inner_execute_read: specifies to read an internal SQL statement.
inner_execute_write: specifies to write an internal SQL statement.
inner_commit: specifies to commit an internal SQL transaction.
inner_rollback: specifies to roll back an internal SQL transaction.

Process

Client

ODP

OBServer nodes

Spans

Tags