Kernel Resources

This section describes kernel resource parameters. Whether these parameters take effect depends on OS settings.

max_files_per_node

Parameter description: Specifies the maximum number of files that can be opened by a single SQL statement on a single node. In most cases, there is no need to configure this parameter.

Only cluster of 8.1.3.310 and later versions support this function.

Parameter type: SUSET

Value range: an integer ranging from –1 to INT_MAX. The value –1 indicates that the maximum number is not limited.

Default value: 50000

For newly installed cluster versions 8.1.3.310 and later, the default value of this parameter is set to 50000.
In an upgrade scenario, if the original cluster supports the max_files_per_node parameter, the default value of this parameter remains the same for forward compatibility.
In the upgrade scenario, if the original cluster does not support the max_files_per_node parameter, the default value of this parameter is –1 after the upgrade.
If error message "The last file name is [%s] and %d files have already been opened on data node [%s] with a maximum of %d files." is displayed during statement execution, increase the value of max_files_per_node.