You can tune the performance of OBDUMPER from three aspects: command-line options, virtual machine (VM) memory, and database kernel.
Command-line options-based performance tuning
You can tune the performance of OBDUMPER by adjusting the settings of options in the following table.
Option |
Default value |
Description |
|---|---|---|
| --thread | Number of CPU cores × 2 | The number of concurrent threads for data export. You can adjust the value of this option based on the resource utilization of the database system. |
| --page-size | 1000000 | The page size. You can adjust the value of this option based on the resource utilization of the database system. |
| --fetch-size | 1000 | The number of rows read from the database cursor at a time in Oracle mode of OceanBase Database. |
Note
During performance tuning, take into account the resource utilization on the server where OBDUMPER runs, on the ODP service nodes, and on the nodes in the OceanBase cluster,
VM parameter-based performance tuning
Set the VM parameter in the export script to 60% of the available physical memory. Default value: -Xms4G -Xmx4G.
vim bin/obdumper
JAVA_OPTS="$JAVA_OPTS -server -Xms4G -Xmx4G -XX:MetaspaceSize=128M -XX:MaxMetaspaceSize=128M -Xss352K"
Database kernel-based performance tuning
If you want to export consistent data, we recommend that you manually trigger a major compaction before the export and export data only after the major compaction is completed.
For more information about how to perform a major compaction, see the Major compaction management chapter.
Note
At present, the consistent export feature of OBDUMPER does not apply to OceanBase Database V4.0.0.